static void _create_binary_guid()
{
GdaParameterList *plist;
GdaParameter *param;
GdaDict *dict = gda_dict_new();
gda_dict_set_connection (dict , mgd->priv->connection);
const gchar *sql = "INSERT INTO guids_bin (guid) VALUES(##/*name:'guid' type:GdaBinary*/)";
GdaQuery *query = gda_query_new_from_sql (dict, sql, NULL);
if (!query)
g_error("Failed to create new query from string");
plist = gda_query_get_parameter_list (query);
param = gda_parameter_list_find_param (plist, "guid");
gchar *guid = midgard_uuid_new();
GValue *valb = gda_value_new_from_string ( (const gchar *) guid, GDA_TYPE_BINARY);
gda_parameter_set_value (param, valb);
gda_connection_clear_events_list (mgd->priv->connection);
GError *error = NULL;
GdaObject *res_obj = gda_query_execute (query, plist, FALSE, &error);
}
/**
* gdaui_numeric_entry_get_text:
* @entry: a #GdauiNumericEntry widget
*
* Get @entry's contents as a #GValue.
*
* Returns: (transfer full): a new #GValue, or %NULL
*/
GValue *
gdaui_numeric_entry_get_value (GdauiNumericEntry *entry)
{
gchar *text;
GValue *value = NULL;
g_return_val_if_fail (GDAUI_IS_NUMERIC_ENTRY (entry), NULL);
text = gdaui_entry_get_text ((GdauiEntry*) entry);
if (text) {
gchar *ptr;
gint len;
len = strlen (text);
for (ptr = text; *ptr; ) {
if (*ptr == entry->priv->thousands_sep)
memmove (ptr, ptr+1, len - (ptr - text));
else {
if (*ptr == entry->priv->decimal_sep)
*ptr = '.';
ptr++;
}
}
value = gda_value_new_from_string (text, entry->priv->type);
g_free (text);
}
return value;
}
/**
* wmud_db_save_player:
* @player: the player record to save
* @err: a GError to put error messages in it
*
* Saves a player record to the database backend.
*
* Return value: %TRUE on success. Upon failure, %FALSE is returned, and err is
* set accordingly.
*/
gboolean
wmud_db_save_player(WmudPlayer *player, GError **err)
{
GError *local_err = NULL;
GValue *login_value,
*email_value;
g_log(G_LOG_DOMAIN, G_LOG_LEVEL_DEBUG, "Saving player");
if (dbh == NULL) {
if (err) {
g_set_error(err,
WMUD_DB_ERROR, WMUD_DB_ERROR_NOINIT,
"Database backend not initialized");
}
return FALSE;
}
login_value = gda_value_new_from_string(
wmud_player_get_player_name(player),
G_TYPE_STRING);
email_value = gda_value_new_from_string(
wmud_player_get_email(player),
G_TYPE_STRING);
if (!gda_connection_insert_row_into_table(dbh,
"players",
&local_err,
"id", NULL,
"login", login_value,
"password", NULL,
"email", email_value,
NULL)) {
g_set_error(err,
WMUD_DB_ERROR, WMUD_DB_ERROR_BADQUERY,
"Error saving player: %s",
local_err->message);
return FALSE;
}
return TRUE;
}
static void
handle_user_prefs_for_sql_statement (UiFormGrid *formgrid, TConnection *tcnc,
GdaSqlStatement *sqlst)
{
g_assert (sqlst);
if (sqlst->stmt_type == GDA_SQL_STATEMENT_COMPOUND) {
GdaSqlStatementCompound *comp;
GSList *list;
comp = (GdaSqlStatementCompound*) sqlst->contents;
for (list = comp->stmt_list; list; list = list->next)
handle_user_prefs_for_sql_statement (formgrid, tcnc,
(GdaSqlStatement *) list->data);
}
else {
GdaSet *set;
set = (GdaSet*) ui_formgrid_get_form_data_set (UI_FORMGRID (formgrid));
GdaSqlStatementSelect *sel;
GSList *list;
gint pos;
sel = (GdaSqlStatementSelect*) sqlst->contents;
for (pos = 0, list = sel->expr_list; list; pos ++, list = list->next) {
GdaSqlSelectField *field = (GdaSqlSelectField*) list->data;
if (! field->validity_meta_object ||
(field->validity_meta_object->obj_type != GDA_META_DB_TABLE) ||
!field->validity_meta_table_column)
continue;
gchar *plugin;
plugin = t_connection_get_table_column_attribute (tcnc,
GDA_META_TABLE (field->validity_meta_object),
field->validity_meta_table_column,
T_CONNECTION_COLUMN_PLUGIN, NULL);
if (!plugin)
continue;
GdaHolder *holder;
holder = gda_set_get_nth_holder (set, pos);
if (holder) {
GValue *value;
value = gda_value_new_from_string (plugin, G_TYPE_STRING);
gda_holder_set_attribute_static (holder, GDAUI_ATTRIBUTE_PLUGIN, value);
gda_value_free (value);
}
g_free (plugin);
}
}
}
static gboolean
param_to_null_foreach (GdaSqlAnyPart *part, G_GNUC_UNUSED gpointer data, G_GNUC_UNUSED GError **error)
{
if (part->type == GDA_SQL_ANY_EXPR) {
GdaSqlExpr *expr = (GdaSqlExpr*) part;
if (expr->param_spec) {
GType type = expr->param_spec->g_type;
gda_sql_param_spec_free (expr->param_spec);
expr->param_spec = NULL;
if (!expr->value) {
if (type != GDA_TYPE_NULL)
expr->value = gda_value_new_from_string ("0", type);
else
g_value_set_int ((expr->value = gda_value_new (G_TYPE_INT)), 0);
}
}
}
return TRUE;
}
gboolean
wmud_db_update_player_password(WmudPlayer *player,
gchar *crypted_password,
GError **err)
{
GValue *cpw,
*player_id;
GError *local_err = NULL;
g_log(G_LOG_DOMAIN, G_LOG_LEVEL_DEBUG,
"Saving player password for %s",
wmud_player_get_player_name(player));
if (dbh == NULL) {
g_set_error(err,
WMUD_DB_ERROR, WMUD_DB_ERROR_NOINIT,
"Database backend not initialized");
return FALSE;
}
player_id = gda_value_new(G_TYPE_UINT);
g_value_set_uint(player_id, wmud_player_get_id(player));
cpw = gda_value_new_from_string(crypted_password, G_TYPE_STRING);
if (!gda_connection_update_row_in_table(dbh,
"players",
"id", player_id,
&local_err,
"password", cpw,
NULL)) {
g_set_error(err,
WMUD_DB_ERROR, WMUD_DB_ERROR_BADQUERY,
"Error saving player password: %s",
local_err->message);
return FALSE;
}
return TRUE;
}
/*
* gda_ldap_attr_value_to_g_value:
* Converts a #BerValue to a new #GValue
*
* Returns: a new #GValue, or %NULL on error
*/
GValue *
gda_ldap_attr_value_to_g_value (LdapConnectionData *cdata, GType type, BerValue *bv)
{
GValue *value = NULL;
if ((type == G_TYPE_DATE_TIME) ||
(type == G_TYPE_DATE)) {
/* see ftp://ftp.rfc-editor.org/in-notes/rfc4517.txt,
* section 3.3.13: Generalized Time
*/
GTimeVal tv;
gboolean conv;
if (! (conv = g_time_val_from_iso8601 (bv->bv_val,
&tv))) {
/* Add the 'T' char */
gchar *tmp, *str;
gint i, len;
str = bv->bv_val;
len = strlen (str);
if (len > 8) {
tmp = g_new (gchar, len + 2);
for (i = 0; i < 8; i++)
tmp[i] = str[i];
tmp [8] = 'T';
for (i = 9; str[i]; i++)
tmp[i] = str[i-1];
tmp[i] = 0;
conv = g_time_val_from_iso8601 (tmp, &tv);
g_free (tmp);
}
}
if (conv) {
struct tm *ptm;
#ifdef HAVE_LOCALTIME_R
struct tm tmpstm;
ptm = localtime_r (&(tv.tv_sec), &tmpstm);
#elif HAVE_LOCALTIME_S
struct tm tmpstm;
if (localtime_s (&tmpstm, &(tv.tv_sec)) == 0)
ptm = &tmpstm;
else
ptm = NULL;
#else
ptm = localtime (&(tv.tv_sec));
#endif
if (!ptm)
return NULL;
if (g_type_is_a (type, G_TYPE_DATE_TIME)) {
GTimeZone *tz = g_time_zone_new ("Z"); // UTC
GDateTime *ts = g_date_time_new (tz,
ptm->tm_year + 1900,
ptm->tm_mon + 1,
ptm->tm_mday,
ptm->tm_hour,
ptm->tm_min,
ptm->tm_sec);
value = gda_value_new (G_TYPE_DATE_TIME);
g_value_set_boxed (value, ts);
g_date_time_unref (ts);
}
else {
GDate *date;
date = g_date_new ();
g_date_set_time_val (date, &tv);
value = gda_value_new (type);
g_value_take_boxed (value, date);
}
}
}
else if (type == GDA_TYPE_BINARY) {
guchar *data;
data = g_new (guchar, bv->bv_len);
memcpy (data, bv->bv_val, sizeof (guchar) * bv->bv_len);
value = gda_value_new_binary (data, bv->bv_len);
}
else
value = gda_value_new_from_string (bv->bv_val, type);
return value;
}
GtkWidget *
do_form_pict (GtkWidget *do_widget)
{
if (!window) {
GdaStatement *stmt;
GtkWidget *vbox;
GtkWidget *label;
GdaDataModel *model;
GtkWidget *form;
GdaSet *data_set;
GdaHolder *param;
GValue *value;
window = gtk_dialog_new_with_buttons ("Form with the 'picture' plugin",
GTK_WINDOW (do_widget),
0,
GTK_STOCK_CLOSE,
GTK_RESPONSE_NONE,
NULL);
g_signal_connect (window, "response",
G_CALLBACK (gtk_widget_destroy), NULL);
g_signal_connect (window, "destroy",
G_CALLBACK (gtk_widget_destroyed), &window);
vbox = gtk_box_new (GTK_ORIENTATION_VERTICAL, 5);
gtk_box_pack_start (GTK_BOX (gtk_dialog_get_content_area (GTK_DIALOG (window))),
vbox, TRUE, TRUE, 0);
gtk_container_set_border_width (GTK_CONTAINER (vbox), 5);
label = gtk_label_new ("The following GdauiForm widget displays data from the 'pictures' table.\n\n"
"The pictures are stored as BLOB inside the database and\n"
"are displayed using the 'picture' plugin (right click to \n"
"open a menu, or double click to load an image).");
gtk_box_pack_start (GTK_BOX (vbox), label, FALSE, FALSE, 0);
/* Create the demo widget */
stmt = gda_sql_parser_parse_string (demo_parser, "SELECT id, pict FROM pictures", NULL, NULL);
model = gda_connection_statement_execute_select (demo_cnc, stmt, NULL, NULL);
g_object_unref (stmt);
gda_data_select_compute_modification_statements (GDA_DATA_SELECT (model), NULL);
form = gdaui_form_new (model);
g_object_unref (model);
g_object_set (G_OBJECT (form), "info-flags",
GDAUI_DATA_PROXY_INFO_CURRENT_ROW |
GDAUI_DATA_PROXY_INFO_ROW_MOVE_BUTTONS |
GDAUI_DATA_PROXY_INFO_ROW_MODIFY_BUTTONS, NULL);
/* specify that we want to use the 'picture' plugin */
data_set = GDA_SET (gdaui_data_selector_get_data_set (GDAUI_DATA_SELECTOR (form)));
param = gda_set_get_holder (data_set, "pict");
value = gda_value_new_from_string ("picture", G_TYPE_STRING);
gda_holder_set_attribute_static (param, GDAUI_ATTRIBUTE_PLUGIN, value);
gda_value_free (value);
gtk_box_pack_start (GTK_BOX (vbox), form, TRUE, TRUE, 0);
}
gboolean visible;
g_object_get (G_OBJECT (window), "visible", &visible, NULL);
if (!visible)
gtk_widget_show_all (window);
else {
gtk_widget_destroy (window);
window = NULL;
}
return window;
}
GtkWidget *
do_data_model_dir (GtkWidget *do_widget)
{
if (!window) {
GtkWidget *vbox;
GtkWidget *label;
GdaDataModel *model;
GtkWidget *form, *grid, *nb;
GdaSet *data_set;
GdaHolder *param;
gchar *path;
GValue *value;
window = gtk_dialog_new_with_buttons ("GdaDataModelDir data model",
GTK_WINDOW (do_widget),
0,
GTK_STOCK_CLOSE,
GTK_RESPONSE_NONE,
NULL);
g_signal_connect (window, "response",
G_CALLBACK (gtk_widget_destroy), NULL);
g_signal_connect (window, "destroy",
G_CALLBACK (gtk_widget_destroyed), &window);
vbox = gtk_box_new (GTK_ORIENTATION_VERTICAL, 5);
gtk_box_pack_start (GTK_BOX (gtk_dialog_get_content_area (GTK_DIALOG (window))),
vbox, TRUE, TRUE, 0);
gtk_container_set_border_width (GTK_CONTAINER (vbox), 5);
label = gtk_label_new ("The following GdauiForm widget displays data from a GdaDataModelDir "
"data model which lists the files contained in the selected directory.\n\n"
"Each file contents is then displayed using the 'picture' plugin \n"
"(right click to open a menu, or double click to load an image).");
gtk_box_pack_start (GTK_BOX (vbox), label, FALSE, FALSE, 0);
/* GdaDataModelDir object */
path = get_data_path ();
model = gda_data_model_dir_new (path);
g_free (path);
/* Create the demo widget */
nb = gtk_notebook_new ();
gtk_box_pack_start (GTK_BOX (vbox), nb, TRUE, TRUE, 0);
form = gdaui_form_new (model);
gtk_notebook_append_page (GTK_NOTEBOOK (nb), form, gtk_label_new ("Form"));
grid = gdaui_grid_new (model);
gtk_notebook_append_page (GTK_NOTEBOOK (nb), grid, gtk_label_new ("Grid"));
g_object_unref (model);
/* specify that we want to use the 'picture' plugin */
data_set = GDA_SET (gdaui_data_selector_get_data_set (GDAUI_DATA_SELECTOR (grid)));
param = gda_set_get_holder (data_set, "data");
value = gda_value_new_from_string ("picture", G_TYPE_STRING);
gda_holder_set_attribute_static (param, GDAUI_ATTRIBUTE_PLUGIN, value);
gdaui_data_proxy_column_show_actions (GDAUI_DATA_PROXY (grid), -1, TRUE);
gda_value_free (value);
}
gboolean visible;
g_object_get (G_OBJECT (window), "visible", &visible, NULL);
if (!visible)
gtk_widget_show_all (window);
else {
gtk_widget_destroy (window);
window = NULL;
}
return window;
}
