1 /* PSPPIRE - a graphical user interface for PSPP.
2 Copyright (C) 2006 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/gtksheet.h>
29 #include <gtksheet/gsheetmodel.h>
30 #include <gtksheet/gsheet-column-iface.h>
32 #include <pango/pango-context.h>
34 #include "psppire-data-store.h"
35 #include "psppire-case-file.h"
38 #include <data/dictionary.h>
39 #include <data/missing-values.h>
40 #include <data/value-labels.h>
41 #include <data/data-in.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_column_init (GSheetColumnIface *iface);
48 static void psppire_data_store_sheet_row_init (GSheetRowIface *iface);
50 static void psppire_data_store_finalize (GObject *object);
52 static gboolean psppire_data_store_clear_datum (GSheetModel *model,
53 glong row, glong column);
56 #define MIN_COLUMNS 10
58 #define TRAILING_ROWS 10
60 static GObjectClass *parent_class = NULL;
66 static guint signals [n_SIGNALS];
70 psppire_data_store_get_type (void)
72 static GType data_store_type = 0;
76 static const GTypeInfo data_store_info =
78 sizeof (PsppireDataStoreClass),
80 NULL, /* base_finalize */
81 (GClassInitFunc) psppire_data_store_class_init,
82 NULL, /* class_finalize */
83 NULL, /* class_data */
84 sizeof (PsppireDataStore),
86 (GInstanceInitFunc) psppire_data_store_init,
89 static const GInterfaceInfo sheet_model_info =
91 (GInterfaceInitFunc) psppire_data_store_sheet_model_init,
96 static const GInterfaceInfo sheet_column_info =
98 (GInterfaceInitFunc) psppire_data_store_sheet_column_init,
103 static const GInterfaceInfo sheet_row_info =
105 (GInterfaceInitFunc) psppire_data_store_sheet_row_init,
111 data_store_type = g_type_register_static (G_TYPE_OBJECT, "PsppireDataStore",
112 &data_store_info, 0);
114 g_type_add_interface_static (data_store_type,
118 g_type_add_interface_static (data_store_type,
122 g_type_add_interface_static (data_store_type,
127 return data_store_type;
132 psppire_data_store_class_init (PsppireDataStoreClass *class)
134 GObjectClass *object_class;
136 parent_class = g_type_class_peek_parent (class);
137 object_class = (GObjectClass*) class;
139 object_class->finalize = psppire_data_store_finalize;
141 signals [FONT_CHANGED] =
142 g_signal_new ("font_changed",
143 G_TYPE_FROM_CLASS (class),
147 g_cclosure_marshal_VOID__VOID,
155 psppire_data_store_get_var_count (const GSheetModel *model)
157 const PsppireDataStore *store = PSPPIRE_DATA_STORE (model);
159 return psppire_dict_get_var_cnt (store->dict);
163 psppire_data_store_get_case_count (const PsppireDataStore *store)
165 return psppire_case_file_get_case_count (store->case_file);
169 psppire_data_store_get_case_count_wrapper (const GSheetModel *model)
171 const PsppireDataStore *store = PSPPIRE_DATA_STORE (model);
172 return psppire_data_store_get_case_count (store);
176 psppire_data_store_init (PsppireDataStore *data_store)
178 data_store->dict = 0;
179 data_store->case_file = 0;
180 data_store->width_of_m = 10;
185 const PangoFontDescription *
186 psppire_data_store_get_font_desc (const GSheetModel *model,
187 glong row, glong column)
189 PsppireDataStore *store = PSPPIRE_DATA_STORE (model);
191 return store->font_desc;
194 static inline gchar *
195 psppire_data_store_get_string_wrapper (const GSheetModel *model, glong row,
198 return psppire_data_store_get_string (PSPPIRE_DATA_STORE (model), row, column);
202 static inline gboolean
203 psppire_data_store_set_string_wrapper (GSheetModel *model,
205 glong row, glong column)
207 return psppire_data_store_set_string (PSPPIRE_DATA_STORE (model), text,
215 psppire_data_store_sheet_model_init (GSheetModelIface *iface)
217 iface->free_strings = TRUE;
218 iface->get_string = psppire_data_store_get_string_wrapper;
219 iface->set_string = psppire_data_store_set_string_wrapper;
220 iface->clear_datum = psppire_data_store_clear_datum;
221 iface->is_editable = NULL;
222 iface->is_visible = NULL;
223 iface->get_foreground = NULL;
224 iface->get_background = NULL;
225 iface->get_font_desc = psppire_data_store_get_font_desc;
226 iface->get_cell_border = NULL;
227 iface->get_column_count = psppire_data_store_get_var_count;
228 iface->get_row_count = psppire_data_store_get_case_count_wrapper;
232 gboolean always_true ()
239 delete_cases_callback (GtkWidget *w,
240 casenumber first, casenumber n_cases, gpointer data)
242 PsppireDataStore *store ;
244 g_return_if_fail (data);
246 store = PSPPIRE_DATA_STORE (data);
248 g_assert (first >= 0);
250 g_sheet_model_rows_deleted (G_SHEET_MODEL (store), first, n_cases);
255 insert_case_callback (GtkWidget *w, casenumber casenum, gpointer data)
257 PsppireDataStore *store ;
259 g_return_if_fail (data);
261 store = PSPPIRE_DATA_STORE (data);
263 g_sheet_model_range_changed (G_SHEET_MODEL (store),
265 psppire_case_file_get_case_count (store->case_file),
268 g_sheet_model_rows_inserted (G_SHEET_MODEL (store), casenum, 1);
273 changed_case_callback (GtkWidget *w, gint casenum, gpointer data)
275 PsppireDataStore *store ;
276 g_return_if_fail (data);
278 store = PSPPIRE_DATA_STORE (data);
280 g_sheet_model_range_changed (G_SHEET_MODEL (store),
287 A callback which occurs after a variable has been deleted.
290 delete_variable_callback (GObject *obj, gint dict_index,
291 gint case_index, gint val_cnt,
294 PsppireDataStore *store = PSPPIRE_DATA_STORE (data);
296 g_sheet_model_columns_deleted (G_SHEET_MODEL (store), dict_index, 1);
298 g_sheet_column_columns_changed (G_SHEET_COLUMN (store),
304 variable_changed_callback (GObject *obj, gint var_num, gpointer data)
306 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),
318 insert_variable_callback (GObject *obj, gint var_num, gpointer data)
320 PsppireDataStore *store;
323 g_return_if_fail (data);
325 store = PSPPIRE_DATA_STORE (data);
329 struct variable *variable =
330 psppire_dict_get_variable (store->dict, var_num);
332 g_assert (variable != NULL);
334 posn = var_get_case_index (variable);
341 psppire_case_file_insert_values (store->case_file, 1, posn);
343 g_sheet_column_columns_changed (G_SHEET_COLUMN (store),
346 g_sheet_model_columns_inserted (G_SHEET_MODEL (store), var_num, 1);
351 dict_size_change_callback (GObject *obj,
352 gint posn, gint adjustment, gpointer data)
354 PsppireDataStore *store = PSPPIRE_DATA_STORE (data);
356 const struct variable *v = psppire_dict_get_variable (store->dict, posn);
358 const gint new_val_width = value_cnt_from_width (var_get_width (v));
360 if ( adjustment > 0 )
361 psppire_case_file_insert_values (store->case_file, adjustment,
362 new_val_width - adjustment +
363 var_get_case_index(v));
369 * psppire_data_store_new:
370 * @dict: The dictionary for this data_store.
373 * Return value: a new #PsppireDataStore
376 psppire_data_store_new (PsppireDict *dict)
378 PsppireDataStore *retval;
380 retval = g_object_new (GTK_TYPE_DATA_STORE, NULL);
382 psppire_data_store_set_dictionary (retval, dict);
389 psppire_data_store_set_case_file (PsppireDataStore *ds,
395 g_object_unref (ds->case_file);
400 g_sheet_model_range_changed (G_SHEET_MODEL (ds),
403 for (i = 0 ; i < n_cf_signals ; ++i )
405 if ( ds->cf_handler_id [i] > 0 )
406 g_signal_handler_disconnect (ds->case_file,
407 ds->cf_handler_id[i]);
412 for (i = 0 ; i < n_dict_signals; ++i )
414 if ( ds->dict_handler_id [i] > 0)
416 g_signal_handler_unblock (ds->dict,
417 ds->dict_handler_id[i]);
421 ds->cf_handler_id [CASES_DELETED] =
422 g_signal_connect (ds->case_file, "cases-deleted",
423 G_CALLBACK (delete_cases_callback),
426 ds->cf_handler_id [CASE_INSERTED] =
427 g_signal_connect (ds->case_file, "case-inserted",
428 G_CALLBACK (insert_case_callback),
431 ds->cf_handler_id [CASE_CHANGED] =
432 g_signal_connect (ds->case_file, "case-changed",
433 G_CALLBACK (changed_case_callback),
439 * psppire_data_store_replace_set_dictionary:
440 * @data_store: The variable store
441 * @dict: The dictionary to set
443 * If a dictionary is already associated with the data-store, then it will be
447 psppire_data_store_set_dictionary (PsppireDataStore *data_store, PsppireDict *dict)
451 /* Disconnect any existing handlers */
452 if ( data_store->dict )
453 for (i = 0 ; i < n_dict_signals; ++i )
455 g_signal_handler_disconnect (data_store->dict,
456 data_store->dict_handler_id[i]);
459 data_store->dict = dict;
464 data_store->dict_handler_id [VARIABLE_INSERTED] =
465 g_signal_connect (dict, "variable-inserted",
466 G_CALLBACK (insert_variable_callback),
469 data_store->dict_handler_id [VARIABLE_DELETED] =
470 g_signal_connect (dict, "variable-deleted",
471 G_CALLBACK (delete_variable_callback),
474 data_store->dict_handler_id [VARIABLE_CHANGED] =
475 g_signal_connect (dict, "variable-changed",
476 G_CALLBACK (variable_changed_callback),
479 data_store->dict_handler_id [SIZE_CHANGED] =
480 g_signal_connect (dict, "dict-size-changed",
481 G_CALLBACK (dict_size_change_callback),
487 /* The entire model has changed */
488 g_sheet_model_range_changed (G_SHEET_MODEL (data_store), -1, -1, -1, -1);
490 g_sheet_column_columns_changed (G_SHEET_COLUMN (data_store), 0, -1);
493 if ( data_store->dict )
494 for (i = 0 ; i < n_dict_signals; ++i )
496 if ( data_store->dict_handler_id [i] > 0)
498 g_signal_handler_block (data_store->dict,
499 data_store->dict_handler_id[i]);
505 psppire_data_store_finalize (GObject *object)
509 (* parent_class->finalize) (object);
513 psppire_data_store_delete_cases (PsppireDataStore *ds,
514 casenumber first, casenumber count)
516 g_return_val_if_fail (ds, FALSE);
518 return psppire_case_file_delete_cases (ds->case_file, count, first);
523 /* Insert a blank case before POSN */
525 psppire_data_store_insert_new_case (PsppireDataStore *ds, casenumber posn)
530 g_return_val_if_fail (ds, FALSE);
532 val_cnt = datasheet_get_column_cnt (ds->case_file->datasheet) ;
534 g_return_val_if_fail (val_cnt > 0, FALSE);
536 g_return_val_if_fail (posn <= psppire_data_store_get_case_count (ds), FALSE);
538 case_create (&cc, val_cnt);
540 memset ( case_data_rw_idx (&cc, 0), 0, val_cnt * MAX_SHORT_STRING);
542 for (v = 0 ; v < psppire_dict_get_var_cnt (ds->dict) ; ++v)
544 const struct variable *pv = psppire_dict_get_variable (ds->dict, v);
545 if ( var_is_alpha (pv))
548 case_data_rw (&cc, pv)->f = SYSMIS;
551 result = psppire_case_file_insert_case (ds->case_file, &cc, posn);
560 psppire_data_store_get_string (PsppireDataStore *store, glong row, glong column)
564 const struct fmt_spec *fp ;
565 const struct variable *pv ;
569 g_return_val_if_fail (store->dict, NULL);
570 g_return_val_if_fail (store->case_file, NULL);
572 if (column >= psppire_dict_get_var_cnt (store->dict))
575 if ( row >= psppire_case_file_get_case_count (store->case_file))
578 pv = psppire_dict_get_variable (store->dict, column);
582 idx = var_get_case_index (pv);
586 v = psppire_case_file_get_value (store->case_file, row, idx, NULL,
589 g_return_val_if_fail (v, NULL);
591 if ( store->show_labels)
593 const gchar *label = var_lookup_value_label (pv, v);
597 return pspp_locale_to_utf8 (label, -1, 0);
601 fp = var_get_write_format (pv);
603 s = g_string_sized_new (fp->w + 1);
604 g_string_set_size (s, fp->w);
606 memset (s->str, 0, fp->w);
608 g_assert (fp->w == s->len);
610 /* Converts binary value V into printable form in the exactly
611 FP->W character in buffer S according to format specification
612 FP. No null terminator is appended to the buffer. */
613 data_out (v, fp, s->str);
615 text = pspp_locale_to_utf8 (s->str, fp->w, 0);
616 g_string_free (s, TRUE);
626 psppire_data_store_clear_datum (GSheetModel *model,
627 glong row, glong col)
629 PsppireDataStore *store = PSPPIRE_DATA_STORE (model);
632 const struct variable *pv = psppire_dict_get_variable (store->dict, col);
634 const gint index = var_get_case_index (pv) ;
636 if ( var_is_numeric (pv))
639 memcpy (v.s, "", MAX_SHORT_STRING);
641 psppire_case_file_set_value (store->case_file, row, index, &v,
648 /* Attempts to update that part of the variable store which corresponds
649 to ROW, COL with the value TEXT.
650 Returns true if anything was updated, false otherwise.
653 psppire_data_store_set_string (PsppireDataStore *store,
654 const gchar *text, glong row, glong col)
656 const struct variable *pv = psppire_dict_get_variable (store->dict, col);
657 g_return_val_if_fail (pv, FALSE);
660 /* Allow the user to insert a lot of blank cases, simply by skipping rows */
661 for (r = psppire_case_file_get_case_count (store->case_file); r <= row ; ++r)
666 psppire_case_array_insert_case (store->cases, r, 0, 0);
669 for (c = 0 ; c < psppire_dict_get_var_cnt (store->dict); ++c )
670 psppire_data_store_clear_datum (model, r, c);
674 psppire_case_file_data_in (store->case_file, row,
675 var_get_case_index (pv), ss_cstr (text),
676 var_get_write_format (pv));
683 psppire_data_store_set_font (PsppireDataStore *store,
684 const PangoFontDescription *fd)
686 g_return_if_fail (store);
687 g_return_if_fail (PSPPIRE_IS_DATA_STORE (store));
689 store->font_desc = fd;
691 store->width_of_m = calc_m_width (fd);
693 g_signal_emit (store, signals [FONT_CHANGED], 0);
696 g_sheet_model_range_changed (G_SHEET_MODEL (store),
702 psppire_data_store_show_labels (PsppireDataStore *store, gboolean show_labels)
704 g_return_if_fail (store);
705 g_return_if_fail (PSPPIRE_IS_DATA_STORE (store));
707 store->show_labels = show_labels;
709 g_sheet_model_range_changed (G_SHEET_MODEL (store),
715 psppire_data_store_clear (PsppireDataStore *data_store)
717 psppire_case_file_clear (data_store->case_file);
719 psppire_dict_clear (data_store->dict);
724 /* Return a casereader made from this datastore */
726 psppire_data_store_get_reader (PsppireDataStore *ds)
729 struct casereader *reader ;
731 for (i = 0 ; i < n_cf_signals ; ++i )
733 g_signal_handler_disconnect (ds->case_file, ds->cf_handler_id[i]);
734 ds->cf_handler_id[i] = 0 ;
738 for (i = 0 ; i < n_dict_signals; ++i )
740 g_signal_handler_block (ds->dict,
741 ds->dict_handler_id[i]);
744 reader = psppire_case_file_make_reader (ds->case_file);
751 /* Column related funcs */
754 geometry_get_column_count (const GSheetColumn *geom)
756 PsppireDataStore *ds = PSPPIRE_DATA_STORE (geom);
758 return MAX (MIN_COLUMNS, psppire_dict_get_var_cnt (ds->dict));
764 geometry_get_width (const GSheetColumn *geom, glong unit)
766 const struct variable *pv ;
767 PsppireDataStore *ds = PSPPIRE_DATA_STORE (geom);
769 if ( unit >= psppire_dict_get_var_cnt (ds->dict) )
770 return ds->width_of_m * 8 ;
772 pv = psppire_dict_get_variable (ds->dict, unit);
775 return ds->width_of_m * 8 ;
777 return ds->width_of_m * var_get_display_width (pv);
781 geometry_set_width (GSheetColumn *geom, glong unit, gint width)
783 PsppireDataStore *ds = PSPPIRE_DATA_STORE (geom);
785 struct variable *pv = psppire_dict_get_variable (ds->dict, unit);
787 var_set_display_width (pv, width / ds->width_of_m );
792 static GtkJustification
793 geometry_get_justification (const GSheetColumn *geom, glong unit)
795 PsppireDataStore *ds = PSPPIRE_DATA_STORE (geom);
796 const struct variable *pv ;
799 if ( unit >= psppire_dict_get_var_cnt (ds->dict) )
800 return GTK_JUSTIFY_LEFT;
802 pv = psppire_dict_get_variable (ds->dict, unit);
804 return (var_get_alignment (pv) == ALIGN_LEFT ? GTK_JUSTIFY_LEFT
805 : var_get_alignment (pv) == ALIGN_RIGHT ? GTK_JUSTIFY_RIGHT
806 : GTK_JUSTIFY_CENTER);
810 static const gchar null_var_name[]=N_("var");
813 geometry_get_column_button_label (const GSheetColumn *geom, glong unit)
816 struct variable *pv ;
817 PsppireDataStore *ds = PSPPIRE_DATA_STORE (geom);
819 if ( unit >= psppire_dict_get_var_cnt (ds->dict) )
820 return g_locale_to_utf8 (null_var_name, -1, 0, 0, 0);
822 pv = psppire_dict_get_variable (ds->dict, unit);
824 text = pspp_locale_to_utf8 (var_get_name (pv), -1, 0);
831 geometry_get_column_subtitle (const GSheetColumn *geom, glong unit)
834 const struct variable *v ;
835 PsppireDataStore *ds = PSPPIRE_DATA_STORE (geom);
837 if ( unit >= psppire_dict_get_var_cnt (ds->dict) )
840 v = psppire_dict_get_variable (ds->dict, unit);
842 if ( ! var_has_label (v))
845 text = pspp_locale_to_utf8 (var_get_label (v), -1, 0);
852 geometry_get_sensitivity (const GSheetColumn *geom, glong unit)
854 PsppireDataStore *ds = PSPPIRE_DATA_STORE (geom);
856 return (unit < psppire_dict_get_var_cnt (ds->dict));
861 psppire_data_store_sheet_column_init (GSheetColumnIface *iface)
863 iface->get_column_count = geometry_get_column_count;
864 iface->get_width = geometry_get_width;
865 iface->set_width = geometry_set_width;
866 iface->get_visibility = always_true;
867 iface->get_sensitivity = geometry_get_sensitivity;
868 iface->get_justification = geometry_get_justification;
869 iface->get_button_label = geometry_get_column_button_label;
870 iface->get_subtitle = geometry_get_column_subtitle;
874 /* Row related funcs */
877 geometry_get_row_count (const GSheetRow *geom, gpointer data)
879 PsppireDataStore *ds = PSPPIRE_DATA_STORE (geom);
881 return TRAILING_ROWS + psppire_case_file_get_case_count (ds->case_file);
884 #define ROW_HEIGHT 25
887 geometry_get_height (const GSheetRow *geom, glong unit, gpointer data)
893 geometry_get_top_ypixel (const GSheetRow *geo, glong row, gpointer data)
895 return row * ROW_HEIGHT;
899 geometry_pixel_to_row (const GSheetRow *geo, guint pixel, gpointer data)
901 glong row = pixel / ROW_HEIGHT;
903 if (row >= geometry_get_row_count (geo, data))
904 row = geometry_get_row_count (geo, data) - 1;
911 geometry_get_row_sensitivity (const GSheetRow *geom, glong unit, gpointer data)
913 PsppireDataStore *ds = PSPPIRE_DATA_STORE (geom);
916 return (unit < psppire_case_file_get_case_count (ds->case_file));
921 geometry_get_row_button_label (const GSheetRow *geom, glong unit, gpointer data)
925 PsppireDataStore *ds = PSPPIRE_DATA_STORE (geom);
928 TRAILING_ROWS + psppire_case_file_get_case_count (ds->case_file))
931 s = g_strdup_printf (_("%ld"), unit + FIRST_CASE_NUMBER);
933 text = pspp_locale_to_utf8 (s, -1, 0);
941 psppire_data_store_sheet_row_init (GSheetRowIface *iface)
943 iface->get_row_count = geometry_get_row_count;
945 iface->get_height = geometry_get_height;
946 iface->set_height = 0;
947 iface->get_visibility = always_true;
948 iface->get_sensitivity = geometry_get_row_sensitivity;
949 iface->top_ypixel = geometry_get_top_ypixel;
950 iface->pixel_to_row = geometry_pixel_to_row;
951 iface->get_button_label = geometry_get_row_button_label;