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()
