Python BaseTable示例

示例#1

def main(args):
    print('Star Spider...')
    db = BaseTable()
    db.connect()
    row = BaseTable(code='001', name='jeck')
    db.add(row)
    for row in db.get_all():
        print(row['code'], row['name'])

示例#2

文件： manager_20210212014216.py 项目： jeckun/SpiderX

def main(args):
    print('Star Spider...')
    db = Test()
    db.connect()
    row = BaseTable(code='001', name='jeck')
    db.add(row)
    row = BaseTable(code='002', name='frank')
    db.add(row)

    rst = db.query(code='001', name='jeck')
    rst.name = 'new name'
    db.update(rst)

    row = BaseTable(code='003', name='black')
    db.add(row)
    db.delete(rst)

    for row in db.get_all():
        print(row.id, row.code, row.name, row.createtime, row.modifytime)

示例#3

文件： manager_20210212003952.py 项目： jeckun/SpiderX

def main(args):
    print('Star Spider...')
    db = BaseTable()
    db.connect()
    row = BaseTable(code='001', name='jeck')
    db.add(row)
    row = BaseTable(code='002', name='frank')
    db.add(row)

    for row in db.get_all():
        print(row.id, row.code, row.name, row.createtime, row.modifytime)

示例#4

文件： manager_20210212010823.py 项目： jeckun/SpiderX

def main(args):
    print('Star Spider...')
    db = BaseTable()
    db.connect()
    row = BaseTable(code='001', name='jeck')
    db.add(row)
    row = BaseTable(code='002', name='frank')
    db.add(row)

    rst = db.session.query(BaseTable).filter(BaseTable.id == 2).first()
    rst.name = 'new name'
    rst.save()

    for row in db.get_all():
        print(row.id, row.code, row.name, row.createtime, row.modifytime)

示例#5

文件： manager_20210212002011.py 项目： jeckun/SpiderX

def main(args):
    print('Star Spider...')
    db = BaseTable()
    db.connect()
    row = BaseTable(code='')

示例#6

def main(args):
    print('Star Spider...')
    db = BaseTable()

示例#7

def main(args):
    print('Star Spider...')
    db = BaseTable()
    db.connect()
    row = BaseTable(code='001', name='jeck')
    db.add(row)