def is_table_exist(table_name): ''' 检查table_name的数据库表是否存在 ''' con = sqlite3.connect(Config.get_sqlite_path()) return True if con.cursor().execute( "SELECT count(*) FROM sqlite_master WHERE type= 'table' and name = ? ", (table_name, )).fetchone()[0] > 0 else False
def execute_sql(sql, data = ""): ''' 执行sql语句 data默认为空,data为list,可执行多条数据操作 ''' con = sqlite3.connect(Config.get_sqlite_path()) if not check_sql(sql): return cur = con.cursor() if data == "": cur.execute(sql) else: for d in data: if Config.SHOW_SQL: print('process sql:[{}],paras:[{}]'.format(sql, d)) cur.execute(sql, d) con.commit() close_all(con)
def execute_sql(sql, data=""): ''' 执行sql语句 data默认为空,data为list,可执行多条数据操作 ''' con = sqlite3.connect(Config.get_sqlite_path()) if not check_sql(sql): return cur = con.cursor() if data == "": cur.execute(sql) else: for d in data: if Config.SHOW_SQL: print('process sql:[{}],paras:[{}]'.format(sql, d)) cur.execute(sql, d) con.commit() close_all(con)
def save_return_id(sql, data): ''' 插入数据 data为要插入的数据 返回插入生成的id,要求id为INTEGER PRIMARY KEY AUTOINCREMENT格式 ''' id = 0 if not data: return con = sqlite3.connect(Config.get_sqlite_path()) if not check_sql(sql): return cur = con.cursor() if Config.SHOW_SQL: print('process sql:[{}],paras:[{}]'.format(sql, d)) cur.execute(sql, data) id = cur.lastrowid con.commit() close_all(con) print "save_return_id :%d" % id return id
def save_return_id(sql, data): ''' 插入数据 data为要插入的数据 返回插入生成的id,要求id为INTEGER PRIMARY KEY AUTOINCREMENT格式 ''' id = 0 if not data: return con = sqlite3.connect(Config.get_sqlite_path()) if not check_sql(sql): return cur = con.cursor() if Config.SHOW_SQL: print('process sql:[{}],paras:[{}]'.format(sql, d)) cur.execute(sql, data) id = cur.lastrowid con.commit() close_all(con) print "save_return_id :%d" %id return id
def is_table_exist(table_name): ''' 检查table_name的数据库表是否存在 ''' con = sqlite3.connect(Config.get_sqlite_path()) return True if con.cursor().execute("SELECT count(*) FROM sqlite_master WHERE type= 'table' and name = ? ",(table_name,)).fetchone()[0] > 0 else False