dbcq is a little database connection and query wrapper for python.
db = dbcq("<target in .dbc>")
db.qfad("select * from table where name = ?", "adam")
documentation here.
download dbcq whl from here. install whl with pip:
pip install dbcq-<version>.whl
in your home directory, create a file named .dbc and fill in the
connection info in the <> brackets like this:
[<db target name used in code>]
type = <mssql|sqlite>
database = <database name>
username = <user name>
password = <password>
server = <ip address>
port = <port>
driver = <path to db driver if needed>
for example:
[my_db]
type = mssql
database = my_db
username = hireader
password = ?hireaderpass?
server = 10.11.22.33
port = 1234
driver = /path/to/my/libmsodbcsql-18.3.so.2.1
if you're unsure where your home directory is, say dbcq to see
where dbcq looks the .dbc file and put it there.
install the database connector with pip (for mssql install pyodbc, for sqlite install sqlite3):
pip install pyodbc
pip install sqlite3