Python Column 예제들

예제 #1

class AccountActivity(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    account_id = db.Column(db.Integer,
                           db.ForeignKey('account.id'),
                           nullable=False)
    message = db.Column(db.String(256), nullable=False)
    date_time = db.Column(db.DateTime, default=datetime.datetime.utcnow)

예제 #2

class Account(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    customer_id = db.Column(db.Integer,
                            db.ForeignKey('customer.id'),
                            nullable=False)
    account_type = db.Column(db.String(20),
                             default=ACC_TYPE['S'],
                             nullable=False)
    balance = db.Column(db.Float(precision=2), default=0.0)
    status = db.Column(db.String(20), default=ACC_STATUS['A'])

예제 #3

class AccountActivity(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    account_id = db.Column(db.Integer, db.ForeignKey(
        'account.id'), nullable=False)
    message = db.Column(db.String(256), nullable=False)
    date_time = db.Column(db.DateTime, default=datetime.datetime.utcnow)

    def serialize(self):
        return {
            'id': self.id,
            'account_id': self.account_id,
            'message': self.message,
            'date_time': self.date_time,
        }

예제 #4

class CustomerActivity(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    customer_id = db.Column(db.Integer, db.ForeignKey(
        'customer.id'), nullable=False)
    message = db.Column(db.String(256), nullable=False)
    date_time = db.Column(db.DateTime, default=datetime.datetime.utcnow)

    def serialize(self):
        return {
            'id': self.id,
            'customer_id': self.customer_id,
            'message': self.message,
            'date_time': str(self.date_time),
        }

예제 #5

class Account(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    customer_id = db.Column(db.Integer, db.ForeignKey(
        'customer.id'), nullable=False)
    account_type = db.Column(
        db.String(20), default=ACC_TYPE['S'], nullable=False)
    balance = db.Column(db.Float(precision=2), default=0.0)
    status = db.Column(db.String(20), default=ACC_STATUS['A'])

    def serialize(self):
        return {'id': self.id,
                'customer_id': self.customer_id,
                'account_type': self.account_type,
                'balance': self.balance,
                'status': self.status
                }

예제 #6

class Customer(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    ssn = db.Column(db.Integer, unique=True, nullable=False)
    name = db.Column(db.String(80), nullable=False)
    dob = db.Column(db.Date, nullable=False)
    address = db.Column(db.String(256), nullable=False)
    state = db.Column(db.String(256), nullable=False)
    city = db.Column(db.String(256), nullable=False)
    status = db.Column(db.String(256),
                       default=CUSTOMER_STATUS['A'],
                       nullable=False)

예제 #7

class Transaction(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    src_account_type = db.Column(db.String(20), nullable=True)
    des_account_type = db.Column(db.String(20), nullable=True)
    amount = db.Column(db.Float(precision=2), default=0.0)
    operation = db.Column(db.String(20), nullable=False)
    balance = db.Column(db.Float(precision=2), default=0.0)

예제 #8

class Employee(db.Model, UserMixin):
    id = db.Column(Integer, primary_key=True)
    username = db.Column(db.String(80), unique=True, nullable=False)
    password = db.Column(db.String(80), nullable=False)
    name = db.Column(db.String(80), nullable=False)
    dob = db.Column(db.String(80), nullable=False)
    is_executive = db.Column(db.Boolean(), default=False)

예제 #9

파일: models.py 프로젝트: Saurabh-Singh-00/Retail-Banking

class Customer(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    ssn = db.Column(db.Integer, unique=True, nullable=False)
    name = db.Column(db.String(80), nullable=False)
    dob = db.Column(db.Date, nullable=False)
    address = db.Column(db.String(256), nullable=False)
    state = db.Column(db.String(256), nullable=False)
    city = db.Column(db.String(256), nullable=False)
    status = db.Column(db.String(256), default=CUSTOMER_STATUS['A'])

    def serialize(self):
        return {
            'id': self.id,
            'ssn': self.ssn,
            'name': self.name,
            'dob': str(self.dob),
            'address': self.address,
            'state': self.state,
            'city': self.city,
            'status': self.status
        }

예제 #10

class Employee(db.Model, UserMixin):
    id = db.Column(Integer, primary_key=True)
    username = db.Column(db.String(80), unique=True, nullable=False)
    password = db.Column(db.String(80), nullable=False)
    name = db.Column(db.String(80), nullable=False)
    dob = db.Column(db.String(80), nullable=False)
    is_executive = db.Column(db.Boolean(), default=False)

    def serialize(self):
        return {'id': self.id,
                'username': self.username,
                'name': self.name,
                'dob': self.dob,
                'is_executive': self.is_executive
                }

예제 #11

파일: models.py 프로젝트: Saurabh-Singh-00/Retail-Banking

class Transaction(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    account_id = db.Column(db.Integer,
                           db.ForeignKey('account.id'),
                           nullable=False)
    src_account_type = db.Column(db.String(20), nullable=True)
    des_account_type = db.Column(db.String(20), nullable=True)
    amount = db.Column(db.Float(precision=2), default=0.0)
    operation = db.Column(db.String(20), nullable=False)
    balance = db.Column(db.Float(precision=2), default=0.0)

    def serialize(self):
        return {
            'id': self.id,
            'src_account_type': self.src_account_type,
            'des_account_type': self.des_account_type,
            'amount': self.amount,
            'operation': self.operation,
            'balance': self.balance
        }