Python SQLite ORM

In this Python SQLite tutorial we are going to learn about Python SQLite ORM, so Python is popular programming language for building web applications, data analysis and scientific computing. and the best feature that Python has is that we can work with different types of databases. SQLite is lightweight database engine that can be embedded in Python applications. Object Relational Mapping or ORM is a programming technique that allows developers to work with databases using objects instead of SQL statements. in this article we want to talk about SQLite ORM in Python.

 

 

What is SQLite ORM ?

SQLite ORM is a Python library that provides a way to map Python objects to database tables. it allows developers to work with databases using high level objects instead of writing low level SQL statements. with SQLite ORM you can create, read, update and delete (CRUD) records in a database without writing any SQL.

 

How to Use SQLite ORM in Python ?

For using SQLite ORM in Python, we need to install a library called SQLAlchemy. you can install it using pip:

 

 

After that you have installed SQLAlchemy, you can start using it to create a database and map Python objects to database tables, in this example we have created a User class that inherits from the declarative_base() class provided by SQLAlchemy. after that we define the tablename attribute to specify the name of the database table that corresponds to this class. we also defines three columns id, name and age. after that we creates an engine object that connects to a SQLite database called example.db. and lastly we call create_all() method on the metadata object to create the table in the database.

 

 

Run the code you will see the database with table, but for right now we don’t have any data on that.

Python SQLite ORM
Python SQLite ORM

 

 

For adding a new record to the database, we can create a User object and adds it to a session, in this example we have created a session object by calling sessionmaker() function and passing in the engine object. after that we creates a new User object and add it to the session using add() method. and lastly we call the commit() method to save the changes to the database.

 

 

Run the code and we have added two records in our table.

Python SQLite ORM
Python SQLite ORM

 

 

For retrieving records from the database, we can use query() method, in this example we have used the query() method to retrieve all records from the users table. after that we loop over the results and print out the id, name and age of each record.

 

 

 

This will be the result

SQLite ORM
SQLite ORM

 

 

Learn More

Leave a Comment