def conyxDBLast(forum_id):
try:
conn=sqlite3.connect(conyxDBLocation())
cur = conn.cursor()
cur.execute("insert into last values (?)",(forum_id,))
conn.commit()
conn.close()
except Exception:
traceback.print_exc(file=sys.stdout)
print ("ERR [ FAILED STORE LAST FORUM VISITED ] 001030x0010 (1) : Cannot store Last Visited Forum")
def conyxDBGenDMLVars(qry,vars):
try:
conn=sqlite3.connect(conyxDBLocation())
cur = conn.cursor()
cur.execute(qry,vars)
conn.commit()
conn.close()
except Exception:
traceback.print_exc(file=sys.stdout)
print ("ERR [ FAILED TO EXECUTE GENERAL DML ] 001060x0010 (1) : Cannot execute General DML")
def deleteLastVisited():
try:
conn = sqlite3.connect(conyxDBLocation())
cur = conn.cursor()
cur.execute("delete from last")
conn.commit()
conn.close()
except Exception:
traceback.print_exc(file=sys.stdout)
print(
"ERR [ FAILED STORE LAST FORUM VISITED ] 001040x0010 (1) : Cannot store Last Visited Forum"
)
def conyxDBUpdNickname(p_nickname):
try:
conn = sqlite3.connect(conyxDBLocation())
cur = conn.cursor()
cur.execute("update nick set nickname= ?", (p_nickname, ))
conn.commit()
conn.close()
except Exception:
traceback.print_exc(file=sys.stdout)
print(
"ERR [ FAILED STORE AUTH KEY ] 001040x0010 (1) : Cannot store Authorization Key"
)
def conyxDBSetForumLast(forum_id):
try:
conn = sqlite3.connect(conyxDBLocation())
cur = conn.cursor()
cur.execute("update current set id = (?)", (forum_id, ))
conn.commit()
conn.close()
except Exception:
traceback.print_exc(file=sys.stdout)
print(
"ERR [ FAILED STORE LAST FORUM VISITED ] 001030x0010 (1) : Cannot updaste Last Visited Forum"
)
def conyxDBStoreAuth(p_auth_key):
try:
conn = sqlite3.connect(conyxDBLocation())
cur = conn.cursor()
cur.execute("update auth set auth_key = ?", (p_auth_key, ))
conn.commit()
conn.close()
except Exception:
traceback.print_exc(file=sys.stdout)
print(
"ERR [ FAILED STORE AUTH KEY ] 001040x0010 (1) : Cannot store Authorization Key"
)
def conyxDBQuery(qry):
try:
cols = []
con = sqlite3.connect(conyxDBLocation())
con.row_factory=sqlite3.Row
c = con.cursor()
c.execute(qry)
rows = c.fetchall()
#print (cols)
#print (rows)
return (cols, rows)
except Exception:
traceback.print_exc(file=sys.stdout)
print ("ERR [ CONYX FAILED TO READ FROM DATABASE ] 001040x0010 (1) : CONYX Failed to Connect to DB")
def conyxDBQueryTable(table):
try:
cols = []
con = sqlite3.connect(conyxDBLocation())
con.row_factory = sqlite3.Row
conm = con.cursor()
cm = conm.execute(
"select * from " + table + " order by rowid asc limit 1", )
row = cm.fetchone()
if (row):
cols = row.keys()
c = con.cursor()
c.execute("select * from " + table)
rows = c.fetchall()
print(cols)
print(rows)
return (cols, rows)
except Exception:
traceback.print_exc(file=sys.stdout)
print(
"ERR [ CONYX FAILED TO READ FROM DATABASE ] 001040x0010 (1) : CONYX Failed to Connect to DB"
)
