def _get(self, _app_uuid, _group_uuid): _redis = self.application.redis _key = OrgGroup.__tablename__ + ".app_uuid." + _app_uuid _is = _redis.sismember(_key, _group_uuid) if _is != True: self.setErrorCode(API_ERR.NO_ORG_GROUP) return _row = OrgGroup(uuid=_group_uuid) _row.async_delete(_redis) _row.delete_redis_keys(_redis) return
def update_group_icon(_redis, _group_uuid): _key = OrgUserGroupData.__tablename__ + ".group_uuid." + _group_uuid _users = _redis.smembers(_key) _group_icon = None if len(_users) == 0: _group_icon = create_user_icon(_group_uuid) else: _group_icon = create_group_icon(_redis, _users) _row = OrgGroup(uuid=_group_uuid, group_icon=_group_icon) _row.update_redis_keys(_redis) _row.async_update() return
def _remove(self, _app_uuid, _group_uuid): _redis = self.application.redis _key = OrgGroup.__tablename__ + ".app_uuid." + _app_uuid _is = _redis.sismember(_key, _group_uuid) if _is != True: logging.error("group: %s not belong to app_uuid: %s" % (_group_uuid, _app_uuid)) return _row = OrgGroup(uuid=_group_uuid) _row.async_delete(_redis) _row.delete_redis_keys(_redis) return
def _get(self, _app_uuid, _group_name, _group_desc): _redis = self.application.redis _uuid = str(uuid.uuid1()) _row = OrgGroup( uuid=_uuid, app_uuid=_app_uuid, group_name=_group_name, group_icon=create_user_icon(_uuid), group_desc=_group_desc ) _row.async_add() _row.create_redis_keys(_redis) _group = redis_hash_to_dict(_redis, OrgGroup, _row.uuid) if _group == None: self.setErrorCode(API_ERR.NO_ORG_GROUP) return _r = self.getReturnData() _r.update(_group) return
def _get(self, _app_uuid, _group_uuid, _body): _redis = self.application.redis _key = OrgGroup.__tablename__ + \ ".app_uuid." + _app_uuid _is = _redis.sismember(_key, _group_uuid) if _is != True: self.setErrorCode(API_ERR.NO_ORG_GROUP) return _group = redis_hash_to_dict(_redis, OrgGroup, _group_uuid) if _group == None: self.setErrorCode(API_ERR.NO_ORG_GROUP) return del _body["group_uuid"] del _body["app_uuid"] for _i in _body: if _i not in _group: logging.error("can not set: %s" % _i) continue _group[_i] = _body[_i] _r = self.getReturnData() for _i in _group: _r[_i] = _group[_i] _r["group_uuid"] = _group["uuid"] del _group["createtime"] del _group["updatetime"] _row = OrgGroup(**_group) _row.async_update() _row.update_redis_keys(_redis) return
def _get(self, _app_uuid, _group_uuid): _redis = self.application.redis _key = OrgGroup.__tablename__ + \ ".app_uuid." + _app_uuid _is = _redis.sismember(_key, _group_uuid) if _is != True: self.setErrorCode(API_ERR.NO_ORG_GROUP) return _row = OrgGroup(uuid=_group_uuid) _row.async_delete(_redis) _row.delete_redis_keys(_redis) return
def _get(self, _app_uuid, _group_name, _group_desc): _redis = self.application.redis _uuid = str(uuid.uuid1()) _row = OrgGroup(uuid=_uuid, app_uuid=_app_uuid, group_name=_group_name, group_icon=create_user_icon(_uuid), group_desc=_group_desc) _row.async_add() _row.create_redis_keys(_redis) _group = redis_hash_to_dict(_redis, OrgGroup, _row.uuid) if _group == None: self.setErrorCode(API_ERR.NO_ORG_GROUP) return _r = self.getReturnData() _r.update(_group) return
def Csv2Mysql(csv_file): dbsession_class = getDatabaseInstance().dbsession_class db_session = dbsession_class() csv_data = csv.reader(file(csv_file)) flag = 0 for i in csv_data: flag += 1 if flag != 1: row = [] for item in i: row.append(encodeToUtf8(item, code_str)) try: user_id = isUserExists(db_session, row[0]) if not user_id: deviceuser = DeviceUser() deviceuser.user_name = row[0] deviceuser.user_fullname = row[1] deviceuser.user_email = row[2] deviceuser.user_type = row[3] deviceuser.user_status = row[4] deviceuser.user_icon = "/static/yvertical/assets/img/user1.png" deviceuser.user_gender = row[5] deviceuser.user_dob = row[6] deviceuser.user_doj = row[7] deviceuser.user_rid = row[8] deviceuser.user_iid = row[9] is_byod = isByod(row[12]) deviceuser.user_is_byod = is_byod deviceuser.user_is_enod = not is_byod db_session.add(deviceuser) db_session.commit() user_id = deviceuser.id except: dbsession_class.remove() traceback.print_exc() break try: group_id = isGroupExists(db_session, row[11]) if not group_id: orggroup = OrgGroup() orggroup.group_name = row[11] orggroup.group_icon = "/static/yvertical/assets/img/group.jpg" db_session.add(orggroup) db_session.commit() group_id = orggroup.id except: dbsession_class.remove() traceback.print_exc() try: user_data_id = isUserDataExists(db_session, user_id, group_id) if not user_data_id: user_data = OrgGroupUserData() user_data.group_id = group_id user_data.user_id = user_id user_data.is_leader = isLeader(row[10]) db_session.add(user_data) db_session.commit() except: dbsession_class.remove() traceback.print_exc() else: if isinstance(i[0], unicode): code_str = None else: code_str = chardet.detect(i[0])["encoding"]