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")