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)
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)
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
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)
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))
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')
class Block(db.Model):
__tablename__ = 'blocks'
number = db.Column(db.Integer, primary_key=True, autoincrement=False)
date = db.Column(db.DateTime, )
"""
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)
