Function tbl_delete

lib_acl_cpp/samples/db/pgsql_pool/main.cpp:158–183

ɾ��������

// ɾ��������
static bool tbl_delete(acl::db_handle& db, int n)
{
	acl::query query;
	query.create_sql("delete from group_tbl where group_name=:group")
		.set_format("group", "group:%d", n);

	if (db.exec_update(query) == false)
	{
		printf("delete sql error\r\n");
		return (false);
	}

	printf(">>%s<<\r\n", query.to_string().c_str());

	for (size_t i = 0; i < db.length(); i++)
	{
		const acl::db_row* row = db[i];
		for (size_t j = 0; j < row->length(); j++)
			printf("%s, ", (*row)[j]);
		printf("\r\n");
	}
	// �ͷŲ�ѯ���
	db.free_result();

	return (true);
}

//////////////////////////////////////////////////////////////////////////////