class tradius_accounting(SQLModel):
id = SQLModel.Uuid(default=uuid4, internal=True)
acctsessionid = SQLModel.String(max_length=64, null=False, default='')
acctuniqueid = SQLModel.String(max_length=32, null=False, default='')
username = SQLModel.String(max_length=64, null=False, default='')
realm = SQLModel.String(max_length=64, null=True, default='')
nasipaddress = SQLModel.String(max_length=15, null=False, default='')
nasportid = SQLModel.String(max_length=15, null=True, default=None)
nasporttype = SQLModel.String(max_length=32, null=True, default=None)
acctstarttime = SQLModel.DateTime()
acctupdatetime = SQLModel.DateTime()
acctstoptime = SQLModel.DateTime()
acctinterval = SQLModel.Integer(null=True, default=None)
acctsessiontime = SQLModel.Integer(signed=False, null=True, default=None)
acctauthentic = SQLModel.String(null=True, default=None, max_length=32)
connectinfo_start = SQLModel.String(max_length=50, null=True, default=None)
connectinfo_stop = SQLModel.String(max_length=50, null=True, default=None)
acctinputoctets = SQLModel.BigInt(null=True, default=None)
acctoutputoctets = SQLModel.BigInt(null=True, default=None)
calledstationid = SQLModel.String(max_length=50, null=False, default='')
callingstationid = SQLModel.String(max_length=50, null=False, default='')
acctterminatecause = SQLModel.String(max_length=32, null=False, default='')
servicetype = SQLModel.String(max_length=32, default=None, null=True)
framedprotocol = SQLModel.String(max_length=32, default=None, null=True)
framedipaddress = SQLModel.String(max_length=15, default='', null=False)
primary_key = id
acctuniqueid_index = SQLModel.UniqueIndex(acctuniqueid)
username_index = SQLModel.Index(username, nasipaddress)
framedipaddress_index = SQLModel.Index(framedipaddress, nasipaddress)
acctsessionid_index = SQLModel.Index(acctsessionid)
acctsessiontime_index = SQLModel.Index(acctsessiontime)
acctstarttime_index = SQLModel.Index(acctstarttime)
acctinterval_index = SQLModel.Index(acctinterval)
acctstoptime_index = SQLModel.Index(acctstoptime)
nasipaddress_index = SQLModel.Index(nasipaddress)
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 luxon_endpoint(SQLModel):
id = SQLModel.Uuid(default=uuid4, internal=True)
name = SQLModel.Fqdn(max_length=64, null=False)
interface = SQLModel.Enum('public', 'internal', 'admin', null=False)
region = SQLModel.String(max_length=64, null=False)
uri = SQLModel.Uri(max_length=64, null=False)
creation_time = SQLModel.DateTime(default=now, internal=True)
primary_key = id
unique_endpoint = SQLModel.UniqueIndex(interface, uri)
endpoint_name = SQLModel.Index(name)
endpoint_find = SQLModel.Index(name, interface)
endpoint_exact = SQLModel.Index(name, interface, region)
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 luxon_tenant(SQLModel):
id = SQLModel.Uuid(default=uuid4, internal=True)
domain = SQLModel.Fqdn(internal=True)
tenant_id = SQLModel.Uuid(internal=True)
name = SQLModel.String(max_length=100, null=False)
enabled = SQLModel.Boolean(default=True)
creation_time = SQLModel.DateTime(default=now, readonly=True)
unique_tenant = SQLModel.UniqueIndex(domain, name)
tenants = SQLModel.Index(id, domain)
tenants_search_name = SQLModel.Index(domain, name)
tenants_per_domain = SQLModel.Index(domain)
primary_key = id
tenant_domain_ref = SQLModel.ForeignKey(domain, luxon_domain.name)
tenant_parent_ref = SQLModel.ForeignKey(tenant_id, id)
class luxon_user_role(SQLModel):
id = SQLModel.Uuid(default=uuid4, internal=True)
role_id = SQLModel.Uuid()
domain = SQLModel.Fqdn(internal=True)
tenant_id = SQLModel.String()
user_id = SQLModel.Uuid()
creation_time = SQLModel.DateTime(readonly=True, default=now)
unique_user_role = SQLModel.UniqueIndex(role_id, tenant_id, user_id)
user_role_id_ref = SQLModel.ForeignKey(role_id, luxon_role.id)
user_role_domain_ref = SQLModel.ForeignKey(domain, luxon_domain.name)
user_role_tenant_ref = SQLModel.ForeignKey(tenant_id, luxon_tenant.id)
user_roles = SQLModel.Index(domain, tenant_id)
primary_key = id
db_default_rows = USER_ROLES
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
class luxon_user(SQLModel):
id = SQLModel.Uuid(default=uuid4, internal=True)
tag = SQLModel.String(hidden=True, max_length=30, null=False)
domain = SQLModel.Fqdn(internal=True)
tenant_id = SQLModel.Uuid(internal=True)
username = SQLModel.Username(max_length=100, null=False)
password = SQLModel.String(max_length=100, null=True)
email = SQLModel.Email(max_length=255)
name = SQLModel.String(max_length=100)
phone_mobile = SQLModel.Phone()
phone_office = SQLModel.Phone()
designation = SQLModel.Enum('', 'Mr', 'Mrs', 'Ms', 'Dr', 'Prof')
last_login = SQLModel.DateTime(readonly=True)
enabled = SQLModel.Boolean(default=True)
creation_time = SQLModel.DateTime(default=now, readonly=True)
unique_username = SQLModel.UniqueIndex(domain, username)
user_tenant_ref = SQLModel.ForeignKey(tenant_id, luxon_tenant.id)
user_domain_ref = SQLModel.ForeignKey(domain, luxon_domain.name)
users = SQLModel.Index(domain, username)
users_tenants = SQLModel.Index(domain, tenant_id)
users_domain = SQLModel.Index(domain)
primary_key = id
db_default_rows = USERS
