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,
