commit ebb0236cc4974d465f0b179382c32239b18a4326
parent bbda33a6f04cda956d93fee15c90b5a66b655c76
Author: parazyd <parazyd@dyne.org>
Date: Sun, 20 Jan 2019 22:12:07 +0100
Linting db.py.
Diffstat:
M | db.py | | | 24 | ++++++++++++------------ |
1 file changed, 12 insertions(+), 12 deletions(-)
diff --git a/db.py b/db.py
@@ -63,37 +63,37 @@ def initdb(dbpath):
return _dbctx, _db
-dbctx, db = initdb('./stories.db')
+DBCTX, DB = initdb('./stories.db')
def sql_select_col_where(col0, col1, val, table='stories'):
"""
Queries col0 where col1 = val.
"""
- db.execute("""
+ DB.execute("""
SELECT %s FROM %s WHERE %s = '%s';
""" % (col0, table, col1, val))
- return db.fetchall()
+ return DB.fetchall()
def sql_select_col(col, table='stories'):
"""
Executes a SELECT query and returns the entire col.
"""
- db.execute("SELECT %s FROM %s;" % (col, table))
- return db.fetchall()
+ DB.execute("SELECT %s FROM %s;" % (col, table))
+ return DB.fetchall()
def sql_delete_row_where(col, val, table='stories'):
"""
Executes a DELETE query where col=val.
"""
- db.execute("""
+ DB.execute("""
DELETE
FROM %s
WHERE %s = '%s';
""" % (table, col, val))
- dbctx.commit()
+ DBCTX.commit()
def sql_update_row_where(vals, col, val, table='stories'):
@@ -103,12 +103,12 @@ def sql_update_row_where(vals, col, val, table='stories'):
vals is a list of tuples.
"""
for i in vals:
- db.execute("""
+ DB.execute("""
UPDATE %s
SET %s = ?
WHERE %s = ?;
""" % (table, i[0], col), (i[1], val))
- dbctx.commit()
+ DBCTX.commit()
def sql_insert(args):
@@ -119,7 +119,7 @@ def sql_insert(args):
"""
if len(args) == 11:
# Story
- db.execute("""
+ DB.execute("""
INSERT INTO stories VALUES (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
);
@@ -127,11 +127,11 @@ def sql_insert(args):
args[6], args[7], args[8], args[9], args[10]))
elif len(args) == 7:
# User
- db.execute("""
+ DB.execute("""
INSERT INTO users VALUES (
?, ?, ?, ?, ?, ?, ?
);
""", (args[0], args[1], args[2], args[3], args[4], args[5],
args[6]))
- dbctx.commit()
+ DBCTX.commit()