1 /* PSPPIRE - a graphical user interface for PSPP.
2 Copyright (C) 2006, 2008 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 <gtksheet/gsheetmodel.h>
29 #include <gtksheet/gsheet-row-iface.h>
31 #include <pango/pango-context.h>
33 #include "psppire-data-store.h"
34 #include "psppire-case-file.h"
37 #include <data/dictionary.h>
38 #include <data/missing-values.h>
39 #include <data/value-labels.h>
40 #include <data/data-in.h>
41 #include <data/format.h>
44 static void psppire_data_store_init (PsppireDataStore *data_store);
45 static void psppire_data_store_class_init (PsppireDataStoreClass *class);
46 static void psppire_data_store_sheet_model_init (GSheetModelIface *iface);
47 static void psppire_data_store_sheet_row_init (GSheetRowIface *iface);
49 static void psppire_data_store_finalize (GObject *object);
50 static void psppire_data_store_dispose (GObject *object);
52 static gboolean psppire_data_store_clear_datum (GSheetModel *model,
53 glong row, glong column);
56 #define MIN_COLUMNS 10
57 #define TRAILING_ROWS 10
59 static GObjectClass *parent_class = NULL;
65 static guint signals [n_SIGNALS];
69 psppire_data_store_get_type (void)
71 static GType data_store_type = 0;
75 static const GTypeInfo data_store_info =
77 sizeof (PsppireDataStoreClass),
79 NULL, /* base_finalize */
80 (GClassInitFunc) psppire_data_store_class_init,
81 NULL, /* class_finalize */
82 NULL, /* class_data */
83 sizeof (PsppireDataStore),
85 (GInstanceInitFunc) psppire_data_store_init,
88 static const GInterfaceInfo sheet_model_info =
90 (GInterfaceInitFunc) psppire_data_store_sheet_model_init,
95 static const GInterfaceInfo sheet_row_info =
97 (GInterfaceInitFunc) psppire_data_store_sheet_row_init,
103 data_store_type = g_type_register_static (G_TYPE_OBJECT, "PsppireDataStore",
104 &data_store_info, 0);
106 g_type_add_interface_static (data_store_type,
110 g_type_add_interface_static (data_store_type,
115 return data_store_type;
120 psppire_data_store_class_init (PsppireDataStoreClass *class)
122 GObjectClass *object_class;
124 parent_class = g_type_class_peek_parent (class);
125 object_class = (GObjectClass*) class;
127 object_class->finalize = psppire_data_store_finalize;
128 object_class->dispose = psppire_data_store_dispose;
130 signals [FONT_CHANGED] =
131 g_signal_new ("font_changed",
132 G_TYPE_FROM_CLASS (class),
136 g_cclosure_marshal_VOID__VOID,
144 psppire_data_store_get_var_count (const GSheetModel *model)
146 const PsppireDataStore *store = PSPPIRE_DATA_STORE (model);
148 return psppire_dict_get_var_cnt (store->dict);
152 psppire_data_store_get_case_count (const PsppireDataStore *store)
154 return psppire_case_file_get_case_count (store->case_file);
158 psppire_data_store_get_value_count (const PsppireDataStore *store)
160 return psppire_dict_get_value_cnt (store->dict);
164 psppire_data_store_get_case_count_wrapper (const GSheetModel *model)
166 const PsppireDataStore *store = PSPPIRE_DATA_STORE (model);
167 return psppire_data_store_get_case_count (store);
171 psppire_data_store_init (PsppireDataStore *data_store)
173 data_store->dict = 0;
174 data_store->case_file = NULL;
175 data_store->width_of_m = 10;
176 data_store->dispose_has_run = FALSE;
179 const PangoFontDescription *
180 psppire_data_store_get_font_desc (const GSheetModel *model,
181 glong row, glong column)
183 PsppireDataStore *store = PSPPIRE_DATA_STORE (model);
185 return store->font_desc;
188 static inline gchar *
189 psppire_data_store_get_string_wrapper (const GSheetModel *model, glong row,
192 return psppire_data_store_get_string (PSPPIRE_DATA_STORE (model), row, column);
196 static inline gboolean
197 psppire_data_store_set_string_wrapper (GSheetModel *model,
199 glong row, glong column)
201 return psppire_data_store_set_string (PSPPIRE_DATA_STORE (model), text,
207 static gchar * get_column_subtitle (const GSheetModel *model, gint col);
208 static gchar * get_column_button_label (const GSheetModel *model, gint col);
209 static gboolean get_column_sensitivity (const GSheetModel *model, gint col);
210 static GtkJustification get_column_justification (const GSheetModel *model, gint col);
214 psppire_data_store_sheet_model_init (GSheetModelIface *iface)
216 iface->free_strings = TRUE;
217 iface->get_string = psppire_data_store_get_string_wrapper;
218 iface->set_string = psppire_data_store_set_string_wrapper;
219 iface->clear_datum = psppire_data_store_clear_datum;
220 iface->is_editable = NULL;
221 iface->is_visible = NULL;
222 iface->get_foreground = NULL;
223 iface->get_background = NULL;
224 iface->get_font_desc = psppire_data_store_get_font_desc;
225 iface->get_cell_border = NULL;
226 iface->get_column_count = psppire_data_store_get_var_count;
227 iface->get_row_count = psppire_data_store_get_case_count_wrapper;
229 iface->get_column_subtitle = get_column_subtitle;
230 iface->get_column_title = get_column_button_label;
231 iface->get_column_sensitivity = get_column_sensitivity;
232 iface->get_column_justification = get_column_justification;
236 delete_cases_callback (GtkWidget *w,
237 casenumber first, casenumber n_cases, gpointer data)
239 PsppireDataStore *store ;
241 g_return_if_fail (data);
243 store = PSPPIRE_DATA_STORE (data);
245 g_assert (first >= 0);
247 g_sheet_model_rows_deleted (G_SHEET_MODEL (store), first, n_cases);
252 insert_case_callback (GtkWidget *w, casenumber casenum, gpointer data)
254 PsppireDataStore *store ;
256 g_return_if_fail (data);
258 store = PSPPIRE_DATA_STORE (data);
260 g_sheet_model_range_changed (G_SHEET_MODEL (store),
262 psppire_case_file_get_case_count (store->case_file),
265 g_sheet_model_rows_inserted (G_SHEET_MODEL (store), casenum, 1);
270 changed_case_callback (GtkWidget *w, gint casenum, gpointer data)
272 PsppireDataStore *store ;
273 g_return_if_fail (data);
275 store = PSPPIRE_DATA_STORE (data);
277 g_sheet_model_range_changed (G_SHEET_MODEL (store),
284 A callback which occurs after a variable has been deleted.
287 delete_variable_callback (GObject *obj, gint dict_index,
288 gint case_index, gint val_cnt,
291 PsppireDataStore *store = PSPPIRE_DATA_STORE (data);
294 g_sheet_model_columns_deleted (G_SHEET_MODEL (store), dict_index, 1);
296 g_sheet_column_columns_changed (G_SHEET_COLUMN (store),
303 variable_changed_callback (GObject *obj, gint var_num, gpointer data)
305 PsppireDataStore *store = PSPPIRE_DATA_STORE (data);
308 g_sheet_column_columns_changed (G_SHEET_COLUMN (store),
312 g_sheet_model_range_changed (G_SHEET_MODEL (store),
319 insert_variable_callback (GObject *obj, gint var_num, gpointer data)
321 PsppireDataStore *store;
324 g_return_if_fail (data);
326 store = PSPPIRE_DATA_STORE (data);
330 struct variable *variable =
331 psppire_dict_get_variable (store->dict, var_num);
333 g_assert (variable != NULL);
335 posn = var_get_case_index (variable);
342 psppire_case_file_insert_values (store->case_file, 1, posn);
345 g_sheet_column_columns_changed (G_SHEET_COLUMN (store),
349 g_sheet_model_columns_inserted (G_SHEET_MODEL (store), var_num, 1);
354 dict_size_change_callback (GObject *obj,
355 gint posn, gint adjustment, gpointer data)
357 PsppireDataStore *store = PSPPIRE_DATA_STORE (data);
359 const struct variable *v = psppire_dict_get_variable (store->dict, posn);
361 const gint new_val_width = value_cnt_from_width (var_get_width (v));
363 if ( adjustment > 0 )
364 psppire_case_file_insert_values (store->case_file, adjustment,
365 new_val_width - adjustment +
366 var_get_case_index(v));
372 * psppire_data_store_new:
373 * @dict: The dictionary for this data_store.
376 * Return value: a new #PsppireDataStore
379 psppire_data_store_new (PsppireDict *dict)
381 PsppireDataStore *retval;
383 retval = g_object_new (GTK_TYPE_DATA_STORE, NULL);
385 psppire_data_store_set_dictionary (retval, dict);
392 psppire_data_store_set_case_file (PsppireDataStore *ds,
396 if ( ds->case_file) g_object_unref (ds->case_file);
401 g_sheet_model_range_changed (G_SHEET_MODEL (ds),
404 for (i = 0 ; i < n_cf_signals ; ++i )
406 if ( ds->cf_handler_id [i] > 0 )
407 g_signal_handler_disconnect (ds->case_file,
408 ds->cf_handler_id[i]);
413 for (i = 0 ; i < n_dict_signals; ++i )
415 if ( ds->dict_handler_id [i] > 0)
417 g_signal_handler_unblock (ds->dict,
418 ds->dict_handler_id[i]);
422 ds->cf_handler_id [CASES_DELETED] =
423 g_signal_connect (ds->case_file, "cases-deleted",
424 G_CALLBACK (delete_cases_callback),
427 ds->cf_handler_id [CASE_INSERTED] =
428 g_signal_connect (ds->case_file, "case-inserted",
429 G_CALLBACK (insert_case_callback),
432 ds->cf_handler_id [CASE_CHANGED] =
433 g_signal_connect (ds->case_file, "case-changed",
434 G_CALLBACK (changed_case_callback),
440 * psppire_data_store_replace_set_dictionary:
441 * @data_store: The variable store
442 * @dict: The dictionary to set
444 * If a dictionary is already associated with the data-store, then it will be
448 psppire_data_store_set_dictionary (PsppireDataStore *data_store, PsppireDict *dict)
452 /* Disconnect any existing handlers */
453 if ( data_store->dict )
454 for (i = 0 ; i < n_dict_signals; ++i )
456 g_signal_handler_disconnect (data_store->dict,
457 data_store->dict_handler_id[i]);
460 data_store->dict = dict;
465 data_store->dict_handler_id [VARIABLE_INSERTED] =
466 g_signal_connect (dict, "variable-inserted",
467 G_CALLBACK (insert_variable_callback),
470 data_store->dict_handler_id [VARIABLE_DELETED] =
471 g_signal_connect (dict, "variable-deleted",
472 G_CALLBACK (delete_variable_callback),
475 data_store->dict_handler_id [VARIABLE_CHANGED] =
476 g_signal_connect (dict, "variable-changed",
477 G_CALLBACK (variable_changed_callback),
480 data_store->dict_handler_id [SIZE_CHANGED] =
481 g_signal_connect (dict, "dict-size-changed",
482 G_CALLBACK (dict_size_change_callback),
488 /* The entire model has changed */
489 g_sheet_model_range_changed (G_SHEET_MODEL (data_store), -1, -1, -1, -1);
492 g_sheet_column_columns_changed (G_SHEET_COLUMN (data_store), 0, -1);
495 if ( data_store->dict )
496 for (i = 0 ; i < n_dict_signals; ++i )
498 if ( data_store->dict_handler_id [i] > 0)
500 g_signal_handler_block (data_store->dict,
501 data_store->dict_handler_id[i]);
507 psppire_data_store_finalize (GObject *object)
511 (* parent_class->finalize) (object);
516 psppire_data_store_dispose (GObject *object)
518 PsppireDataStore *ds = PSPPIRE_DATA_STORE (object);
520 if (ds->dispose_has_run)
523 if (ds->case_file) g_object_unref (ds->case_file);
526 (* parent_class->dispose) (object);
528 ds->dispose_has_run = TRUE;
533 psppire_data_store_delete_cases (PsppireDataStore *ds,
534 casenumber first, casenumber count)
536 g_return_val_if_fail (ds, FALSE);
538 return psppire_case_file_delete_cases (ds->case_file, count, first);
543 /* Insert a blank case before POSN */
545 psppire_data_store_insert_new_case (PsppireDataStore *ds, casenumber posn)
550 g_return_val_if_fail (ds, FALSE);
552 val_cnt = datasheet_get_column_cnt (ds->case_file->datasheet) ;
554 g_return_val_if_fail (val_cnt > 0, FALSE);
556 g_return_val_if_fail (posn <= psppire_data_store_get_case_count (ds), FALSE);
558 case_create (&cc, val_cnt);
560 memset ( case_data_rw_idx (&cc, 0), 0, val_cnt * MAX_SHORT_STRING);
562 for (v = 0 ; v < psppire_dict_get_var_cnt (ds->dict) ; ++v)
564 const struct variable *pv = psppire_dict_get_variable (ds->dict, v);
565 if ( var_is_alpha (pv))
568 case_data_rw (&cc, pv)->f = SYSMIS;
571 result = psppire_case_file_insert_case (ds->case_file, &cc, posn);
580 psppire_data_store_get_string (PsppireDataStore *store, glong row, glong column)
584 const struct fmt_spec *fp ;
585 const struct variable *pv ;
589 g_return_val_if_fail (store->dict, NULL);
590 g_return_val_if_fail (store->case_file, NULL);
592 if (column >= psppire_dict_get_var_cnt (store->dict))
595 if ( row >= psppire_case_file_get_case_count (store->case_file))
598 pv = psppire_dict_get_variable (store->dict, column);
602 idx = var_get_case_index (pv);
606 v = psppire_case_file_get_value (store->case_file, row, idx, NULL,
609 g_return_val_if_fail (v, NULL);
611 if ( store->show_labels)
613 const gchar *label = var_lookup_value_label (pv, v);
617 return pspp_locale_to_utf8 (label, -1, 0);
621 fp = var_get_write_format (pv);
623 s = g_string_sized_new (fp->w + 1);
624 g_string_set_size (s, fp->w);
626 memset (s->str, 0, fp->w);
628 g_assert (fp->w == s->len);
630 /* Converts binary value V into printable form in the exactly
631 FP->W character in buffer S according to format specification
632 FP. No null terminator is appended to the buffer. */
633 data_out (v, fp, s->str);
635 text = pspp_locale_to_utf8 (s->str, fp->w, 0);
636 g_string_free (s, TRUE);
646 psppire_data_store_clear_datum (GSheetModel *model,
647 glong row, glong col)
649 PsppireDataStore *store = PSPPIRE_DATA_STORE (model);
652 const struct variable *pv = psppire_dict_get_variable (store->dict, col);
654 const gint index = var_get_case_index (pv) ;
656 if ( var_is_numeric (pv))
659 memcpy (v.s, "", MAX_SHORT_STRING);
661 psppire_case_file_set_value (store->case_file, row, index, &v,
668 /* Attempts to update that part of the variable store which corresponds
669 to ROW, COL with the value TEXT.
670 Returns true if anything was updated, false otherwise.
673 psppire_data_store_set_string (PsppireDataStore *store,
674 const gchar *text, glong row, glong col)
677 const struct variable *pv = psppire_dict_get_variable (store->dict, col);
678 g_return_val_if_fail (pv, FALSE);
680 n_cases = psppire_data_store_get_case_count (store);
686 psppire_data_store_insert_new_case (store, row);
688 psppire_case_file_data_in (store->case_file, row,
689 var_get_case_index (pv), ss_cstr (text),
690 var_get_write_format (pv));
697 psppire_data_store_set_font (PsppireDataStore *store,
698 const PangoFontDescription *fd)
700 g_return_if_fail (store);
701 g_return_if_fail (PSPPIRE_IS_DATA_STORE (store));
703 store->font_desc = fd;
705 store->width_of_m = calc_m_width (fd);
707 g_signal_emit (store, signals [FONT_CHANGED], 0);
710 g_sheet_model_range_changed (G_SHEET_MODEL (store),
716 psppire_data_store_show_labels (PsppireDataStore *store, gboolean show_labels)
718 g_return_if_fail (store);
719 g_return_if_fail (PSPPIRE_IS_DATA_STORE (store));
721 store->show_labels = show_labels;
723 g_sheet_model_range_changed (G_SHEET_MODEL (store),
729 psppire_data_store_clear (PsppireDataStore *data_store)
731 psppire_case_file_clear (data_store->case_file);
733 psppire_dict_clear (data_store->dict);
738 /* Return a casereader made from this datastore */
740 psppire_data_store_get_reader (PsppireDataStore *ds)
743 struct casereader *reader ;
745 for (i = 0 ; i < n_cf_signals ; ++i )
747 g_signal_handler_disconnect (ds->case_file, ds->cf_handler_id[i]);
748 ds->cf_handler_id[i] = 0 ;
752 for (i = 0 ; i < n_dict_signals; ++i )
754 g_signal_handler_block (ds->dict,
755 ds->dict_handler_id[i]);
758 reader = psppire_case_file_make_reader (ds->case_file);
765 /* Column related funcs */
769 geometry_get_column_count (const GSheetColumn *geom)
771 PsppireDataStore *ds = PSPPIRE_DATA_STORE (geom);
773 return MAX (MIN_COLUMNS, psppire_dict_get_var_cnt (ds->dict));
779 geometry_get_width (const GSheetColumn *geom, glong unit)
781 const struct variable *pv ;
782 PsppireDataStore *ds = PSPPIRE_DATA_STORE (geom);
784 if ( unit >= psppire_dict_get_var_cnt (ds->dict) )
785 return ds->width_of_m * 8 ;
787 pv = psppire_dict_get_variable (ds->dict, unit);
790 return ds->width_of_m * 8 ;
792 return ds->width_of_m * var_get_display_width (pv);
796 geometry_set_width (GSheetColumn *geom, glong unit, gint width)
798 PsppireDataStore *ds = PSPPIRE_DATA_STORE (geom);
800 struct variable *v = psppire_dict_get_variable (ds->dict, unit);
802 g_return_if_fail (v);
804 var_set_display_width (v, width / ds->width_of_m );
810 static const gchar null_var_name[]=N_("var");
813 /* Row related funcs */
816 geometry_get_row_count (const GSheetRow *geom)
818 PsppireDataStore *ds = PSPPIRE_DATA_STORE (geom);
820 return TRAILING_ROWS + psppire_case_file_get_case_count (ds->case_file);
823 #define ROW_HEIGHT 25
826 geometry_get_height (const GSheetRow *geom, glong unit)
832 geometry_get_top_ypixel (const GSheetRow *geo, glong row)
834 return row * ROW_HEIGHT;
838 geometry_pixel_to_row (const GSheetRow *geo, guint pixel)
840 glong row = pixel / ROW_HEIGHT;
842 if (row >= geometry_get_row_count (geo))
843 row = geometry_get_row_count (geo) - 1;
850 geometry_get_row_sensitivity (const GSheetRow *geom, glong unit)
852 PsppireDataStore *ds = PSPPIRE_DATA_STORE (geom);
855 return (unit < psppire_case_file_get_case_count (ds->case_file));
859 geometry_get_row_button_label (const GSheetRow *geom, glong unit)
863 PsppireDataStore *ds = PSPPIRE_DATA_STORE (geom);
866 TRAILING_ROWS + psppire_case_file_get_case_count (ds->case_file))
869 s = g_strdup_printf (_("%ld"), unit + FIRST_CASE_NUMBER);
871 text = pspp_locale_to_utf8 (s, -1, 0);
879 psppire_data_store_sheet_row_init (GSheetRowIface *iface)
881 iface->get_row_count = geometry_get_row_count;
883 iface->get_height = geometry_get_height;
884 iface->set_height = 0;
885 iface->get_sensitivity = geometry_get_row_sensitivity;
886 iface->top_ypixel = geometry_get_top_ypixel;
887 iface->pixel_to_row = geometry_pixel_to_row;
888 iface->get_button_label = geometry_get_row_button_label;
894 /* Column related stuff */
897 get_column_subtitle (const GSheetModel *model, gint col)
900 const struct variable *v ;
901 PsppireDataStore *ds = PSPPIRE_DATA_STORE (model);
903 if ( col >= psppire_dict_get_var_cnt (ds->dict) )
906 v = psppire_dict_get_variable (ds->dict, col);
908 if ( ! var_has_label (v))
911 text = pspp_locale_to_utf8 (var_get_label (v), -1, 0);
917 get_column_button_label (const GSheetModel *model, gint col)
920 struct variable *pv ;
921 PsppireDataStore *ds = PSPPIRE_DATA_STORE (model);
923 if ( col >= psppire_dict_get_var_cnt (ds->dict) )
924 return g_locale_to_utf8 (null_var_name, -1, 0, 0, 0);
926 pv = psppire_dict_get_variable (ds->dict, col);
928 text = pspp_locale_to_utf8 (var_get_name (pv), -1, 0);
934 get_column_sensitivity (const GSheetModel *model, gint col)
936 PsppireDataStore *ds = PSPPIRE_DATA_STORE (model);
938 return (col < psppire_dict_get_var_cnt (ds->dict));
943 static GtkJustification
944 get_column_justification (const GSheetModel *model, gint col)
946 PsppireDataStore *ds = PSPPIRE_DATA_STORE (model);
947 const struct variable *pv ;
949 if ( col >= psppire_dict_get_var_cnt (ds->dict) )
950 return GTK_JUSTIFY_LEFT;
952 pv = psppire_dict_get_variable (ds->dict, col);
954 return (var_get_alignment (pv) == ALIGN_LEFT ? GTK_JUSTIFY_LEFT
955 : var_get_alignment (pv) == ALIGN_RIGHT ? GTK_JUSTIFY_RIGHT
956 : GTK_JUSTIFY_CENTER);