[knowledge base] removed and added patch to move to notes
diff --git a/patches/may_2013/p06_make_notes.py b/patches/may_2013/p06_make_notes.py
new file mode 100644
index 0000000..e1ea656
--- /dev/null
+++ b/patches/may_2013/p06_make_notes.py
@@ -0,0 +1,20 @@
+import webnotes
+
+def execute():
+ webnotes.reload_doc("utilities", "doctype", "note")
+ for question in webnotes.conn.sql("""select * from tabQuestion""", as_dict=True):
+ name = question.question[:180]
+ if webnotes.conn.exists("Note", name):
+ webnotes.delete_doc("Note", name)
+ note = webnotes.bean({
+ "doctype":"Note",
+ "title": name,
+ "content": "<hr>".join(webnotes.conn.sql_list("""select answer from tabAnswer
+ where question=%s""", question.name)),
+ "owner": question.owner,
+ "creation": question.creation,
+ "public": 1
+ }).insert()
+
+ webnotes.delete_doc("DocType", "Question")
+ webnotes.delete_doc("DocType", "Answer")