def action_delete(self, ids):
try:
query = tools.get_query_for_ids(self.get_query(), self.model, ids)
if self.fast_mass_delete:
count = query.delete(synchronize_session=False)
else:
count = 0
for m in query.all():
if self.delete_model(m):
count += 1
self.session.commit()
flash(
ngettext('Record was successfully deleted.',
'%(count)s records were successfully deleted.',
count,
count=count), 'success')
except Exception as ex:
if not self.handle_view_exception(ex):
raise
flash(
gettext('Failed to delete records. %(error)s', error=str(ex)),
'error')
def action_delete(self, ids):
try:
model_pk = getattr(self.model, self._primary_key)
if self.fast_mass_delete:
count = self.model.delete().where(model_pk << ids).execute()
else:
count = 0
query = self.model.select().filter(model_pk << ids)
for m in query:
self.on_model_delete(m)
m.delete_instance(recursive=True)
count += 1
flash(
ngettext('Record was successfully deleted.',
'%(count)s records were successfully deleted.',
count,
count=count), 'success')
except Exception as ex:
if not self.handle_view_exception(ex):
flash(
gettext('Failed to delete records. %(error)s',
error=str(ex)), 'error')
def action_delete(self, ids):
try:
model_pk = getattr(self.model, self._primary_key)
if self.fast_mass_delete:
count = self.model.delete().where(model_pk << ids).execute()
else:
count = 0
query = self.model.select().filter(model_pk << ids)
for m in query:
self.on_model_delete(m)
m.delete_instance(recursive=True)
count += 1
flash(
ngettext(
"Record was successfully deleted.",
"%(count)s records were successfully deleted.",
count,
count=count,
)
)
except Exception as ex:
if not self.handle_view_exception(ex):
flash(gettext("Failed to delete records. %(error)s", error=str(ex)), "error")
def action_delete(self, ids):
try:
query = tools.get_query_for_ids(self.get_query(), self.model, ids)
if self.fast_mass_delete:
count = query.delete(synchronize_session=False)
else:
count = 0
for m in query.all():
if self.delete_model(m):
count += 1
self.session.commit()
flash(
ngettext(
"Record was successfully deleted.",
"%(count)s records were successfully deleted.",
count,
count=count,
),
"success",
)
except Exception as ex:
if not self.handle_view_exception(ex):
raise
flash(gettext("Failed to delete records. %(error)s", error=str(ex)), "error")
def action_delete(self, ids):
count = 0
for pk in ids:
self.get_one(pk).destroy()
count += 1
flash(ngettext('Record was successfully deleted.',
'%(count)s records were successfully deleted.',
count,
count=count))
def action_delete(self, ids):
count = 0
for pk in ids:
self.get_one(pk).destroy()
count += 1
flash(
ngettext('Record was successfully deleted.',
'%(count)s records were successfully deleted.',
count,
count=count))
def modified(self, ids):
model_pk = getattr(self.model, self._primary_key)
query = self.get_query().filter(model_pk.in_(ids))
count = 0
for s in query.all():
s.flag = 'M'
count += 1
self.session.commit()
flash(ngettext('Model was successfully flagged (M)odified.',
'%(count)s models were successfully flagged (M)odified.',
count, count=count))
return
def modified(self, ids):
model_pk = getattr(self.model, self._primary_key)
query = self.get_query().filter(model_pk.in_(ids))
count = 0
for s in query.all():
s.flag = 'M'
count += 1
self.session.commit()
flash(ngettext('Model was successfully flagged (M)odified.',
'%(count)s models were successfully flagged (M)odified.',
count, count=count))
return
def action_resuccess(self, ids):
try:
query = tools.get_query_for_ids(self.get_query(), self.model, ids)
count = query.update({self.model.status, 'success'}, synchronize_session=False)
flash(ngettext('jobs was successfully success.',
'%(count)s records were successfully success.',
count,
count=count), 'success')
except Exception as ex:
if not self.handle_view_exception(ex):
raise
flash(gettext('Failed to rerun records. %(error)s', error=str(ex)), 'error')
def set_inactive(self, ids):
try:
count = 0
for user in users.get_all(*ids):
users.update(user, active=False)
count += 1
flash(ngettext('User(s) successfully set to inactive.',
'%(count)s users were successfully deactivated.',
count,
count=count))
except Exception as ex:
if not self.handle_view_exception(ex):
raise
flash(gettext('Failed to set user(s) to inactive. %(error)s', error=str(ex)), 'error')
def action_delete(self, ids):
try:
count = 0
# TODO: Optimize me
for pk in ids:
if self.delete_model(self.get_one(pk)):
count += 1
flash(ngettext('Record was successfully deleted.',
'%(count)s records were successfully deleted.',
count,
count=count))
except Exception as ex:
flash(gettext('Failed to delete records. %(error)s', error=str(ex)), 'error')
def action_delete(self, ids):
try:
count = 0
# TODO: Optimize me
for pk in ids:
if self.delete_model(self.get_one(pk)):
count += 1
flash(ngettext('Record was successfully deleted.',
'%(count)s records were successfully deleted.',
count,
count=count), 'success')
except Exception as ex:
flash(gettext('Failed to delete records. %(error)s', error=str(ex)), 'error')
def action_delete(self, ids):
try:
count = 0
all_ids = [self.object_id_converter(pk) for pk in ids]
for obj in self.get_query().in_bulk(all_ids).values():
count += self.delete_model(obj)
flash(ngettext('Record was successfully deleted.',
'%(count)s records were successfully deleted.',
count,
count=count), 'success')
except Exception as ex:
if not self.handle_view_exception(ex):
flash(gettext('Failed to delete records. %(error)s', error=str(ex)),
'error')
def action_delete(self, ids):
try:
count = 0
# TODO: Optimize me
for pk in ids:
self.coll.remove({'_id': ObjectId(pk)})
count += 1
flash(ngettext('Model was successfully deleted.',
'%(count)s models were successfully deleted.',
count,
count=count))
except Exception, ex:
flash(gettext('Failed to delete models. %(error)s', error=str(ex)),
'error')
def action_delete(self, ids):
try:
count = 0
all_ids = [self.object_id_converter(pk) for pk in ids]
for obj in self.get_query().in_bulk(all_ids).values():
count += self.delete_model(obj)
flash(ngettext('Record was successfully deleted.',
'%(count)s records were successfully deleted.',
count,
count=count), 'success')
except Exception as ex:
if not self.handle_view_exception(ex):
flash(gettext('Failed to delete records. %(error)s', error=str(ex)),
'error')
def action_delete(self, ids):
try:
count = 0
all_ids = [ObjectId(pk) for pk in ids]
for obj in self.model.objects.in_bulk(all_ids).values():
obj.delete()
count += 1
flash(ngettext('Model was successfully deleted.',
'%(count)s models were successfully deleted.',
count,
count=count))
except Exception, ex:
flash(gettext('Failed to delete models. %(error)s', error=str(ex)),
'error')
def action_update(self, ids):
count = 0
query = get_query_for_ids(self.get_query(), self.model, ids)
def update(project):
update_single_project(project)
self.session.commit()
return True
for project in query.all():
if update_single_project(project):
count += 1
self.session.commit()
flash(ngettext('Record was successfully updated.',
'%(count)s records were successfully updated.', count, count=count))
def action_confirm(self, ids):
count = 0
query = get_query_for_ids(self.get_query(), self.model, ids)
def confirm(project):
project.status = "True"
self.session.commit()
return True
for project in query.all():
if confirm(project):
count += 1
self.session.commit()
flash(ngettext('Record was successfully confirmed.',
'%(count)s records were successfully confirmed.', count, count=count))
def action_delete(self, ids):
try:
count = 0
for i in Coupon.query.all():
count += 1
db.session.delete(i)
db.session.commit()
flash(
ngettext('Record was successfully deleted.',
'%(count)s records were successfully deleted.',
count,
count=count), 'success')
except Exception as ex:
if not self.handle_view_exception(ex):
raise
flash(gettext('Failed to delete records. %(error)s', error=str(ex)),
'error')
def action_resuccess(self, ids):
try:
query = tools.get_query_for_ids(self.get_query(), self.model, ids)
count = query.update({self.model.status, 'success'},
synchronize_session=False)
flash(
ngettext('jobs was successfully success.',
'%(count)s records were successfully success.',
count,
count=count), 'success')
except Exception as ex:
if not self.handle_view_exception(ex):
raise
flash(gettext('Failed to rerun records. %(error)s', error=str(ex)),
'error')
def set_inactive(self, ids):
try:
count = 0
for user in users.get_all(*ids):
users.update(user, active=False)
count += 1
flash(
ngettext('User(s) successfully set to inactive.',
'%(count)s users were successfully deactivated.',
count,
count=count))
except Exception as ex:
if not self.handle_view_exception(ex):
raise
flash(
gettext('Failed to set user(s) to inactive. %(error)s',
error=str(ex)), 'error')
def action_approve(self, ids):
try:
query = User.query.filter(User.id.in_(ids))
count = 0
for user in query.all():
if user.approve():
count += 1
flash(ngettext('User was successfully approved.',
'%(count)s users were successfully approved.',
count,
count=count))
except Exception as ex:
if not self.handle_view_exception(ex):
raise
flash(gettext('Failed to approve users. %(error)s', error=str(ex)), 'error')
def action_dryrun(self, ids):
try:
query = tools.get_query_for_ids(self.get_query(), self.model, ids)
count = 0
for job in query:
msg = models.Admin().rerun_task(job.task_id, job.etl_day,
up_and_down=False,
run_up=False,
run_down=False,
force=True)
count += 1
flash(ngettext('jobs was successfully dryrun.',
'%(count)s records were successfully dryrun.',
count,
count=count), 'success')
except Exception as ex:
if not self.handle_view_exception(ex):
raise
flash(gettext('Failed to rerun records. %(error)s', error=str(ex)), 'error')
def action_delete(self, ids):
try:
model_pk = getattr(self.model, self._primary_key)
if self.fast_mass_delete:
count = self.model.delete().where(model_pk << ids).execute()
else:
count = 0
query = self.model.select().filter(model_pk << ids)
for m in query:
m.delete_instance(recursive=True)
count += 1
flash(ngettext('Model was successfully deleted.',
'%(count)s models were successfully deleted.',
count,
count=count))
except Exception, ex:
flash(gettext('Failed to delete models. %(error)s', error=str(ex)), 'error')
def action_backup(self, ids):
try:
query = self.model.query.filter(self.model.id.in_(ids))
models = query.all()
self.backup_models(models)
count = len(models)
flash(
ngettext('Model was successfully backup.',
'%(count)s models were successfully backup.',
count,
count=count))
except Exception as ex:
if not self.handle_view_exception(ex):
raise
flash(
gettext('Failed to backup models. %(error)s',
error=str(ex)), 'error')
def action_delete(self, ids, query):
try:
if self.fast_mass_delete:
count = query.delete(synchronize_session=False)
else:
count = 0
for m in query.all():
self.session.delete(m)
count += 1
self.session.commit()
flash(ngettext('Model was successfully deleted.',
'%(count)s models were successfully deleted.',
count,
count=count))
except Exception as ex:
if self._debug:
raise
flash(gettext('Failed to delete models. %(error)s', error=str(ex)), 'error')
def action_delete(self, ids):
try:
count = 0
# TODO: Optimize me
for pk in ids:
if self.delete_model(self.get_one(pk)):
count += 1
flash(
ngettext(
"Record was successfully deleted.",
"%(count)s records were successfully deleted.",
count,
count=count,
),
"success",
)
except Exception as ex:
flash(
gettext("Failed to delete records. %(error)s", error=str(ex)),
"error")
def set_approval(self, ids, action):
if action == 'approve':
jsonb_val = 'approved'
action_text = 'approved'
elif action == 'reject':
jsonb_val = 'rejected'
action_text = 'rejected'
try:
t = tables.comment
mod_mode = sa.func.jsonb_set(
sa.text('custom_json'),
sa.text("'{mod_mode}'"),
sa.text('\'"{}"\''.format(jsonb_val))
)
stmt = (
t.update()
.where(t.c.id.in_(ids))
.values(custom_json=mod_mode)
.returning(t.c.id)
)
result = db.engine.execute(stmt).fetchall()
count = len(result)
flask.flash(ngettext(
'Comment was successfully {}.'
.format(action_text),
'%(count)s comments were successfully {}.'
.format(action_text),
count,
count=count))
except Exception as ex:
if not self.handle_view_exception(ex):
raise
flask.flash(gettext('Failed to {} records. %(error)s'
.format(action_text),
error=str(ex)), 'error')
def toggle_user_status(self, ids, flag=False):
try:
query = User.query.filter(User.id.in_(ids))
count = 0
for user in query.all():
if user.active != flag:
user.active = flag
count += 1
if count > 0:
self.session.commit()
flash(
ngettext('User was successfully disabled',
'%(count)s users were successfully disabled',
count,
count=count))
except Exception as ex:
if not self.handle_view_exception(ex):
raise
flash(
gettext('Failed to update user status. %(error)s',
error=str(ex)), 'error')
def action_dryrun(self, ids):
try:
query = tools.get_query_for_ids(self.get_query(), self.model, ids)
count = 0
for job in query:
msg = models.Admin().rerun_task(job.task_id,
job.etl_day,
up_and_down=False,
run_up=False,
run_down=False,
force=True)
count += 1
flash(
ngettext('jobs was successfully dryrun.',
'%(count)s records were successfully dryrun.',
count,
count=count), 'success')
except Exception as ex:
if not self.handle_view_exception(ex):
raise
flash(gettext('Failed to rerun records. %(error)s', error=str(ex)),
'error')
def _n(*args, **kwargs):
return ngettext(*args, **kwargs)
def ngettext(self, singular, plural, n):
return ngettext(singular, plural, n)
