from sqlalchemy import create_engine from sqlalchemy import Column, ForeignKey, ColumnDefault from sqlalchemy import Integer, String, Date, Boolean, Unicode, Float from sqlalchemy.ext.declarative import declarative_base from amir.database import get_declarative_base Base = get_declarative_base() ## \defgroup DataBase ## @{ #Version 0.1 tables class Subject(Base): __tablename__ = "subject" id = Column(Integer, primary_key=True) code = Column(String(20), unique=True) name = Column(String(60), nullable=False) parent_id = Column(Integer, ColumnDefault(0), ForeignKey('subject.id'), nullable=False) lft = Column(Integer, nullable=False) rgt = Column(Integer, nullable=False) type = Column(Integer) # 0 for Debtor, 1 for Creditor, 2 for both permanent = Column(Boolean, ColumnDefault(False)) def __init__(self, code=0, name='', parent_id=0,
from sqlalchemy import create_engine from sqlalchemy import Column, ForeignKey, ColumnDefault from sqlalchemy import Integer, String, Date, Boolean, Unicode, Float from sqlalchemy.ext.declarative import declarative_base from amir.database import get_declarative_base Base = get_declarative_base() ## \defgroup DataBase ## @{ #Version 0.2 tables class BankAccounts(Base): __tablename__ = "bankAccounts" accId = Column( Integer, primary_key = True ) accName = Column( Unicode(100), nullable = False ) accNumber = Column( Unicode(40) , nullable = False, unique=True) accType = Column( Integer, nullable = True ) accOwner = Column( Unicode(50), nullable = True ) accBank = Column( Integer, ForeignKey('BankNames.Id'), nullable = True ) accBankBranch = Column( Unicode(50), nullable = True ) accBankAddress = Column( Unicode(100), nullable = True ) accBankPhone = Column( Unicode(40), nullable = True ) accBankWebPage = Column( Unicode(100), nullable = True ) accDesc = Column( Unicode(200), nullable = True ) def __init__( self, accName, accNumber, accType, accOwner, accBank, accBankBranch, accBankAddress, accBankPhone, accBankWebPage, accDesc ): self.accName = accName self.accNumber = accNumber