class AtomProperty(Model):
id = AutoField(primary_key=True)
atom = ForeignKeyField(PDB, related_name='properties', db_column="atom_id")
property = ForeignKeyField(PDB, db_column="property_id")
value = DoubleField(null=True)
tag = CharField(null=True)
class Meta:
database = sqldb
class EmailLogs(BaseModel):
id = AutoField(column_name='id')
error = CharField(column_name='error')
email = CharField(column_name='email')
process = CharField(column_name='process')
date = DateTimeField(column_name='date', default=datetime.datetime.today())
class Meta:
table_name = 'EmailLogs'
class Coin(ModelBase):
Id = AutoField()
TxId = BlobField()
Index = IntegerField()
AssetId = BlobField()
Value = IntegerField()
ScriptHash = BlobField()
State = IntegerField()
Address = ForeignKeyField(Address)
class PercepDGR(ModeloBase):
idpercepdgr = AutoField()
codjur = IntegerField()
idpcabecera = ForeignKeyField(CabFactProv, db_column='idpcabecera')
monto = DecimalField(max_digits=12, decimal_places=4, default=0)
class Meta:
table_name = "percepdgr"
class GamNetwork(BaseModel):
nw_comment = CharField(column_name='NW_COMMENT', null=True)
nw_id = AutoField(column_name='NW_ID')
nw_name = CharField(column_name='NW_NAME')
nw_outofoperation = DecimalField(column_name='NW_OUTOFOPERATION',
constraints=[SQL("DEFAULT 0")])
class Meta:
table_name = 'gam_network'
class MysqlData(Model):
id = AutoField(primary_key=True)
data = CharField()
job_id = IntegerField()
create_time = DateTimeField()
class Meta:
database = mysql_db
table_name = 'fetch_table'
class Target(BaseCommandsModel):
uid = AutoField()
name = TextField(unique=True)
def to_dict(self):
return {"name": self.name}
def get_command(self, name):
return Command.get_or_none((Command.target == self)
& (Command.name % name))
def get_all_commands(self):
try:
return [command for command in self.commands]
except:
return []
def get_all_commands_as_dict(self):
return [command.to_dict() for command in self.commands]
def add_command(self, name, value):
if Command.get_or_none((Command.target == self)
& (Command.name % name)):
return False
else:
Command.create(target=self, name=name, value=value)
return True
def put_command(self, name, value):
command = Command.get_or_none((Command.target == self)
& (Command.name % name))
if command:
command.value = value
command.save()
else:
Command.create(target=self, name=name, value=value)
def delete_command(self, name):
command = Command.get_or_none((Command.target == self)
& (Command.name % name))
if command:
return bool(command.delete_instance())
else:
return False
def update_name(self, new_name):
check_target = Target.get_or_none(Target.name % new_name)
if check_target:
return False
else:
self.name = new_name
self.save()
return True
class Segment(BaseModel):
id = AutoField()
uuid = UUIDField()
sentences_sequ = CharField()
sent_lens = IntegerField()
difficult_factor = FloatField()
category_source = CharField()
class Meta:
db_table = 'segment'
class OreoLetters(Model):
id = AutoField()
token = CharField(max_length=50,
collation="utf8mb4_general_ci",
default="")
token_class = SmallIntegerField()
class Meta:
database = connection
class PumpToValve(BaseModel):
id = AutoField()
pump = ForeignKeyField(Pump, on_delete='CASCADE')
valve = ForeignKeyField(Valve, on_delete='CASCADE')
class Meta:
indexes = (
(('pump_id', 'valve_id'), True),
)
class Post(BaseModel):
id = AutoField()
author = ForeignKeyField(User, backref='posts')
created = DateTimeField(default=datetime.datetime.now)
title = CharField()
body = TextField()
def html_body(self):
return markdown.markdown(self.body)
class Impuesto(ModeloBase):
idimpuesto = AutoField()
detalle = CharField(max_length=30, default='')
porcentaje = DecimalField(max_digits=12, decimal_places=2, default=0)
minimo = DecimalField(max_digits=12, decimal_places=2, default=0)
class Meta:
table_name = "impuestos"
class Log(Model):
log_id = AutoField(primary_key=True)
description = CharField(max_length=1024)
date = DateField()
member = ForeignKeyField(Member, related_name='member_id')
class Meta:
database = db
table_name = 'logs'
class SavedLink(BaseModel):
id = AutoField()
user = ForeignKeyField(User, backref='saved_links', on_delete='CASCADE')
link = ForeignKeyField(Link, backref='saved_links', on_delete='CASCADE')
saved_at = DateTimeField()
deleted_at = DateTimeField(null=True)
class Meta:
indexes = ((('user', 'link'), True), )
class Persona(BaseModel):
id = AutoField(null=False, primary_key=True) # SERIAL, PK, NOT NULL
nombre = CharField(null=False, max_length=255) # VARCHAR(255), NOT NULL
apellido = CharField(null=False, max_length=255) # VARCHAR(255), NOT NULL
email = CharField(null=False, unique=True, max_length=255) # VARCHAR(255), UNIQUE, NOT NULL
institucion = CharField(null=False, max_length=255) # VARCHAR(255), NOT NULL
password = CharField(null=False, max_length=255) # VARCHAR(255), NOT NULL
conexion = DateTimeField(null=True, formats='%d-%m-%Y %H:%M:%S', default=datetime.now().strftime("%d-%m-%Y %H:%M:%S"))
conductor = BooleanField(null=True, default=False)
class ReactWatch(Model):
id = AutoField()
serverid = BigIntegerField()
# guild = ForeignKeyField(Guild, backref='watchemoji')
muteduration = SmallIntegerField(default=600)
watchremoves = BooleanField(default=False)
class Meta:
database = connection
class CpbteRel(ModeloBase):
id = AutoField()
idcabfact = ForeignKeyField(Cabfact, db_column='idcabfact')
idtipocpbte = ForeignKeyField(TipoComprobante, db_column='idtipocpbte')
numero = CharField(max_length=12)
class Meta:
table_name = "cpbterel"
class UserPermission(Model):
id = AutoField()
guild = ForeignKeyField(Guild, backref='command_permissions')
userid = BigIntegerField()
command = CharField(max_length=200, default='')
allow = BooleanField(default=True)
class Meta:
database = connection
class User(Model):
class Meta:
database = db
id = AutoField()
name = CharField()
email = CharField()
telegram_handle = CharField()
wallet = CharField()
class Todo(Model):
current_time = datetime.datetime.now
id = AutoField()
todo_message = CharField()
date_created = DateTimeField(default=current_time)
date_updated = DateTimeField(default=current_time)
class Meta:
database = db
class Valve(BaseModel):
id = AutoField()
number = IntegerField(unique=True)
name = CharField()
delay = IntegerField(default=60)
output = ForeignKeyField(Output,
backref='valve',
on_delete='SET NULL',
unique=True)
class Simulation(BaseModel):
comments = TextField(null=True)
date = DateTimeField(null=True)
id = IntegerField(null=True)
pk = AutoField()
class Meta:
table_name = 'simulation'
schema = 'targetdb'
class ViajeReservado(BaseModel):
id = AutoField(null=False, primary_key=True) # SERIAL, PK, NOT NULL
latitudOrig = FloatField(null=False)
longitudOrig = FloatField(null=False)
latitudDst = FloatField(null=False)
longitudDst = FloatField(null=False)
fecha = DateField(null=False, formats='%d-%m-%Y')
hora = TimeField(null=False, formats='%H:%M')
fk_persona = ForeignKeyField(null=False, model=Persona, field=Persona.id)
class Weather(BaseModel):
pk = AutoField()
cloud_cover = FloatField(null=True)
transparency = FloatField(null=True)
temperature = FloatField(null=True)
class Meta:
table_name = 'weather'
schema = 'targetdb'
class Module(BaseModel):
id = AutoField()
source = CharField()
address = CharField()
module_type = CharField(null=True)
hardware_type = CharField()
firmware_version = CharField(null=True)
hardware_version = CharField(null=True)
order = IntegerField(null=True)
class StudentDocument(BaseModel):
id = AutoField() # Primary key
student = ForeignKeyField(Student, backref='documents')
document_type = CharField()
document_name = CharField()
document_key = CharField(unique=True)
state = CharField()
created_at = DateTimeField(default=datetime.now())
modified_at = DateTimeField(default=datetime.now())
class TestModel(BaseModel):
id = AutoField()
time_start = TimestampField()
time_end = TimestampField()
status = IntegerField()
elapsed_time = IntegerField()
test_info = ForeignKeyField(TestInfoModel)
test_set = ForeignKeyField(TestSetModel, backref="tests")
class CoronaLocationLog(db_wrapper.Model): # type: ignore
id = AutoField()
date = DateField(default=datetime.date.today(), index=True)
infected = IntegerField(default=0)
infected_females = IntegerField(default=0)
cured = IntegerField(default=0)
tests = IntegerField(default=0)
deaths = IntegerField(default=0)
location = ForeignKeyField(CoronaLocation, backref="data")
class offers(Model):
ID = AutoField()
Type = BitField()
God = ForeignKeyField(gods)
UserID = CharField(max_length=snowflake_max_length)
CreationDate = DateTimeField(default=datetime.datetime.now())
class Meta:
database = db
class SentenceModel(BaseModel):
class Meta:
db_table = "sentence"
id = AutoField()
sentences = CharField(max_length=512)
intent_id = IntegerField()
create_time = DateTimeField(default=datetime.now)
update_time = DateTimeField(default=datetime.now)
