access sqlite db python

Maxime Merveille answered on May 2, 2022 Popularity 10/10 Helpfulness 5/10

answer access sqlite db python

access sqlite db python

Comment

import sqlite3
import os.path

#Connection to the DB
try:
    # Make sure to find the file.db in the script directory
    BASE_DIR = os.path.dirname(os.path.abspath(__file__)) 
    db_path = os.path.join(BASE_DIR, "sqlite.db")
    conn = sqlite3.connect(db_path)

except sqlite3.Error as error:
    print("Failed to read data from sqlite table", error)



# Execute query on the sqlite DB
cur = conn.cursor()
cur.execute("SELECT * FROM tasks")

# Print everything from a table
rows = cur.fetchall()
for row in rows:
        print(row)
    
# Update field 
conn.execute("""UPDATE tasks SET name = \'jhon\'
 where id = 1""")

# close the DB connection 
conn.close()

Popularity 10/10 Helpfulness 5/10 Language python

Source: www.sqlitetutorial.net

Tags: python sqlite

Link to this answer
Share Copy Link

Contributed on May 02 2022

Maxime Merveille

0 Answers Avg Quality 2/10

access sqlite db python

Contents

More Related Answers

access sqlite db python

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.