From 4889395650b972b3567560878fb75cdf18a2f882 Mon Sep 17 00:00:00 2001 From: Andrea Zagli Date: Thu, 2 Sep 2010 08:42:21 +0200 Subject: [PATCH] Changed db struct. ALTER TABLE actions RENAME dn TO username; ALTER TABLE actions ALTER username TYPE character varying(255); ALTER TABLE fields DROP CONSTRAINT fields_pkey; ALTER TABLE fields ADD PRIMARY KEY (id); --- configure.ac | 4 ++-- docs/sql/audit.sql | 4 ++-- src/audit.c | 20 ++++++++++---------- 3 files changed, 14 insertions(+), 14 deletions(-) diff --git a/configure.ac b/configure.ac index 75cff57..4a829df 100644 --- a/configure.ac +++ b/configure.ac @@ -2,7 +2,7 @@ # Process this file with autoconf to produce a configure script. AC_PREREQ(2.59) -AC_INIT([libaudit], [0.0.1], [azagli@libero.it]) +AC_INIT([libaudit], [0.0.2], [azagli@libero.it]) AC_CONFIG_SRCDIR([src/audit.c]) AC_CONFIG_HEADER([config.h]) @@ -18,7 +18,7 @@ AC_PROG_CC AC_PROG_LIBTOOL # Checks for libraries. -GDAEX_REQUIRED=0.1.0 +GDAEX_REQUIRED=0.2.0 dnl Check for pkgconfig first AC_CHECK_PROG(HAVE_PKGCONFIG, pkg-config, yes, no) diff --git a/docs/sql/audit.sql b/docs/sql/audit.sql index a744b77..237ff01 100644 --- a/docs/sql/audit.sql +++ b/docs/sql/audit.sql @@ -19,13 +19,13 @@ CREATE TABLE fields ( id_tables integer NOT NULL, name character varying(30) DEFAULT '', status character varying(1) DEFAULT '', - CONSTRAINT campi_pkey PRIMARY KEY (id) + CONSTRAINT fields_pkey PRIMARY KEY (id) ); CREATE TABLE actions ( id bigint NOT NULL, type integer, - dn character varying(200) DEFAULT '', + username character varying(255) DEFAULT '', date timestamp without time zone, id_tables integer, CONSTRAINT actions_pkey PRIMARY KEY (id) diff --git a/src/audit.c b/src/audit.c index fb9dcec..748a29e 100644 --- a/src/audit.c +++ b/src/audit.c @@ -581,7 +581,7 @@ Audit * audit_action: * @audit: an #Audit object. * @action: the action's type. - * @dn: the username that make the action. + * @username: the username that make the action. * @datasource_name: the datasource's name. * @table_name: the table's name. * @...: a #NULL terminated list of couples field-value. @@ -591,7 +591,7 @@ Audit gboolean audit_action (Audit *audit, enum AuditActions action, - const gchar *dn, + const gchar *username, const gchar *datasource_name, const gchar *table_name, ...) @@ -624,7 +624,7 @@ audit_action (Audit *audit, if (g_strcmp0 (str, "") != 0) { - ret = audit_action_v (audit, action, dn, datasource_name, table_name, (const gchar **)g_strsplit (str, "|", -1)); + ret = audit_action_v (audit, action, username, datasource_name, table_name, (const gchar **)g_strsplit (str, "|", -1)); } return ret; @@ -634,7 +634,7 @@ audit_action (Audit *audit, * audit_action_v: * @audit: an #Audit object. * @action: the action's type. - * @dn: the username that make the action. + * @username: the username that make the action. * @datasource_name: the datasource's name. * @table_name: the table's name. * @fields_values: a #NULL-terminated array of strings in the form @@ -645,7 +645,7 @@ audit_action (Audit *audit, gboolean audit_action_v (Audit *audit, enum AuditActions action, - const gchar *dn, + const gchar *username, const gchar *datasource_name, const gchar *table_name, const gchar **fields_values) @@ -710,9 +710,9 @@ audit_action_v (Audit *audit, { /* TODO find the way to save more than 2 digits for the seconds */ sql = g_strdup_printf ("INSERT INTO actions" - " (id, type, dn, date, id_tables)" + " (id, type, username, date, id_tables)" " VALUES (%d, %d, '%s', '%04d-%02d-%02d %02d:%02d:%02d', %d)", - id, action, dn, + id, action, username, tm_ora->tm_year + 1900, tm_ora->tm_mon + 1, tm_ora->tm_mday, tm_ora->tm_hour, tm_ora->tm_min, tm_ora->tm_sec, table->id); @@ -868,7 +868,7 @@ audit_action_v (Audit *audit, * audit_action_from_gdastatement: * @audit: an #Audit object. * @action: the action's type. - * @dn: the username that make the action. + * @username: the username that make the action. * @datasource_name: the datasource's name. * @gda_statement: a #GdaStatement object. * @@ -877,7 +877,7 @@ audit_action_v (Audit *audit, gboolean audit_action_from_gdastatement (Audit *audit, enum AuditActions action, - const gchar *dn, + const gchar *username, const gchar *datasource_name, GdaStatement *gda_statement) { @@ -970,7 +970,7 @@ audit_action_from_gdastatement (Audit *audit, if (g_strcmp0 (str, "") != 0) { - ret = audit_action_v (audit, action, dn, datasource_name, table_name, (const gchar **)g_strsplit (str, "|", -1)); + ret = audit_action_v (audit, action, username, datasource_name, table_name, (const gchar **)g_strsplit (str, "|", -1)); } return ret; -- 2.49.0