db.py

from config import db
from sqlalchemy import create_engine, Column, String, Integer, Boolean
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker, scoped_session

Base = declarative_base()
engine = create_engine(db.uri, convert_unicode=True, pool_recycle=280)
session = scoped_session(sessionmaker(expire_on_commit=False, autocommit=False, autoflush=False, bind=engine))

class Transaction(Base):
	__tablename__ = 'transactions'

	id = Column(Integer, primary_key=True)
	email = Column(String(length=255))
	paypal_transaction_id = Column(String(length=255), unique=True)
	invoice = Column(String(length=255), unique=True)
	payment_status = Column(String(length=255))
	downloads = Column(Integer, default=0)

	def __repr__(self):
		return "<Transaction(id={}, email='{}', paypal_transaction_id='{}', invoice='{}', payment_status={}, downloads={})>".format(self.id, self.email, self.paypal_transaction_id, self.invoice, self.payment_status, self.downloads)

def initDB():
	Base.metadata.drop_all(engine)
	Base.metadata.create_all(engine)