NotAOrm 1.0.1

A sample python library for managing a SQLite database

NotAOrm

A sample python library for managing a SQLite database

Download and Install

pip install notaorm or git clone https://github.com/ludel/notaorm.git in your project

There are no hard dependencies other than the Python standard library. notaorm run with python 3.6+.

Doc

Data types list

SQL	Python	lib	Args	Note
INTEGER	int	Int	not_null, unique, default, primary_key	Automatic incrementation is activated when the primary_key argument is true
FLOAT	float	Float	not_null, unique, default
VARCHAR	str	Varchar	not_null, unique, default, length	By default length is 255
TEXT	str	Text	length, not_null, unique, default	By default length is 5000
DATE	datetime.date	Date	not_null, unique, default	if default argument is set to now, the date will be automatically generate
TIMESTAMP	datetime.datetime	Datetime	not_null, unique, default	Same as Date
BOOLEAN	bool	Bool	not_null, unique, default

Examples

Create a new model

import notaorm
from notaorm.table import Table
from notaorm.datatype import Int, Varchar, Date

notaorm.database = 'test.db'


site = Table('site', table_row=(Int('id', primary_key=True, not_null=True),
                                Varchar('url', length=255, unique=True, not_null=True),
                                Int('visitor', default=0),
                                Date('last_check', default='now')))

site.create()

Show methods

Get one element

site.show.get(site.url == 'google.com')

or if we want specific columns

site.show.get(site.url == 'google.com', columns=[site.url, site.last_check])

Get all elements

all_sites = site.show.all()
for site in all_sites:
    print('=>', site.id, site.url, site.visitor, site.last_check, sep='\t')

We can order and limit the request

order_asc_sites = site.show.all(order_by=site.last_check, limit=3)
order_desc_sites = site.show.all(order_by_desc=site.last_check, limit=3)

Filter by where clause

filter_sites = site.show.filter(site.visitor >= 10, site.id)
for site in filter_sites:
    print('=>', site.id, sep='\t')

With several conditions

condition_or = (site.visitor >= 10) | (site.id > 2)
site.show.filter(condition_or, site.id)

condition_and = (site.visitor >= 10) & (site.id > 2)
site.show.filter(condition_and, site.id)

Group by and math methods

By SUM

sites_visitor = site.show.all(site.visitor.sum, group_by=site.last_check)

By COUNT

sites_count = site.show.all(site.visitor.count, group_by=site.last_check)

Change methods

Insert

site.change.insert(url='google.com')

Update

site.change.update(site.url.is_like('bing%'), url='google.com')

Delete

site.change.delete(site.visitor == 0, commit=True)

By default in the delete method, commit is set to false

License

notaorm is MIT licensed.