def get(self):
try:
entities = session.query(MODEL).order_by((MODEL.name)).all()
# session.autocommit = False
# session.autoflush = False
for entity in entities:
entity.images_data = []
if (entity.images != None and len(entity.images) > 0):
for img_id in entity.images:
image = session.query(Attachments).filter(
Attachments.id == img_id).first()
if not image:
continue
entity.images_data.append(image)
entity.products_count = 0
products = session.query(Products).filter(
Products.brand_id == entity.id,
Products.not_show_in_catalog != True,
Products.is_delete != True).all()
if (not products):
entity.products_count = 0
else:
entity.products_count = len(products)
return entities
except Exception as e:
session.rollback()
abort(400, message="Error while update " + ENTITY_NAME)
finally:
pass
def fan_out(self, period=30):
LOGGER.debug('Fanning out rows...')
stations = session.query(WeatherStation).filter_by(is_sent=0).all()
for station in stations:
session.begin()
try:
LOGGER.debug('Fanning out station %s' % str(station))
self.publish_station(station)
station.is_sent = 1
session.commit()
except Exception as e:
LOGGER.error('Error %s when processing station.', str(e))
session.rollback()
raise
metrics = session.query(Metric).filter_by(is_sent=0).all()
for metric in metrics:
session.begin()
try:
LOGGER.debug('Fanning out metric %s' % str(metric))
self.publish_metric(metric)
metric.is_sent = 1
session.commit()
except Exception as e:
LOGGER.error('Error %s when processing metric.', str(e))
session.rollback()
raise
threading.Timer(period, self.fan_out, [period]).start() # Periodic loop.
def get(self):
try:
# session.autocommit = False
# session.autoflush = False
entities = session.query(MODEL).filter(MODEL.is_delete == False).all()
for entity in entities:
entity.images_data = []
api_url = settings.API_URL
# if hasattr(entity, 'default_image_data'):
# if (entity.default_image_data != None and entity.default_image_data.file_path != None):
# entity.default_image_data.file_path = urllib.parse.urljoin(api_url,
# entity.default_image_data.file_path)
# if hasattr(entity, 'default_image_data'):
# if (entity.default_image_data != None and entity.default_image_data.thumb_file_path != None):
# entity.default_image_data.thumb_file_path = urllib.parse.urljoin(api_url,
# entity.default_image_data.thumb_file_path)
# if hasattr(entity, 'default_image_data'):
# if (entity.default_image_data != None and entity.default_image_data.optimized_size_file_path != None):
# entity.default_image_data.optimized_size_file_path = urllib.parse.urljoin(api_url,
# entity.default_image_data.optimized_size_file_path)
if (entity.gallery_images != None and len(entity.gallery_images) > 0):
for img_id in entity.gallery_images:
image = session.query(Attachments).filter(Attachments.id == img_id).first()
if not image:
continue
entity.images_data.append(image)
return entities
except Exception as e:
session.rollback()
abort(400, message="Error while update " + ENTITY_NAME)
finally:
pass
def post(self):
try:
json_data = request.get_json(force=True)
login = json_data["login"]
password = json_data["password"]
o_password = copy.copy(password)
t = bytes(password, 'utf-8')
password = str(base64.b64encode(t))
user_login = session.query(UserLogins).filter(and_(
UserLogins.login == login,
UserLogins.password == password))\
.first()
if user_login is None:
message = "Попытка авторизации с IP адреса " + request.remote_addr + ". Данными Login="******" Password="******"User doesn't exist")
user_login.last_login_date = datetime.datetime.now()
session.add(user_login)
message = "Пользователь " + user_login.user_data.first_name + " " + user_login.user_data.last_name + " зашел в кабинет (компания " + user_login.user_data.client.name + ")"
log = Log(message)
session.add(log)
session.commit()
return user_login
except Exception as e:
session.rollback()
abort(400, message="Error Auth")
def post(self):
try:
json_data = request.get_json(force=True)
client_type = ClientTypes(name=json_data["name"])
session.add(client_type)
session.commit()
return client_type, 201
except Exception as e:
session.rollback()
abort(400, message="Error while adding record Client Type")
def post(self):
try:
json_data = request.get_json(force=True)
action_log_type = ActionLogTypes(message=json_data["message"])
session.add(action_log_type)
session.commit()
return action_log_type, 201
except Exception as e:
session.rollback()
abort(400, message="Error while adding record Action Log Type")
def clean_log_by_condition():
try:
logs = session.query(Log).all()
if (len(logs) > 2000):
session.query(Log).delete()
session.commit()
pass
except Exception as e:
session.rollback()
def post(self):
try:
json_data = request.get_json(force=True)
log = Log(message=json_data["message"])
session.add(log)
session.commit()
return log, 201
except Exception as e:
session.rollback()
abort(400, message="Error while adding record Log")
def post(self):
try:
json_data = request.get_json(force=True)
user_role = UserRoles(json_data['name'])
session.add(user_role)
session.commit()
return user_role, 201
except Exception as e:
session.rollback()
abort(400, message="Error in adding User Role")
def post(self):
try:
json_data = request.get_json(force=True)
entity = MODEL(json_data)
session.add(entity)
session.commit()
return entity, 201
except Exception as e:
session.rollback()
abort(400, message="Error while adding record " + ENTITY_NAME)
def put(self, id):
try:
# session.autocommit = False
# session.autoflush = False
json_data = request.get_json(force=True)
entity = session.query(MODEL).filter(MODEL.id == id).first()
if not entity:
abort(404,
message=ENTITY_NAME + " {} doesn't exist".format(id))
product_positions = session.query(ProductsPositions).filter(
ProductsPositions.products_positions.any(entity.id)).all()
if product_positions is not None:
session.bulk_update_mappings(ProductsPositions, [{
'id':
x.id,
'products_positions':
list(filter(lambda y: y != entity.id,
x.products_positions))
} for x in product_positions])
session.commit()
db_transformer.transform_update_params(entity, json_data)
session.add(entity)
session.commit()
# api_url = settings.API_URL
# if hasattr(entity, 'default_image_data'):
# if (entity.default_image_data != None and entity.default_image_data.file_path != None):
# entity.default_image_data.file_path = urllib.parse.urljoin(api_url,
# entity.default_image_data.file_path)
# if hasattr(entity, 'default_image_data'):
# if (entity.default_image_data != None and entity.default_image_data.thumb_file_path != None):
# entity.default_image_data.thumb_file_path = urllib.parse.urljoin(api_url,
# entity.default_image_data.thumb_file_path)
# if hasattr(entity, 'default_image_data'):
# if (entity.default_image_data != None and entity.default_image_data.optimized_size_file_path != None):
# entity.default_image_data.optimized_size_file_path = urllib.parse.urljoin(api_url,
# entity.default_image_data.optimized_size_file_path)
entity.images_data = []
if (entity.gallery_images != None
and len(entity.gallery_images) > 0):
for img_id in entity.gallery_images:
image = session.query(Attachments).filter(
Attachments.id == img_id).first()
if not image:
continue
entity.images_data.append(image)
return entity, 201
except Exception as e:
session.rollback()
abort(400, message="Error while update " + ENTITY_NAME)
finally:
pass
def delete(self, id):
try:
entity = session.query(MODEL).filter(MODEL.id == id).first()
if not entity:
abort(404, message=ENTITY_NAME+" {} doesn't exist".format(id))
session.delete(entity)
session.commit()
return {}, 204
except Exception as e:
session.rollback()
abort(400, message="Error while remove "+ENTITY_NAME)
def post(self):
try:
json_data = request.get_json(force=True)
client = Clients(name=json_data["name"], registration_number=json_data["registration_number"],
lock_state=json_data["lock_state"], client_type_id=json_data["client_type_id"])
session.add(client)
session.commit()
return client, 201
except Exception as e:
session.rollback()
abort(400, message="Error while adding record Client")
def delete(self, id):
try:
client = session.query(Clients).filter(Clients.id == id).first()
if not client:
abort(404, message="Client type {} doesn't exist".format(id))
session.delete(client)
session.commit()
return {}, 204
except Exception as e:
session.rollback()
abort(400, message="Error while remove Client")
def delete(self, id):
try:
object = session.query(Objects).filter(Objects.id == id).first()
if not object:
abort(404, message="Object {} doesn't exist".format(id))
session.delete(object)
session.commit()
return {}, 204
except Exception as e:
session.rollback()
abort(400, message="Error while remove Entity")
def delete(self, id):
try:
setting = session.query(Settings).filter(Settings.id == id).first()
if not setting:
abort(404, message=" Settings {} doesn't exist".format(id))
session.delete(setting)
session.commit()
return {}, 204
except Exception as e:
session.rollback()
abort(400, message="Error while remove Settings")
def post(self):
try:
json_data = request.get_json(force=True)
action_log = ActionLog(message=json_data["message"],
user_id=json_data["user_id"],
action_type_id=json_data["action_type_id"])
session.add(action_log)
session.commit()
return action_log, 201
except Exception as e:
session.rollback()
abort(400, message="Error while adding record Action Log")
def put(self, id):
try:
json_data = request.get_json(force=True)
group_object_right = session.query(GroupObjectRights).filter(
GroupObjectRights.id == id).first()
group_object_right.data = json_data['data']
session.add(group_object_right)
session.commit()
return group_object_right, 201
except Exception as e:
session.rollback()
abort(400, message="Error while update Group Object Rights")
def delete(self, id):
try:
attachment = session.query(Attachments).filter(
Attachments.id == id).first()
if not attachment:
abort(404, message="Attachment {} doesn't exist".format(id))
session.delete(attachment)
session.commit()
return {}, 204
except Exception as e:
session.rollback()
abort(400, message="Error while remove Attachment ")
def delete(self, id):
try:
user_login = session.query(UserLogins).filter(
UserLogins.id == id).first()
if not user_login:
abort(404, message="User Login {} doesn't exist".format(id))
session.delete(user_login)
session.commit()
return {}, 204
except Exception as e:
session.rollback()
abort(400, message="Error remove user login")
def put(self, id):
try:
json_data = request.get_json(force=True)
user_group_setting = session.query(UserGroupSettings).filter(
UserGroupSettings.id == id).first()
user_group_setting.data = json_data['data']
session.add(user_group_setting)
session.commit()
return user_group_setting, 201
except Exception as e:
session.rollback()
abort(400, message="Error while update User Group Settings")
def post(self):
try:
json_data = request.get_json(force=True)
setting = Settings(name=json_data["name"],
value=json_data["value"])
session.add(setting)
session.commit()
return setting, 201
except Exception as e:
session.rollback()
abort(400, message="Error while adding record Settings")
def put(self, id):
try:
json_data = request.get_json(force=True)
client_type = session.query(ClientTypes).filter(
ClientTypes.id == id).first()
client_type.name = json_data['name']
session.add(client_type)
session.commit()
return client_type, 201
except Exception as e:
session.rollback()
abort(400, message="Error while update Client Type")
def delete(self, id):
try:
client_info = session.query(ClientInfo).filter(
ClientInfo.id == id).first()
if not client_info:
abort(404, message="Attachment {} doesn't exist".format(id))
session.delete(client_info)
session.commit()
return {}, 204
except Exception as e:
session.rollback()
abort(400, message="Error while remove Attachment ")
def put(self, id):
try:
json_data = request.get_json(force=True)
user_role = session.query(UserRoles).filter(
UserRoles.id == id).first()
user_role.task = json_data['name']
session.add(user_role)
session.commit()
return user_role, 201
except Exception as e:
session.rollback()
abort(400, message="Error while update user role")
def delete(self, id):
try:
user_role = session.query(UserRoles).filter(
UserRoles.id == id).first()
if not user_role:
abort(404, message="User role {} doesn't exist".format(id))
session.delete(user_role)
session.commit()
return {}, 204
except Exception as e:
session.rollback()
abort(400, message="Error while remove user role")
def delete(self, id):
try:
action_log = session.query(ActionLog).filter(
ActionLog.id == id).first()
if not action_log:
abort(404, message="Action log {} doesn't exist".format(id))
session.delete(action_log)
session.commit()
return {}, 204
except Exception as e:
session.rollback()
abort(400, message="Error while remove Action Type")
def put(self, id):
try:
json_data = request.get_json(force=True)
object_view = session.query(ObjectViews).filter(
ObjectViews.id == id).first()
object_view.data = json_data['data']
session.add(object_view)
session.commit()
return object_view, 201
except Exception as e:
session.rollback()
abort(400, message="Error while update Object Views")
def delete(self, id):
try:
schema = session.query(Schemas).filter(Schemas.id == id).first()
if not schema:
abort(404, message="Client type {} doesn't exist".format(id))
session.delete(schema)
session.commit()
return {}, 204
except Exception as e:
# db.db.init_session()
session.rollback()
abort(400, message="Error in remove schema".format(id))
def post(self):
try:
json_data = request.get_json(force=True)
user_group = UserGroups(
user_creator_id=json_data['user_creator_id'],
group_name=json_data['group_name'])
session.add(user_group)
session.commit()
return user_group, 201
except Exception as e:
session.rollback()
abort(400, message="Error while adding record User Group")
def put(self, id):
try:
# session.autocommit = False
# session.autoflush = False
json_data = request.get_json(force=True)
entity = session.query(MODEL).filter(MODEL.id == id).first()
if not entity:
abort(404, message=ENTITY_NAME + " {} doesn't exist".format(id))
# check if this category has another parent_id, so we should delete it from positions
if json_data['parent_category_id'] != entity.parent_category_id\
or json_data.get('is_delete', False)\
or json_data.get('is_lock', False):
position = session.query(ProductCategoryPositions) \
.filter(ProductCategoryPositions.parent_category_id == entity.parent_category_id).first()
if position is not None:
position.child_category_positions = [e for e in position.child_category_positions if e != entity.id]
session.add(position)
session.commit()
db_transformer.transform_update_params(entity, json_data)
session.add(entity)
session.commit()
# session.close()
# api_url = settings.API_URL
# if hasattr(entity, 'default_image_data'):
# if (entity.default_image_data != None and entity.default_image_data.file_path != None):
# entity.default_image_data.file_path = urllib.parse.urljoin(api_url,
# entity.default_image_data.file_path)
# if hasattr(entity, 'default_image_data'):
# if (entity.default_image_data != None and entity.default_image_data.thumb_file_path != None):
# entity.default_image_data.thumb_file_path = urllib.parse.urljoin(api_url,
# entity.default_image_data.thumb_file_path)
# if hasattr(entity, 'default_image_data'):
# if (entity.default_image_data != None and entity.default_image_data.optimized_size_file_path != None):
# entity.default_image_data.optimized_size_file_path = urllib.parse.urljoin(api_url,
# entity.default_image_data.optimized_size_file_path)
#
entity.images_data = []
if entity.images is not None and len(entity.images) > 0:
for img_id in entity.images:
image = session.query(Attachments).filter(Attachments.id == img_id).first()
if not image:
continue
entity.images_data.append(image)
return entity, 201
except Exception as e:
session.rollback()
abort(400, message="Error while update " + ENTITY_NAME)
finally:
pass
