def init_database():
from globaldb import global_conn as db
for table_name in config.BASE_TABLE :
with open(config.SQL_TPL_DIR+'argo_'+table_name+'.sql') as f:
sql = f.read()
print sql
db.execute(sql)
def init_table(table_name):
from globaldb import global_conn as db
with open(config.SQL_TPL_DIR+'argo_'+table_name+'.sql') as f:
sql = f.read()
print sql
try:
db.execute(sql)
except Exception as e:
print e
raw_input('>> ')
def init_table(table_name):
from globaldb import global_conn as db
with open(config.SQL_TPL_DIR + 'argo_' + table_name + '.sql') as f:
sql = f.read()
print sql
try:
db.execute(sql)
except Exception as e:
print e
raw_input('>> ')
def init_table(table_name):
from globaldb import global_conn as db
with open(argo_conf.SQL_DIR + "argo_" + table_name + ".sql") as f:
sql = f.read()
print sql
try:
db.execute(sql)
except Exception as e:
print e
raw_input(">> ")
def set_up_new_board(boardname,keys):
keys['boardname'] = boardname
db.execute(new_board_text % { "boardname":boardname})
insert_dict('argo_boardhead',keys)
def insert_dict(table,kv_pairs):
exist_attr = kv_pairs.keys()
exist_val = map(lambda x : "'%s'" % x,kv_pairs.values())
sql = "INSERT INTO %s(%s) values(%s)" % (table, ','.join(exist_attr), ','.join(exist_val))
db.execute(sql)
