def get_bmy_id_model_ids(): ''' 获取bmy_id对应model_id的对应关系 ''' query_cond = {} fields = {'bmy_id': 1, 'model_id': 1} return MMongoDb.convert_recs(MMongoDb.db['t_bmy']\ .find(query_cond, fields))
def get_bmy_code_to_bmy_id_dict(): ''' 获取bmy_code到bmy_id字典 ''' query_cond = {} fields = {'bmy_code': 1, 'bmy_id': 1} return MMongoDb.convert_recs(MMongoDb.db['t_bmy']\ .find(query_cond, fields))
def get_bmys(): query_cond = {} fields = { 'bmy_id': 1, 'bmy_name': 1, 'bmy_code': 1, 'brand_id': 1, 'brand_code': 1, 'model_id': 1, 'model_code': 1 } return MMongoDb.convert_recs(MMongoDb.db['t_bmy']\ .find(query_cond, fields).sort([('bmy_id', pymongo.ASCENDING)]))
def get_bmy_id_bmy_vos(): query_cond = {} fields = { 'bmy_id': 1, 'bmy_name': 1, 'bmy_code': 1, 'brand_id': 1, 'brand_code': 1, 'model_id': 1, 'model_code': 1 } return MMongoDb.convert_recs(MMongoDb.db['t_bmy']\ .find(query_cond, fields))
def get_wxs_bms(): query_cond = {'source_type': 1} fields = {'model_code': 1, 'model_name': 1} return MMongoDb.convert_recs(MMongoDb.db['t_model']\ .find(query_cond, fields))
def get_bmy_id_bmy_names(): query_cond = {} fields = {'bmy_id': 1, 'bmy_name': 1} return MMongoDb.convert_recs(MMongoDb.db['t_bmy'].find( query_cond, fields))
def get_vin_id_codes(): query_cond = {'vin_code': {'$regex': '_'}} fields = {'vin_id': 1, 'vin_code': 1, 'bmy_id': 1} return MMongoDb.convert_recs(MMongoDb.db['t_vin']\ .find(query_cond, fields).sort([('vin_code', 1)]))
def get_wxs_brands(): query_cond = {'source_type': 1} fields = {'brand_id': 1, 'brand_name': 1, 'brand_code': 1} return MMongoDb.convert_recs(MMongoDb.db['t_brand']\ .find(query_cond, fields))
def get_vins_base(source_type): query_cond = {'source_type': source_type} fields = {'vin_id': 1, 'vin_code': 1, 'bmy_id': 1} return MMongoDb.convert_recs(MMongoDb.db['t_vin']\ .find(query_cond, fields).sort([('vin_code', 1)]))
def get_vin_code_bmy_id_dict(): query_cond = {} fields = {'vin_code': 1, 'bmy_id': 1} return MMongoDb.convert_recs(MMongoDb.db['t_vin']\ .find(query_cond, fields))
def get_vin_codes(): query_cond = {} fields = {"vin_id": 1, "vin_code": 1} return MMongoDb.convert_recs(MMongoDb.db['t_vin'].find( query_cond, fields).sort([('vin_code', 1)]))
def get_bmy_ids_by_vin_code(prefix_vin_code): query_cond = {"vin_code": prefix_vin_code} fields = {"vin_id": 1, "bmy_id": 1} return MMongoDb.convert_recs(MMongoDb.db['t_vin'].find( query_cond, fields))
def get_vin_samples(vin_id): query_cond = {'vin_id': vin_id} fields = {"img_file": 1, "bmy_id": 1} return MMongoDb.convert_recs(MMongoDb.db['t_sample'].find( query_cond, fields).sort([('img_file', 1)]))