class PatientDao(db.Model):
__tablename__ = 'patients'
__table_args__ = (ForeignKeyConstraint(['patient_type_symbol'],
['patient_type.symbol'],
name="fk_patient_type_sybol"), )
id = Column(Integer, Sequence('patient_id_seq'), primary_key=True)
email = Column(String, unique=True, nullable=False)
name = Column(String, nullable=False)
surname = Column(String, nullable=False)
birthdate = Column(Date, nullable=False)
sex = Column(String, nullable=False)
patient_type_symbol = Column(String, ForeignKey('patient_type.symbol'))
def __init__(self, email: str, name: str, surname: str, birthdate: Date,
sex: SexType, patient_type: PatientTypeDao):
self.email = email
self.name = name
self.surname = surname
self.birthdate = birthdate
self.sex = sex.name
self.patient_type_symbol = patient_type.name
def toParamsDict(self):
return {
'id': self.id,
'first_name': self.name,
'last_name': self.surname,
'birthdate': self.birthdate,
'email': self.email,
'sex': self.sex,
'type': self.patient_type_symbol
}
class SqlStoredEvent(Base):
# Explicit table name.
__tablename__ = 'stored_events'
# Unique constraint.
__table_args__ = UniqueConstraint('aggregate_id',
'aggregate_version',
name='stored_events_uc'),
# Primary key.
id = Column(Integer, Sequence('stored_event_id_seq'), primary_key=True)
# Sequence ID (e.g. an entity or aggregate ID).
aggregate_id = Column(UUIDType(), index=True)
# Position (timestamp) of item in sequence.
aggregate_version = Column(BigInteger(), index=True)
# Type of the event (class name).
event_type = Column(String(100))
# Timestamp of the event.
timestamp = Column(Float())
# State of the item (serialized dict, possibly encrypted).
state = Column(Text())
class CommonLookups(Base):
__tablename__ = "common_lookup_tbl"
__table_args__ = {'schema': 'apps'}
primary_id = Column('primary_id',
Integer,
Sequence('lookup_primary_id_sequence', schema='apps'),
primary_key=True)
lookup_name = Column('lookup_name', String)
lookup_code = Column('lookup_code', String)
meaning = Column('meaning', String)
description = Column('description', String)
tag = Column('tag', String)
enabled = Column('enabled', String)
effective_from = Column('effective_from',
DateTime,
default=datetime.datetime.utcnow)
effective_to = Column('effective_to', DateTime)
created_by = Column('created_by', Integer)
creation_date = Column('creation_date',
DateTime,
default=datetime.datetime.utcnow)
last_update_date = Column('last_update_date',
DateTime,
default=datetime.datetime.utcnow,
onupdate=datetime.datetime.utcnow)
last_updated_by = Column('last_updated_by', Integer)
class PurchaseTrxHeader(Base):
__tablename__ = "purchase_trx_header_tbl"
__table_args__ = {'schema': 'apps'}
transaction_header_id = Column('transaction_header_id',
Integer,
Sequence('purchase_trx_header_sequence',
schema='apps'),
primary_key=True)
purchase_trx_number = Column('purchase_trx_number', String)
transaction_date = Column('transaction_date',
DateTime,
default=datetime.datetime.utcnow)
order_status = Column('order_status', String)
buyer_id = Column('buyer_id', Integer)
supplier_id = Column('supplier_id', Integer)
created_by = Column('created_by', Integer)
creation_date = Column('creation_date',
DateTime,
default=datetime.datetime.utcnow)
last_update_date = Column('last_update_date',
DateTime,
default=datetime.datetime.utcnow,
onupdate=datetime.datetime.utcnow)
last_updated_by = Column('last_updated_by', Integer)
purchase_trx_lines = relationship(
'model.PurchaseTrxLines.PurchaseTrxLines',
back_populates='purchase_trx_header')
class ReceiptHeader(Base):
__tablename__ = "receipt_header_tbl"
__table_args__ = {'schema': 'apps'}
receipt_header_id = Column('receipt_header_id',
Integer,
Sequence('receipt_header_sequence',
schema='apps'),
primary_key=True)
receipt_number = Column('receipt_number', String)
challan_number = Column('challan_number', String)
receipt_date = Column('receipt_date', DateTime)
challan_date = Column('challan_date', DateTime)
source_transaction_header_id = Column('source_transaction_header_id',
String)
source_transaction_type = Column('source_transaction_type', String)
vehicle_number = Column('vehicle_number', String)
bata = Column('bata', Float)
net_weight = Column('net_weight', Float)
average_weight = Column('average_weight', Float)
total_bags = Column('total_bags', Float)
unit_of_measure = Column('unit_of_measure', String, default='KG')
created_by = Column('created_by', Integer)
creation_date = Column('creation_date',
DateTime,
default=datetime.datetime.utcnow)
last_update_date = Column('last_update_date',
DateTime,
default=datetime.datetime.utcnow,
onupdate=datetime.datetime.utcnow)
last_updated_by = Column('last_updated_by', Integer)
receipt_header_status = Column('receipt_header_status', String)
receipt_lines = relationship('model.ReceiptLines.ReceiptLines',
back_populates='receipt_header')
class ReceiptLines(Base):
__tablename__ = "receipt_lines_tbl"
__table_args__ = {'schema': 'apps'}
receipt_line_id = Column('receipt_line_id',
Integer,
Sequence('receipt_lines_sequence', schema='apps'),
primary_key=True)
receipt_header_id = Column(
'receipt_header_id', Integer,
ForeignKey('apps.receipt_header_tbl.receipt_header_id'))
line_number = Column('line_number', Integer, nullable=False)
item_id = Column('item_id', Integer)
description = Column('description', String)
load_unload_number = Column('load_unload_number', String)
load_unload_area = Column('load_unload_area', String)
weighing_number = Column('weighing_number', String)
receipt_line_status = Column('receipt_line_status', String)
quantity = Column('quantity', Float)
number_of_bags = Column('number_of_bags', Float)
unit_price = Column('unit_price', Float)
unit_of_measure = Column('unit_of_measure', String, default='KG')
discount = Column('discount', Float)
created_by = Column('created_by', Integer)
creation_date = Column('creation_date',
DateTime,
default=datetime.datetime.utcnow)
last_update_date = Column('last_update_date',
DateTime,
default=datetime.datetime.utcnow,
onupdate=datetime.datetime.utcnow)
last_updated_by = Column('last_updated_by', Integer)
receipt_header = relationship("model.ReceiptHeader.ReceiptHeader",
back_populates="receipt_lines")
class User(Base):
__tablename__ = "user_tbl"
__table_args__ = {'schema': 'apps'}
user_id = Column('user_id',
Integer,
Sequence('user_id_sequence', schema='apps'),
primary_key=True)
user_name = Column('user_name', String)
description = Column('description', String)
phone_number1 = Column('phone_number1', String)
phone_number2 = Column('phone_number2', String)
email = Column('email', String)
password = Column('password', String)
user_type = Column('user_type', String)
effective_from = Column('effective_from', DateTime)
effective_to = Column('effective_to', DateTime)
created_by = Column('created_by', Integer)
creation_date = Column('creation_date',
DateTime,
default=datetime.datetime.utcnow)
last_update_date = Column('last_update_date',
DateTime,
default=datetime.datetime.utcnow,
onupdate=datetime.datetime.utcnow)
last_updated_by = Column('last_updated_by', Integer)
password_life_span = Column('password_life_span', Integer)
employee_id = Column('employee_id', Integer)
class SalesTrxLines(Base):
__tablename__ = "sales_trx_lines_tbl"
__table_args__ = {'schema': 'apps'}
transaction_line_id = Column('transaction_line_id',
Integer,
Sequence('sales_trx_lines_sequence',
schema='apps'),
primary_key=True)
transaction_header_id = Column(
'transaction_header_id', Integer,
ForeignKey('apps.sales_trx_header_tbl.transaction_header_id'))
item_id = Column('item_id', Integer)
booking_unit_price = Column('booking_unit_price', Float)
booking_quantity = Column('booking_quantity', Float)
unit_of_measure = Column('unit_of_measure', String)
created_by = Column('created_by', Integer)
creation_date = Column('creation_date',
DateTime,
default=datetime.datetime.utcnow)
last_update_date = Column('last_update_date',
DateTime,
default=datetime.datetime.utcnow,
onupdate=datetime.datetime.utcnow)
last_updated_by = Column('last_updated_by', Integer)
line_number = Column('line_number', Integer, nullable=False)
sales_trx_header = relationship("model.SalesTrxHeader.SalesTrxHeader",
back_populates="sales_trx_lines")
class SqlTimestampSequencedItem(Base):
# Explicit table name.
__tablename__ = 'timestamp_sequenced_items'
# Unique constraint.
__table_args__ = UniqueConstraint('sequence_id',
'position',
name='time_sequenced_items_uc'),
# Primary key.
id = Column(Integer,
Sequence('integer_sequened_item_id_seq'),
primary_key=True)
# Sequence ID (e.g. an entity or aggregate ID).
sequence_id = Column(UUIDType(), index=True)
# Position (timestamp) of item in sequence.
position = Column(Float(), index=True)
# Topic of the item (e.g. path to domain event class).
topic = Column(String(255))
# State of the item (serialized dict, possibly encrypted).
data = Column(Text())
class SqlIntegerSequencedItem(Base):
__tablename__ = 'integer_sequenced_items'
id = Column(Integer,
Sequence('integer_sequened_item_id_seq'),
primary_key=True)
# Sequence ID (e.g. an entity or aggregate ID).
sequence_id = Column(UUIDType(), index=True)
# Position (index) of item in sequence.
position = Column(BigInteger(), index=True)
# Topic of the item (e.g. path to domain event class).
topic = Column(String(255))
# State of the item (serialized dict, possibly encrypted).
data = Column(Text())
# Unique constraint includes 'entity_id' which is a good value
# to partition on, because all events for an entity will be in the same
# partition, which may help performance.
__table_args__ = UniqueConstraint('sequence_id',
'position',
name='integer_sequenced_item_uc'),
class Catalogue(Base):
__tablename__="catalogues"
id = Column(Integer,Sequence("catalogue_id_seq"),primary_key=True)
title = Column(String(1000))
article=relationship("Article", backref="catalogues")
def __init__(self,title):
self.title=title
def __repr(self):
return "<Catalogue('%s')>"%(self.title)
class SqlStoredEvent(Base):
__tablename__ = 'stored_events'
id = Column(Integer, Sequence('stored_event_id_seq'), primary_key=True)
event_id = Column(String(255), index=True)
timestamp_long = Column(BigInteger(), index=True)
stored_entity_id = Column(String(255), index=True)
event_topic = Column(String(255))
event_attrs = Column(Text())
class ReportCardSubject(Base):
__tablename__ = 'report_card_subject'
report_card_subject_id = Column(Integer,
Sequence('report_card_subject_id'),
primary_key=True)
report_card_id = Column(
Integer, ForeignKey('report_card.report_card_id', ondelete="CASCADE"))
subject_name = Column(String(255))
marks = Column(Float)
max_marks = Column(Float)
class Article(Base):
__tablename__ = "articles"
id = Column(Integer, Sequence("article_id_seq"), primary_key=True)
title = Column(String(1000))
catalogue_id=Column(Integer,ForeignKey("catalogues.id"))
catalogue=relationship("Catalogue",backref=backref('catalogues',order_by=id))
replys=relationship("Reply", backref="articles")
def __init__(self,title,catalogue_id):
self.title=title
self.catalogue_id=catalogue_id
def __repr(self):
return "<Article('%s')>"%(self.title)
class CustomerMasterSites (Base):
__tablename__ = "customer_master_sites_tbl"
__table_args__ = {'schema' : 'apps'}
customer_site_id = Column('customer_site_id', Integer, Sequence('customer_site_id_sequence', schema='apps') , primary_key = True)
customer_id = Column('customer_id', Integer,ForeignKey('apps.customer_master_header_tbl.customer_id'))
customer_site_code = Column('customer_site_code', String)
customer_address = Column('customer_address', String)
phone_number1 = Column('phone_number1', String)
phone_number2 = Column('phone_number2', String)
email = Column('email', String)
effective_from = Column('effective_from', DateTime)
effective_to = Column('effective_to', DateTime)
created_by = Column('created_by', Integer)
creation_date = Column('creation_date', DateTime,default=datetime.datetime.utcnow)
last_update_date = Column('last_update_date',DateTime, default=datetime.datetime.utcnow, onupdate=datetime.datetime.utcnow)
last_updated_by = Column('last_updated_by', Integer)
customer = relationship("model.CustomerMasterHeader.CustomerMasterHeader", back_populates="sites")
class LiveDbItem(Tuple, DeclarativeBase):
__tupleTypeShort__ = 'LDK'
__tablename__ = 'LiveDbItem'
__tupleType__ = livedbTuplePrefix + __tablename__
NUMBER_VALUE = 0
STRING_VALUE = 1
COLOR = 2
LINE_WIDTH = 3
LINE_STYLE = 4
GROUP_PTR = 5
id_seq = Sequence('LiveDbItem_id_seq',
metadata=DeclarativeBase.metadata,
schema=DeclarativeBase.metadata.schema)
id = Column(Integer, id_seq, server_default=id_seq.next_value(),
primary_key=True, autoincrement=False)
modelSetId = Column(Integer, ForeignKey('LiveDbModelSet.id', ondelete='CASCADE'),
doc=JSON_EXCLUDE, nullable=False)
modelSet = relationship(LiveDbModelSet)
# comment="The unique reference of the value we want from the live db"
key = Column(String, nullable=False)
# comment="The last value from the source"
rawValue = Column(String)
# comment="The PEEK value, converted to PEEK IDs if required (Color for example)"
displayValue = Column(String)
# comment="The type of data this value represents"
dataType = Column(Integer, nullable=False)
importHash = Column(String)
# Store custom props for this link
propsJson = Column(String)
__table_args__ = (
Index("idx_LiveDbDKey_importHash", importHash, unique=False),
Index("idx_LiveDbDKey_modelSet_key", modelSetId, key, unique=True),
)
class AccessRights(Base):
__tablename__ = "access_rights_tbl"
__table_args__ = {'schema': 'apps'}
access_id = Column('access_id',
Integer,
Sequence('access_id_sequence', schema='apps'),
primary_key=True)
user_type = Column('user_type', String)
access_area = Column('access_area', String)
view = Column('view', String)
create = Column('create', String)
update = Column('update', String)
delete = Column('delete', String)
effective_from = Column('effective_from', DateTime)
effective_to = Column('effective_to', DateTime)
created_by = Column('created_by', Integer)
creation_date = Column('creation_date', DateTime)
last_update_date = Column('last_update_date', Integer)
last_updated_by = Column('last_updated_by', Integer)
class Jobstate(Base):
__tablename__="jobsstate"
id = Column(Integer,Sequence("jobsstate_id_seq"),primary_key=True)
scriptname=Column(String(1000))
foldername=Column(String(1000))
scriptcontent=Column(String(1000))
outputinfo=Column(Text())
# startdate=Column(DateTime, default=time.strftime(ISOTIMEFORMAT, time.localtime()))
startdate=Column(DateTime)
finishdate=Column(DateTime)
state=Column(Integer)
def __init__(self,scriptname,foldername,state):
self.scriptname=scriptname
self.foldername=foldername
self.state=state
def __repr(self):
return "<Jobstat('%s')>"%(self.scriptname)
class CustomerMasterHeader (Base):
__tablename__ = "customer_master_header_tbl"
__table_args__ = {'schema' : 'apps'}
customer_id = Column('customer_id', Integer, Sequence('customer_id_sequence', schema='apps') , primary_key = True)
customer_code = Column('customer_code', String)
customer_name = Column('customer_name', String)
description = Column('description', String)
customer_type = Column('customer_type', String)
remarks = Column('remarks', String)
enabled_flag = Column('enabled_flag', String)
effective_from = Column('effective_from', DateTime)
effective_to = Column('effective_to', DateTime)
created_by = Column('created_by', Integer)
creation_date = Column('creation_date', DateTime,default=datetime.datetime.utcnow)
last_update_date = Column('last_update_date',DateTime, default=datetime.datetime.utcnow, onupdate=datetime.datetime.utcnow)
last_updated_by = Column('last_updated_by', Integer)
sites = relationship('model.CustomerMasterSites.CustomerMasterSites', back_populates='customer')
class Person (Base):
__tablename__ = "person_tbl"
__table_args__ = {'schema' : 'apps'}
person_id = Column('person_id', Integer, Sequence('person_id_sequence', schema='apps') , primary_key = True)
employee_number = Column('employee_number', String)
first_name = Column('first_name', String)
middle_name = Column('middle_name', String)
last_name = Column('last_name', String)
date_of_birth = Column('date_of_birth', Date)
gender = Column('gender', String)
address = Column('address', String)
phone_number1 = Column('phone_number1', String)
phone_number2 = Column('phone_number2', String)
email = Column('email', String)
effective_from = Column('effective_from', DateTime)
effective_to = Column('effective_to', DateTime)
created_by = Column('created_by', Integer)
creation_date = Column('creation_date', DateTime)
last_updated_by = Column('last_updated_by', Integer)
last_update_date = Column('last_update_date', DateTime)
class Jobs_recoder(Base):
__tablename__="jobs_recoder"
id = Column(Integer,Sequence("jobs_recoder_id_seq"),primary_key=True)
logicalpurpose=Column(String(200))
scriptname=Column(String(1000))
foldername=Column(String(1000))
inputdata=Column(String(1000))
outputdata=Column(String(1000))
scriptcontent=Column(String(1000))
outputinfo=Column(Text())
# startdate=Column(DateTime, default=time.strftime(ISOTIMEFORMAT, time.localtime()))
startdate=Column(DateTime)
finishdate=Column(DateTime)
state=Column(Integer)
def __init__(self,scriptname,foldername,logicalpurpose,state):
if foldername[-1]=="/":
foldername=foldername[0:-1]
scriptfile=open(foldername+"/"+scriptname,'r')
line=scriptfile.readline()
if re.search(r"^scriptinputdata=(.*)",line)!=None:
self.inputdata=re.search(r"^scriptinputdata=(.*)",line).group(1)
else:
self.inputdata="unknow"
line=scriptfile.readline()
if re.search(r"^scriptoutputdata=(.*)",line)!=None:
self.outputdata=re.search(r"^scriptoutputdata=(.*)",line).group(1)
else:
self.outputdata="unknow"
# scriptcontent_all=scriptfile.read()
# scriptfile.close()
# if re.search(r"(.*(\n)*)cmdline=\s*(.*)",scriptcontent_all)!=None:
# scriptcontent_cmdline=re.search(r"(.*(\n)*)cmdline=\s*(.*)",scriptcontent_all).group(3)
# self.scriptcontent=scriptcontent_cmdline
self.scriptname=scriptname
self.foldername=foldername
self.state=state
self.logicalpurpose=logicalpurpose
def __repr(self):
return "<jobs_recoder('%s')>"%(self.scriptname)
class ReportCard(Base):
INDEX_EXAM_NAME = 0
INDEX_NAME = 1
INDEX_ADM_NO = 2
INDEX_CLASS = 3
INDEX_SECTION = 4
__tablename__ = 'report_card'
report_card_id = Column(Integer,
Sequence('report_card_id'),
primary_key=True)
exam_name = Column(String(255))
student_name = Column(String(255))
student_addmission_number = Column(String(255))
student_class = Column(String(50))
student_section = Column(String(10))
report_card_subjects = relationship('ReportCardSubject',
backref='report_card',
lazy=True,
passive_deletes=True,
cascade='all, delete, delete-orphan')
def setup(self):
self.graph = create_object_graph(
"microcosm_eventsource",
root_path=join(dirname(__file__), pardir),
testing=True,
)
self.graph.use(
"task_store",
"task_event_store",
"activity_store",
"activity_event_store",
)
self.store = self.graph.task_event_store
self.context = SessionContext(self.graph)
self.context.recreate_all()
self.context.open()
with transaction() as session:
self.task = Task().create()
self.offset = session.execute(Sequence("task_event_clock_seq"))
class InventoryItems(Base):
__tablename__ = "inventory_item_tbl"
__table_args__ = {'schema': 'apps'}
item_id = Column('item_id',
Integer,
Sequence('item_id_sequence', schema='apps'),
primary_key=True)
item_number = Column('item_number', String)
organization_id = Column('organization_id', Integer)
enabled_flag = Column('enabled_flag', String)
description = Column('description', String)
buyer_id = Column('buyer_id', Integer)
item_type = Column('item_type', String)
long_description = Column('long_description', String)
asset_flag = Column('asset_flag', String)
asset_id = Column('asset_id', Integer)
purchasing_enabled_flag = Column('purchasing_enabled_flag', String)
customer_order_enabled_flag = Column('customer_order_enabled_flag', String)
returnable_flag = Column('returnable_flag', String)
inspection_required_flag = Column('inspection_required_flag', String)
list_price_per_unit = Column('list_price_per_unit', String)
shelf_life_days = Column('shelf_life_days', String)
item_control_code = Column('item_control_code', String)
min_order_quantity = Column('min_order_quantity', String)
max_order_quantity = Column('max_order_quantity', String)
planner_code = Column('planner_code', String)
transaction_uom = Column('transaction_uom', String)
conversion = Column('conversion', Float)
base_uom = Column('base_uom', String)
created_by = Column('created_by', Integer)
creation_date = Column('creation_date',
DateTime,
default=datetime.datetime.utcnow)
last_update_date = Column('last_update_date',
DateTime,
default=datetime.datetime.utcnow,
onupdate=datetime.datetime.utcnow)
last_updated_by = Column('last_updated_by', Integer)
def setup(self):
loader = load_from_dict(
secret=dict(postgres=dict(
host=environ.get("MICROCOSM_EVENTSOURCE__POSTGRES__HOST",
"localhost"),
password=environ.get(
"MICROCOSM_EVENTSOURCE__POSTGRES__PASSWORD", ""),
), ),
postgres=dict(
host=environ.get("MICROCOSM_EVENTSOURCE__POSTGRES__HOST",
"localhost"),
password=environ.get(
"MICROCOSM_EVENTSOURCE__POSTGRES__PASSWORD", ""),
),
sns_producer=dict(mock_sns=False, ),
)
self.graph = create_object_graph(
"microcosm_eventsource",
loader=loader,
root_path=dirname(__file__),
testing=True,
)
self.graph.use(
"session_factory",
"task_store",
"task_event_store",
"task_event_controller",
"task_crud_routes",
)
self.client = self.graph.flask.test_client()
recreate_all(self.graph)
with SessionContext(self.graph), transaction() as session:
self.task = Task().create()
self.graph.sns_producer.sns_client.reset_mock()
self.offset = session.execute(Sequence("task_event_clock_seq"))
class SupplierMasterSites(Base):
__tablename__ = "supplier_master_sites_tbl"
__table_args__ = {'schema': 'apps'}
supplier_site_id = Column('supplier_site_id',
Integer,
Sequence('supplier_site_id_sequence',
schema='apps'),
primary_key=True)
supplier_id = Column(
'supplier_id', Integer,
ForeignKey('apps.supplier_master_header_tbl.supplier_id'))
supplier_site_code = Column('supplier_site_code', String)
supplier_site_address = Column('supplier_site_address', String)
phone_number1 = Column('phone_number1', String)
phone_number2 = Column('phone_number2', String)
email = Column('email', String)
payment_method_lookup_code = Column('payment_method_lookup_code', String)
gstin_number = Column('gstin_number', String)
pay_group_lookup_code = Column('pay_group_lookup_code', String)
payment_term = Column('payment_term', String)
purchasing_site_flag = Column('purchasing_site_flag', String)
rfq_only_site = Column('rfq_only_site', String)
tax_registration_number = Column('tax_registration_number', String)
inactive_date = Column('inactive_date', Date)
created_by = Column('created_by', Integer)
creation_date = Column('creation_date',
DateTime,
default=datetime.datetime.utcnow)
last_update_date = Column('last_update_date',
DateTime,
default=datetime.datetime.utcnow,
onupdate=datetime.datetime.utcnow)
last_updated_by = Column('last_updated_by', Integer)
supplier = relationship("model.SupplierMasterHeader.SupplierMasterHeader",
back_populates="sites")