basedb 0.2.0

Low-level MariaDB/MySQL table abstraction layer

basedb

basedb is a thin, pure-Python abstraction layer over MariaDB/MySQL. It provides Column, Row, Table, and Database base classes that handle DDL generation, value marshalling, and connection management — without hiding the SQL.

Installation

pip install basedb

Quick Start

Subclass Row to define your schema, then subclass Table to wrap it:

from basedb.database import Database
from basedb.row import Row
from basedb.table import Table

class MyRow(Row):
    def get_col_def(self):
        defs = [
            {'name': 'id',    'type': int, 'length': 4,  'primary': True,
             'autoincrement': True},
            {'name': 'label', 'type': str, 'length': 64, 'notNull': True},
            {'name': 'value', 'type': float},
        ]
        cols, _ = self.define_cols(defs)
        return cols

class MyTable(Table):
    def __init__(self, db):
        self.row = MyRow()
        super().__init__(db, 'my_table', columns=self.row.get_col_def())
        self.row = MyRow()

db = Database(host='localhost', user='dqr', password='s3cr3t', database='mydb')

t = MyTable(db)
t.create(ifnotexists=True)

row = MyRow()
row.set({'label': 'alpha', 'value': 3.14})
t.insert(row)
db.commit()

results = t.select(where='label = "alpha"')
print(results[0]['value'])   # → 3.14

db.close()

Documentation

Full documentation — including a column type reference and a detailed subclassing guide — is available at:

https://dqr-builder.docs.ligo.org/dqr_basedb/

License

basedb is distributed under the GNU General Public License v3 or later.