from aestate.util.Log import logging from testOpera.table.demoModels import Demo import pandas demo = Demo() log = logging.gen(demo) r1 = demo.find_all(print_sql=False) r1[0].name = "aaaaa" r1[0].update() r2 = demo.find_many("SELECT * FROM demo") r3 = demo.find_field("id", "name", "password") r4 = demo.find_one("SELECT * FROM demo WHERE id=%s", params=[1]) r5 = demo.find_sql("SELECT * FROM demo WHERE id>%s", params=[0]) r6 = demo.orm.find().where(name__love='a').end() log.error('r1', type(r1), r1) log.error('r2', type(r2), r2) log.error('r3', type(r3), r3) log.error('r4', type(r4), r4) log.error('r5', type(r5), r5) log.error('r6', type(r6), r6) df = pandas.DataFrame.from_dict(r1.to_dict()) print(df)
# -*- utf-8 -*- from aestate.util.Log import logging from testOpera.table.demoModels import Demo log = logging.gen(Demo()) [log.info(True, 'test info') for _ in range(1000)] print('--------------------') [log.warn(True, 'test warn') for _ in range(1000)] [log.error(True, 'test error') for _ in range(1000)]
# -*- utf-8 -*- from aestate.ajson import aj from aestate.util.Log import logging from testOpera.table.demoModels import ReadXmlClass rxc = ReadXmlClass() log = logging.gen(rxc) r1 = rxc.findAllById(id=18) rr1 = rxc.findAllByIdDict(id=18) r2 = rxc.insertTest(name='a', password="******") r3 = rxc.updateTest(name='a', password="******", id=1) r4 = rxc.deleteTest(id=2) log.info('r1:', r1) log.info('rr1:', rr1) log.info('r2:', aj.parse(r2, bf=True)) log.info('r3:', aj.parse(r3, bf=True)) log.info('r4:', aj.parse(r4, bf=True))