def moveinst(inst_nm, origin_book_nm, target_book_nm):
origin_book = db_session.query(models.InstrumentMaster).filter_by(name=origin_book_nm).first()
if origin_book is None:
return message.noExistBook(origin_book)
origin_instruments = json.loads(origin_book.instruments)
if origin_instruments.has_key(inst_nm):
inst = origin_instruments.pop(inst_nm)
target_book = db_session.query(models.InstrumentMaster).filter_by(name=target_book_nm).first()
if target_book is None:
return message.noExistBook(target_book)
target_instruments = json.loads(target_book.instruments)
if target_instruments.has_key(inst_nm):
return message.instrumentExistInBook(inst_nm, target_book_nm)
target_instruments[inst_nm] = inst
target_book.instruments = target_instruments
db_session.commit()
else:
return message.noInstrumentExistInBook(inst_nm, origin_book_nm)
def removebook(book_nm):
book = db_session.query(models.MxfBook).filter_by(name=book_nm).first()
if book is None:
return message.noExistBook(book_nm)
db_session.delete(book)
db_session.commit()
return 'book : ' + book_nm + ' is removed'
def removeinst(inst_nm):
inst = db_session.query(models.InstrumentMaster).filter_by(name=inst_nm).first()
if inst is None:
return message.noExistInst(inst_nm)
db_session.delete(inst)
db_session.commit()
return 'inst : ' + inst_nm + ' is removed'
def booklist():
books = db_session.query(models.MxfBook).all()
b = []
for book in books:
#b.append(json.dumps(book.to_json()))
b.append(book.to_json())
return b
def instinfo(inst_nm):
inst = db_session.query(models.InstrumentMaster).filter_by(name=inst_nm).first()
return inst.contents
def get_book(name):
book = db_session.query(models.MxfBook).filter_by(name=name).first()
return book