From ee6e9cc6547d93bdaa7c8a61bd70449e3b9ccbee Mon Sep 17 00:00:00 2001 From: Andrea Zagli Date: Wed, 5 Dec 2012 21:51:20 +0100 Subject: [PATCH] Started managing authorizations. --- data/autoz-gui/gui/autoz-gui.ui | 1439 +++++++++++++++++-------------- src/Makefile.am | 4 + src/authorization.c | 336 ++++++++ src/authorization.h | 65 ++ src/authorizations.c | 407 +++++++++ src/authorizations.h | 63 ++ src/main.c | 16 +- tests/db.db | Bin 7168 -> 7168 bytes 8 files changed, 1692 insertions(+), 638 deletions(-) create mode 100644 src/authorization.c create mode 100644 src/authorization.h create mode 100644 src/authorizations.c create mode 100644 src/authorizations.h diff --git a/data/autoz-gui/gui/autoz-gui.ui b/data/autoz-gui/gui/autoz-gui.ui index f95ae13..681a72a 100644 --- a/data/autoz-gui/gui/autoz-gui.ui +++ b/data/autoz-gui/gui/autoz-gui.ui @@ -1,152 +1,8 @@ - + - - - - Autoz GUI - center - 600 - 400 - - - - True - vertical - - - True - - - True - _File - True - - - True - - - gtk-open - True - True - True - - - - - - gtk-close - True - True - True - - - - - - True - - - - - gtk-quit - True - True - True - - - - - - - - - - True - _View - True - - - True - - - True - _Roles - True - - - - - - True - Re_sources - True - - - - - - True - _Authorizations - True - - - - - - - - - True - A_iuto - True - - - True - - - gtk-about - True - True - True - - - - - - - - - - False - 0 - - - - - True - vertical - - - - - - 1 - - - - - True - 2 - - - False - 2 - - - - - + + False 5 Informazioni su... True @@ -154,229 +10,335 @@ True normal w_main - True Autoz GUI 0.0.1 Andrea Zagli 2011-2012 Andrea Zagli <azagli@libero.it> True - + True + False vertical 2 - - - - + True + False end False + True end 0 + + + - - Open Autoz Datasource - Autoz GUI + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + False + Authorization - Autoz GUI True center-on-parent + 500 True - + True + False 5 - vertical 5 - + True - 5 + False + 5 + 2 + 5 + 5 - + True + False 0 - Table name prefix + ID - False - 0 + GTK_FILL + GTK_FILL - + True - True - • + False + 0 + lbl_id - 1 + 1 + 2 + GTK_FILL - - - False - 0 - - - - - True - 0 - - - - - - True - <b>Connection parameters</b> - True - - - - - 1 - - - - - True - 5 - end - - gtk-cancel + True - True - True - True + False + 0 + Resource - False - False - 0 + 2 + 3 + GTK_FILL + GTK_FILL - - gtk-open + True - True - True - True - - - False - False - 1 + False + 5 + + + True + True + False + • + + + True + True + 0 + + + + + ... + False + True + True + True + False + + + False + True + 1 + + + + + False + True + lbl_id_role + + + False + True + 2 + + + + + 1 + 2 + 1 + 2 + GTK_FILL - - - False - 2 - - - - - - - Role - Autoz GUI - True - center-on-parent - 500 - True - - - True - 5 - vertical - 5 - - - True - 3 - 2 - 5 - 5 - + True + False 0 - ID + Role + 1 + 2 GTK_FILL GTK_FILL - + + False True - 0 - lbl_id + True + False + False + 0.5 + True + True 1 2 + 3 + 4 GTK_FILL - + + False True - 0 - Name + True + False + False + 0.5 + True + True + radiobutton1 - 1 - 2 - GTK_FILL + 1 + 2 + 4 + 5 GTK_FILL - + True - True - 255 - ● + False + 0 + Allow - 1 - 2 - 1 - 2 + 3 + 4 + GTK_FILL GTK_FILL - + + True + False + 0 + Deny + + + 4 + 5 + GTK_FILL + GTK_FILL + - + + True + False + 5 + + + True + True + False + • + True + + + True + True + 0 + + + + + ... + False + True + True + True + False + + + False + True + 1 + + + + + False + True + lbl_id_resource + + + False + True + 2 + + + + + 1 + 2 + 2 + 3 + GTK_FILL + + True + True 0 - + True + False 5 end - + gtk-cancel + False True True True + False True @@ -386,11 +348,13 @@ - + gtk-save + False True True True + False True @@ -402,174 +366,466 @@ False + True 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Roles - Autoz GUI + + False + Authorizations - Autoz GUI True center-on-parent 550 400 True - + True + False 5 - vertical 5 - + + True + False + <b>Authorizations</b> + True + + + False + True + 0 + + + + True True - automatic - automatic etched-in - + True True - lstore_roles - False + lstore_authorizations True 1 + + + - - Roles + + Resource True 1 - + 1 + + + Role + True + 2 + + + + 2 + + + + + + + Allow/Deny + True + 3 + + + + 3 + + + + + + + + + True + True + 1 + + + + + True + False + 5 + end + + + gtk-new + False + True + True + True + False + True + True + + + False + False + 0 + + + + + gtk-edit + False + True + True + True + False + True + + + False + False + 1 + + + + + gtk-delete + False + True + True + True + False + True + + False + False + 2 + - 0 + False + True + 2 + + + + + + + False + Autoz GUI + center + 600 + 400 + + + + True + False + + + True + False + + + False + True + False + _File + True + + + True + False + + + gtk-open + False + True + False + True + True + + + + + + gtk-close + False + True + False + True + True + + + + + + True + False + + + + + gtk-quit + False + True + False + True + True + + + + + + + + + + False + True + False + _View + True + + + True + False + + + False + True + False + _Roles + True + + + + + + False + True + False + Re_sources + True + + + + + + False + True + False + _Authorizations + True + + + + + + + + + + False + True + False + A_iuto + True + + + True + False + + + gtk-about + False + True + False + True + True + + + + + + + + + + False + True + 0 + + + + + True + False + + + + + + True + True + 1 + + + + + True + False + 2 + + + False + True + 2 + + + + + False + Open Autoz Datasource - Autoz GUI + True + center-on-parent + True + + + True + False + 5 + 5 - + True + False 5 - end - - gtk-new + True - True - True - True - True + False + 0 + Table name prefix False - False + True 0 - - gtk-edit + True True - True - True + • - False - False + True + True 1 + + + False + True + 0 + + + + + True + False + 0 - - gtk-delete + + + + True - True - True - True + False + <b>Connection parameters</b> + True - - False - False - 2 - + + + True + True + 1 + + + + + True + False + 5 + end - + gtk-cancel + False True True True + False True False False - 3 + 0 - - gtk-ok + + gtk-open + False True True True + False True False False - 4 + 1 False - 1 + True + 2 + False Audit GUI True center-on-parent @@ -579,25 +835,29 @@ True + False 5 - vertical 5 True + False label False + True 0 True + False False + True 1 @@ -605,6 +865,7 @@ + False Resource - Autoz GUI True center-on-parent @@ -613,19 +874,27 @@ True + False 5 - vertical 5 True + False 3 2 5 5 + + + + + + True + False 0 ID @@ -637,6 +906,7 @@ True + False 0 lbl_id @@ -649,6 +919,7 @@ True + False 0 Name @@ -664,7 +935,7 @@ True True 255 - • + • 1 @@ -674,28 +945,27 @@ GTK_FILL - - - - - - + True + True 0 True + False 5 end gtk-cancel + False True True True + False True @@ -707,9 +977,11 @@ gtk-save + False True True True + False True @@ -721,6 +993,7 @@ False + True 1 @@ -728,6 +1001,7 @@ + False Resources - Autoz GUI True center-on-parent @@ -737,15 +1011,13 @@ True + False 5 - vertical 5 True True - automatic - automatic etched-in @@ -755,6 +1027,9 @@ False True 1 + + + Resources @@ -772,20 +1047,25 @@ + True + True 0 True + False 5 end gtk-new + False True True True + False True True @@ -798,9 +1078,11 @@ gtk-edit + False True True True + False True @@ -812,9 +1094,11 @@ gtk-delete + False True True True + False True @@ -826,9 +1110,11 @@ gtk-cancel + False True True True + False True @@ -840,9 +1126,11 @@ gtk-ok + False True True True + False True @@ -854,175 +1142,44 @@ False + True 1 - - Authorizations - Autoz GUI - True - center-on-parent - 550 - 400 - True - - - True - 5 - vertical - 5 - - - True - <b>Authorizations</b> - True - - - False - 0 - - - - - True - True - automatic - automatic - etched-in - - - True - True - lstore_authorizations - True - 1 - - - Resource - True - 1 - - - - 1 - - - - - - - Role - True - 2 - - - - 2 - - - - - - - Allow/Deny - True - 3 - - - - 3 - - - - - - - - - 1 - - - - - True - 5 - end - - - gtk-new - True - True - True - True - True - - - False - False - 0 - - - - - gtk-edit - True - True - True - True - - - False - False - 1 - - - - - gtk-delete - True - True - True - True - - - False - False - 2 - - - - - False - 2 - - - - - - - Authorization - Autoz GUI + + False + Role - Autoz GUI True center-on-parent 500 True - + True + False 5 - vertical 5 - + True - 5 + False + 3 2 5 5 - + + + + + + + True + False 0 ID @@ -1032,8 +1189,9 @@ - + True + False 0 lbl_id @@ -1044,10 +1202,11 @@ - + True + False 0 - Resource + Name 1 @@ -1057,42 +1216,11 @@ - + True - 5 - - - True - True - False - • - - - 0 - - - - - ... - True - True - True - - - False - 1 - - - - - True - lbl_id_resource - - - False - 2 - - + True + 255 + ● 1 @@ -1102,167 +1230,204 @@ GTK_FILL + + + True + True + 0 + + + + + True + False + 5 + end - + + gtk-cancel + False True - 5 - - - True - True - False - • - - - 0 - - - - - ... - True - True - True - - - False - 1 - - - - - True - lbl_id_role - - - False - 2 - - + True + True + False + True - 1 - 2 - 2 - 3 - GTK_FILL + False + False + 0 - + + gtk-save + False True - 0 - Role + True + True + False + True - 2 - 3 - GTK_FILL - GTK_FILL + False + False + 1 + + + False + True + 1 + + + + + + + False + Roles - Autoz GUI + True + center-on-parent + 550 + 400 + True + + + True + False + 5 + 5 + + + True + True + etched-in - - radiobutton + True True - False - True - True + lstore_roles + False + True + 1 + + + + + + Roles + True + 1 + + + + 1 + + + + - - 1 - 2 - 3 - 4 - GTK_FILL - + + + True + True + 0 + + + + + True + False + 5 + end - - radiobutton + + gtk-new + False True True - False - True - True - radiobutton1 + True + False + True + True - 1 - 2 - 4 - 5 - GTK_FILL + False + False + 0 - + + gtk-edit + False True - 0 - Allow + True + True + False + True - 3 - 4 - GTK_FILL - GTK_FILL + False + False + 1 - + + gtk-delete + False True - 0 - Deny + True + True + False + True - 4 - 5 - GTK_FILL - GTK_FILL + False + False + 2 - - - 0 - - - - - True - 5 - end - + gtk-cancel + False True True True + False True False False - 0 + 3 - - gtk-save + + gtk-ok + False True True True + False True False False - 1 + 4 False + True 1 diff --git a/src/Makefile.am b/src/Makefile.am index 57a2a40..56c5dd4 100644 --- a/src/Makefile.am +++ b/src/Makefile.am @@ -9,6 +9,10 @@ LIBS = $(AUTOZGUI_LIBS) \ bin_PROGRAMS = autoz-gui autoz_gui_SOURCES = \ + authorization.c \ + authorization.h \ + authorizations.c \ + authorizations.h \ commons.h \ main.c \ openauditds.c \ diff --git a/src/authorization.c b/src/authorization.c new file mode 100644 index 0000000..6fec23b --- /dev/null +++ b/src/authorization.c @@ -0,0 +1,336 @@ +/* + * Copyright (C) 2012 Andrea Zagli + * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License as published by the Free Software Foundation; either + * version 2.1 of the License, or (at your option) any later version. + * + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. + * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA + * + */ + +#include +#include + +#include "authorization.h" + +static void authorization_class_init (AuthorizationClass *klass); +static void authorization_init (Authorization *authorization); + +static void authorization_load (Authorization *authorization); +static void authorization_save (Authorization *authorization); + +static void authorization_set_property (GObject *object, + guint property_id, + const GValue *value, + GParamSpec *pspec); +static void authorization_get_property (GObject *object, + guint property_id, + GValue *value, + GParamSpec *pspec); + +static void authorization_on_btn_cancel_clicked (GtkButton *button, + gpointer user_data); +static void authorization_on_btn_save_clicked (GtkButton *button, + gpointer user_data); + +#define AUTHORIZATION_GET_PRIVATE(obj) (G_TYPE_INSTANCE_GET_PRIVATE ((obj), TYPE_AUTHORIZATION, AuthorizationPrivate)) + +typedef struct _AuthorizationPrivate AuthorizationPrivate; +struct _AuthorizationPrivate + { + Commons *commons; + + GtkWidget *w; + + gint id; + }; + +G_DEFINE_TYPE (Authorization, authorization, G_TYPE_OBJECT) + +static void +authorization_class_init (AuthorizationClass *klass) +{ + GObjectClass *object_class = G_OBJECT_CLASS (klass); + + g_type_class_add_private (object_class, sizeof (AuthorizationPrivate)); + + object_class->set_property = authorization_set_property; + object_class->get_property = authorization_get_property; + + /** + * Authorization::updated: + * @authorization: + * + */ + klass->updated_signal_id = g_signal_new ("updated", + G_TYPE_FROM_CLASS (object_class), + G_SIGNAL_RUN_LAST, + 0, + NULL, + NULL, + g_cclosure_marshal_VOID__VOID, + G_TYPE_NONE, + 0); +} + +static void +authorization_init (Authorization *authorization) +{ + AuthorizationPrivate *priv = AUTHORIZATION_GET_PRIVATE (authorization); +} + +/** + * authorization_new: + * @commons: + * @id: + * + * Returns: the newly created #Authorization object. + */ +Authorization +*authorization_new (Commons *commons, gint id) +{ + GError *error; + + Authorization *a = AUTHORIZATION (g_object_new (authorization_get_type (), NULL)); + + AuthorizationPrivate *priv = AUTHORIZATION_GET_PRIVATE (a); + + priv->commons = commons; + + error = NULL; + gtk_builder_add_objects_from_file (priv->commons->gtkbuilder, priv->commons->guifile, + g_strsplit ("w_authorization", "|", -1), + &error); + if (error != NULL) + { + g_warning ("Error: %s.", error->message); + return NULL; + } + + priv->w = GTK_WIDGET (gtk_builder_get_object (priv->commons->gtkbuilder, "w_authorization")); + + g_signal_connect (gtk_builder_get_object (priv->commons->gtkbuilder, "button20"), + "clicked", G_CALLBACK (authorization_on_btn_cancel_clicked), (gpointer *)a); + g_signal_connect (gtk_builder_get_object (priv->commons->gtkbuilder, "button21"), + "clicked", G_CALLBACK (authorization_on_btn_save_clicked), (gpointer *)a); + + priv->id = id; + if (priv->id == 0) + { + gtk_label_set_text (GTK_LABEL (gtk_builder_get_object (priv->commons->gtkbuilder, "label12")), ""); + } + else + { + gtk_label_set_text (GTK_LABEL (gtk_builder_get_object (priv->commons->gtkbuilder, "label12")), g_strdup_printf ("%d", priv->id)); + authorization_load (a); + } + + return a; +} + +/** + * authorization_get_widget: + * @authorization: + * + */ +GtkWidget +*authorization_get_widget (Authorization *authorization) +{ + AuthorizationPrivate *priv = AUTHORIZATION_GET_PRIVATE (authorization); + + return priv->w; +} + +/* PRIVATE */ +static void +authorization_load (Authorization *authorization) +{ + AuthorizationPrivate *priv = AUTHORIZATION_GET_PRIVATE (authorization); + + GError *error; + gchar *sql; + GdaStatement *stmt; + GdaDataModel *dm; + + sql = g_strdup_printf ("SELECT id_roles, id_resource, type" + " FROM %srules" + " WHERE id = %d", + priv->commons->prefix, + priv->id); + stmt = gda_sql_parser_parse_string (priv->commons->gdaparser, sql, NULL, NULL); + g_free (sql); + dm = gda_connection_statement_execute_select (priv->commons->gdacon, stmt, NULL, &error); + g_object_unref (stmt); + if (dm != NULL && gda_data_model_get_n_rows (dm) == 1) + { + gtk_label_set_text (GTK_LABEL (gtk_builder_get_object (priv->commons->gtkbuilder, "label15")), + gda_value_stringify (gda_data_model_get_value_at (dm, 0, 0, NULL))); + gtk_label_set_text (GTK_LABEL (gtk_builder_get_object (priv->commons->gtkbuilder, "label14")), + gda_value_stringify (gda_data_model_get_value_at (dm, 1, 0, NULL))); + } + else + { + GtkWidget *dialog; + dialog = gtk_message_dialog_new (GTK_WINDOW (priv->w), + GTK_DIALOG_DESTROY_WITH_PARENT, + GTK_MESSAGE_WARNING, + GTK_BUTTONS_OK, + "Record %d doesn't exist.", priv->id); + gtk_dialog_run (GTK_DIALOG (dialog)); + gtk_widget_destroy (dialog); + } + g_object_unref (dm); +} + +static void +authorization_save (Authorization *authorization) +{ + const GdaDsnInfo *info; + GError *error; + gchar *sql; + GdaStatement *stmt; + GdaDataModel *dm; + GtkWidget *dialog; + + AuthorizationClass *klass = AUTHORIZATION_GET_CLASS (authorization); + + AuthorizationPrivate *priv = AUTHORIZATION_GET_PRIVATE (authorization); + + if (priv->id == 0) + { + /* find the new id */ + guint new_id; + + new_id = 0; + sql = g_strdup_printf ("SELECT COALESCE (MAX (id), 0) FROM %srules", priv->commons->prefix); + stmt = gda_sql_parser_parse_string (priv->commons->gdaparser, sql, NULL, NULL); + g_free (sql); + dm = gda_connection_statement_execute_select (priv->commons->gdacon, stmt, NULL, &error); + g_object_unref (stmt); + if (dm != NULL && gda_data_model_get_n_rows (dm) == 1) + { + new_id = g_value_get_int (gda_data_model_get_value_at (dm, 0, 0, NULL)); + } + new_id++; + g_object_unref (dm); + + sql = g_strdup_printf ("INSERT INTO %srules" + " (id, id_roles, id_resources, type)" + " VALUES (%d, %d, %d, %d)", + priv->commons->prefix, + new_id, + strtol (gtk_label_get_text (GTK_LABEL (gtk_builder_get_object (priv->commons->gtkbuilder, "label15"))), NULL, 10), + strtol (gtk_label_get_text (GTK_LABEL (gtk_builder_get_object (priv->commons->gtkbuilder, "label14"))), NULL, 10), + 0); + stmt = gda_sql_parser_parse_string (priv->commons->gdaparser, sql, NULL, NULL); + } + else + { + sql = g_strdup_printf ("UPDATE %srules" + " SET" + " id_roles = %s," + " id_resources = %s," + " type = %s," + " WHERE id = %d", + priv->commons->prefix, + strtol (gtk_label_get_text (GTK_LABEL (gtk_builder_get_object (priv->commons->gtkbuilder, "label15"))), NULL, 10), + strtol (gtk_label_get_text (GTK_LABEL (gtk_builder_get_object (priv->commons->gtkbuilder, "label14"))), NULL, 10), + 0, + priv->id); + stmt = gda_sql_parser_parse_string (priv->commons->gdaparser, sql, NULL, NULL); + } + g_free (sql); + + error = NULL; + if (gda_connection_statement_execute_non_select (priv->commons->gdacon, stmt, NULL, NULL, &error) == 1) + { + g_object_unref (stmt); + + g_signal_emit (authorization, klass->updated_signal_id, 0); + + if (priv->id == 0) + { + priv->id = strtol (gtk_label_get_text (GTK_LABEL (gtk_builder_get_object (priv->commons->gtkbuilder, "label12"))), NULL, 10); + } + + dialog = gtk_message_dialog_new (GTK_WINDOW (priv->w), + GTK_DIALOG_DESTROY_WITH_PARENT, + GTK_MESSAGE_INFO, + GTK_BUTTONS_OK, + "Saved with success."); + gtk_dialog_run (GTK_DIALOG (dialog)); + gtk_widget_destroy (dialog); + } + else + { + if (priv->id == 0) + { + gtk_label_set_text (GTK_LABEL (gtk_builder_get_object (priv->commons->gtkbuilder, "label12")), ""); + } + + dialog = gtk_message_dialog_new (GTK_WINDOW (priv->w), + GTK_DIALOG_DESTROY_WITH_PARENT, + GTK_MESSAGE_WARNING, + GTK_BUTTONS_OK, + "Error on saving.\n\n%s", + (error != NULL && error->message != NULL ? error->message : "No details.")); + gtk_dialog_run (GTK_DIALOG (dialog)); + gtk_widget_destroy (dialog); + } +} + +static void +authorization_set_property (GObject *object, guint property_id, const GValue *value, GParamSpec *pspec) +{ + Authorization *authorization = AUTHORIZATION (object); + AuthorizationPrivate *priv = AUTHORIZATION_GET_PRIVATE (authorization); + + switch (property_id) + { + default: + G_OBJECT_WARN_INVALID_PROPERTY_ID (object, property_id, pspec); + break; + } +} + +static void +authorization_get_property (GObject *object, guint property_id, GValue *value, GParamSpec *pspec) +{ + Authorization *authorization = AUTHORIZATION (object); + AuthorizationPrivate *priv = AUTHORIZATION_GET_PRIVATE (authorization); + + switch (property_id) + { + default: + G_OBJECT_WARN_INVALID_PROPERTY_ID (object, property_id, pspec); + break; + } +} + +/* CALLBACK */ +static void +authorization_on_btn_cancel_clicked (GtkButton *button, + gpointer user_data) +{ + Authorization *authorization = (Authorization *)user_data; + + AuthorizationPrivate *priv = AUTHORIZATION_GET_PRIVATE (authorization); + + gtk_widget_destroy (priv->w); +} + +static void +authorization_on_btn_save_clicked (GtkButton *button, + gpointer user_data) +{ + authorization_save ((Authorization *)user_data); +} diff --git a/src/authorization.h b/src/authorization.h new file mode 100644 index 0000000..019b129 --- /dev/null +++ b/src/authorization.h @@ -0,0 +1,65 @@ +/* + * Copyright (C) 2012 Andrea Zagli + * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License as published by the Free Software Foundation; either + * version 2.1 of the License, or (at your option) any later version. + * + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. + * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA + * + */ + +#ifndef __AUTHORIZATION_H__ +#define __AUTHORIZATION_H__ + +#include +#include + +#include + +#include "commons.h" + +G_BEGIN_DECLS + + +#define TYPE_AUTHORIZATION (authorization_get_type ()) +#define AUTHORIZATION(obj) (G_TYPE_CHECK_INSTANCE_CAST ((obj), TYPE_AUTHORIZATION, Authorization)) +#define AUTHORIZATION_CLASS(klass) (G_TYPE_CHECK_CLASS_CAST ((klass), TYPE_AUTHORIZATION, AuthorizationClass)) +#define IS_AUTHORIZATION(obj) (G_TYPE_CHECK_INSTANCE_TYPE ((obj), TYPE_AUTHORIZATION)) +#define IS_AUTHORIZATION_CLASS(klass) (G_TYPE_CHECK_CLASS_TYPE ((klass), TYPE_AUTHORIZATION)) +#define AUTHORIZATION_GET_CLASS(obj) (G_TYPE_INSTANCE_GET_CLASS ((obj), TYPE_AUTHORIZATION, AuthorizationClass)) + + +typedef struct _Authorization Authorization; +typedef struct _AuthorizationClass AuthorizationClass; + +struct _Authorization + { + GObject parent; + }; + +struct _AuthorizationClass + { + GObjectClass parent_class; + + guint updated_signal_id; + }; + +GType authorization_get_type (void) G_GNUC_CONST; + +Authorization *authorization_new (Commons *commons, gint id); + +GtkWidget *authorization_get_widget (Authorization *authorization); + + +G_END_DECLS + +#endif /* __AUTHORIZATION_H__ */ diff --git a/src/authorizations.c b/src/authorizations.c new file mode 100644 index 0000000..3f31624 --- /dev/null +++ b/src/authorizations.c @@ -0,0 +1,407 @@ +/* + * Copyright (C) 2012 Andrea Zagli + * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License as published by the Free Software Foundation; either + * version 2.1 of the License, or (at your option) any later version. + * + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. + * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA + * + */ + +#include + +#include + +#include "authorizations.h" +#include "authorization.h" + +static void authorizations_class_init (AuthorizationsClass *klass); +static void authorizations_init (Authorizations *authorizations); + +static void authorizations_load (Authorizations *authorizations); +static void authorizations_edit (Authorizations *authorizations); + +static void authorizations_on_authorization_updated (gpointer instance, gpointer user_data); + +static void authorizations_set_property (GObject *object, + guint property_id, + const GValue *value, + GParamSpec *pspec); +static void authorizations_get_property (GObject *object, + guint property_id, + GValue *value, + GParamSpec *pspec); + +static void authorizations_on_btn_new_clicked (GtkButton *button, + gpointer user_data); +static void authorizations_on_btn_edit_clicked (GtkButton *button, + gpointer user_data); +static void authorizations_on_btn_delete_clicked (GtkButton *button, + gpointer user_data); +static void authorizations_on_trv_authorizations_row_activated (GtkTreeView *tree_view, + GtkTreePath *tree_path, + GtkTreeViewColumn *column, + gpointer user_data); + +#define AUTHORIZATIONS_GET_PRIVATE(obj) (G_TYPE_INSTANCE_GET_PRIVATE ((obj), TYPE_AUTHORIZATIONS, AuthorizationsPrivate)) + +enum +{ + COL_ID, + COL_ROLE, + COL_RESOURCE, + COL_TYPE +}; + +typedef struct _AuthorizationsPrivate AuthorizationsPrivate; +struct _AuthorizationsPrivate + { + Commons *commons; + + GtkWidget *widget; + + GtkTreeSelection *selection; + GtkListStore *lstore_authorizations; + }; + +G_DEFINE_TYPE (Authorizations, authorizations, G_TYPE_OBJECT) + +static void +authorizations_class_init (AuthorizationsClass *klass) +{ + GObjectClass *object_class = G_OBJECT_CLASS (klass); + + g_type_class_add_private (object_class, sizeof (AuthorizationsPrivate)); + + object_class->set_property = authorizations_set_property; + object_class->get_property = authorizations_get_property; +} + +static void +authorizations_init (Authorizations *authorizations) +{ + AuthorizationsPrivate *priv = AUTHORIZATIONS_GET_PRIVATE (authorizations); +} + +/** + * authorizations_new: + * @commons: + * @selection: + * + * Returns: the newly created #Authorizations object. + */ +Authorizations +*authorizations_new (Commons *commons, gboolean selection) +{ + GError *error; + + Authorizations *a = AUTHORIZATIONS (g_object_new (authorizations_get_type (), NULL)); + + AuthorizationsPrivate *priv = AUTHORIZATIONS_GET_PRIVATE (a); + + priv->commons = commons; + + error = NULL; + gtk_builder_add_objects_from_file (priv->commons->gtkbuilder, priv->commons->guifile, + g_strsplit (g_strconcat ("lstore_authorizations", + (selection ? "|w_authorizations" : "|vbox8"), + NULL), + "|", -1), + &error); + if (error != NULL) + { + g_warning ("Error: %s.", error->message); + return NULL; + } + + priv->widget = GTK_WIDGET (gtk_builder_get_object (priv->commons->gtkbuilder, (selection ? "w_authorizations" : "vbox8"))); + priv->selection = gtk_tree_view_get_selection (GTK_TREE_VIEW (gtk_builder_get_object (priv->commons->gtkbuilder, "treeview3"))); + priv->lstore_authorizations = GTK_LIST_STORE (gtk_builder_get_object (priv->commons->gtkbuilder, "lstore_authorizations")); + + g_signal_connect (gtk_builder_get_object (priv->commons->gtkbuilder, "button17"), + "clicked", G_CALLBACK (authorizations_on_btn_new_clicked), (gpointer)a); + g_signal_connect (gtk_builder_get_object (priv->commons->gtkbuilder, "button18"), + "clicked", G_CALLBACK (authorizations_on_btn_edit_clicked), (gpointer)a); + g_signal_connect (gtk_builder_get_object (priv->commons->gtkbuilder, "button19"), + "clicked", G_CALLBACK (authorizations_on_btn_delete_clicked), (gpointer)a); + g_signal_connect (gtk_builder_get_object (priv->commons->gtkbuilder, "treeview3"), + "row-activated", G_CALLBACK (authorizations_on_trv_authorizations_row_activated), (gpointer)a); + + if (!selection) + { + /*gtk_widget_hide (GTK_WIDGET (gtk_builder_get_object (priv->commons->gtkbuilder, "button10"))); + gtk_widget_hide (GTK_WIDGET (gtk_builder_get_object (priv->commons->gtkbuilder, "button13")));*/ + } + + authorizations_load (a); + + return a; +} + +/** + * authorizations_get_widget: + * @authorizations: + * + */ +GtkWidget +*authorizations_get_widget (Authorizations *authorizations) +{ + AuthorizationsPrivate *priv; + + g_return_val_if_fail (IS_AUTHORIZATIONS (authorizations), NULL); + + priv = AUTHORIZATIONS_GET_PRIVATE (authorizations); + + return priv->widget; +} + +/* PRIVATE */ +static void +authorizations_load (Authorizations *authorizations) +{ + GtkTreeIter iter; + + gchar *sql; + + GdaStatement *stmt; + GError *error; + GdaDataModel *dm; + + gint rows; + gint row; + + AuthorizationsPrivate *priv = AUTHORIZATIONS_GET_PRIVATE (authorizations); + + gtk_list_store_clear (priv->lstore_authorizations); + + sql = g_strdup_printf ("SELECT ru.id," + " ro.role_id," + " re.resource_id," + " ru.type" + " FROM %srules AS ru" + " INNER JOIN %sroles AS ro ON ru.id_roles = ro.id" + " INNER JOIN %sresources AS re ON ru.id_resources = re.id" + " ORDER BY ro.role_id, re.resource_id, ru.type", + priv->commons->prefix, + priv->commons->prefix, + priv->commons->prefix); + stmt = gda_sql_parser_parse_string (priv->commons->gdaparser, sql, NULL, NULL); + g_free (sql); + dm = gda_connection_statement_execute_select (priv->commons->gdacon, stmt, NULL, &error); + g_object_unref (stmt); + if (dm != NULL) + { + rows = gda_data_model_get_n_rows (dm); + for (row = 0; row < rows; row++) + { + gtk_list_store_append (priv->lstore_authorizations, &iter); + gtk_list_store_set (priv->lstore_authorizations, &iter, + COL_ID, g_value_get_int (gda_data_model_get_value_at (dm, 0, row, NULL)), + COL_ROLE, gda_value_stringify (gda_data_model_get_value_at (dm, 1, row, NULL)), + COL_RESOURCE, gda_value_stringify (gda_data_model_get_value_at (dm, 2, row, NULL)), + COL_TYPE, gda_value_stringify (gda_data_model_get_value_at (dm, 3, row, NULL)), + -1); + } + + g_object_unref (dm); + } + else + { + /* TODO */ + } +} + +static void +authorizations_edit (Authorizations *authorizations) +{ + GtkTreeIter iter; + guint id; + + AuthorizationsPrivate *priv = AUTHORIZATIONS_GET_PRIVATE (authorizations); + + if (gtk_tree_selection_get_selected (priv->selection, NULL, &iter)) + { + GtkWidget *w; + + gtk_tree_model_get (GTK_TREE_MODEL (priv->lstore_authorizations), &iter, + COL_ID, &id, + -1); + + Authorization *c = authorization_new (priv->commons, id); + + g_signal_connect (G_OBJECT (c), "updated", + G_CALLBACK (authorizations_on_authorization_updated), (gpointer)authorizations); + + w = role_get_widget (c); + gtk_window_set_transient_for (GTK_WINDOW (w), GTK_WINDOW (gtk_builder_get_object (priv->commons->gtkbuilder, "w_main"))); + gtk_widget_show_all (w); + } + else + { + GtkWidget *dialog = gtk_message_dialog_new (GTK_WINDOW (gtk_builder_get_object (priv->commons->gtkbuilder, "w_main")), + GTK_DIALOG_DESTROY_WITH_PARENT, + GTK_MESSAGE_WARNING, + GTK_BUTTONS_OK, + "Select an authorization."); + gtk_dialog_run (GTK_DIALOG (dialog)); + gtk_widget_destroy (dialog); + } +} + +static void +authorizations_on_authorization_updated (gpointer instance, gpointer user_data) +{ + authorizations_load ((Authorizations *)user_data); +} + +static void +authorizations_set_property (GObject *object, guint property_id, const GValue *value, GParamSpec *pspec) +{ + Authorizations *authorizations = AUTHORIZATIONS (object); + AuthorizationsPrivate *priv = AUTHORIZATIONS_GET_PRIVATE (authorizations); + + switch (property_id) + { + default: + G_OBJECT_WARN_INVALID_PROPERTY_ID (object, property_id, pspec); + break; + } +} + +static void +authorizations_get_property (GObject *object, guint property_id, GValue *value, GParamSpec *pspec) +{ + Authorizations *authorizations = AUTHORIZATIONS (object); + AuthorizationsPrivate *priv = AUTHORIZATIONS_GET_PRIVATE (authorizations); + + switch (property_id) + { + default: + G_OBJECT_WARN_INVALID_PROPERTY_ID (object, property_id, pspec); + break; + } +} + +/* CALLBACK */ +static void +authorizations_on_btn_new_clicked (GtkButton *button, + gpointer user_data) +{ + GtkWidget *w; + + Authorizations *authorizations = (Authorizations *)user_data; + AuthorizationsPrivate *priv = AUTHORIZATIONS_GET_PRIVATE (authorizations); + + Authorization *c = authorization_new (priv->commons, 0); + + g_signal_connect (G_OBJECT (c), "updated", + G_CALLBACK (authorizations_on_authorization_updated), (gpointer)authorizations); + + w = authorization_get_widget (c); + gtk_window_set_transient_for (GTK_WINDOW (w), GTK_WINDOW (gtk_builder_get_object (priv->commons->gtkbuilder, "w_main"))); + gtk_widget_show_all (w); +} + +static void +authorizations_on_btn_edit_clicked (GtkButton *button, + gpointer user_data) +{ + authorizations_edit ((Authorizations *)user_data); +} + +static void +authorizations_on_btn_delete_clicked (GtkButton *button, + gpointer user_data) +{ + GtkWidget *dialog; + gboolean risp; + + GtkTreeIter iter; + guint id; + + Authorizations *authorizations = (Authorizations *)user_data; + AuthorizationsPrivate *priv = AUTHORIZATIONS_GET_PRIVATE (authorizations); + + if (gtk_tree_selection_get_selected (priv->selection, NULL, &iter)) + { + dialog = gtk_message_dialog_new (GTK_WINDOW (gtk_builder_get_object (priv->commons->gtkbuilder, "w_main")), + GTK_DIALOG_DESTROY_WITH_PARENT, + GTK_MESSAGE_QUESTION, + GTK_BUTTONS_YES_NO, + "Are you sure to want to delete the selected authorization?"); + risp = gtk_dialog_run (GTK_DIALOG (dialog)); + gtk_widget_destroy (dialog); + if (risp == GTK_RESPONSE_YES) + { + GError *error; + GdaStatement *stmt; + + gtk_tree_model_get (GTK_TREE_MODEL (priv->lstore_authorizations), &iter, + COL_ID, &id, + -1); + + error = NULL; + stmt = gda_sql_parser_parse_string (priv->commons->gdaparser, + g_strdup_printf ("DELETE FROM %srules WHERE id = %d", priv->commons->prefix, id), + NULL, &error); + + if (stmt == NULL || error != NULL) + { + dialog = gtk_message_dialog_new (GTK_WINDOW (gtk_builder_get_object (priv->commons->gtkbuilder, "w_main")), + GTK_DIALOG_DESTROY_WITH_PARENT, + GTK_MESSAGE_WARNING, + GTK_BUTTONS_OK, + "You must select an authorization.%s", + error != NULL && error->message != NULL ? g_strdup_printf ("\n\n%s", error->message) : ""); + gtk_dialog_run (GTK_DIALOG (dialog)); + gtk_widget_destroy (dialog); + return; + } + + error = NULL; + if (gda_connection_statement_execute_non_select (priv->commons->gdacon, stmt, NULL, NULL, &error) <= 0) + { + dialog = gtk_message_dialog_new (GTK_WINDOW (gtk_builder_get_object (priv->commons->gtkbuilder, "w_main")), + GTK_DIALOG_DESTROY_WITH_PARENT, + GTK_MESSAGE_WARNING, + GTK_BUTTONS_OK, + "Error on saving.\n\n%s", + (error != NULL && error->message != NULL ? error->message : "No details.")); + gtk_dialog_run (GTK_DIALOG (dialog)); + gtk_widget_destroy (dialog); + } + + authorizations_load (authorizations); + } + } + else + { + dialog = gtk_message_dialog_new (GTK_WINDOW (gtk_builder_get_object (priv->commons->gtkbuilder, "w_main")), + GTK_DIALOG_DESTROY_WITH_PARENT, + GTK_MESSAGE_WARNING, + GTK_BUTTONS_OK, + "Select an authorization."); + gtk_dialog_run (GTK_DIALOG (dialog)); + gtk_widget_destroy (dialog); + } +} + +static void +authorizations_on_trv_authorizations_row_activated (GtkTreeView *tree_view, + GtkTreePath *tree_path, + GtkTreeViewColumn *column, + gpointer user_data) +{ + AuthorizationsPrivate *priv = AUTHORIZATIONS_GET_PRIVATE ((Authorizations *)user_data); + + authorizations_edit ((Authorizations *)user_data); +} diff --git a/src/authorizations.h b/src/authorizations.h new file mode 100644 index 0000000..339320e --- /dev/null +++ b/src/authorizations.h @@ -0,0 +1,63 @@ +/* + * Copyright (C) 2012 Andrea Zagli + * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License as published by the Free Software Foundation; either + * version 2.1 of the License, or (at your option) any later version. + * + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. + * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA + * + */ + +#ifndef __AUTHORIZATIONS_H__ +#define __AUTHORIZATIONS_H__ + +#include +#include + +#include + +#include "commons.h" + +G_BEGIN_DECLS + + +#define TYPE_AUTHORIZATIONS (authorizations_get_type ()) +#define AUTHORIZATIONS(obj) (G_TYPE_CHECK_INSTANCE_CAST ((obj), TYPE_AUTHORIZATIONS, Authorizations)) +#define AUTHORIZATIONS_CLASS(klass) (G_TYPE_CHECK_CLASS_CAST ((klass), TYPE_AUTHORIZATIONS, AuthorizationsClass)) +#define IS_AUTHORIZATIONS(obj) (G_TYPE_CHECK_INSTANCE_TYPE ((obj), TYPE_AUTHORIZATIONS)) +#define IS_AUTHORIZATIONS_CLASS(klass) (G_TYPE_CHECK_CLASS_TYPE ((klass), TYPE_AUTHORIZATIONS)) +#define AUTHORIZATIONS_GET_CLASS(obj) (G_TYPE_INSTANCE_GET_CLASS ((obj), TYPE_AUTHORIZATIONS, AuthorizationsClass)) + + +typedef struct _Authorizations Authorizations; +typedef struct _AuthorizationsClass AuthorizationsClass; + +struct _Authorizations + { + GObject parent; + }; + +struct _AuthorizationsClass + { + GObjectClass parent_class; + }; + +GType authorizations_get_type (void) G_GNUC_CONST; + +Authorizations *authorizations_new (Commons *commons, gboolean selection); + +GtkWidget *authorizations_get_widget (Authorizations *authorizations); + + +G_END_DECLS + +#endif /* __AUTHORIZATIONS_H__ */ diff --git a/src/main.c b/src/main.c index dc437c4..8d3c9f2 100644 --- a/src/main.c +++ b/src/main.c @@ -1,5 +1,5 @@ /* - * Copyright (C) 2011 Andrea Zagli + * Copyright (C) 2011-2012 Andrea Zagli * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by @@ -31,6 +31,7 @@ #include "openauditds.h" #include "roles.h" #include "resources.h" +#include "authorizations.h" G_MODULE_EXPORT void on_mnu_file_close_activate (GtkMenuItem *menuitem, gpointer user_data); @@ -176,6 +177,19 @@ on_mnu_view_resources_activate (GtkMenuItem *menuitem, main_set_vbx_body_child (vbx); } +G_MODULE_EXPORT void +on_mnu_view_authorizations_activate (GtkMenuItem *menuitem, + gpointer user_data) +{ + GtkWidget *vbx; + + Authorizations *m = authorizations_new (commons, FALSE); + + vbx = authorizations_get_widget (m); + + main_set_vbx_body_child (vbx); +} + G_MODULE_EXPORT void on_mnu_help_about_activate (GtkMenuItem *menuitem, gpointer user_data) diff --git a/tests/db.db b/tests/db.db index 5ac3002335eb3b0b7349734ef59edecaec3ecabb..767bff35747ee5f9aefd8cd2100ffea8b194ee0d 100644 GIT binary patch delta 73 zcmZp$Xt0SxEpW!YIjHl%JETV9dn? VWHW);Mx2byoRT2s=70Q5JOIg65{3W( delta 71 zcmZp$Xt0