PYTHON PROGRAM THAT USE DB SQLITE CODE

Inside this function, we have a try block where the connect() function is returning a connection object after establishing the connection. Print('Connection is established: Database is created in memory')įirst, we import the sqlite3 module, then we define a function sql_connection.

PYTHON PROGRAM THAT USE DB SQLITE CODE

This database is called in-memory database.Ĭonsider the code below in which we have created a database with a try, except and finally blocks to handle any exceptions: import sqlite3 This database file is created on disk we can also create a database in RAM by using :memory: with the connect function. When you create a connection with SQLite, that will create a database file automatically if it doesn’t already exist. Now we can use the cursor object to call the execute() method to execute any SQL queries. To execute the SQLite3 statements, you should establish a connection at first and then create an object of the cursor using the connection object as follows: con = nnect('mydatabase.db') The SQLite3 cursor is a method of the connection object. You can create it using the cursor() method. To execute SQLite statements in Python, you need a cursor object.

That will create a new file with the name ‘mydatabase.db’.

You can a connection object using the connect() function: import sqlite3 To use SQLite3 in Python, first of all, you will have to import the sqlite3 module and then create a connection object which will connect us to the database and will let us execute the SQL statements.

Python program that use db sqlite