def _add_user(email, location): try: cursor.execute('''INSERT INTO subscribers(email, city) VALUES(?,?)''', (email, location)) logger.debug('User %s added', email) conn.commit() except sqlite3.IntegrityError as er: return "User already exists" return "User Added"
def execuesql(sql): # 执行SQL,并返回收影响行数 try: # 执行SQL语句 cursor.execute(sql) # 获取所有记录列表 results = cursor.fetchone() # 返回结果 return results[0] except: print("Error: unable to fetch data")
def select_time_sql(user_id): # SQL 查询语句 sql = "SELECT time_s,date_s,content FROM time WHERE id = %s" % user_id # 执行SQL,并返回收影响行数 try: # 执行SQL语句 cursor.execute(sql) # 获取所有记录列表 results = cursor.fetchall() #返回结果 return results except: print("Error: unable to fetch data")
def insert_time_sql(id, time, date, content): dt = datetime.datetime.now().strftime("%Y-%m-%d") dt = '2012-12-12' sql = "INSERT INTO time (id,time_s,date_s,content) VALUES(%s,%s,'%s','%s')" % ( id, time, date, content) try: # 执行SQL语句 cursor.execute(sql) conn.commit() return 1 except: print("Error: unable to fetch data") return 0
def select_all_sql(): # SQL 查询语句 sql = "select user.id,user.name,time.time_s,time.date_s,time.content from user left outer join time on user.id = time.id;" # 执行SQL,并返回收影响行数 try: # 执行SQL语句 cursor.execute(sql) # 获取所有记录列表 results = cursor.fetchall() #返回结果 # for i in results: # print(i) return results except: print("Error: unable to fetch data")