Python Column Examples

Example #1

File: transaction.py Project: muhammadalibakhtiar/Tutorial-Flask

class Transactions(db.Model):

    id = db.Column(db.Integer, primary_key=True, autoincrement=True)

    create_on = db.Column(db.DateTime, nullable=False)

    def __init__(self):
        self.create_on = datetime.now()

Example #2

class Products(db.Model):

    id = db.Column(db.Integer, primary_key=True, autoincrement=True)

    name = db.Column(db.Integer, nullable=False)

    price = db.Column(db.Integer, nullable=False)

    stock = db.Column(db.Integer, nullable=False)

Example #3

class Transactions(db.Model):

    customer_transaction_id = db.Column(db.Integer,
                                        primary_key=True,
                                        autoincrement=True)
    event_time = db.Column(db.DateTime, nullable=False)

    def __init__(self):
        self.event_time = datetime.now()

Example #4

File: products.py Project: joshuawinter/flask-pos

class Products(db.Model):

    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    name = db.Column(db.String(45), nullable=False)
    price = db.Column(db.Integer, nullable=False)
    stock = db.Column(db.Integer, nullable=False)
    event_time = db.Column(db.DateTime, nullable=False)

    def __init__(self):
        self.event_time = datetime.now()

Example #5

File: transactions_products.py Project: nadikris2/Point-Of-Sale-UTS

class TransactionProducts(db.Model):
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    transaction_id = db.Column(db.Integer,
                               db.ForeignKey("transactions.id"),
                               nullable=False)
    product_id = db.Column(db.Integer,
                           db.ForeignKey("products.id"),
                           nullable=False)
    product_qty = db.Column(db.Integer, nullable=False)
    transaction = relationship("Transactions", backref="transaction_products")
    product = relationship("Products", backref="transaction_products")

Example #6

File: transactions_products.py Project: joshuawinter/flask-pos

class TransactionProducts(db.Model):
	id = db.Column(db.Integer, primary_key=True, autoincrement=True)
	transaction_id = db.Column(db.Integer, db.ForeignKey("transactions.customer_transaction_id"), nullable=False)
	product_id = db.Column(db.Integer, db.ForeignKey("products.id"), nullable=False)
	product_qty = db.Column(db.Integer, nullable=False)
	transaction = relationship("Transactions", backref="transaction_products")
	#transaction = relationship("Transactions")
	#product = relationship("Products", backref="transaction_products")
	product = relationship("Products")
	event_time = db.Column(db.DateTime, nullable=False)


	def __init__(self):
		self.event_time = datetime.now()

Example #7

class TB_user(db.Model):
    id_user = db.Column(db.Integer, primary_key=True, autoincrement=True)
    first_name = db.Column(db.String(100), nullable=False)
    last_name = db.Column(db.String(100), nullable=False)
    username = db.Column(db.String(50), nullable=False)
    password = db.Column(db.String(120), nullable=False)
    email = db.Column(db.String(50), nullable=False)

    def __init__(self, username, password, email):
        self.username = username
        self.password = password
        self.email = email
        self.registered_on = datetime.utcnow()

    def is_authenticated(self):
        return True

    def is_active(self):
        return True

    def is_anonymous(self):
        return False

    def get_id(self):
        return unicode(self.id)

    def __repr__(self):
        return '<User %r>' % (self.username)

Example #8

class tb_user(db.Model):
    id_user = db.Column(db.Integer, primary_key=True, autoincrement=True)
    first_name = db.Column(db.String(100), nullable=False)
    last_name = db.Column(db.String(100), nullable=False)