Connect SQLite with Python
First you have to install Python and SQLite on your syatem.
Install Python
Use the following code:
Press y and installation will be completed within seconds.
Install SQLite
Installation steps
type in the following command:
After installation check installation, sqlite terminal will give you a prompt and version info ?
Go to desired folder and create database:
sqlite3 database.db
It’ll create database.db in the folder you’ve given the command.
To check if your database is created, use the following command in sqlite3 terminal:
Note: To connect SQLite with Python, you do not need to install the connection module separately because its being shipped by default along with Python version 2.5.x onwards.
SQLite with Python
Create a python file “connect.py”, having the following code:
Execute the following statement on command prompt:
Now connection is created with the tutoraspire database. Now you can create a table.
Create a table
Create a table “Employees” within the database “tutoraspire”.
Create a python file “createtable.py”, having the following code:
Execute the following statement on command prompt:
A table “Employees” is created in the “tutoraspire” database.
Insert Records
Insert some records in “Employees” table.
Create a python file “connection.py”, having the following code:
Execute the following statement on command prompt:
Records are inserted successfully.
Select Records
Now you can fetch and display your records from the table “Employees” by using SELECT statement.
Create a python file “select.py”, having the following code:
Execute the following statement on command prompt:
See all the records you have inserted before.
By same procedures, you can update and delete the table in SQLite database usnig Python.