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