def old_test(): address = ["127.0.0.1:11211"] #要连接的Memcached的主机地址端口号 hostname = "localhost" #要连接的Memcached的主机名 mclient.connect(address, hostname) #firefly重新封装的连接Memcached的方法,这样你就可连接到你要使用的Memcached tower_info = MAdmin("tb_tower_info", "id") #实例化一个MAdmin管理器,用来管理player表中的数据,player是你要管理的表名,id是该表的主键 #不清楚MAdmin是什么的童鞋请移步http://firefly.9miao.com/wiki/index.htm,wiki里面有个dbentrust使用文档,里面详细说明了firefly自定义的几个类与数据库之间的关联 tower_info.insert() #将管理器player注册到memcached中 tower_info.load() #一次性从数据库中将player表中所有数据读取到memcached中,如果不写本句,player只是一个空模型,没有数据,第一次取值时会到数据库中取出此次需要的数据并加载到memcached中, #如果第二次取值同第一次相同,则在memcached中取,否则需要再次同数据库建立连接进行取值 m = tower_info.getObj(1) #取出player表中主键(本例为id)为100001的这条数据对象(Mmode) data = m.get("data") #获取数据对象m里面包含的信息 print data #打印信息 data = {'name': u'haha', 'monsterdesc': u'1213', 'level': 30L, 'expbound': 10000L, 'dropoutid': 4001L, 'matrixid': 100001L, 'rule': u'[[4001,4001,4001,4001,4001],[1,3,5,7,9]]', 'boundinfo': u'sdfsadfas', 'id': 2} n = tower_info.new(data) n.insert() m = tower_info.getObj(2) data = m.get("data") print data MAdminManager().registe(tower_info) MAdminManager().checkAdmins()
def old_test(): address = ["127.0.0.1:11211"] #要连接的Memcached的主机地址端口号 hostname = "localhost" #要连接的Memcached的主机名 mclient.connect( address, hostname) #firefly重新封装的连接Memcached的方法,这样你就可连接到你要使用的Memcached tower_info = MAdmin( "tb_tower_info", "id") #实例化一个MAdmin管理器,用来管理player表中的数据,player是你要管理的表名,id是该表的主键 #不清楚MAdmin是什么的童鞋请移步http://firefly.9miao.com/wiki/index.htm,wiki里面有个dbentrust使用文档,里面详细说明了firefly自定义的几个类与数据库之间的关联 tower_info.insert() #将管理器player注册到memcached中 tower_info.load( ) #一次性从数据库中将player表中所有数据读取到memcached中,如果不写本句,player只是一个空模型,没有数据,第一次取值时会到数据库中取出此次需要的数据并加载到memcached中, #如果第二次取值同第一次相同,则在memcached中取,否则需要再次同数据库建立连接进行取值 m = tower_info.getObj(1) #取出player表中主键(本例为id)为100001的这条数据对象(Mmode) data = m.get("data") #获取数据对象m里面包含的信息 print data #打印信息 data = { 'name': u'haha', 'monsterdesc': u'1213', 'level': 30L, 'expbound': 10000L, 'dropoutid': 4001L, 'matrixid': 100001L, 'rule': u'[[4001,4001,4001,4001,4001],[1,3,5,7,9]]', 'boundinfo': u'sdfsadfas', 'id': 2 } n = tower_info.new(data) n.insert() m = tower_info.getObj(2) data = m.get("data") print data MAdminManager().registe(tower_info) MAdminManager().checkAdmins()
class UserManager: __metaclass__ = Singleton # 单例 def __init__(self): self._users = {} # 玩家字典 self.memUsers = MAdmin("tb_user", "acc") # 玩家表mem实例 self.memUsers.insert() MAdminManager().registe(self.memUsers) return def createUser(self, dynamicId, acc, pwd): """ 创建用户 """ if self.memUsers.getObj(str(acc)): return False userData = {"acc": acc, "pwd": pwd} memUser = self.memUsers.new(userData) # 创建mem对象 user = User(userData) # 实例化用户 self._users[dynamicId] = user # 添加到管理器 return user.getData() # 返回用户数据 def addUser(self, dynamicId, acc, pwd): """ 添加用户到管理器 """ userData = self.memUsers.getObjData(str(acc)) # 从mem中获取用户数据 if not userData: # mem中无数据 return False if userData.get("pwd") != pwd: # 密码错了 return False user = User(userData) # 实例化用户 self._users[dynamicId] = user # 添加到管理器 return user # 返回用户实例 def getUser(self, dynamicId): """ 获取用户 """ return self._users.get(dynamicId) # 返回用户实例 def dropUser(self, dynamicId): """ 从管理器删除用户 """ user = self.getUser(dynamicId) # 获取用户实例 if not user: return 0 acc = user.getAcc() # 获取帐号名 memUser = self.memUsers.getObj(str(acc)) # 获取mem对象 if not memUser: return 0 memUser.update_multi(user.data) # 更新数据 memUser.syncDB() # 保存到数据库 del self._users[dynamicId] # 从管理器删除用户 return 1
#coding:utf8 ''' Created on 2014-1-17 @author: CC ''' from gfirefly.dbentrust.mmode import MAdmin tb_character_admin=MAdmin('tb_character','id',incrkey='id') tb_character_admin.insert() tb_player_admin=MAdmin('tb_player','id',fk='cid',incrkey='id') tb_player_admin.insert() tb_item_admin=MAdmin('tb_item','id',fk='characterId',incrkey='id') tb_item_admin.insert() tb_zen_admin=MAdmin('tb_character_zen','characterId',incrkey='id') tb_zen_admin.insert()
# -*-coding:utf8-*- from gfirefly.dbentrust.mmode import MAdmin tb_account = MAdmin('tb_account', 'id') # 甯���疯〃 tb_account.insert() # ��ㄦ�蜂俊���琛� tb_character_info = MAdmin('tb_character_info', 'id') tb_character_info.insert() # ��遍��淇℃��琛� tb_character_hero = MAdmin('tb_character_hero', 'id', 1800) tb_character_hero.insert() # ��ㄦ�疯�遍��纰����淇℃��琛� tb_character_hero_chip = MAdmin('tb_character_hero_chip', 'id', 1800) tb_character_hero_chip.insert() # ��ㄦ�烽����疯����� tb_character_item_package = MAdmin('tb_character_item_package', 'id') tb_character_item_package.insert() # ��ㄦ�烽�靛�逛俊��� tb_character_line_up = MAdmin('tb_character_line_up', 'id') tb_character_line_up.insert() # 瑁�澶�淇℃��琛� tb_equipment_info = MAdmin('tb_equipment_info', 'id') tb_equipment_info.insert()
# -*- coding:utf-8 -*- """ created by server on 14-6-6上午11:12. """ from gfirefly.dbentrust.mmode import MAdmin tb_account = MAdmin('tb_account', 'id') # 帐号表 tb_account.insert() tb_character_info = MAdmin('tb_character_info', 'id') tb_character_info.insert()
mconfig = json.load(open('../models.json', 'r')) model_config = mconfig.get('models', {}) GlobalObject().json_model_config = model_config GlobalObject().json_model_default_config = {} address = ["127.0.0.1:11211"] #要连接的Memcached的主机地址端口号 hostname = "mem" #要连接的Memcached的主机名 mclient.connect(address, hostname) #firefly重新封装的连接Memcached的方法,这样你就可连接到你要使用的Memcached # 用户信息表 tb_character_info = MAdmin('tb_character_info', 'id') tb_character_info.insert() # 英雄信息表 tb_character_hero = MAdmin('tb_character_hero', 'id', 1800, fk='character_id') tb_character_hero.insert() character = tb_character_info.getObj(1037) print character print tb_character_hero.getObj('1037_10001') tb_character_hero.loadByFK(1037) print tb_character_hero.getObj('1037_10002')
#-*-coding:utf8-*- ''' Created on 2013-6-5 @author: lan (www.9miao.com) ''' from gfirefly.dbentrust.mmode import MAdmin tbitemadmin = MAdmin('tb_item', 'id', fk='characterId', incrkey='id') tbitemadmin.insert() tb_character_admin = MAdmin('tb_character', 'id', incrkey='id') tb_character_admin.insert() tb_zhanyi_record_admin = MAdmin('tb_zhanyi_record', 'id', fk='characterId', incrkey='id') tb_zhanyi_record_admin.insert() tb_matrix_amin = MAdmin('tb_character_matrix', 'characterId', incrkey='id') tb_matrix_amin.insert() tb_equipment = MAdmin('tb_equipment', 'characterId', incrkey='id') tb_equipment.insert() tbpetadmin = MAdmin('tb_pet', 'id', fk='ownerID', incrkey='id') tbpetadmin.insert()
#coding:utf8 ''' Created on 2013年9月4日 @author: MSI ''' from gfirefly.dbentrust.mmode import MAdmin register_admin = MAdmin( 'tb_register', 'username') #从数据库中读取tb_register表中的信息,key为第二个参数,即 username,value为对应的信息 register_admin.insert() #将数据写入到memcached中
# -*- coding:utf-8 -*- """ created by server on 14-6-10下午9:09. """ from gfirefly.dbentrust.mmode import MAdmin # 用户信息表 tb_character_info = MAdmin('tb_character_info', 'id') tb_character_info.insert() # 英雄信息表 tb_character_hero = MAdmin('tb_character_hero', 'id', fk='character_id') tb_character_hero.insert() # 用户英雄碎片信息表 tb_character_hero_chip = MAdmin('tb_character_hero_chip', 'id') tb_character_hero_chip.insert() # 用户道具背包 tb_character_item_package = MAdmin('tb_character_item_package', 'id') tb_character_item_package.insert() # 用户阵容信息 tb_character_line_up = MAdmin('tb_character_line_up', 'id') tb_character_line_up.insert() # 装备信息表 tb_equipment_info = MAdmin('tb_equipment_info', 'id', fk='character_id') tb_equipment_info.insert() # 装备碎片表
print data MAdminManager().registe(tower_info) MAdminManager().checkAdmins() mconfig = json.load(open('../models.json', 'r')) model_config = mconfig.get('models', {}) GlobalObject().json_model_config = model_config GlobalObject().json_model_default_config = {} address = ["127.0.0.1:11211"] #要连接的Memcached的主机地址端口号 hostname = "mem" #要连接的Memcached的主机名 mclient.connect(address, hostname) #firefly重新封装的连接Memcached的方法,这样你就可连接到你要使用的Memcached # 用户信息表 tb_character_info = MAdmin('tb_character_info', 'id') tb_character_info.insert() # 英雄信息表 tb_character_hero = MAdmin('tb_character_hero', 'id', 1800, fk='character_id') tb_character_hero.insert() character = tb_character_info.getObj(1037) print character print tb_character_hero.getObj('1037_10001') tb_character_hero.loadByFK(1037) print tb_character_hero.getObj('1037_10002')
def __init__(self): self._users = {} # 玩家字典 self.memUsers = MAdmin("tb_user", "acc") # 玩家表mem实例 self.memUsers.insert() MAdminManager().registe(self.memUsers) return
#coding:utf8 ''' Created on 2014-1-17 @author: CC ''' from gfirefly.dbentrust.mmode import MAdmin tb_character_admin = MAdmin('tb_character', 'id', incrkey='id') tb_character_admin.insert() tb_player_admin = MAdmin('tb_player', 'id', fk='cid', incrkey='id') tb_player_admin.insert() tb_item_admin = MAdmin('tb_item', 'id', fk='characterId', incrkey='id') tb_item_admin.insert() tb_zen_admin = MAdmin('tb_character_zen', 'characterId', incrkey='id') tb_zen_admin.insert()
#coding:utf8 ''' Created on 2014-3-20 @author: CC ''' from gfirefly.dbentrust.mmode import MAdmin register_admin=MAdmin('tb_character','nickname') register_admin.insert()