コード例 #1
0
ファイル: DBAuthority.py プロジェクト: SealOfFire/webpy_test
	def selectMenu(self, userName, parnetId=0):
		'''
		查询用户权限
		return 返回用户可以访问的菜单列表
		'''
		returnValue = []
		sql = '''
		select menu.menu_id, menu.text, menu.url,menu.parent_id,menu.sort from mgame_tool.menu
		inner join mgame_tool.authority on menu.menu_id=authority.menu_id
		inner join mgame_tool.user_authority on user_authority.authority_id=authority.authority_id
		where user_authority.user_name=%s 
		order by menu.sort
		'''
		db = DBConn()
		rownum, db_res = db.query(sql, (userName))
		rownum += 0
		for row in db_res:
			menu = {}
			menu["id"] = row[0]
			menu["text"] = row[1]
			menu["url"] = row[2]
			menu["parentId"] = row[3]
			menu["sort"] = row[4]
			returnValue.append(menu)
		return returnValue
コード例 #2
0
ファイル: DBAuthority.py プロジェクト: SealOfFire/webpy_test
	def checkUrl(self, url):
		'''
		测试url是否在权限管理之内
		'''
		# Logger.info('DBAuthority.checkUrl begin')
		sql = 'select count(*) from mgame_tool.menu where url=%s'
		db = DBConn()
		rownum, db_res = db.query(sql, (url))
		rownum += 0
		for row in db_res:
			if row[0] >= 1:
				return True
				# Logger.info('DBAuthority.checkUrl end')
			elif row[0] == 0:
				return False
				# Logger.info('DBAuthority.checkUrl end')
				'''
			elif row[0] > 1:
				msg = 'DBAuthority.checkUrl:有重复url[%s]' % url
				Logger.error(msg)
				raise Exception(msg);
				'''
		msg = 'DBUserInfo.login:有重复url[%s]' % url
		Logger.error(msg)
		raise Exception(msg);
コード例 #3
0
	def updateAuthority(self, authorityId, text, menuIdList):
		DBConn().begin();
		try:
			DBAuthority.deleteByAuthorityId(authorityId)
			DBAuthority.insrt(text, authorityId, menuIdList)
			DBConn().commit(); 
		except Exception, e:
			print e
			DBConn().rollback();
コード例 #4
0
ファイル: DBUserInfo.py プロジェクト: SealOfFire/webpy_test
    def insert(self, userName, password):
        '''
		创建用户
		'''
        Logger.info('DBUserInfo.insert begin')
        sql = ''' insert into mgame_tool.user_info(user_name, password) values(%s,%s)'''
        db = DBConn()
        rownum, db_res = db.query(sql, (userName, password))
        return rownum
コード例 #5
0
ファイル: DBUserInfo.py プロジェクト: SealOfFire/webpy_test
	def insert(self, userName, password):
		'''
		创建用户
		'''
		Logger.info('DBUserInfo.insert begin')
		sql = ''' insert into mgame_tool.user_info(user_name, password) values(%s,%s)'''
		db = DBConn()
		rownum, db_res = db.query(sql, (userName, password))
		return rownum
コード例 #6
0
ファイル: DBAuthority.py プロジェクト: SealOfFire/webpy_test
	def insrtaaaaaaaaaaaaaaaa(self, text, menuIdList=None):
		sql = ''' insert into mgame_tool.authority(menu_id,comment) values(%s,%s)'''
		db = DBConn()
		param = []
		if menuIdList == None:
			param.append((-1, text))
		else:
			for menuId in menuIdList:
				param.append((menuId, text))
		rownum, db_res = db.execMany(sql, param)
		return rownum
コード例 #7
0
ファイル: DBAuthority.py プロジェクト: SealOfFire/webpy_test
	def insrt(self, text, authorityId=None, menuIdList=None):
		sql = ''' insert into mgame_tool.authority(menu_id,comment) values(%s,%s)'''
		db = DBConn()
		param = []
		if menuIdList == None:
			rownum, db_res = db.query(sql, (-1, text))
			return db.getLastInsertId()
		else:
			sql = ''' insert into mgame_tool.authority(authority_id,menu_id,comment) values(%s,%s,%s)'''
			for menuId in menuIdList:
				rownum, db_res = db.query(sql, (authorityId, menuId, text))
		return rownum
コード例 #8
0
ファイル: DBAuthority.py プロジェクト: SealOfFire/webpy_test
	def selectAuthorityByUserName(self, userName):
		'''
		'''
		returnValue = []
		sql = ''' select user_name,authority_id from mgame_tool.user_authority where user_name=%s '''
		db = DBConn()
		rownum, db_res = db.query(sql, (userName))
		for row in 	db_res:
			returnValue = {}
			returnValue['userName'] = row[0]
			returnValue['authorityId'] = row[1]
			return returnValue
		return returnValue;
