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 make_book(name):
# if models.LoginID is None:
# raise Exception('Login is needed')
instruments = '''{ }'''
book = models.MxfBook(name=name, user=models.LoginID, created_date=datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S"), instruments=instruments)
db_session.add(book)
db_session.commit()
return book
def bookinginst(inst_nm, book_nm, contents):
book = get_book(book_nm)
if book is None:
return message.noExistBook(book_nm)
inst = models.InstrumentMaster(name=inst_nm, contents=contents)
if inst is not None:
return message.noInstrumentExistInBook(inst_nm, book_nm)
db_session.add(inst)
db_session.commit()
def booking(self, inst):
inst['booked_time'] = datetime.datetime.now().strftime(
"%Y-%m-%d %H:%M:%S")
booked_insts = json.loads(self.instruments)
if inst.name in booked_insts:
raise Exception('instrument exist. name : ' + inst.name)
booked_inst = dict()
booked_inst['open_time'] = inst['booked_time']
booked_inst['closed_time'] = None
booked_inst['is_closed'] = False
# add inst to book
booked_insts[inst.name] = booked_inst
self.instruments = json.dumps(booked_insts)
# self.instruments.append(inst)
inst_master = InstrumentMaster()
inst_master.name = inst.name
inst_master.contents = json.dumps(inst)
db_session.add(inst_master)
db_session.commit()