Created
November 11, 2020 12:03
-
-
Save andrewm4894/da0b945a72cc10199a5f7c715a8b644c to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import sqlite3 | |
from sqlite3 import Error | |
def create_connection(db_file): | |
""" create a database connection to the SQLite database | |
specified by the db_file | |
:param db_file: database file | |
:return: Connection object or None | |
""" | |
conn = None | |
try: | |
conn = sqlite3.connect(db_file) | |
print(sqlite3.version) | |
except Error as e: | |
print(e) | |
return conn | |
def select_all_tasks(conn): | |
""" | |
Query all rows in the tasks table | |
:param conn: the Connection object | |
:return: | |
""" | |
cur = conn.cursor() | |
query1 = """ | |
SELECT * | |
FROM FACILITIES | |
""" | |
cur.execute(query1) | |
rows = cur.fetchall() | |
for row in rows: | |
print(row) | |
def main(): | |
database = "sqlite_db_pythonsqlite.db" | |
# create a database connection | |
conn = create_connection(database) | |
with conn: | |
print("2. Query all tasks") | |
select_all_tasks(conn) | |
if __name__ == '__main__': | |
main() |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment