From 158b36e51c8c2925d6c8af6e08380369d019378e Mon Sep 17 00:00:00 2001 From: TinWoodman92 Date: Sat, 16 Dec 2023 06:18:44 -0600 Subject: Initial commit --- access_methods.py | 27 +++++++++++++++++++++++++++ 1 file changed, 27 insertions(+) create mode 100644 access_methods.py (limited to 'access_methods.py') diff --git a/access_methods.py b/access_methods.py new file mode 100644 index 0000000..f315b82 --- /dev/null +++ b/access_methods.py @@ -0,0 +1,27 @@ +from sqlite3 import * + +def IIf(chk, true_case, false_case=None): + if chk: return true_case + else: return false_case + +def Nz(val, nul_case=0): + if val == None: return nul_case + else: return val + +# return a list of dictionaries from a db query +# need the connection. Is inherent in DAO.Database +# Read only +def OpenRecordset(con, qry_sql, param=None): + cur = con.cursor() + rst = [] + k = [] + + if param != None: res = cur.execute(qry_sql, param) + else: res = cur.execute(qry_sql) + + for desc in cur.description: k.append(desc[0]) + + for row in res.fetchall(): rst.append(dict(zip(k,row))) + + cur = None + return rst \ No newline at end of file -- cgit v1.2.3