def insertWord(obj):
query = """
INSERT INTO talk_words(lesson_id, file_path, text) values ({0}, "{1}", "{2}")
""".format(obj['lesson_id'], obj['file_path'], obj['text'])
id = mysql.executeInsert(query)
return id
def insertSite(obj):
query = """
SELECT id FROM sites WHERE url = '{0}'
""".format(obj['url'])
id = mysql.executeScalar(query)
if id == None:
query = """
INSERT INTO sites(url) values ('{0}')
""".format(obj['url'])
id = mysql.executeInsert(query)
return id
