How to Execute a SQLite Statement in Python?

In this article, we are going to see how to execute SQLite statements using Python. We are going to execute how to create a table in a database, insert records and display data present in the table.

In order to execute an SQLite script in python, we will use the execute() method with connect() object:

connection_object.execute(“sql statement”)

Approach:

To perform the execution, we have to follow the below steps:

• Import sqlite3 module. This statement will import SQLite module, import keyword is used to import a module in python.

import sqlite3

• Create a connection to the database. This will create a new database by connecting the database, here we have to specify the database name and connect to it using a cursor object.

connection_object = sqlite3.connect('database_name.db')

• Execute query connection object. Here we need to execute the connection object by specifying the SQL statement.

connection_object.execute("sql statement");

• Finally terminate the connection using the close() method.

connection_object.close();

Example 1: Python code to create a database and a table, below are the steps:

• Importing sqlite3 module
• Create a connection by using an object to connect with the college_details database
• SQLite execute a query to create a table

Python3

# importing sqlite3 module
import sqlite3

# create connection by using object to
# connect with college_details database
connection = sqlite3.connect('college.db')


# sqlite execute query to create a table
connection.execute("""create table college(
        geek_id,
        geek_name,
        address
    );""")

print("Table created successfully")

# terminate the connection
connection.close()

Output:

Database created:

Example 2: Python code to insert and display data into the above-created table.

Python3

# importing sqlite3 module
import sqlite3

# create connection by using object
# to connect with college_details
# database
connection = sqlite3.connect('college.db')

# sqlite execute query to insert a table
connection.execute(
    '''insert into college values ( '7058', 'sravan kumar','hyd' )''')
connection.execute(
    '''insert into college values ( '7059', 'jyothika','tenali' )''')
connection.execute(
    '''insert into college values ( '7072', 'harsha verdhan','nandyal' )''')
connection.execute(
    '''insert into college values ( '7099', 'virinchi','Guntur' )''')

# sqlite execute query to display data
# in the college
a = connection.execute("select * from college")

# fetch all records
print(a.fetchall())

# terminate the connection
connection.close()

Output: