Python SQLModel.Text Examples

Example #1

File: groups.py Project: Vuader/tradius

class tradius_group(SQLModel):
    id = SQLModel.Uuid(default=uuid4, internal=True)
    domain = SQLModel.Fqdn(internal=True)
    name = SQLModel.String(max_length=64, null=False)
    description = SQLModel.Text()
    creation_time = SQLModel.DateTime(default=now, readonly=True)
    primary_key = id

Example #2

File: newsletter.py Project: Vuader/tachweb

class newslist(SQLModel):
    id = SQLModel.Uuid(default=uuid4, internal=True)
    email = SQLModel.Email(null=False)
    name = SQLModel.Text()
    creation_time = SQLModel.DateTime(default=now, readonly=True)
    primary_key = id
    unique_email = SQLModel.UniqueIndex(email)
    db_default_rows = EMAILS

Example #3

File: roles.py Project: Vuader/infinitystone

class luxon_role(SQLModel):
    id = SQLModel.Uuid(default=uuid4, internal=True)
    name = SQLModel.String(max_length=64, null=False)
    description = SQLModel.Text()
    creation_time = SQLModel.DateTime(default=now, readonly=True)
    primary_key = id
    unique_role = SQLModel.UniqueIndex(name)
    db_default_rows = ROLES
    roles = SQLModel.Index(name)

Example #4

File: domains.py Project: Vuader/infinitystone

class luxon_domain(SQLModel):
    id = SQLModel.Uuid(default=uuid4, internal=True)
    name = SQLModel.Fqdn(null=False)
    description = SQLModel.Text()
    enabled = SQLModel.Boolean(default=True)
    creation_time = SQLModel.DateTime(default=now, readonly=True)
    primary_key = id
    unique_domain = SQLModel.UniqueIndex(name)
    db_default_rows = DOMAINS
    domains = SQLModel.Index(name)

Example #5

class Model_Test2(SQLModel):
    id = SQLModel.Integer(length=11, null=True)
    primary_key = id
    stringcol = SQLModel.String(length=128)
    floatcol = SQLModel.Float(4,4)
    doublecol = SQLModel.Double(4,4)
    decimalcol = SQLModel.Decimal(4,4)
    datetimecol = SQLModel.DateTime(4,4)
    pyobject = SQLModel.PyObject()
    blob = SQLModel.Blob()
    text = SQLModel.Text()
    enum = SQLModel.Enum('option1', 'option2')
    boolean = SQLModel.Boolean()
    unique_index2 = SQLModel.UniqueIndex(stringcol)

Example #6

File: nas.py Project: Vuader/subscriber

class tradius_nas(SQLModel):
    id = SQLModel.Uuid(default=uuid4, internal=True)
    virtual_id = SQLModel.Uuid(internal=True)
    domain = SQLModel.Fqdn(internal=True)
    name = SQLModel.Word(max_length=64, null=False)
    nas_type = SQLModel.String(max_length=64, null=False)
    secret = SQLModel.String(max_length=64, null=False)
    server = SQLModel.String(max_length=64, null=False)
    description = SQLModel.Text()
    creation_time = SQLModel.DateTime(default=now, readonly=True)
    nas_virtual_ref = SQLModel.ForeignKey(virtual_id, tradius_virtual.id)
    virtual_index = SQLModel.Index(virtual_id)
    nas_index = SQLModel.Index(server)
    primary_key = id
    unique_group = SQLModel.UniqueIndex(server)

Example #7

File: nas.py Project: TachyonicProject/calabiyau

class calabiyau_nas(SQLModel):
    id = SQLModel.Uuid(default=uuid4, internal=True)
    virtual_id = SQLModel.Uuid(internal=True)
    name = SQLModel.Word(max_length=64, null=False, regex=r'^[a-z0-9\._-]+$')
    nas_type = SQLModel.Word(max_length=64,
                             upper=True,
                             null=False,
                             regex=r'^[a-z0-9\._-]+$')
    secret = SQLModel.String(max_length=64, null=False)
    server = SQLModel.Ip4(null=False)
    description = SQLModel.Text()
    creation_time = SQLModel.DateTime(default=now, readonly=True)
    nas_virtual_ref = SQLModel.ForeignKey(virtual_id, calabiyau_virtual.id)
    nas_virtual_index = SQLModel.Index(virtual_id)
    nas_server_index = SQLModel.Index(server)
    nas_unique = SQLModel.UniqueIndex(server)
    primary_key = id