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)