for dp in old_db.departments.find(): depts[dp['_id']] = dp['name'] for pj in old_db.projects.find(): projects[pj['_id']] = pj['name'] for source in old_db.sources.find(): sources[source['_id']] = source['name'] for e in old_db.equipment.find(): if not e['asset_no']: continue dept = depts[e['department_id']] dept_name = get_department(dept) if dept_name is None: print 'Invalid department - {}, {}'.format(dept, e['flex_id']) continue project = projects[e['project_id']] source = sources[e['source_id']].title() req_date = e.get('request_date', '') if req_date and hasattr(req_date, 'strftime'): req_date = req_date.strftime('%Y-%m-%d') doc = dict(_id=e['_id'], department=dept_name, project=project, source=source, sr=e['source_remark'],
accept=accept, remark=h['reject_remark'], flow=flow, ) user = get_user(h['user_id']) if user: item.update(user=user['full_name']) else: item.update(user='') history.append(item) doc = dict(_id=buy['_id'], login=login, login_id=login_id, department=get_department(depts[obj['department_id']]), project=projects[obj['project_id']], source=sources[buy['source_id']].title(), source_remark=buy['source_remark'], po=buy['po_no'], mf=buy['manufacturer'], supplier=buy['supplier'], model=obj.get('model', ''), owner=obj.get('owner', ''), price=buy['price'], date=buy['buy_date'].strftime('%Y-%m-%d'), tn=tn, cn=cn, kind=kind, name=name, asset=asset,