Data Types (SQLite)

Embar provides support for SQLite data types. All types are imported from embar.column.sqlite and embar.column.common.

SQLite has a flexible type system. These column types provide the standard SQLite type affinities.

Integer

Integer values.

from embar.column.common import Integer, integer
from embar.table import Table

class Product(Table):
    quantity: Integer = integer()

Generates:

"quantity" INTEGER

Text

Variable-length text.

from embar.column.common import Text, text

class User(Table):
    email: Text = text()

Generates:

"email" TEXT

Float

Floating point values (stored as REAL in SQLite).

from embar.column.common import Float, float_col

class Measurement(Table):
    temperature: Float = float_col()

Generates:

"temperature" REAL

Blob

Binary data storage.

from embar.column.sqlite import Blob, blob

class Document(Table):
    file_data: Blob = blob()

# Usage
doc = Document(file_data=b"binary content here")
async def main():
    await db.insert(Document).values(doc)

Generates:

"file_data" BLOB

Common Column Options

All column types support these options:

Primary Key

class User(Table):
    id: Integer = integer(primary=True)

Not Null

class User(Table):
    email: Text = text(not_null=True)

Default Values

class User(Table):
    status: Text = text(default="active")

Custom Column Name

class User(Table):
    email: Text = text("user_email")