nonsqlite

Non SQL Database over SQLite3

Getting Started

$ pip install nonsqlite

This package install nonsqlite and Object modules

Object Module

Micro ORM Framework

Create a new Object collection

from nonsqlite.Object import Object


class Person(Object):
  def __init__(self):
    self.name = ''
    self.age  = 0

Specify the database to save the collection

Person._db_name = 'db.db'

If the _db_name is omitted, Object use the default database: Object.db in the current directory

Save a new Object in collection

a = Person()
a.name = 'Piter'
a.age  = 21
a.save()

Load the object from a json

a = Person.loads(json)
a.save()

Query Objects in collection

• Get one object

a = Person.get({'name': 'Piter'})
print a.name

• Get list of coincidences: filter({}, limit=, sort=), filterAND([{}]), filterOR([{}])

a = Person.filter({'name': 'Piter'}, sort='-age') # Order by age desc
for i in a:
  print i.name

a = Person.filterAND([{'name': 'Piter'}, {'age': 21}])
for i in a:
  print i.name

• Wildcard $

a = Person.filter({'$': 'Piter'})

Delete an Object in collection

a = Person.get({'name': 'Piter'})
a.delete()

Drop all Objects in collection

Person.drop()

Count Objects with Occurrences

n = Person.count({'name': 'Piter'})

Count all Objects in Collection

n = Person.len()