Python Column 예제들

예제 #1

파일: models.py 프로젝트: gitter-badger/token-state-relational-mapper

class Token(db.Model):
    __tablename__ = 'tokens'
    id = db.Column(db.BigInteger, primary_key=True)
    last_changed_in_block = db.Column(db.BigInteger)
    total_tokens_supply = db.Column(db.Numeric)
    total_tokens_created = db.Column(db.Numeric)
    total_tokens_destroyed = db.Column(db.Numeric)

예제 #2

파일: models.py 프로젝트: gitter-badger/token-state-relational-mapper

class BalanceChange(db.Model):
    __tablename__ = 'balance_changes'
    id = db.Column(db.BigInteger, primary_key=True)
    block_time = db.Column(db.BigInteger)
    amount = db.Column(db.Numeric)
    to_address = db.Column(db.Text)
    from_address = db.Column(db.Text)

예제 #3

파일: models.py 프로젝트: Neufund/token-state-relational-mapper

class Transfer(db.Model):
    __tablename__ = 'transfers'
    id = db.Column(db.Integer, primary_key=True)
    tx_hash = db.Column(db.Text)

    block_time = db.Column(db.Integer)
    amount = db.Column(db.Numeric(scale=0))

    token_id = db.Column(db.Integer, db.ForeignKey('tokens.id'))
    token = db.relationship('Token', back_populates='transfers')

    to_address = db.Column(db.Text)
    from_address = db.Column(db.Text)

    sent_from_id = db.Column("sent_from_id", db.Integer,
                             db.ForeignKey("token_holders.id"))
    sent_from = db.relationship("TokenHolder",
                                backref="sent_transfers",
                                foreign_keys='Transfer.sent_from_id')

    sent_to_id = db.Column("sent_to_id", db.BigInteger,
                           db.ForeignKey("token_holders.id"))
    sent_to = db.relationship("TokenHolder",
                              backref="received_transfers",
                              foreign_keys='Transfer.sent_to_id')

    def is_minting_event(self):
        return self.from_address == ZERO_ADDRESS

    def is_burning_transfer(self):
        return self.to_address == ZERO_ADDRESS

예제 #4

파일: models.py 프로젝트: JTraversa/token-state-relational-mapper

class Token(db.Model):
    __tablename__ = 'tokens'
    id = db.Column(db.Integer, primary_key=True)
    address = db.Column(db.Text, unique=True)
    name = db.Column(db.Text)
    symbol = db.Column(db.Text)
    decimals = db.Column(db.Numeric(scale=0), default=0)
    total_tokens_supply = db.Column(db.Numeric(scale=0), default=0)
    total_tokens_created = db.Column(db.Numeric(scale=0), default=0)
    total_tokens_destroyed = db.Column(db.Numeric(scale=0), default=0)
    last_changed_in_block = db.Column(db.Integer)

    transfers = db.relationship("Transfer", back_populates='token')
    token_holders = db.relationship("TokenHolder", back_populates='held_token')
    mapped_blocks = db.relationship('Block', secondary=block_token_association_table)

예제 #5

파일: models.py 프로젝트: gitter-badger/token-state-relational-mapper

class TokenHolder(db.Model):
    __tablename__ = 'token_holders'
    id = db.Column(db.BigInteger, primary_key=True)
    last_changed_in_block = db.Column(db.BigInteger)
    address = db.Column(db.Text, nullable=False)
    balance = db.Column(db.Numeric)
    token_turnover = db.Column(db.Numeric)
    held_token_id = db.Column(db.BigInteger, db.ForeignKey('tokens.id'))
    held_token = db.relationship('Token', backref=db.backref('holders', lazy=True))

예제 #6

파일: models.py 프로젝트: Neufund/token-state-relational-mapper

class TokenHolder(db.Model):
    __tablename__ = 'token_holders'
    id = db.Column(db.Integer, primary_key=True)
    address = db.Column(db.Text, nullable=False)

    last_changed_in_block = db.Column(db.Integer)
    balance = db.Column(db.Numeric(scale=0), default=0)
    token_turnover = db.Column(db.Numeric(scale=0), default=0)

    held_token_id = db.Column(db.Integer, db.ForeignKey('tokens.id'))
    held_token = db.relationship('Token')

예제 #7

파일: models.py 프로젝트: Neufund/token-state-relational-mapper

class Block(db.Model):
    __tablename__ = 'blocks'
    number = db.Column(db.Integer, primary_key=True, autoincrement=False)
    date = db.Column(db.DateTime, )

예제 #8

파일: models.py 프로젝트: Neufund/token-state-relational-mapper

"""
Database models
"""
from token_state_relational_mapper import db

ZERO_ADDRESS = '0x0000000000000000000000000000000000000000'

block_token_association_table = db.Table(
    'block_token_association',
    db.Column('block_number',
              db.Integer,
              db.ForeignKey('blocks.number'),
              primary_key=True),
    db.Column('token_id',
              db.Integer,
              db.ForeignKey('tokens.id'),
              primary_key=True))


class Block(db.Model):
    __tablename__ = 'blocks'
    number = db.Column(db.Integer, primary_key=True, autoincrement=False)
    date = db.Column(db.DateTime, )


class Token(db.Model):
    __tablename__ = 'tokens'
    id = db.Column(db.Integer, primary_key=True)
    address = db.Column(db.Text, unique=True)
    name = db.Column(db.Text)
    symbol = db.Column(db.Text)