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))
示例#3
0
    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)
示例#13
0

@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