How can I connect to SQLite using Python?

This article describes steps to connect to SQLite using Python.

Getting connect to SQLite using Python :

The features required to access and operate with SQLite databases are all included in the sqlite3 module, which is a component of Python’s standard library. There are no vendor-specific modules that need to be installed in order to use SQLite with Python.

The code below shows how to use the sqlite3 module to connect to a SQLite database and perform some common manipulations:

#!/usr/bin/python

from sqlite3 import connect

# Replace username with your own Hostvento account username:
conn = connect('/home/username/test.db')
curs = conn.cursor()

curs.execute("CREATE TABLE employees (firstname varchar(32), lastname varchar(32), title varchar(32));")
curs.execute("INSERT INTO employees VALUES('Courtney', 'Kem', 'Engineer');")
conn.commit()

curs.execute("SELECT lastname FROM employees;")
for (name) in curs.fetchall():
print name

conn.close()

In this example shown, we have first created a Connection object that will open SQLite database. In case the test.db file exists already, Python will open that file. Otherwise, Python will create a new database in the test.db.

Once we get a Connection object associated with the database, next we can create a Cursor object. The Cursor object allows us to run the execute() method, which then allows us to run raw SQL statements (like CREATE TABLE, SELECT, etc).

At-last, we can call the close() method in-order to close the connection to the database.

For more information about sqlite3 method, visit this :

https://docs.python.org/2/library/sqlite3.html

Learn to configure and download Raw access logs in cPanel
Using cPanel Site Publisher to build website easily
What Is DNS Propagation?