DEV Community

Discussion on: Battery Included Philosophy, python

Collapse
 
yusufadel profile image
YusufAdel

I'll start with,
The sqlite3 module is a wrapper for the SQLite database library, providing a persistent database that can be updated and accessed using slightly nonstandard SQL syntax.

The code needed to make a database connections:
import sqlite3
con = sqlite3.connect('example.db')

create a cursor:
cur = con.cursor()

Now we can excute SQL statment:
cur.execute('''CREATE TABLE stocks
(date text, trans text, symbol text, qty real, price real)''')

Don't forget to close db connection
cur.close()

Full code:

import sqlite3

con = sqlite3.connect('example.db')
cur = sqlite3.curser()

cur.excute("")

cur.close

For further reading Here are sqlite3 official docs