コード例 #9
0
ファイル: DBMenu.py プロジェクト: SealOfFire/webpy_test
	def selectByMenuId(self, menuId):
		'''
		'''
		returnValue = {}
		sql = ''' select  menu_id,text,url,sort from mgame_tool.menu where menu_id=%s '''
		db = DBConn()
		rownum, db_res = db.query(sql, (menuId))
		rownum += 0
		for row in	 db_res:
			returnValue['menuId'] = row[0]
			returnValue['text'] = row[1]
			returnValue['url'] = row[2]
			returnValue['sort'] = row[3]
		return returnValue
コード例 #10
0
    def selectByMenuId(self, menuId):
        '''
		'''
        returnValue = {}
        sql = ''' select  menu_id,text,url,sort from mgame_tool.menu where menu_id=%s '''
        db = DBConn()
        rownum, db_res = db.query(sql, (menuId))
        rownum += 0
        for row in db_res:
            returnValue['menuId'] = row[0]
            returnValue['text'] = row[1]
            returnValue['url'] = row[2]
            returnValue['sort'] = row[3]
        return returnValue
コード例 #11
0
ファイル: DBAuthority.py プロジェクト: SealOfFire/webpy_test
	def selectAuthorityById(self, id):
		'''
		通过id查找权限
		'''
		returnValue = []
		sql = ''' select authority_id,menu_id,comment from mgame_tool.authority where authority_id=%s '''
		db = DBConn()
		rownum, db_res = db.query(sql, (id))
		for row in 	db_res:
			temp = {}
			temp['authorityId'] = row[0]
			temp['menuId'] = row[1]
			temp['comment'] = row[2]
			returnValue.append(temp)
		return returnValue;
コード例 #12
0
ファイル: DBUserInfo.py プロジェクト: SealOfFire/webpy_test
	def select(self, userName):
		'''
		查找指定的用户
		'''
		returnValue = {}
		sql = ''' select * from mgame_tool.user_info where user_name=%s '''
		db = DBConn()
		rownum, db_res = db.query(sql, (userName))
		for row in 	db_res:
			temp = {}
			temp['userName'] = row[0]
			returnValue.append(temp)
		if rownum == 0:
			return None
		else:
			return returnValue;
コード例 #13
0
ファイル: DBUserInfo.py プロジェクト: SealOfFire/webpy_test
    def select(self, userName):
        '''
		查找指定的用户
		'''
        returnValue = {}
        sql = ''' select * from mgame_tool.user_info where user_name=%s '''
        db = DBConn()
        rownum, db_res = db.query(sql, (userName))
        for row in db_res:
            temp = {}
            temp['userName'] = row[0]
            returnValue.append(temp)
        if rownum == 0:
            return None
        else:
            return returnValue
コード例 #14
0
ファイル: DBAuthority.py プロジェクト: SealOfFire/webpy_test
	def checkUserUrl(self, userName, url):
		'''
		验证用户是否有权限访问页面
		'''
		sql = '''
		select count(*) from mgame_tool.menu
		inner join mgame_tool.authority on menu.menu_id=authority.menu_id
		inner join mgame_tool.user_authority on user_authority.authority_id=authority.authority_id
		where user_authority.user_name=%s and menu.url=%s
		'''
		db = DBConn()
		rownum, db_res = db.query(sql, (userName, url))
		rownum += 0
		for row in db_res:
			if row[0] >= 1:
				return True
		return False
コード例 #15
0
ファイル: DBAuthority.py プロジェクト: SealOfFire/webpy_test
	def selectAuthority(self, text):
		'''
		查找指定的用户
		'''
		Logger.info('DBAuthority.selectAuthority begin')
		returnValue = {}
		sql = ''' select authority_id,comment from mgame_tool.authority where comment=%s group by authority_id,comment '''
		db = DBConn()
		rownum, db_res = db.query(sql, (text))
		for row in 	db_res:
			temp = {}
			temp['id'] = row[0]
			temp['comment'] = row[1]
			returnValue.append(temp)
		if rownum == 0:
			return None
		else:
			return returnValue;
コード例 #16
0
    def selectAll(self):
        '''
		
		'''
        returnValue = []
        Logger.info('DBMenu.selectAll begin')
        db = DBConn()
        sql = 'select menu_id,text,url,sort from mgame_tool.menu where parent_id>0 order by parent_id,sort'
        rownum, db_res = db.query(sql)
        rownum += 0
        for row in db_res:
            temp = {}
            temp['menuId'] = row[0]
            temp['text'] = row[1]
            temp['url'] = row[2]
            temp['sort'] = row[3]
            returnValue.append(temp)
        return returnValue
コード例 #17
0
ファイル: DBMenu.py プロジェクト: SealOfFire/webpy_test
	def selectAll(self):
		'''
		
		'''
		returnValue = []
		Logger.info('DBMenu.selectAll begin')
		db = DBConn()
		sql = 'select menu_id,text,url,sort from mgame_tool.menu where parent_id>0 order by parent_id,sort'
		rownum, db_res = db.query(sql)
		rownum += 0
		for row in	 db_res:
			temp = {}
			temp['menuId'] = row[0]
			temp['text'] = row[1]
			temp['url'] = row[2]
			temp['sort'] = row[3]
			returnValue.append(temp)
		return returnValue
