pfalcon/pycopy-btreedb

Very simple ORM for Pycopy's btree module

btreedb is a simple ORM-like wrapper for Pycopy's btree module.

Note that it's recommended to use the btree module directly, but if you want to build an abstraction on top of it, btreedb may show an example of doing that.

For more information, see https://github.com/pfalcon/picoweb .

An example application where this module is used is https://github.com/pfalcon/notes-pico .

pycopy-btreedb's Issues

Example, docs ?

Hi,

The project sounds interesting and I am trying to make it work for my uses (esp32).
However, even if code is simple, reverse eng. isn't very fun :)

Do you have a little example or doc stub for this package ?

Thanks,
Jonathan

Example use

from . import db
from .db import EasyDB

db.db.connect()

db.EasyDB.create_table()

upy_id = db.EasyDB.create(test=1)
upy_id = db.EasyDB.create(test=2)
upy_id = db.EasyDB.create(test=3)

pkey='2017-09-26 00:04:34'
db.EasyDB.delete({"timestamp": pkey})

pkey='2017-09-26 00:06:54'
upy_id = db.EasyDB.get_id(pkey)

upy_id = db.EasyDB.select(test=1)
print(list(upy_id))

upy_id = db.EasyDB.scan()
print(list(upy_id))

db.db.close()

Example use: EasyDB

from ucollections import OrderedDict
import ujson
import utime

import btreedb as uorm
import btree

db = uorm.DB("test.db")

class EasyDB(uorm.Model):

# Create controller table
__db__ = db
__table__ = "testtable"
__schema__ = OrderedDict([
    ("timestamp", ("TIMESTAMP", uorm.now)),
    ("test", ("INT", 0)),
])

Example

From an ex-Oracle girl:

• Two additonal functions: Delete and Select
• Example ('example use' and 'example use: easydb', save the latter as db.py)
  It's almost Oracle now... ;-)

Additional functions: Delete and Select

@classmethod
def delete(cls, where, **fields):
    pkey_field = cls.__fields__[0]
    assert len(where) == 1 and pkey_field in where
    #print("update:", where)

    db = cls.__db__.db
    pkey = where[pkey_field]
    del(db[pkey])
    db.flush()

@classmethod
def select(cls, **fields):
    for v in cls.__db__.db.values():
        row = cls.Row(*ujson.loads(v))
        i = 0
        for k in cls.__fields__:
            if k in fields:
               if row[i] == fields[k]:
                  yield row
            i += 1