class presentation_instance(Base, TemporalModelMixin): def __init__(self, rid=None, id=None, deleted=False, meta_instance_id=None, presentation_id=None, system_id=None, _metadata=None, **kwargs): self.rid = rid self.id = id self.deleted = deleted self.meta_instance_id = meta_instance_id self.presentation_id = presentation_id self.system_id = system_id self._metadata = _metadata self.branch = kwargs.get('branch', 'master') self.from_id = kwargs.get('from_id') self.modified = kwargs.get('modified') def dict(self): return { "presentation_id": self.presentation_id, "system_id": self.system_id, "id": self.id, "rid": self.rid, "branch": self.branch, "modified": self.modified, "created_at": self.created_at, "_metadata": self._metadata } @declared_attr def __tablename__(cls): return cls.__name__.lower() class Temporal: fields = ( 'deleted', 'modified', 'created_at', 'meta_instance_id', 'from_id', 'branch', 'presentation_id', 'system_id', ) presentation_id = Column(sap.UUID(as_uuid=True)) system_id = Column(sap.UUID(as_uuid=True)) id = Column(sap.UUID(as_uuid=True), default=uuid4) deleted = Column(sap.BOOLEAN(), default=False) meta_instance_id = Column(sap.UUID(as_uuid=True)) modified = Column(DateTime(), default=datetime.utcnow()) created_at = Column(DateTime(), default=datetime.utcnow()) branch = Column(String(), default='master') from_id = Column(sap.UUID(as_uuid=True), nullable=True)
class conta(Base, TemporalModelMixin): def __init__(self, rid=None, _id=None, deleted=False, meta_instance_id=None, titular=None, saldo=None, _metadata=None, branch='master', from_id=None, **kwargs): self.rid = rid self.id = _id self.deleted = deleted self.titular = titular self.saldo = saldo self._metadata = _metadata self.meta_instance_id = meta_instance_id self.branch = branch self.from_id = from_id self.modified = kwargs.get('modified', datetime.utcnow()) self.created_at = kwargs.get('modified', datetime.utcnow()) def dict(self): return { "titular": self.titular, "saldo": self.saldo, "id": self.id, "_metadata": self._metadata } @declared_attr def __tablename__(cls): return cls.__name__.lower() class Temporal: fields = ('deleted', 'titular', 'saldo', 'meta_instance_id', 'modified', 'created_at', 'from_id', 'branch') titular = Column(String) saldo = Column(Integer) id = Column(sap.UUID(as_uuid=True), default=uuid4) deleted = Column(sap.BOOLEAN()) meta_instance_id = Column(sap.UUID(as_uuid=True)) modified = Column(DateTime(), default=datetime.utcnow()) created_at = Column(DateTime(), default=datetime.utcnow()) branch = Column(String, default='master') from_id = Column(sap.UUID(as_uuid=True))
def test_boolean(self): result = format_partition_value(postgresql.BOOLEAN(), 'f') assert result == 'FALSE' result = format_partition_value(postgresql.BOOLEAN(), 'true') assert result == 'TRUE'
class process(Base, TemporalModelMixin): def __init__(self, rid=None, id=None, deleted=False, meta_instance_id=None, name=None, relative_path=None, deploy_date=None, tag=None, image_id=None, system_id=None, _metadata=None, **kwargs): self.rid = rid self.id = id self.deleted = deleted self.meta_instance_id = meta_instance_id self.name = name self.relative_path = relative_path self.deploy_date = deploy_date self.tag = tag self.image_id = image_id self.system_id = system_id self._metadata = _metadata self.branch = kwargs.get('branch', 'master') self.from_id = kwargs.get('from_id') self.modified = kwargs.get('modified') def dict(self): return { "name": self.name, "relative_path": self.relative_path, "deploy_date": self.deploy_date, "tag": self.tag, "image_id": self.image_id, "system_id": self.system_id, "id": self.id, "rid": self.rid, "branch": self.branch, "modified": self.modified, "created_at": self.created_at, "_metadata": self._metadata } @declared_attr def __tablename__(cls): return cls.__name__.lower() class Temporal: fields = ( 'deleted', 'modified', 'created_at', 'meta_instance_id', 'from_id', 'branch', 'name', 'relative_path', 'deploy_date', 'tag', 'image_id', 'system_id', ) name = Column(String) relative_path = Column(String) deploy_date = Column(DateTime) tag = Column(String) image_id = Column(String) system_id = Column(sap.UUID(as_uuid=True)) id = Column(sap.UUID(as_uuid=True), default=uuid4) deleted = Column(sap.BOOLEAN(), default=False) meta_instance_id = Column(sap.UUID(as_uuid=True)) modified = Column(DateTime(), default=datetime.utcnow()) created_at = Column(DateTime(), default=datetime.utcnow()) branch = Column(String(), default='master') from_id = Column(sap.UUID(as_uuid=True), nullable=True)
class operation_instance(Base, TemporalModelMixin): def __init__(self, rid=None, id=None, deleted=False, meta_instance_id=None, status=None, must_commit=None, process_instance_id=None, process_id=None, system_id=None, operation_id=None, image=None, event_name=None, version=None, _metadata=None, **kwargs): self.rid = rid self.id = id self.deleted = deleted self.meta_instance_id = meta_instance_id self.status = status self.must_commit = must_commit self.process_instance_id = process_instance_id self.process_id = process_id self.system_id = system_id self.operation_id = operation_id self.image = image self.event_name = event_name self.version = version self._metadata = _metadata self.branch = kwargs.get('branch', 'master') self.from_id = kwargs.get('from_id') self.modified = kwargs.get('modified') def dict(self): return { "status": self.status, "must_commit": self.must_commit, "process_instance_id": self.process_instance_id, "process_id": self.process_id, "system_id": self.system_id, "operation_id": self.operation_id, "image": self.image, "event_name": self.event_name, "version": self.version, "id": self.id, "rid": self.rid, "branch": self.branch, "modified": self.modified, "created_at": self.created_at, "_metadata": self._metadata } @declared_attr def __tablename__(cls): return cls.__name__.lower() class Temporal: fields = ( 'deleted', 'modified', 'created_at', 'meta_instance_id', 'from_id', 'branch', 'status', 'must_commit', 'process_instance_id', 'process_id', 'system_id', 'operation_id', 'image', 'event_name', 'version', ) status = Column(String) must_commit = Column(Boolean) process_instance_id = Column(sap.UUID(as_uuid=True)) process_id = Column(sap.UUID(as_uuid=True)) system_id = Column(sap.UUID(as_uuid=True)) operation_id = Column(sap.UUID(as_uuid=True)) image = Column(String) event_name = Column(String) version = Column(String) id = Column(sap.UUID(as_uuid=True), default=uuid4) deleted = Column(sap.BOOLEAN(), default=False) meta_instance_id = Column(sap.UUID(as_uuid=True)) modified = Column(DateTime(), default=datetime.utcnow()) created_at = Column(DateTime(), default=datetime.utcnow()) branch = Column(String(), default='master') from_id = Column(sap.UUID(as_uuid=True), nullable=True)
class presentation(Base, TemporalModelMixin): def __init__(self, rid=None, id=None, deleted=False, meta_instance_id=None, name=None, url=None, system_id=None, version=None, image=None, _metadata=None, **kwargs): self.rid = rid self.id = id self.deleted = deleted self.meta_instance_id = meta_instance_id self.name = name self.url = url self.system_id = system_id self.version = version self.image = image self._metadata = _metadata self.branch = kwargs.get('branch', 'master') self.from_id = kwargs.get('from_id') self.modified = kwargs.get('modified') def dict(self): return { "name": self.name, "url": self.url, "system_id": self.system_id, "version": self.version, "image": self.image, "id": self.id, "rid": self.rid, "branch": self.branch, "modified": self.modified, "created_at": self.created_at, "_metadata": self._metadata } @declared_attr def __tablename__(cls): return cls.__name__.lower() class Temporal: fields = ( 'deleted', 'modified', 'created_at', 'meta_instance_id', 'from_id', 'branch', 'name', 'url', 'system_id', 'version', 'image', ) name = Column(String) url = Column(String) system_id = Column(sap.UUID(as_uuid=True)) version = Column(sap.UUID(as_uuid=True)) image = Column(String) id = Column(sap.UUID(as_uuid=True), default=uuid4) deleted = Column(sap.BOOLEAN(), default=False) meta_instance_id = Column(sap.UUID(as_uuid=True)) modified = Column(DateTime(), default=datetime.utcnow()) created_at = Column(DateTime(), default=datetime.utcnow()) branch = Column(String(), default='master') from_id = Column(sap.UUID(as_uuid=True), nullable=True)
class dependency_domain(Base, TemporalModelMixin): def __init__(self, rid=None, id=None, deleted=False, meta_instance_id=None, system_id=None, process_id=None, app_name=None, entity=None, filter=None, version=None, _metadata=None, **kwargs): self.rid = rid self.id = id self.deleted = deleted self.meta_instance_id = meta_instance_id self.system_id = system_id self.process_id = process_id self.app_name = app_name self.entity = entity self.filter = filter self.version = version self._metadata = _metadata self.branch = kwargs.get('branch', 'master') self.from_id = kwargs.get('from_id') self.modified = kwargs.get('modified') def dict(self): return { "system_id": self.system_id, "process_id": self.process_id, "app_name": self.app_name, "entity": self.entity, "filter": self.filter, "version": self.version, "id": self.id, "rid": self.rid, "branch": self.branch, "modified": self.modified, "created_at": self.created_at, "_metadata": self._metadata } @declared_attr def __tablename__(cls): return cls.__name__.lower() class Temporal: fields = ( 'deleted', 'modified', 'created_at', 'meta_instance_id', 'from_id', 'branch', 'system_id', 'process_id', 'app_name', 'entity', 'filter', 'version', ) system_id = Column(sap.UUID(as_uuid=True)) process_id = Column(sap.UUID(as_uuid=True)) app_name = Column(String) entity = Column(String) filter = Column(String) version = Column(sap.UUID(as_uuid=True)) id = Column(sap.UUID(as_uuid=True), default=uuid4) deleted = Column(sap.BOOLEAN(), default=False) meta_instance_id = Column(sap.UUID(as_uuid=True)) modified = Column(DateTime(), default=datetime.utcnow()) created_at = Column(DateTime(), default=datetime.utcnow()) branch = Column(String(), default='master') from_id = Column(sap.UUID(as_uuid=True), nullable=True)
class installed_apps(Base, TemporalModelMixin): def __init__(self, rid=None, id=None, deleted=False, meta_instance_id=None, system_id=None, host=None, name=None, port=None, type=None, _metadata=None, **kwargs): self.rid = rid self.id = id self.deleted = deleted self.meta_instance_id = meta_instance_id self.system_id = system_id self.host = host self.name = name self.port = port self.type = type self._metadata = _metadata self.branch = kwargs.get('branch', 'master') self.from_id = kwargs.get('from_id') self.modified = kwargs.get('modified') def dict(self): return { "system_id": self.system_id, "host": self.host, "name": self.name, "port": self.port, "type": self.type, "id": self.id, "rid": self.rid, "branch": self.branch, "modified": self.modified, "created_at": self.created_at, "_metadata": self._metadata } @declared_attr def __tablename__(cls): return cls.__name__.lower() class Temporal: fields = ( 'deleted', 'modified', 'created_at', 'meta_instance_id', 'from_id', 'branch', 'system_id', 'host', 'name', 'port', 'type', ) system_id = Column(sap.UUID(as_uuid=True)) host = Column(String) name = Column(String) port = Column(Integer) type = Column(String) id = Column(sap.UUID(as_uuid=True), default=uuid4) deleted = Column(sap.BOOLEAN(), default=False) meta_instance_id = Column(sap.UUID(as_uuid=True)) modified = Column(DateTime(), default=datetime.utcnow()) created_at = Column(DateTime(), default=datetime.utcnow()) branch = Column(String(), default='master') from_id = Column(sap.UUID(as_uuid=True), nullable=True)
class branch(Base, TemporalModelMixin): def __init__(self, rid=None, id=None, deleted=False, meta_instance_id=None, system_id=None, name=None, description=None, owner=None, status=None, started_at=None, _metadata=None, **kwargs): self.rid = rid self.id = id self.deleted = deleted self.meta_instance_id = meta_instance_id self.system_id = system_id self.name = name self.description = description self.owner = owner self.status = status self.started_at = started_at self._metadata = _metadata self.branch = kwargs.get('branch', 'master') self.from_id = kwargs.get('from_id') self.modified = kwargs.get('modified') def dict(self): return { "system_id": self.system_id, "name": self.name, "description": self.description, "owner": self.owner, "status": self.status, "started_at": self.started_at, "id": self.id, "rid": self.rid, "branch": self.branch, "modified": self.modified, "created_at": self.created_at, "_metadata": self._metadata } @declared_attr def __tablename__(cls): return cls.__name__.lower() class Temporal: fields = ( 'deleted', 'modified', 'created_at', 'meta_instance_id', 'from_id', 'branch', 'system_id', 'name', 'description', 'owner', 'status', 'started_at', ) system_id = Column(sap.UUID(as_uuid=True)) name = Column(String) description = Column(String) owner = Column(String) status = Column(String) started_at = Column(DateTime) id = Column(sap.UUID(as_uuid=True), default=uuid4) deleted = Column(sap.BOOLEAN(), default=False) meta_instance_id = Column(sap.UUID(as_uuid=True)) modified = Column(DateTime(), default=datetime.utcnow()) created_at = Column(DateTime(), default=datetime.utcnow()) branch = Column(String(), default='master') from_id = Column(sap.UUID(as_uuid=True), nullable=True)
class sent_event(Base, TemporalModelMixin): def __init__(self, rid=None, id=None, deleted=False, meta_instance_id=None, event_id=None, presentation_instance_id=None, operation_instance_id=None, event_date=None, reference_date=None, payload=None, is_reproduction=None, _metadata=None, **kwargs): self.rid = rid self.id = id self.deleted = deleted self.meta_instance_id = meta_instance_id self.event_id = event_id self.presentation_instance_id = presentation_instance_id self.operation_instance_id = operation_instance_id self.event_date = event_date self.reference_date = reference_date self.payload = payload self.is_reproduction = is_reproduction self._metadata = _metadata self.branch = kwargs.get('branch', 'master') self.from_id = kwargs.get('from_id') self.modified = kwargs.get('modified') def dict(self): return { "event_id": self.event_id, "presentation_instance_id": self.presentation_instance_id, "operation_instance_id": self.operation_instance_id, "event_date": self.event_date, "reference_date": self.reference_date, "payload": self.payload, "is_reproduction": self.is_reproduction, "id": self.id, "rid": self.rid, "branch": self.branch, "modified": self.modified, "created_at": self.created_at, "_metadata": self._metadata } @declared_attr def __tablename__(cls): return cls.__name__.lower() class Temporal: fields = ( 'deleted', 'modified', 'created_at', 'meta_instance_id', 'from_id', 'branch', 'event_id', 'presentation_instance_id', 'operation_instance_id', 'event_date', 'reference_date', 'payload', 'is_reproduction', ) event_id = Column(sap.UUID(as_uuid=True)) presentation_instance_id = Column(sap.UUID(as_uuid=True)) operation_instance_id = Column(sap.UUID(as_uuid=True)) event_date = Column(Date) reference_date = Column(Date) payload = Column(Text) is_reproduction = Column(Boolean) id = Column(sap.UUID(as_uuid=True), default=uuid4) deleted = Column(sap.BOOLEAN(), default=False) meta_instance_id = Column(sap.UUID(as_uuid=True)) modified = Column(DateTime(), default=datetime.utcnow()) created_at = Column(DateTime(), default=datetime.utcnow()) branch = Column(String(), default='master') from_id = Column(sap.UUID(as_uuid=True), nullable=True)
class reproduction(Base, TemporalModelMixin): def __init__(self, rid=None, id=None, deleted=False, meta_instance_id=None, system_id=None, process_id=None, original_instance_id=None, instance_id=None, owner=None, external_id=None, execution_start_date=None, _metadata=None, **kwargs): self.rid = rid self.id = id self.deleted = deleted self.meta_instance_id = meta_instance_id self.system_id = system_id self.process_id = process_id self.original_instance_id = original_instance_id self.instance_id = instance_id self.owner = owner self.external_id = external_id self.execution_start_date = execution_start_date self._metadata = _metadata self.branch = kwargs.get('branch', 'master') self.from_id = kwargs.get('from_id') self.modified = kwargs.get('modified') def dict(self): return { "system_id": self.system_id, "process_id": self.process_id, "original_instance_id": self.original_instance_id, "instance_id": self.instance_id, "owner": self.owner, "external_id": self.external_id, "execution_start_date": self.execution_start_date, "id": self.id, "rid": self.rid, "branch": self.branch, "modified": self.modified, "created_at": self.created_at, "_metadata": self._metadata } @declared_attr def __tablename__(cls): return cls.__name__.lower() class Temporal: fields = ( 'deleted', 'modified', 'created_at', 'meta_instance_id', 'from_id', 'branch', 'system_id', 'process_id', 'original_instance_id', 'instance_id', 'owner', 'external_id', 'execution_start_date', ) system_id = Column(sap.UUID(as_uuid=True)) process_id = Column(sap.UUID(as_uuid=True)) original_instance_id = Column(sap.UUID(as_uuid=True)) instance_id = Column(sap.UUID(as_uuid=True)) owner = Column(String) external_id = Column(String) execution_start_date = Column(DateTime) id = Column(sap.UUID(as_uuid=True), default=uuid4) deleted = Column(sap.BOOLEAN(), default=False) meta_instance_id = Column(sap.UUID(as_uuid=True)) modified = Column(DateTime(), default=datetime.utcnow()) created_at = Column(DateTime(), default=datetime.utcnow()) branch = Column(String(), default='master') from_id = Column(sap.UUID(as_uuid=True), nullable=True)
class process_instance(Base, TemporalModelMixin): def __init__(self, rid=None, id=None, deleted=False, meta_instance_id=None, start_execution=None, reference_date=None, status=None, process_id=None, origin_event_name=None, system_id=None, is_fork=None, owner=None, baseline=None, scope=None, _metadata=None, **kwargs): self.rid = rid self.id = id self.deleted = deleted self.meta_instance_id = meta_instance_id self.start_execution = start_execution self.reference_date = reference_date self.status = status self.process_id = process_id self.origin_event_name = origin_event_name self.system_id = system_id self.is_fork = is_fork self.owner = owner self.baseline = baseline self.scope = scope self._metadata = _metadata self.branch = kwargs.get('branch', 'master') self.from_id = kwargs.get('from_id') self.modified = kwargs.get('modified') def dict(self): return { "start_execution": self.start_execution, "reference_date": self.reference_date, "status": self.status, "process_id": self.process_id, "origin_event_name": self.origin_event_name, "system_id": self.system_id, "is_fork": self.is_fork, "owner": self.owner, "baseline": self.baseline, "scope": self.scope, "id": self.id, "rid": self.rid, "branch": self.branch, "modified": self.modified, "created_at": self.created_at, "_metadata": self._metadata } @declared_attr def __tablename__(cls): return cls.__name__.lower() class Temporal: fields = ( 'deleted', 'modified', 'created_at', 'meta_instance_id', 'from_id', 'branch', 'start_execution', 'reference_date', 'status', 'process_id', 'origin_event_name', 'system_id', 'is_fork', 'owner', 'baseline', 'scope', ) start_execution = Column(DateTime) reference_date = Column(DateTime) status = Column(String) process_id = Column(sap.UUID(as_uuid=True)) origin_event_name = Column(String) system_id = Column(sap.UUID(as_uuid=True)) is_fork = Column(Boolean) owner = Column(String) baseline = Column(String) scope = Column(String) id = Column(sap.UUID(as_uuid=True), default=uuid4) deleted = Column(sap.BOOLEAN(), default=False) meta_instance_id = Column(sap.UUID(as_uuid=True)) modified = Column(DateTime(), default=datetime.utcnow()) created_at = Column(DateTime(), default=datetime.utcnow()) branch = Column(String(), default='master') from_id = Column(sap.UUID(as_uuid=True), nullable=True)
@compiles(TINYINT) def compile_tinyint(type_, compiler, **kw): return "TINYINT" @compiles(DOUBLE) def compile_double(type_, compiler, **kw): return "DOUBLE" boolean_map = { MYSQL: mysql.BIT(1), ORACLE: oracle.NUMBER(1), POSTGRES: postgresql.BOOLEAN() } byte_map = { MYSQL: mysql.TINYINT(), ORACLE: oracle.NUMBER(3), POSTGRES: postgresql.SMALLINT(), } short_map = { MYSQL: mysql.SMALLINT(), ORACLE: oracle.NUMBER(5), POSTGRES: postgresql.SMALLINT(), } # Skip Oracle