Python QueryHandler.create_audit示例

示例#1

def update_record(self, service_id):
	data = get_attributes(self)
	valid, errors = validate_attributes(data)
	sql_statement = update_sql_statement(data, service_id)
	record = QueryHandler.execute_query(sql_statement, insert=True)
	record_audit = QueryHandler.create_audit(self, "Service", data['name_french'], data, "Update Service")
	return

示例#2

def update_record(self, org_key):
	data = get_attributes(self)
	# raise Exception(self.request)
	valid, errors = validate_attributes(data)
	sql_statement = populate_update_statement(data, org_key)
	record = QueryHandler.execute_query(sql_statement, True)
	record_audit = QueryHandler.create_audit(self, "Organization", "Organization", data, "Edit Organization")
	return

示例#3

文件： ProgramHelper.py 项目： StraubCreative/timoun

def update_record(self):
    data = get_attributes(self)
    # raise Exception(data)
    valid, errors = validate_attributes(data)
    sql_statement = populate_update_statement(data)
    record = QueryHandler.execute_query(sql_statement, True)
    record_audit = QueryHandler.create_audit(self, "Program", "Program", data,
                                             "Update Program")
    return

示例#4

文件： ProgramHelper.py 项目： StraubCreative/timoun

def save_record(self):
    data = get_attributes(self)
    valid, errors = validate_attributes(data)
    sql_statement = populate_sql_statement(data)
    record = QueryHandler.execute_query(sql_statement, insert=True)
    self.redirect("/admin/records/" + data['org_id'] +
                  "?message=Program saved")
    record_audit = QueryHandler.create_audit(self, "Program", "Program", data,
                                             "Create Program")
    return

示例#5

def save_record(self):
	data = get_attributes(self)
	# raise Exception(data)
	find_or_create_program(data)
	check_for_service_duplicate(data)
	valid, errors = validate_attributes(data)
	# raise Exception(len(data))

	sql_statement = populate_sql_statement(data)
	# raise Exception(sql_statement)
	record = QueryHandler.execute_query(sql_statement, insert=True)
	self.redirect("/admin/records/" + data['org_id'] + "?message=Service saved")
	record_audit = QueryHandler.create_audit(self, "Service", data['name_french'], data, "Create Service")
	return 

示例#6

def save_record(self):
	data = get_attributes(self)
	valid, errors = validate_attributes(data)
	if errors:
		self.redirect("/records/new?message=Please review errors")
		return
	if record_exists(data):

		self.redirect("/records/new?message=Record already exists")
		return

	sql_statement = populate_sql_statement(data)

	record = QueryHandler.execute_query(sql_statement, insert=True)
	# raise Exception(record)
	last_record_sql = "SELECT id FROM organization ORDER BY id DESC LIMIT 1;"

	last = QueryHandler.execute_query(last_record_sql)
	self.redirect("/records/{0}?message=Saved".format(last[0][0]))
	
	record_audit = QueryHandler.create_audit(self, "Organization", data['1_nom'], data, "Create Organization")
	return