def update_template_to_db(template_id, brand_id, category_id, folder_id, mailchimp_id, name, type, active, thumbnail, user, html="", sections=None): new_template = Template.query.get(template_id) if not new_template: return False, "Template not found" new_template = template_fields_to_obj(new_template, brand_id, category_id, folder_id, mailchimp_id, name, type, active, thumbnail, html) new_template.updated = datetime.datetime.now() new_template.updated_by = user.id try: db.session.commit() if sections != None: status, response = delete_sections_from_db( new_template.sections.all()) if not status: return False, response status, response = add_sections_to_template_db( new_template.id, sections) if not status: return False, response return True, f._obj_to_dict([new_template]) except Exception as e: return False, str(e)
def add_template_to_db(brand_id, category_id, folder_id, mailchimp_id, name, type, active, thumbnail, user, html="", sections=None): new_template = Template() new_template = template_fields_to_obj(new_template, brand_id, category_id, folder_id, mailchimp_id, name, type, active, thumbnail, html) new_template.created_by = user.id try: db.session.add(new_template) db.session.commit() if sections != None: status, response = add_sections_to_template_db( new_template.id, sections) if not status: return False, response return True, f._obj_to_dict([new_template]) except Exception as e: return False, str(e)
def get_template_category_by_name(brand_id, name, sync=False): template_category_query = TemplateCategory.query.filter( and_(TemplateCategory.brand_id == brand_id, TemplateCategory.name == name)).first() if template_category_query.count() == 0: return True, [] if sync: return True, template_category_query.all() return True, f._obj_to_dict(template_category_query.all())
def get_folders(brand, folder_id=None, folder_type=None): if folder_id != None: status, folder = get_folder_by_id(brand, folder_id) if status: return True, f._obj_to_dict([folder]) else: return False, "Folder Not Found" elif folder_type != None: folders = Folder.query.filter( and_(Folder.folder_type == folder_type, Folder.brand_id == brand)).all() if folders and len(folders) > 0: return True, f._obj_to_dict(folders) else: return False, "No Folders Found" else: folders = Folder.query.filter(Folder.brand_id == brand).all() if folders and len(folders) > 0: return True, f._obj_to_dict(folders) else: return False, "No Folders Found"
def add_system_merge_field_to_db(name, tag, description, user): system_merge_field = SystemMergeField() system_merge_field = system_merge_field_fields_to_object( system_merge_field, name, tag, description) system_merge_field.created_by = user.id try: db.session.add(system_merge_field) db.session.commit() return True, f._obj_to_dict([system_merge_field]) except Exception as ex: return False, str(ex)
def add_template_category(brand_id, name, folder_id, user_id, sync=False): template_category = TemplateCategory() template_category.brand_id = brand_id template_category.name = name template_category.folder_id = folder_id template_category.created_by = user_id try: db.session.add(template_category) db.session.commit() if sync: return True, template_category return True, f._obj_to_dict([template_category]) except Exception as e: return False, str(e)
def update_system_merge_field_to_db(id, name, tag, description, user): system_merge_field = SystemMergeField.query.get(id) if not system_merge_field: return False, "System Merge Field not found" system_merge_field = system_merge_field_fields_to_object( system_merge_field, name, tag, description) system_merge_field.updated_by = user.id system_merge_field.updated = datetime.datetime.now() try: db.session.commit() return True, f._obj_to_dict([system_merge_field]) except Exception as ex: return False, str(ex)
def all_segments(brand_id, list_id): all_segments = Segment.query.filter(and_(Segment.brand_id == brand_id, Segment.list_id == list_id)).all() return f._obj_to_dict(all_segments)
def get_all_system_merge_fields_dict(): system_merge_fields = get_all_system_merge_fields() return f._obj_to_dict(system_merge_fields)