Product
Introducing License Enforcement in Socket
Ensure open-source compliance with Socket’s License Enforcement Beta. Set up your License Policy and secure your software!
This project is a simple, stand-alone and lightweight implementation of an Object Relational Mapper (ORM) for Python. The ORM is a library that allows developers to interact with a relational database using Python objects. The ORM will handle the mapping of Python objects to database tables and vice versa.
You can install the ORM by running the following command:
pip install borm
The first step to is to design your models (tables). For each model you can inherit from models.Model
and define its
fields as class attributes of available fields from the fields
module.
from borm import Model
from borm.fields import UUIDField, StringField, IntegerField
class MyModel(Model):
id = UUIDField(primary_key=True)
name = StringField()
rating = IntegerField()
As appears in the example above, you can define the primary key by setting the primary_key
attribute to True
in
only one field. Then you can start data manipulation by creating instances of your models, etc.
from uuid import uuid4
id_1 = uuid4()
my_model = MyModel.objects.create(id=id_1, name='My Model', rating=5)
print(my_model.id)
print(my_model.name)
print(my_model.rating)
id_2 = uuid4()
my_model_2 = MyModel.objects.create(id=id_2, name='My Model 2', rating=4)
print(my_model_2.id)
print(my_model_2.name)
print(my_model_2.rating)
models = MyModel.objects.all()
for model in models:
print(model.id)
print(model.name)
print(model.rating)
specific_model = MyModel.objects.get(id=id_1)
print(specific_model.id)
models_with_rating_4 = MyModel.objects.filter(rating=4)
for model in models_with_rating_4:
print(model.id)
print(model.name)
print(model.rating)
Furthermore, you may manipulate and update the data in the database by updating the fields of the model instances and
calling the save
method to apply the changes to the database.
my_model.rating = 3
my_model.save()
Finally, you can delete a model instance by calling the delete
method.
my_model._delete()
TODO
FAQs
Simple lightweight Django-like ORM for SQLite
We found that borm demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Product
Ensure open-source compliance with Socket’s License Enforcement Beta. Set up your License Policy and secure your software!
Product
We're launching a new set of license analysis and compliance features for analyzing, managing, and complying with licenses across a range of supported languages and ecosystems.
Product
We're excited to introduce Socket Optimize, a powerful CLI command to secure open source dependencies with tested, optimized package overrides.