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'
    db.update(rst)

    for row in db.get_all():
        print(row.id, row.code, row.name, row.createtime, row.modifytime)
Exemple #2
0
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.find(row)
    rst.name = 'new frank'
    db.update(rst)

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