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