def Run(self):
with self.protocol.lockCmd:
if not self.Authorized():
self.SendUnauthorizedResp()
return
CBaseCommand.Run(self)
with SBDB.session_scope() as session :
dev_id=self.body[BaseCommand.PN_DEVICEID]
apartment_id=self.body[BaseCommand.PN_APARTMENTID]
respond=self.GetResp()
if dev_id is None:
respond.SetErrorCode(BaseCommand.CS_PARAMLACK)
else:
try:
apartment=SBDB.IncreaseVersions(session, 0,apartment_id)
#session.query(SBDB_ORM.ApartmentDevice).join(SBDB_ORM.Apartment).join(SBDB_ORM.Device).filter(and_(SBDB_ORM.Apartment.id==apartment_id,SBDB_ORM.Device.id==dev_id)).delete()
session.query(SBDB_ORM.ApartmentDevice).filter(and_(SBDB_ORM.ApartmentDevice.apartment_id==apartment_id,SBDB_ORM.ApartmentDevice.device_id==dev_id)).delete()
respond.body[BaseCommand.PN_VERSION]=apartment.version
session.commit()
except SQLAlchemyError,e:
respond.SetErrorCode(BaseCommand.CS_DBEXCEPTION)
logging.error("transport %d:%s",id(self.protocol.transport),e)
session.rollback()
respond.Send()
def Run(self):
with self.protocol.lockCmd:
if not self.Authorized():
self.SendUnauthorizedResp()
return
CBaseCommand.Run(self)
with SBDB.session_scope() as session :
apartment_id=self.body[BaseCommand.PN_APARTMENTID]
sb_id=self.body[BaseCommand.PN_RELAYERID]
sb_code=self.body.get(BaseCommand.PN_SB_CODE,None)
name=self.body.get(BaseCommand.PN_NAME,None)
respond=self.GetResp()
if sb_id is None:
respond.SetErrorCode(BaseCommand.CS_PARAMLACK)
else:
try:
apartment=None
if sb_code is None:
apartment=SBDB.IncreaseVersion(session, apartment_id)
else:
apartment=SBDB.IncreaseVersions(session, 0,apartment_id)
relayer,apartment_relayer=session.query(SBDB_ORM.Relayer,SBDB_ORM.Apartment_Relayer).join(SBDB_ORM.Apartment_Relayer).filter(and_(SBDB_ORM.Relayer.id==sb_id,SBDB_ORM.Apartment_Relayer.apartment_id==apartment_id)).first()
if name is not None: apartment_relayer.name=name
if sb_code is not None: relayer.uni_code=sb_code
respond.body[BaseCommand.PN_VERSION]=apartment.version
session.commit()
except SQLAlchemyError,e:
respond.SetErrorCode(BaseCommand.CS_DBEXCEPTION)
logging.error("transport %d:%s",id(self.protocol.transport),e)
session.rollback()
respond.Send()
def Run(self):
with self.protocol.lockCmd:
if not self.Authorized():
self.SendUnauthorizedResp()
return
CBaseCommand.Run(self)
apartment_id = self.body[BaseCommand.PN_APARTMENTID]
relayer_id = self.body.get(BaseCommand.PN_RELAYERID)
dev_model = self.body[BaseCommand.PN_DEVMODEL]
dev_code = self.body[BaseCommand.PN_DEVCODE]
dev_keys = self.body.get(BaseCommand.PN_DEVKEYS)
respond = self.GetResp()
with SBDB.session_scope() as session:
model = SBDB.GetDeviceModelByName(session, dev_model)
try:
if relayer_id is None:
relayer_id, = session.query(SBDB_ORM.Relayer.id).join(
SBDB_ORM.Apartment_Relayer).filter(
SBDB_ORM.Apartment_Relayer.apartment_id ==
apartment_id).order_by(
SBDB_ORM.Relayer.id).first()
else:
relayer_id = int(relayer_id)
if model is None:
respond.SetErrorCode(BaseCommand.CS_DEVICEMODEL)
elif relayer_id is None:
respond.SetErrorCode(BaseCommand.CS_NORELAYER)
elif session.query(SBDB_ORM.ApartmentDevice).join(
SBDB_ORM.Device).filter(
and_(
SBDB_ORM.Device.uni_code == dev_code,
SBDB_ORM.ApartmentDevice.apartment_id ==
apartment_id)).first() is not None:
respond.SetErrorCode(BaseCommand.CS_DEVICEEXIST)
else:
apartment = SBDB.IncreaseVersions(
session, 0, apartment_id)
device = SBDB.GetDeviceForcely(session, dev_code,
dev_model)
if device is None:
device = SBDB_ORM.Device()
device.device_model_id = model.id
device.uni_code = dev_code
session.add(device)
else:
apartment_device = SBDB_ORM.ApartmentDevice()
apartment_device.apartment_id = apartment_id
apartment_device.name = model.device_type.name
apartment_device.relayer_id = relayer_id
apartment_device.device_id = device.id
respond.body[
BaseCommand.PN_VERSION] = apartment.version
session.add(apartment_device)
session.commit()
respond.body[BaseCommand.PN_DEVICEID] = device.id
except SQLAlchemyError, e:
respond.SetErrorCode(BaseCommand.CS_DBEXCEPTION)
logging.error("transport %d:%s",
id(self.protocol.transport), e)
session.rollback()
respond.Send()
