# Python SQLite API

###### tags: `Python Notes`

## Importing SQLite in Python

import sqlite3
from sqlite3 import Error

## Getting connection

# after importing
conn = sqlite3.connect(db_name)
# db_name is the name of database

## Executing a SQLite statement

# after connecting
c = conn.cursor() # this is essential before executing any statement
c.execute(stmt)
# stmt is a full SQLite statement

## Executing a SQLite prepared Statement

# after connecting
c.execute(pstmt, values)
# pstmt is a SQLite prepared statement
# value is a tupple

## Comminting changes
When to commit: edit, delete, alter table
When not needed: query, creating table

# after executing 
conn.commit()

## Closing connecion

Always close connection after using. Do not try to use after colsing.

# use database here
# after using
conn.close()
# do not use database here

## Error handing

try:
    # connetion, cursor, execution
except Error as e:
    print(e)
finally:
    #close connection

|Made with :hearts: by [Kavyas](https://hackmd.io/team/kavyas "View our other notes")|
|-|
|Learn SQLite on https://www.sqlitetutorial.net/|