Introduction When you code in a Django web framework, we all know that you won’t directly work with databases. There is an ORM (Object-relational mapping) that will interact with the database using migration and SQL operation. So, I want this tutorial to show you how to implement an ORM manager from scratch. ( ) in computer science is a technique for converting data between incompatible type systems using object-oriented programming languages in order to create virtual database objects. Object–relational mapping ORM Python is a programming language that enables you to design freely anything that you want. And honestly, I was able to implement a Mini ORM manager merely within 3 hours. Notice This project doesn’t contain a lot of features that a complete ORM contains (features like RUD). The purpose of this code is mainly to know how an ORM works, there is no intention to use it for further development. Project Design Our Project is divided into 3 main components: A connection manager to connect directly with a database using SQL commands (we used SQLite3 in our case). A model manager or model file that contains all the definitions of the models we need to migrate to a database. A simple command manager that enables users to input a command (in the command prompt). The Project files are also 3 python files (check this ): Github repository Python file Functionality migrate_manager.py Command manager base.py Model manager db_manager.py Database manager Database manager We mentioned before that we will use SQLite database. Thanks to the python sqlite3 default library, we can connect directly with a database using a python script. If you check the documentation of , you will notice that it is very easy to connect SQLite using python. sqlite3 library Just a few lines of python code will do the job. So, you need to instantiate an sqlite3 connection object with specifying the database file “ ”, then make a cursor to execute SQL commands without forgetting to commit the changes and to close the connection. example.db First, import the sqlite3 library and instantiate the connection: import sqlite3
con = sqlite3.connect('example.db') Then open a cursor, execute the commands you want and finally close the connection: cursor= con.cursor()
cursor.execute('''CREATE TABLE stocks (date text, trans text, symbol text, qty real, price real)''')
cursor.execute("INSERT INTO stocks VALUES ('2006-01-05','BUY','RHAT',100,35.14)")
connection.commit()
connection.close() However, this kind of implementation won’t be reliable in our project, because there is too much redundancy of this block of code. Imagine I will repeat this code with every SQL operation I use including CREATE, DELETE, UPDATE and RETRIEVE. In fact, this problem has a solution, there is a thing in python called context manager. A context manager is a way to manage resources precisely without any cost in complexity and memory. In order to make a context manager that can connect with a database, we make a class called that opens an SQL connection and instantiates the cursor object. ConnectionSqliteManager In this class, we need to write an and magic class methods as a necessary ingredient for database resource management. __enter__ __exit__ So the structure of the context manager class is as follows : The method connects the file (setup operation) and returns the object to variable . __enter__ example.db Connection Connection The method takes care of closing the connection on exiting the block(teardown operation). __exit__ with class ConnectionSqliteManager:
    def __init__(self,filename):
        self.filename = filename

    def __enter__(self):
        print("Connection started ...")
        self.connection = sql3.connect(self.filename)
        self.cursor = self.connection.cursor()
        return self  
    def __exit__(self, type, value, traceback):
        print("Connection ended ...")
        self.connection.close()

with ConnectionSqliteManager("example.db") as Connection:
    # Do what you want with Connection instance In the scope , you manage the database within the scope, without taking the bother of opening and closing the connection manager. with You can make a decorator (Inside “ConnectionSqliteManager” class) on top of each SQL operation method, to commit the changes. Never forget to add some sqlite3 error exception in each command execution. #inside ConnectionSqliteManager class
def commit(operation):
        def wrapper(self, *args,**kwargs):
            operation(self, *args, **kwargs)
            self.connection.commit()
        return wrapper
@commit
def Sql_operation(self):
    # execute an sql command here
    pass Model manager A model is a datastore entity that has a key and a set of properties. . A is a Python class that inherits from the class. The model class defines a new kind of datastore entity and the properties the kind is expected to take. model Model I won’t dive into too much implementation here. all you have to do is to define a model class like the following: class Model(baseModel):
    base_model = base
    tablename = "Model"
    fields = ("field_1", "field_2") In this code, you need to specify the name of the table of the database and its fields. In order to prepare your for migration, you have to add it in the list. model model_list model_list = [Model,
              ] Command Manager Now let’s prepare the user for a good interface in our command prompt. To implement it, we used the library to let the user input the arguments in the command prompt and execute the migration. argparse default All details are in the , there is no need to explain each line of code. I made it as simple as possible. migrate_manager.py file So all you have to do is to execute this command. python migrate_manager.py migrate The output is as following: Begin database Migration ...

Model Migration
Connection started ...
Model: created successfully!
2022-01-04 02:29:53.402991: Commit is successful!!
Connection ended ... Conclusion It’s good to implement a technique like ORM from scratch, it will help you understand and learn technologies quickly without any difficulties in grasping the concept behind it.

Build your Own ORM from Scratch With Python

About Author

Comments

TOPICS

THIS ARTICLE WAS FEATURED IN

Related Stories

Untitled Story

A Practical Guide to Interfaces in Golang

10 Ways to Optimize Your Database

10 Ways to Reduce Data Loss and Potential Downtime Of Your Database

10 Principles of Proper Database Benchmarking

10 Minute Guide to Fixing Damaged SQL Databases - No Recovery Required!

A Practical Guide to Interfaces in Golang

10 Ways to Optimize Your Database

10 Ways to Reduce Data Loss and Potential Downtime Of Your Database

10 Principles of Proper Database Benchmarking

10 Minute Guide to Fixing Damaged SQL Databases - No Recovery Required!

Light-Mode

Classic

Newspaper

Dark-Mode

Neon Noir

Minty

HN StartUps