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)