Connect SQLite with Python

First you have to install Python and SQLite on your syatem.

Install Python

Use the following code:

<br />
sudo apt-get update<br />
sudo apt-get upgrade python<br />

SQLite Connect sqlite with python 1

Press y and installation will be completed within seconds.

Install SQLite

Installation steps

type in the following command:

<br />
sudo apt-get install sqlite3 libsqlite3-dev<br />

After installation check installation, sqlite terminal will give you a prompt and version info ?

<br />
sqlite3<br />

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:

<br />
.databases<br />

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:

<br />
#!/usr/bin/python</p>
<p>import sqlite3</p>
<p>conn = sqlite3.connect(‘javatpoint.db’)</p>
<p>print “Opened database successfully”;<br />

Execute the following statement on command prompt:

<br />
python connect.py<br />

SQLite Connect sqlite with python 2

Now connection is created with the javatpoint database. Now you can create a table.

Create a table

Create a table “Employees” within the database “javatpoint”.

Create a python file “createtable.py”, having the following code:

<br />
#!/usr/bin/python</p>
<p>import sqlite3</p>
<p>conn = sqlite3.connect(‘javatpoint.db’)<br />print “Opened database successfully”;</p>
<p>conn.execute(”’CREATE TABLE Employees<br />       (ID INT PRIMARY KEY     NOT NULL,<br />       NAME           TEXT    NOT NULL,<br />       AGE            INT     NOT NULL,<br />       ADDRESS        CHAR(50),<br />       SALARY         REAL);”’)<br />print “Table created successfully”;</p>
<p>conn.close()<br />

Execute the following statement on command prompt:

<br />
python createtable.py<br />

SQLite Connect sqlite with python 3

A table “Employees” is created in the “javatpoint” database.

Insert Records

Insert some records in “Employees” table.

Create a python file “connection.py”, having the following code:

<br />
#!/usr/bin/python</p>
<p>import sqlite3</p>
<p>conn = sqlite3.connect(‘javatpoint.db’)<br />print “Opened database successfully”;</p>
<p>conn.execute(“INSERT INTO Employees (ID,NAME,AGE,ADDRESS,SALARY) /<br />      VALUES (1, ‘Ajeet’, 27, ‘Delhi’, 20000.00 )”);</p>
<p>conn.execute(“INSERT INTO Employees (ID,NAME,AGE,ADDRESS,SALARY) /<br />      VALUES (2, ‘Allen’, 22, ‘London’, 25000.00 )”);</p>
<p>conn.execute(“INSERT INTO Employees (ID,NAME,AGE,ADDRESS,SALARY) /<br />      VALUES (3, ‘Mark’, 29, ‘CA’, 200000.00 )”);</p>
<p>conn.execute(“INSERT INTO Employees (ID,NAME,AGE,ADDRESS,SALARY) /<br />      VALUES (4, ‘Kanchan’, 22, ‘Ghaziabad ‘, 65000.00 )”);</p>
<p>conn.commit()<br />print “Records inserted successfully”;<br />conn.close()<br />

Execute the following statement on command prompt:

<br />
python connection.py<br />

SQLite Connect sqlite with python 4

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:

<br />
#!/usr/bin/python</p>
<p>import sqlite3</p>
<p>conn = sqlite3.connect(‘javatpoint.db’)</p>
<p>data = conn.execute(“select * from Employees”);</p>
<p>for row in data:<br />   print “ID = “, row[0]<br />   print “NAME = “, row[1]<br />   print “ADDRESS = “, row[2]<br />   print “SALARY = “, row[3], “/n”</p>
<p>conn.close();<br />

Execute the following statement on command prompt:

<br />
python select.py<br />

SQLite Connect sqlite with python 5

See all the records you have inserted before.

By same procedures, you can update and delete the table in SQLite database usnig Python.

原创文章，作者：ItWorker，如若转载，请注明出处：https://blog.ytso.com/263756.html

Connect SQLite with Python

Connect SQLite with Python

Install Python

Install SQLite

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 table

Insert Records

Select Records

相关推荐

发表回复