def articles():
'''Convert all content that have dataset set to 2 from MySQK to MongoDB'''
data = [];
for content in db['content'].find({'settings.dataset': '2'}):
data += [content['path']];
table = content['settings'].get('table', None);
if table is None: continue;
sql_cursor.execute("SELECT full FROM " + table)
full = sql_cursor.fetchone()['full'];
update = {
"$set" : {"data_html": full},
}
db['content'].update({"_id": content["_id"]}, update);
# sql_cursor.execute("DROP TABLE " + table + ";");
# except:
# pass
return data;
def graduates(table_years, table, cid):
'''Convert graduates database'''
sql_cursor.execute("SELECT * FROM " + table_years)
years= []
yearbyid = {}
for row in sql_cursor.fetchall():
y = int(row['year'])
yearbyid[row['id']] = y
years += [y]
sql_cursor.execute("SELECT * FROM " + table)
graduates = sql_cursor.fetchall()
for student in graduates:
student['year'] = yearbyid[student['parent']]
del student['parent']
del student['precedence']
db['content'].update({'id':cid}, {"$set" : {"data_years" : years} })
db['graduates'].insert(graduates);
return graduates
def photogalleries(table):
'''Convert table with info about photogalleries to MongoDB'''
sql_cursor.execute("SELECT * FROM " + table)
db['photogalleries'].insert( sql_cursor.fetchall() )