def del_blog_lib(self, id): if Blog.by_id(id): blog = Blog.by_id(id) dbSession.delete(blog) dbSession.commit() return {'status': True, 'msg': 'it is ok'} return {'status': False, 'msg': 'nobody'}
def del_comment_lib(self, id): if id is None: return {'status': False, 'msg': '评论不存在'} comment = Comment.by_id(id) dbSession.delete(comment) dbSession.commit() return {'status': True, 'msg': 'ok'}
def del_contact_lib(self, id): if id: contact = Contact.by_id(id) dbSession.delete(contact) dbSession.commit() return {'status': True, 'msg': 'OK'} return {'status': False, 'msg': 'error'}
def del_user_lib(self,id): if User.by_id(id) is None: return {'status':False,'msg':'error'} user = User.by_id(id) dbSession.delete(user) dbSession.commit() return {'status':True, 'msg': '删除成功'}
def get(self): for i in range(2, 200): add_data = pt_bs_msg( bednum=str(i), name=str(i), gender=str(i), age=i, contact=str(i), doctor=str(i), IDcard=str(i), ill=str(i), ) dbSession.add(add_data) dbSession.commit()
def create_h(): dbSession.add_all([ Hous_area(area_id=1, area_name='天河区', area_ctime=datetime.now()), Hous_area(area_id=2, area_name='荔湾区', area_ctime=datetime.now()), Hous_area(area_id=3, area_name='海珠区', area_ctime=datetime.now()), Hous_area(area_id=4, area_name='越秀区', area_ctime=datetime.now()), Hous_area(area_id=5, area_name='白云区', area_ctime=datetime.now()), Hous_area(area_id=6, area_name='黄埔区', area_ctime=datetime.now()), Hous_area(area_id=7, area_name='番禺区', area_ctime=datetime.now()), Hous_area(area_id=8, area_name='花都区', area_ctime=datetime.now()), Hous_area(area_id=9, area_name='南沙区', area_ctime=datetime.now()), Hous_area(area_id=10, area_name='增城区', area_ctime=datetime.now()), Hous_area(area_id=11, area_name='从化区', area_ctime=datetime.now()), ]) dbSession.commit()
def create_h(): dbSession.add_all([ Hous_area(area_id=1, area_name='越秀区', area_ctime=datetime.now()), Hous_area(area_id=2, area_name='荔湾区', area_ctime=datetime.now()), Hous_area(area_id=3, area_name='海珠区', area_ctime=datetime.now()), Hous_area(area_id=4, area_name='天河区', area_ctime=datetime.now()), Hous_area(area_id=5, area_name='白云区', area_ctime=datetime.now()), Hous_area(area_id=6, area_name='黄埔区', area_ctime=datetime.now()), Hous_area(area_id=7, area_name='番禺区', area_ctime=datetime.now()), Hous_area(area_id=8, area_name='花都区', area_ctime=datetime.now()), Hous_area(area_id=9, area_name='南沙区', area_ctime=datetime.now()), Hous_area(area_id=10, area_name='增城区', area_ctime=datetime.now()), Hous_area(area_id=11, area_name='从化区', area_ctime=datetime.now()), ]) dbSession.add_all([ Facility(id=1, name='无线网络', cretetime=datetime.now()), Facility(id=2, name='热水淋浴', cretetime=datetime.now()), Facility(id=3, name='空调', cretetime=datetime.now()), Facility(id=4, name='暖气', cretetime=datetime.now()), Facility(id=5, name='允许吸烟', cretetime=datetime.now()), Facility(id=6, name='饮水设备', cretetime=datetime.now()), Facility(id=7, name='牙具', cretetime=datetime.now()), Facility(id=8, name='香皂', cretetime=datetime.now()), Facility(id=9, name='拖鞋', cretetime=datetime.now()), Facility(id=10, name='手纸', cretetime=datetime.now()), Facility(id=11, name='毛巾', cretetime=datetime.now()), Facility(id=12, name='沐浴露、洗发露', cretetime=datetime.now()), Facility(id=13, name='冰箱', cretetime=datetime.now()), Facility(id=14, name='洗衣机', cretetime=datetime.now()), Facility(id=15, name='电梯', cretetime=datetime.now()), Facility(id=16, name='允许做饭', cretetime=datetime.now()), Facility(id=17, name='允许带宠物', cretetime=datetime.now()), Facility(id=18, name='允许聚会', cretetime=datetime.now()), Facility(id=19, name='门禁系统', cretetime=datetime.now()), Facility(id=20, name='停车位', cretetime=datetime.now()), Facility(id=21, name='有线网络', cretetime=datetime.now()), Facility(id=22, name='电视', cretetime=datetime.now()), Facility(id=23, name='浴缸', cretetime=datetime.now()) ]) dbSession.commit()
from config import settings from handlers.main.main_urls import handlers from models.account.account_user_model import User from models.files.upload_file_model import Files from models.article import article_model from libs.db import create_talbes from libs.db.dbsession import dbSession #定义一个默认的端口 define("port", default=8000, help="run port ", type=int) define("runserver", default=False, help="start server", type=bool) define("t", default=False, help="create table", type=bool) define("u", default=False, help="create user", type=bool) if __name__ == "__main__": options.parse_command_line() if options.t: create_talbes.run() if options.u: user = User() user.name = 'zhangsan' user.password = '******' dbSession.add(user) dbSession.commit() if options.runserver: app = tornado.web.Application(handlers, **settings) #创建应用实例 http_server = tornado.httpserver.HTTPServer(app) #通过应用实例创建服务器实例 http_server.listen(options.port) #监听9000端口 print 'start server...' tornado.ioloop.IOLoop.instance().start() #启动服务器
define("port", default=8000, help="run port ", type=int) # 定义端口号 define("runserver", default=False, help="start server", type=bool) # 启动服务 define("t", default=False, help="create table", type=bool) # 创建表 define("u", default=False, help="create user", type=bool) # 创建用户 if __name__ == "__main__": # option(所有已定义的选项都可以作为该对象的属性可用).解析在命令行上给出的所有选项 # 即在命令行输入命令时进行解析 options.parse_command_line() # 当是属性.t时,执行创建表函数 if options.t: create_talbes.run() # 调用创建数据库的映射函数生成数据库中的表 # 当是属性.u时,就是创建用户命令 # 定义如果执行-u时,为创建一个用户 if options.u: user = User() # 类的实例化 user.name = 'achjiang' # 属性的实例化 user.password = '******' # 属性的实例化 dbSession.add(user) # 在session中添加一个数据 dbSession.commit() # 将添加的数据提交到数据库执行 # 当是属性.runserver时,执行如下函数: if options.runserver: app = tornado.web.Application(handlers, **settings) #创建应用实例 http_server = tornado.httpserver.HTTPServer(app) #通过应用实例创建服务器实例 http_server.listen(options.port) #监听8000端口 print 'start server...' tornado.ioloop.IOLoop.instance().start() #启动服务器
def create_super_admin(): emp = Employee() emp.username = "******" emp.password = '******' dbSession.add(emp) dbSession.commit()
def del_article_lib(self, id): article = Article.by_id(id) dbSession.delete(article) dbSession.commit() return {'status': True, 'msg': 'delete ok'}
def init_data(): """往permission_role表中添加admin这个角色""" role = permission_model.Role() role.name = 'admin' dbSession.add(role) dbSession.commit() """添加权限""" for i in range(13): pa = permission_model.Permission() pa.name = pp[i][0] pa.strcode = pp[i][1] dbSession.add(pa) dbSession.commit() """添加管理员用户""" u = [ ('admin', '111111'), ] for i in xrange(1): user = User() user.name = u[i][0] user.password = u[i][1] dbSession.add(user) dbSession.commit() """为处理器添加权限""" for i in xrange(11): user = permission_model.Handler() user.name = h[i][0] user.p_id = h[i][1] dbSession.add(user) dbSession.commit() p = dbSession.query(permission_model.Permission).all() r = dbSession.query(permission_model.Role).filter_by(name='admin').first() for i in p: r.permissions.append(i) dbSession.add(r) dbSession.commit() """给admin用户赋予角色""" u_r = ["1", "1"] user_to_role = permission_model.UserToRole() user_to_role.u_id = u_r[0] user_to_role.r_id = u_r[1] dbSession.add(user_to_role) dbSession.commit() """给admin添加权限管理菜单显示""" p_r = ["adminmenu", "7"] menu = permission_model.Menu() menu.name = p_r[0] menu.p_id = p_r[1] dbSession.add(menu) dbSession.commit()