def obtenerChat(chatId):
conn = database.conect()
cur = database.statement(
conn, "SELECT * from chats where chatId='" + str(chatId) + "';")
rows = cur.fetchall()
database.close(conn)
return rows
def obtenerLastImg():
conn = database.conect()
cur = database.statement(
conn, "SELECT * from parametros where param='lastImg';")
rows = cur.fetchall()
database.close(conn)
return rows
def guardarChat(chatId):
conn = database.conect()
database.statement(conn,
"create table if not exists chats(chatId varchar);")
database.statement(
conn, "insert into chats (chatId) values('" + str(chatId) + "');")
database.close(conn)
def guardarLastImg(img):
conn = database.conect()
database.statement(
conn,
"create table if not exists parametros(param varchar, value varchar);")
database.statement(
conn, "CREATE unique INDEX if not exists param ON parametros(param);")
database.statement(
conn,
"insert into parametros (param,value) values('lastImg','') on conflict (param) do update set value='"
+ str(img) + "';")
database.close(conn)
def obtenerChats():
conn = database.conect()
cur = database.statement(conn, "SELECT * from chats")
rows = cur.fetchall()
database.close(conn)
return rows
def truncateChats():
conn = database.conect()
database.statement(conn, "truncate table chats")
database.close(conn)
def borrarChat(chatId):
conn = database.conect()
database.statement(conn,
"delete from chats where chatId='" + str(chatId) + "';")
database.close(conn)