def add(monitor_bc):
try:
monitor_bc.create_time = datetime.datetime.now()
session.add(monitor_bc)
session.commit()
except Exception as e:
print(e)
def add(weburl):
logger.info("add weburl to db: %s", weburl.url)
engine = create_engine(
'mysql://%s:%s@%s/%s?charset=utf8&autocommit=true' %
(username, password, host, database),
encoding='utf-8',
echo=False,
pool_size=100,
pool_recycle=10)
Session = sessionmaker(bind=engine)
session = Session()
try:
exist_weburl = session.query(Weburl).filter(
Weburl.url == weburl.url).filter(
Weburl.website_id == weburl.website_id).all()
if len(exist_weburl):
pass
else:
weburl.create_time = datetime.datetime.now()
weburl.last_update = datetime.datetime.now()
session.add(weburl)
session.commit()
except Exception as e:
print(e)
session.rollback()
raise
finally:
session.close()
class TestMysql(object):
if __name__ == "__main__":
# 创建新User对象:
new_config = Global(
level='Bob',
freq='1',
create_time=datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S'))
# 添加到session:
session.add(new_config)
# 提交即保存到数据库:
config1 = session.query(Global).filter(Global.id == 4).one()
print(config1.level)
config2 = session.query(Global).filter(Global.level == 'Bob').all()
for i in config2:
print(i.id, i.level)
session.query(Global).filter(Global.id == 4).update({"level": "1099"})
# 关闭session:
session.close()
def add(monitor_website):
monitor_website.create_time = datetime.datetime.now()
session.add(monitor_website)
def add(bc_benefit):
session.add(bc_benefit)
def add(monitor_url):
try:
monitor_url.create_time = datetime.datetime.now()
session.add(monitor_url)
except Exception as e:
logger.info(e)
def add(bc_person):
session.add(bc_person)