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
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
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)
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)
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)
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)
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