import pandas as pd from typing import List, Dict from pydantic import ValidationError, BaseModel from pydantic import Field, StrictStr, StrictInt from enum import Enum __all__ = ('TUserModel', 'UserModel', 'TPaylistModel', 'PaylistModel', 'TEventModel', 'EventModel') class Platform(str, Enum): ios = 'ios' android = 'android' class Sex(int, Enum): unknown = 0 woman = 1 man = 2 class TBaseModel(BaseModel): channel_name: StrictStr = Field(..., title="channel", alias='_channel_name') channel_uid: StrictStr = Field(..., title="channel_uid", alias='_channel_uid') device_id: StrictStr = Field(..., title='device_id', alias='_device_id') district_server_id: StrictInt = Field(..., title="区服id", alias='_district_server_id') first_device_id: StrictStr = Field(..., title='device_id', alias='_first_device_id') game_role_id: StrictStr = Field(..., title="角色id", alias='_game_role_id') owner_name: StrictStr = Field(..., title="owner", alias='_owner_name') platform: Platform = Field(..., title="平台", alias='_platform') event_time: StrictInt = Field(..., title="事件时间", alias='_event_time') role_level: StrictInt = Field(..., title="角色等级") role_stage: StrictStr = Field(..., title="关卡") role_vip: StrictInt = Field(..., title="角色vip等级") role_create_time: StrictInt = Field(..., title="角色创建时间") user_name: StrictStr = Field(..., title="角色名") class Config: error_msg_templates = { 'type_error.integer': '需要整数类型', 'type_error.str': '需要字符串类型', 'type_error.dict': '需要字典类型', 'type_error.list': '需要列表类型', 'value_error.list.min_items': '最少需要{limit_value}项', 'value_error.any_str.min_length': '最小需要{limit_value}个字符', 'value_error.missing': '缺少该字段', 'type_error.enum': '需要{enum_values}' } class GBaseModel(BaseModel): channel_name: str = Field(..., min_length=1, title="channel", alias='_channel_name') channel_uid: str = Field(..., min_length=1, title="channel_uid", alias='_channel_uid') device_id: str = Field(..., min_length=1, title='device_id', alias='_device_id') district_server_id: int = Field(..., title="区服id", alias='_district_server_id') first_device_id: str = Field(..., min_length=1, title='device_id', alias='_first_device_id') game_role_id: str = Field(..., min_length=1, title="角色id", alias='_game_role_id') owner_name: str = Field(..., min_length=1, title="owner", alias='_owner_name') platform: Platform = Field(..., title="平台", alias='_platform') event_time: int = Field(..., title="事件时间", alias='_event_time') role_level: int = Field(..., title="角色等级") role_stage: str = Field(..., min_length=1, title="关卡") role_vip: int = Field(..., title="角色vip等级") role_create_time: int = Field(..., title="角色创建时间") user_name: str = Field(..., min_length=1, title="角色名") class Config: error_msg_templates = { 'type_error.integer': '需要整数类型', 'type_error.str': '需要字符串类型', 'type_error.dict': '需要字典类型', 'type_error.list': '需要列表类型', 'value_error.list.min_items': '最少需要{limit_value}项', 'value_error.any_str.min_length': '最小需要{limit_value}个字符', 'value_error.missing': '缺少该字段', 'type_error.enum': '需要{enum_values}' } class TUserModel(TBaseModel): role_diamonds: StrictInt = Field(...) union_name: StrictStr = Field(...) union_id: StrictStr = Field(...) app_version: StrictStr = Field(..., alias='_app_version') app_name: StrictStr = Field(..., alias='_app_name') game_version: StrictStr = Field(..., alias='_game_version') role_race: StrictStr = Field(...) role_sex: Sex = Field(...) role_type: StrictStr = Field(...) combat_effectiveness: StrictInt = Field(...) last_login_time: StrictInt = Field(...) role_camp: StrictStr = Field(...) role_number: StrictInt = Field(...) role_yxb: StrictInt = Field(...) class UserModel(GBaseModel): role_diamonds: int = Field(..., title="") union_name: str = Field(..., min_length=1, title="") union_id: str = Field(..., min_length=1, title="") app_version: str = Field(..., min_length=1, alias='_app_version') app_name: str = Field(..., min_length=1, alias='_app_name') game_version: str = Field(..., min_length=1, alias='_game_version') role_race: str = Field(..., min_length=1, title="") role_sex: Sex = Field(..., title="") role_type: str = Field(..., min_length=1, title="") combat_effectiveness: int = Field(..., title="") last_login_time: int = Field(..., title="") role_camp: str = Field(..., min_length=1, title="") role_number: int = Field(..., title="") role_yxb: int = Field(..., title="") class TPaylistModel(TBaseModel): orderid: StrictStr = Field(...) money: StrictInt = Field(...) proid: StrictStr = Field(...) class PaylistModel(GBaseModel): orderid: str = Field(..., min_length=1) money: int = Field(..., gt=0) proid: str = Field(..., min_length=1) class TEventModel(TBaseModel): role_diamonds: StrictInt = Field(...) app_version: StrictStr = Field(..., alias='_app_version') app_name: StrictStr = Field(..., alias='_app_name') game_version: StrictStr = Field(..., alias='_game_version') role_yxb: StrictInt = Field(...) need: List[Dict] = Field(None, alias='_game_version') prize: List[Dict] = Field(None, alias='_game_version') class EventModel(GBaseModel): role_diamonds: int = Field(...) app_version: str = Field(..., min_length=1, alias='_app_version') app_name: str = Field(..., min_length=1, alias='_app_name') game_version: str = Field(..., min_length=1, alias='_game_version') role_yxb: int = Field(...) need: List[Dict] = Field(None, min_items=1) prize: List[Dict] = Field(None, min_items=1) # a = """_game_role_id 角色id str >0 # _device_id 设备id str >0 # _first_device_id 注册设备id str >0 # _channel_name 渠道名 str >0 # _channel_uid 账号 str >0 # _district_server_id 区服id int >0 # _owner_name 发行名 str >0 # role_create_time 角色创建时间 int >0 # role_level 角色等级 int >=0 # role_stage 主线关卡 str >0 # role_vip 角色vip int >=0 # _platform 平台 str enum('ios','android') # _app_version app版本 str >0 # _game_version 游戏版本 str >0 # _app_name app名 str >0 # user_name 用户名 str >0 # role_diamonds 钻石数量 int >=0 # role_yxb 游戏币 int >=0 # role_number 角色序号 int >=0 # role_type 角色职业 str # role_sex 角色性别 int enum(0,1,2) # role_race 角色种族 str # role_camp 角色阵营 str # last_login_time 最近上线时间 int >0 # union_id 公会id str # union_name 公会名称 str # combat_effectiveness 玩家战力 int >=0""" # # b = """_game_role_id 角色id str >0 # _platform 平台 str enum('ios','android') # orderid 订单id str >0 # _event_time 事件时间 int >0 # _owner_name 发行 str >0 # money 金额 元 int >0 # _district_server_id 区服id int >0 # _first_device_id 注册设备id str >0 # role_level 角色等级 int >=0 # role_vip 角色vip int >=0 # _device_id 设备id str >0 # proid 计费点 str >0 # _channel_name 渠道名 str >0 # user_name 用户名 str >0 # role_stage 主线关卡 str >0 # _channel_uid 账号 str >0""" # # c = """_game_role_id 角色id str >0 # _device_id 设备id str >0 # _first_device_id 注册设备id str >0 # _channel_name 渠道名 str >0 # _channel_uid 账号 str >0 # _district_server_id 区服id int >0 # _owner_name 发行名 str >0 # role_create_time 角色创建时间 int >0 # role_level 角色等级 int >=0 # role_stage 主线关卡 str >0 # role_vip 角色vip int >=0 # _platform 平台 str enum('ios','android') # _app_version app版本 str >0 # _game_version 游戏版本 str >0 # _app_name app名 str >0 # user_name 用户名 str >0 # role_diamonds 钻石数量 int >=0 # role_yxb 游戏币 int >=0 # _event_name 时间名 str >0 # _event_time 事件时间 int >0 # need 消耗 （如果有） list[dict,...] >0 # prize 奖励（如果有） list[dict,...] >0""" # # aa = set() # bb = set() # cc = set() # for i in a.split('\n'): # aa.add(i.split('\t')[0]) # for i in b.split('\n'): # bb.add(i.split('\t')[0]) # # for i in c.split('\n'): # cc.add(i.split('\t')[0]) # # dd = (aa & bb & cc) # # print(aa - dd) # # print(bb - dd) # # print(cc - dd)