def init_db():
"""Creates the database tables"""
with app.app_context():
db = get_db()
with app.open_resource('schema.sql', mode='r') as f:
db.cursor().executescript(f.read())
db.commit()
def update_csvMeta(list_Name_Title_Desc):
with app.app_context():
db = get_db()
cur = db.cursor()
cur.execute('PRAGMA foreign_keys = ON')
try:
cur.execute('INSERT INTO csvMeta VALUES (?,?,?)', list_Name_Title_Desc)
db.commit()
except:
e = sys.exc_info()[0]
print(e)
pass
def update_db(csvfile, table='csvFiles'):
with app.app_context():
reader = csv.DictReader(open(csvfile, 'rb'))
container = []
table_id = re.match(r'.*(\W+)(\w*)(\.csv)$', csvfile).groups()[1]
row_id = 0
for row in reader:
row_id += 1
for key in row.keys():
container.append((table_id, row_id, json.dumps(key), json.dumps(strip_non_ascii(row[key]))))
db = get_db()
db.cursor().executemany('INSERT INTO csvFiles VALUES (?,?,?,?)', container)
db.commit()
def update_csvFiles(csvFile, table_name):
"""updates the csvFiles table"""
with app.app_context():
reader = csv.DictReader(open(csvFile, 'rb'))
reader.fieldnames = map(lambda x: re.sub("\W","",x), reader.fieldnames)
container = []
row_id = 0
for row in reader:
row_id += 1
for key in row.keys():
container.append((table_name, row_id, json.dumps(key), json.dumps(strip_non_ascii(row[key]))))
db = get_db()
cur = db.cursor()
cur.execute('PRAGMA foreign_keys = ON')
try:
cur.executemany('INSERT INTO csvFiles VALUES (?,?,?,?)', container)
db.commit()
except:
e = sys.exc_info()[0]
print(e)
pass
def query_db(query, args=()): with app.app_context(): cur = get_db().cursor().execute(query, args) rez = cur.fetchall() return rez
