All content is derived from public domain, promotional, or otherwise-compatible
sources and published uniformly under the
Creative Commons Attribution-Share Alike 3.0 license.
See license.README for details.
(C) Neil Tallim, 2009
"""
import os
import sqlite3
import sys
import _db
print "SQLite database expected as first argument...",
mysql_db = _db.getConnection()
mysql_cur = mysql_db.cursor()
sqlite_db = sqlite3.connect(sys.argv[1])
sqlite_cur = sqlite_db.cursor()
print "found"
try:
print "Updating hymmnos..."
sqlite_cur.execute("SELECT word, meaning, japanese, dialect, kana, romaji, description, class, syllables FROM hymmnos ORDER BY word ASC, dialect ASC")
while True:
row = sqlite_cur.fetchone()
if not row:
break
(word, meaning, japanese, dialect, kana, romaji, description, class, syllables) = row
mysql_cur.execute("SELECT meaning, description, japanese FROM hymmnos WHERE word = %s AND dialect = %s", (word, dialect,))
Legal ===== All code, unless otherwise indicated, is original, and subject to the terms of the GNU GPLv3 or, at your option, any later version of the GPL. All content is derived from public domain, promotional, or otherwise-compatible sources and published uniformly under the Creative Commons Attribution-Share Alike 3.0 license. See license.README for details. (C) Neil Tallim, 2009 """ import _db db_con = _db.getConnection() cursor = db_con.cursor() try: while True: print "First word:" word_1 = raw_input() print "First dialect:" dialect_1 = int(raw_input()) print "Second word:" word_2 = raw_input() print "Second dialect:" dialect_2 = int(raw_input())
