def migrate_memo(): from projectl.models import Memo as Ml from projectl.models import User as Ul from project.models import Memo as Mm from project.models import User as Um for i in Ml.query.all(): user_id = Um.query.filter(Um.username==i.created_by).first().id u = Mm() u.id = i.id u.vendor_id = i.vendor_id u.user_id = int(user_id) u.reference_no = i.reference_no u.ref_no_old = i.ref_no_old u.contract_no = i.contract_no u.counter = i.counter u.type_of_doc = i.type_of_doc u.status = i.status u.subject = i.subject u.memo_date = i.memo_date u.remarks = i.remarks u.signed_by = i.signed_by u.waiting_date = i.waiting_date u.path = i.path u.destination = i.destination u.filename = i.filename u.technology = i.technology u.received_from = i.received_from u.end_user = i.end_user u.reply_flag = i.reply_flag u.reserve_flag = i.reserve_flag db.session.add(u) db.session.commit()