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))