Nice Python CSV to sqlite conversion...

# toSqlite.py - Imports humod06.txt to sqlite.

import csv
import sqlite3

conn = sqlite3.connect('humod.sqlite')
c = conn.cursor()

c.execute('''DROP TABLE IF EXISTS skl_desc''')

c.execute('''CREATE TABLE skl_desc (
id INTEGER PRIMARY KEY AUTOINCREMENT,
parent INTEGER,
mod INTEGER,
desc TEXT,
abr TEXT,
r INTEGER)
''')

insertSql = '''
INSERT INTO skl_desc
VALUES (null, ?, ?, ?, ?, ?)
'''

reader = csv.reader(open('humod06.txt', 'rb'), delimiter='\t')
rownum = 0
for row in reader:
    if rownum == 0: pass
    else:
        parent = 0
        rValue = 0
        if row[5] == 'R':
            rValue = 1
        t = (parent,
            row[1],
            unicode(row[4].strip(), 'utf8'),
            unicode(row[2].strip(), 'utf8'),
            rValue)
        c.execute(insertSql, t)
    rownum += 1
print('rows: %s' % rownum)
conn.commit()
c.close()

Social Bookmarks :                                              

  Export this post to PDF document

Add a comment

Posted by Wyatt on April 2, 2010 6:55:19 AM EDT #