Python get_sqlite_dba Beispiele

Beispiel #1

    FROM:   2016年5月30日
********************************************************************

======================================================================

UI and Web Http automation frame for python.

'''


from common.database.dboperation import get_sqlite_dba
from common.models import Column, Integer, String
from usage_demo import APP,APP_PROJ_PATH

# dba=OperateDB(APP,r'sqlite:///%s\%s\%s' %(APP_PROJ_PATH,"db","demo.db"))
dba = get_sqlite_dba(APP, r"%s\%s\%s" %(APP_PROJ_PATH,"db","demo.db"))

class Report(dba.base):
    __tablename__ = 'report'
        
    rid     = Column(Integer, primary_key=True)
    path    = Column(String(32))
    
    def __init__(self,rid,path):
        self.rid = rid
        self.path = path
        
    def __repr__(self):
        return '<Report %r>' % (self.id)
    
    

Beispiel #2

    MAIL:    [email protected]
    RCS:      pyrwbs.models,v 1.0 2016年6月1日
    FROM:   2016年6月1日
********************************************************************

======================================================================

UI and Web Http automation frame for python.

'''
import datetime
from pyrwbs import APP
from common.database.dboperation import get_sqlite_dba
from common.models import Column,Integer,String,DateTime,Date,relationship,ForeignKey

dba = get_sqlite_dba(APP, r'%s\%s\%s' %(APP.root_path,"db","wbs.db"))


class TestStep(dba.base):
    __tablename__ = 'teststep'
        
    id     = Column(Integer, primary_key=True)
    order = Column(Integer)
    step = Column(String(64)) 
    expected = Column(String(32))
    actual = Column(String(32))    
    tcase_name = Column(Integer,ForeignKey("testcase.name"))
        
    def __init__(self,**kwargs):
        
        self.order = int(kwargs.get("order"))