1 /* PSPPIRE - a graphical user interface for PSPP.
2 Copyright (C) 2006, 2008, 2009, 2010, 2011, 2012, 2013 Free Software Foundation
4 This program is free software: you can redistribute it and/or modify
5 it under the terms of the GNU General Public License as published by
6 the Free Software Foundation, either version 3 of the License, or
7 (at your option) any later version.
9 This program is distributed in the hope that it will be useful,
10 but WITHOUT ANY WARRANTY; without even the implied warranty of
11 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 GNU General Public License for more details.
14 You should have received a copy of the GNU General Public License
15 along with this program. If not, see <http://www.gnu.org/licenses/>. */
21 #define _(msgid) gettext (msgid)
22 #define N_(msgid) msgid
24 #include <data/datasheet.h>
25 #include <data/data-out.h>
26 #include <data/variable.h>
28 #include <ui/gui/psppire-marshal.h>
30 #include <pango/pango-context.h>
32 #include "psppire-data-store.h"
33 #include <libpspp/i18n.h>
36 #include <data/dictionary.h>
37 #include <data/missing-values.h>
38 #include <data/value-labels.h>
39 #include <data/data-in.h>
40 #include <data/format.h>
42 #include <math/sort.h>
49 static void psppire_data_store_init (PsppireDataStore *data_store);
50 static void psppire_data_store_class_init (PsppireDataStoreClass *class);
52 static void psppire_data_store_finalize (GObject *object);
53 static void psppire_data_store_dispose (GObject *object);
55 static gboolean psppire_data_store_insert_case (PsppireDataStore *ds,
60 static gboolean psppire_data_store_data_in (PsppireDataStore *ds,
61 casenumber casenum, gint idx,
62 struct substring input,
63 const struct fmt_spec *fmt);
65 static GObjectClass *parent_class = NULL;
77 static guint signals [n_SIGNALS];
80 __tree_model_iter_n_children (GtkTreeModel *tree_model,
83 PsppireDataStore *store = PSPPIRE_DATA_STORE (tree_model);
85 gint n = datasheet_get_n_rows (store->datasheet);
90 static GtkTreeModelFlags
91 __tree_model_get_flags (GtkTreeModel *model)
93 g_return_val_if_fail (PSPPIRE_IS_DATA_STORE (model), (GtkTreeModelFlags) 0);
95 return GTK_TREE_MODEL_LIST_ONLY;
99 __tree_model_get_n_columns (GtkTreeModel *tree_model)
101 PsppireDataStore *store = PSPPIRE_DATA_STORE (tree_model);
103 return psppire_dict_get_value_cnt (store->dict);
108 __iter_nth_child (GtkTreeModel *tree_model,
113 PsppireDataStore *store = PSPPIRE_DATA_STORE (tree_model);
115 g_assert (parent == NULL);
117 g_return_val_if_fail (store, FALSE);
118 g_return_val_if_fail (store->datasheet, FALSE);
120 if (n >= datasheet_get_n_rows (store->datasheet))
123 iter->user_data = NULL;
134 __get_value (GtkTreeModel *tree_model,
139 PsppireDataStore *store = PSPPIRE_DATA_STORE (tree_model);
141 const struct variable *variable = psppire_dict_get_variable (store->dict, column);
143 if (var_is_numeric (variable))
144 g_value_init (value, G_TYPE_DOUBLE);
146 g_value_init (value, G_TYPE_STRING);
148 gint row = GPOINTER_TO_INT (iter->user_data);
150 struct ccase *cc = datasheet_get_row (store->datasheet, row);
152 if (var_is_numeric (variable))
153 g_value_set_double (value, case_data_idx (cc, column)->f);
156 const gchar *ss = value_str (case_data_idx (cc, column),
157 var_get_width (variable));
158 g_value_set_string (value, ss);
165 __get_type (GtkTreeModel *tree_model, gint idx)
167 PsppireDataStore *store = PSPPIRE_DATA_STORE (tree_model);
169 const struct variable *variable = psppire_dict_get_variable (store->dict, idx);
171 if (var_is_numeric (variable))
172 return G_TYPE_DOUBLE;
174 return G_TYPE_STRING;
178 __tree_model_init (GtkTreeModelIface *iface)
180 iface->get_flags = __tree_model_get_flags;
181 iface->get_n_columns = __tree_model_get_n_columns ;
182 iface->get_column_type = __get_type;
183 iface->get_iter = NULL;
184 iface->iter_next = NULL;
185 iface->get_path = NULL;
186 iface->get_value = __get_value;
188 iface->iter_children = NULL;
189 iface->iter_has_child = NULL;
190 iface->iter_n_children = __tree_model_iter_n_children;
191 iface->iter_nth_child = __iter_nth_child;
192 iface->iter_parent = NULL;
197 psppire_data_store_get_type (void)
199 static GType data_store_type = 0;
201 if (!data_store_type)
203 static const GTypeInfo data_store_info =
205 sizeof (PsppireDataStoreClass),
206 NULL, /* base_init */
207 NULL, /* base_finalize */
208 (GClassInitFunc) psppire_data_store_class_init,
209 NULL, /* class_finalize */
210 NULL, /* class_data */
211 sizeof (PsppireDataStore),
213 (GInstanceInitFunc) psppire_data_store_init,
216 static const GInterfaceInfo tree_model_info = {
217 (GInterfaceInitFunc) __tree_model_init,
222 data_store_type = g_type_register_static (G_TYPE_OBJECT,
224 &data_store_info, 0);
226 g_type_add_interface_static (data_store_type, GTK_TYPE_TREE_MODEL,
230 return data_store_type;
235 psppire_data_store_class_init (PsppireDataStoreClass *class)
237 GObjectClass *object_class;
239 parent_class = g_type_class_peek_parent (class);
240 object_class = (GObjectClass*) class;
242 object_class->finalize = psppire_data_store_finalize;
243 object_class->dispose = psppire_data_store_dispose;
245 signals [ITEMS_CHANGED] =
246 g_signal_new ("changed",
247 G_TYPE_FROM_CLASS (class),
251 psppire_marshal_VOID__UINT_UINT_UINT,
258 signals [CASE_INSERTED] =
259 g_signal_new ("case-inserted",
260 G_TYPE_FROM_CLASS (class),
264 g_cclosure_marshal_VOID__INT,
270 signals [CASE_CHANGED] =
271 g_signal_new ("case-changed",
272 G_TYPE_FROM_CLASS (class),
276 g_cclosure_marshal_VOID__INT,
281 signals [CASES_DELETED] =
282 g_signal_new ("cases-deleted",
283 G_TYPE_FROM_CLASS (class),
287 psppire_marshal_VOID__INT_INT,
297 psppire_data_store_insert_value (PsppireDataStore *ds,
298 gint width, gint where);
301 psppire_data_store_get_case_count (const PsppireDataStore *store)
303 return datasheet_get_n_rows (store->datasheet);
307 psppire_data_store_get_value_count (const PsppireDataStore *store)
309 return psppire_dict_get_value_cnt (store->dict);
312 const struct caseproto *
313 psppire_data_store_get_proto (const PsppireDataStore *store)
315 return psppire_dict_get_proto (store->dict);
319 psppire_data_store_init (PsppireDataStore *data_store)
321 data_store->dict = NULL;
322 data_store->datasheet = NULL;
323 data_store->dispose_has_run = FALSE;
327 A callback which occurs after a variable has been deleted.
330 delete_variable_callback (GObject *obj, const struct variable *var UNUSED,
331 gint dict_index, gint case_index,
334 PsppireDataStore *store = PSPPIRE_DATA_STORE (data);
336 g_return_if_fail (store->datasheet);
338 datasheet_delete_columns (store->datasheet, case_index, 1);
339 datasheet_insert_column (store->datasheet, NULL, -1, case_index);
342 struct resize_datum_aux
344 const struct dictionary *dict;
345 const struct variable *new_variable;
346 const struct variable *old_variable;
350 resize_datum (const union value *old, union value *new, const void *aux_)
352 const struct resize_datum_aux *aux = aux_;
353 int new_width = var_get_width (aux->new_variable);
354 const char *enc = dict_get_encoding (aux->dict);
355 const struct fmt_spec *newfmt = var_get_print_format (aux->new_variable);
356 char *s = data_out (old, enc, var_get_print_format (aux->old_variable));
357 enum fmt_type type = (fmt_usable_for_input (newfmt->type)
360 free (data_in (ss_cstr (s), enc, type, new, new_width, enc));
365 variable_changed_callback (GObject *obj, gint var_num, guint what, const struct variable *oldvar,
368 PsppireDataStore *store = PSPPIRE_DATA_STORE (data);
369 struct variable *variable = psppire_dict_get_variable (store->dict, var_num);
371 if (what & VAR_TRAIT_WIDTH)
373 int posn = var_get_case_index (variable);
374 struct resize_datum_aux aux;
375 aux.old_variable = oldvar;
376 aux.new_variable = variable;
377 aux.dict = store->dict->dict;
378 datasheet_resize_column (store->datasheet, posn, var_get_width (variable),
384 insert_variable_callback (GObject *obj, gint var_num, gpointer data)
386 struct variable *variable;
387 PsppireDataStore *store;
390 g_return_if_fail (data);
392 store = PSPPIRE_DATA_STORE (data);
394 variable = psppire_dict_get_variable (store->dict, var_num);
395 posn = var_get_case_index (variable);
396 psppire_data_store_insert_value (store, var_get_width (variable), posn);
400 * psppire_data_store_new:
401 * @dict: The dictionary for this data_store.
404 * Return value: a new #PsppireDataStore
407 psppire_data_store_new (PsppireDict *dict)
409 PsppireDataStore *retval;
411 retval = g_object_new (PSPPIRE_TYPE_DATA_STORE, NULL);
413 psppire_data_store_set_dictionary (retval, dict);
419 psppire_data_store_set_reader (PsppireDataStore *ds,
420 struct casereader *reader)
426 old_n = datasheet_get_n_rows (ds->datasheet);
427 datasheet_destroy (ds->datasheet);
430 ds->datasheet = datasheet_create (reader);
432 gint new_n = datasheet_get_n_rows (ds->datasheet);
435 for (i = 0 ; i < n_dict_signals; ++i )
437 if ( ds->dict_handler_id [i] > 0)
439 g_signal_handler_unblock (ds->dict,
440 ds->dict_handler_id[i]);
444 g_signal_emit (ds, signals[ITEMS_CHANGED], 0, 0, old_n, new_n);
449 * psppire_data_store_replace_set_dictionary:
450 * @data_store: The variable store
451 * @dict: The dictionary to set
453 * If a dictionary is already associated with the data-store, then it will be
457 psppire_data_store_set_dictionary (PsppireDataStore *data_store, PsppireDict *dict)
461 /* Disconnect any existing handlers */
462 if ( data_store->dict )
463 for (i = 0 ; i < n_dict_signals; ++i )
465 g_signal_handler_disconnect (data_store->dict,
466 data_store->dict_handler_id[i]);
469 data_store->dict = dict;
474 data_store->dict_handler_id [VARIABLE_INSERTED] =
475 g_signal_connect (dict, "variable-inserted",
476 G_CALLBACK (insert_variable_callback),
479 data_store->dict_handler_id [VARIABLE_DELETED] =
480 g_signal_connect (dict, "variable-deleted",
481 G_CALLBACK (delete_variable_callback),
484 data_store->dict_handler_id [VARIABLE_CHANGED] =
485 g_signal_connect (dict, "variable-changed",
486 G_CALLBACK (variable_changed_callback),
492 /* The entire model has changed */
494 if ( data_store->dict )
495 for (i = 0 ; i < n_dict_signals; ++i )
497 if ( data_store->dict_handler_id [i] > 0)
499 g_signal_handler_block (data_store->dict,
500 data_store->dict_handler_id[i]);
506 psppire_data_store_finalize (GObject *object)
508 PsppireDataStore *ds = PSPPIRE_DATA_STORE (object);
512 datasheet_destroy (ds->datasheet);
513 ds->datasheet = NULL;
517 (* parent_class->finalize) (object);
522 psppire_data_store_dispose (GObject *object)
524 PsppireDataStore *ds = PSPPIRE_DATA_STORE (object);
526 if (ds->dispose_has_run)
529 psppire_data_store_set_dictionary (ds, NULL);
532 (* parent_class->dispose) (object);
534 ds->dispose_has_run = TRUE;
539 /* Insert a blank case before POSN */
541 psppire_data_store_insert_new_case (PsppireDataStore *ds, casenumber posn)
544 const struct caseproto *proto;
546 g_return_val_if_fail (ds, FALSE);
548 proto = datasheet_get_proto (ds->datasheet);
549 g_return_val_if_fail (caseproto_get_n_widths (proto) > 0, FALSE);
550 g_return_val_if_fail (posn <= psppire_data_store_get_case_count (ds), FALSE);
552 cc = case_create (proto);
553 case_set_missing (cc);
555 result = psppire_data_store_insert_case (ds, cc, posn);
563 psppire_data_store_get_string (PsppireDataStore *store,
564 glong row, const struct variable *var,
565 bool use_value_label)
571 g_return_val_if_fail (store != NULL, NULL);
572 g_return_val_if_fail (store->datasheet != NULL, NULL);
573 g_return_val_if_fail (var != NULL, NULL);
575 if (row < 0 || row >= datasheet_get_n_rows (store->datasheet))
578 width = var_get_width (var);
579 value_init (&v, width);
580 datasheet_get_value (store->datasheet, row, var_get_case_index (var), &v);
585 const char *label = var_lookup_value_label (var, &v);
587 string = g_strdup (label);
590 string = value_to_text (v, var);
592 value_destroy (&v, width);
598 /* Attempts to update that part of the variable store which corresponds to VAR
599 within ROW with the value TEXT.
601 If USE_VALUE_LABEL is true, and TEXT is a value label for the column's
602 variable, then stores the value from that value label instead of the literal
605 Returns true if anything was updated, false otherwise. */
607 psppire_data_store_set_string (PsppireDataStore *store,
609 glong row, const struct variable *var,
610 gboolean use_value_label)
616 n_cases = psppire_data_store_get_case_count (store);
620 psppire_data_store_insert_new_case (store, row);
622 case_index = var_get_case_index (var);
625 const struct val_labs *vls = var_get_value_labels (var);
626 const union value *value = vls ? val_labs_find_value (vls, text) : NULL;
628 ok = datasheet_put_value (store->datasheet, row, case_index, value);
633 ok = psppire_data_store_data_in (store, row, case_index, ss_cstr (text),
634 var_get_print_format (var));
637 g_signal_emit (store, signals [CASE_CHANGED], 0, row);
644 psppire_data_store_clear (PsppireDataStore *ds)
646 datasheet_destroy (ds->datasheet);
647 ds->datasheet = NULL;
649 psppire_dict_clear (ds->dict);
651 g_signal_emit (ds, signals [CASES_DELETED], 0, 0, -1);
656 /* Return a casereader made from this datastore */
658 psppire_data_store_get_reader (PsppireDataStore *ds)
661 struct casereader *reader ;
664 for (i = 0 ; i < n_dict_signals; ++i )
666 g_signal_handler_block (ds->dict,
667 ds->dict_handler_id[i]);
670 reader = datasheet_make_reader (ds->datasheet);
672 /* We must not reference this again */
673 ds->datasheet = NULL;
680 /* Column related funcs */
683 static const gchar null_var_name[]=N_("var");
689 /* Returns the CASENUMth case, or a null pointer on failure.
692 psppire_data_store_get_case (const PsppireDataStore *ds,
695 g_return_val_if_fail (ds, FALSE);
696 g_return_val_if_fail (ds->datasheet, FALSE);
698 return datasheet_get_row (ds->datasheet, casenum);
703 psppire_data_store_delete_cases (PsppireDataStore *ds, casenumber first,
706 g_return_val_if_fail (ds, FALSE);
707 g_return_val_if_fail (ds->datasheet, FALSE);
709 g_return_val_if_fail (first + n_cases <=
710 psppire_data_store_get_case_count (ds), FALSE);
713 datasheet_delete_rows (ds->datasheet, first, n_cases);
715 g_signal_emit (ds, signals [CASES_DELETED], 0, first, n_cases);
722 /* Insert case CC into the case file before POSN */
724 psppire_data_store_insert_case (PsppireDataStore *ds,
730 g_return_val_if_fail (ds, FALSE);
731 g_return_val_if_fail (ds->datasheet, FALSE);
734 result = datasheet_insert_rows (ds->datasheet, posn, &cc, 1);
737 g_signal_emit (ds, signals [CASE_INSERTED], 0, posn);
739 g_warning ("Cannot insert case at position %ld\n", posn);
745 /* Set the value of VAR in case CASENUM to V.
746 V must be the correct width for IDX.
747 Returns true if successful, false on I/O error. */
749 psppire_data_store_set_value (PsppireDataStore *ds, casenumber casenum,
750 const struct variable *var, const union value *v)
755 g_return_val_if_fail (ds, FALSE);
756 g_return_val_if_fail (ds->datasheet, FALSE);
758 n_cases = psppire_data_store_get_case_count (ds);
759 if ( casenum > n_cases)
762 if (casenum == n_cases)
763 psppire_data_store_insert_new_case (ds, casenum);
765 ok = datasheet_put_value (ds->datasheet, casenum, var_get_case_index (var),
768 g_signal_emit (ds, signals [CASE_CHANGED], 0, casenum);
776 /* Set the IDXth value of case C using D_IN */
778 psppire_data_store_data_in (PsppireDataStore *ds, casenumber casenum, gint idx,
779 struct substring input, const struct fmt_spec *fmt)
787 g_return_val_if_fail (ds, FALSE);
788 g_return_val_if_fail (ds->datasheet, FALSE);
790 g_return_val_if_fail (idx < datasheet_get_n_columns (ds->datasheet), FALSE);
794 width = fmt_var_width (fmt);
795 g_return_val_if_fail (caseproto_get_width (
796 datasheet_get_proto (ds->datasheet), idx) == width,
798 value_init (&value, width);
799 ok = (datasheet_get_value (ds->datasheet, casenum, idx, &value)
800 && data_in_msg (input, UTF8, fmt->type, &value, width,
801 dict_get_encoding (dict->dict))
802 && datasheet_put_value (ds->datasheet, casenum, idx, &value));
803 value_destroy (&value, width);
808 /* Resize the cases in the casefile, by inserting a value of the
809 given WIDTH into every one of them at the position immediately
813 psppire_data_store_insert_value (PsppireDataStore *ds,
814 gint width, gint where)
818 g_return_val_if_fail (ds, FALSE);
820 g_assert (width >= 0);
822 if ( ! ds->datasheet )
823 ds->datasheet = datasheet_create (NULL);
825 value_init (&value, width);
826 value_set_missing (&value, width);
828 datasheet_insert_column (ds->datasheet, &value, width, where);
829 value_destroy (&value, width);
835 psppire_data_store_filtered (PsppireDataStore *ds,
840 const struct dictionary *dict;
841 const struct variable *filter;
843 if ( row < 0 || row >= datasheet_get_n_rows (ds->datasheet))
846 dict = ds->dict->dict;
847 g_return_val_if_fail (dict, FALSE);
848 filter = dict_get_filter (dict);
852 g_return_val_if_fail (var_is_numeric (filter), FALSE);
853 value_init (&val, 0);
854 if ( ! datasheet_get_value (ds->datasheet, row,
855 var_get_case_index (filter),
859 return (val.f == 0.0);