コード例 #18
0
ファイル: DBUserInfo.py プロジェクト: SealOfFire/webpy_test
	def selectAll(self, userName=''):
		'''
		查询用户
		'''
		Logger.info('DBUserInfo.select begin')
		returnValue = []
		sql = ''' select * from mgame_tool.user_info '''
		where = ''' where user_name like %s '''
		rownum, db_res = None, None
		db = DBConn()
		if userName == '':
			rownum, db_res = db.query(sql)
		else:
			sql = sql + where
			rownum, db_res = db.query(sql, ('%' + userName + '%'))
		rownum += 0
		for row in 	db_res:
			temp = {}
			temp['userName'] = row[0]
			returnValue.append(temp)
		return returnValue;
コード例 #19
0
ファイル: DBUserInfo.py プロジェクト: SealOfFire/webpy_test
    def selectAll(self, userName=''):
        '''
		查询用户
		'''
        Logger.info('DBUserInfo.select begin')
        returnValue = []
        sql = ''' select * from mgame_tool.user_info '''
        where = ''' where user_name like %s '''
        rownum, db_res = None, None
        db = DBConn()
        if userName == '':
            rownum, db_res = db.query(sql)
        else:
            sql = sql + where
            rownum, db_res = db.query(sql, ('%' + userName + '%'))
        rownum += 0
        for row in db_res:
            temp = {}
            temp['userName'] = row[0]
            returnValue.append(temp)
        return returnValue
コード例 #20
0
ファイル: DBAuthority.py プロジェクト: SealOfFire/webpy_test
	def selectAllAuthority(self, text=''):
		'''
		查询用户
		'''
		Logger.info('DBAuthority.selectAllAuthority begin')
		returnValue = []
		sql = ''' select authority_id,comment from mgame_tool.authority '''
		where = ''' where comment like %s '''
		groupBy = ''' group by authority_id,comment '''
		rownum, db_res = None, None
		db = DBConn()
		if text == '':
			rownum, db_res = db.query(sql + groupBy)
		else:
			sql = sql + where + groupBy
			rownum, db_res = db.query(sql, ('%' + text + '%'))
		rownum += 0
		for row in 	db_res:
			temp = {}
			temp['id'] = row[0]
			temp['comment'] = row[1]
			returnValue.append(temp)
		return returnValue;
コード例 #21
0
ファイル: DBUserInfo.py プロジェクト: SealOfFire/webpy_test
	def login(self, userName, password):
		'''
		用户登录
		'''
		Logger.info('DBUserInfo.login begin')
		# Logger.info('DBUserInfo.login begin')
		db = DBConn()
		sql = 'select count(*) from mgame_tool.user_info where user_name=%s and password=%s'
		rownum, db_res = db.query(sql, (userName, password))
		rownum += 0
		for row in db_res:
			if row[0] == 1:
				return True
				# Logger.info('DBUserInfo.login end')
			elif row[0] == 0:
				return False
				# Logger.info('DBUserInfo.login end')
			elif row[0] > 1:
				msg = 'DBUserInfo.login:有重复用户userName[%s]' % userName
				Logger.error(msg)
				raise Exception(msg);
		msg = 'DBUserInfo.login:用户数据错误userName[%s]' % userName
		Logger.error(msg)
		raise Exception(msg);
コード例 #22
0
ファイル: DBUserInfo.py プロジェクト: SealOfFire/webpy_test
    def login(self, userName, password):
        '''
		用户登录
		'''
        Logger.info('DBUserInfo.login begin')
        # Logger.info('DBUserInfo.login begin')
        db = DBConn()
        sql = 'select count(*) from mgame_tool.user_info where user_name=%s and password=%s'
        rownum, db_res = db.query(sql, (userName, password))
        rownum += 0
        for row in db_res:
            if row[0] == 1:
                return True
                # Logger.info('DBUserInfo.login end')
            elif row[0] == 0:
                return False
                # Logger.info('DBUserInfo.login end')
            elif row[0] > 1:
                msg = 'DBUserInfo.login:有重复用户userName[%s]' % userName
                Logger.error(msg)
                raise Exception(msg)
        msg = 'DBUserInfo.login:用户数据错误userName[%s]' % userName
        Logger.error(msg)
        raise Exception(msg)
コード例 #23
0
ファイル: DBAuthority.py プロジェクト: SealOfFire/webpy_test
	def deleteByAuthorityId(self, authorityId):
		sql = ''' delete from mgame_tool.authority where authority_id=%s '''
		db = DBConn()
		rownum, db_res = db.query(sql, (authorityId))
		return rownum
コード例 #24
0
ファイル: DBAuthority.py プロジェクト: SealOfFire/webpy_test
	def update(self, userName, authorityId):
		# sql = ''' replace mgame_tool.user_authority set authority_id=%s where user_name=%s '''
		sql = ''' replace into mgame_tool.user_authority(user_name,authority_id) values(%s,%s) '''
		db = DBConn()
		rownum, db_res = db.query(sql, (userName, authorityId))
		return rownum