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
