/* * COMMAND: <gda_report_section> * * Creates copies of its contents, one copy per row in the new run context's * data model. * * uses node's contents: yes * requested attributes: none * * REM: either "query_name" or a <gda_report_query> sub node must be provided to create a data model. */ static gboolean command_gda_report_iter_run (GdaReportEngine *engine, xmlNodePtr node, GSList **created_nodes, RunContext *context, GError **error) { if (!context || !context->iter) return TRUE; gda_data_model_iter_move_next (context->iter); while (gda_data_model_iter_is_valid (context->iter)) { xmlNodePtr dup, child; dup = xmlCopyNode (node, 1); if (!real_run_at_node (engine, dup->children, context, error)) { xmlFreeNode (dup); return FALSE; } else { for (child = dup->children; child; child = dup->children) { xmlUnlinkNode (child); *created_nodes = g_slist_prepend (*created_nodes, child); } } xmlFreeNode (dup); gda_data_model_iter_move_next (context->iter); } *created_nodes = g_slist_reverse (*created_nodes); return TRUE; }
gboolean wmud_db_load_exits(GSList **exits, GError **err) { GdaStatement *sth = NULL; GdaDataModel *res = NULL; GdaDataModelIter *iter; g_log(G_LOG_DOMAIN, G_LOG_LEVEL_DEBUG, "Loading exits"); if (dbh == NULL) { if (err) { g_set_error(err, WMUD_DB_ERROR, WMUD_DB_ERROR_NOINIT, "Database backend not initialized"); } return FALSE; } sth = gda_sql_parser_parse_string( parser, "SELECT room_id, direction, other_side FROM room_exits", NULL, NULL); res = gda_connection_statement_execute_select(dbh, sth, NULL, NULL); iter = gda_data_model_create_iter(res); gda_data_model_iter_move_next(iter); while (gda_data_model_iter_is_valid(iter)) { const GValue *val; wmudExit *room_exit; room_exit = g_new0(wmudExit, 1); val = gda_data_model_iter_get_value_at(iter, 0); room_exit->source_room_id = g_value_get_int(val); val = gda_data_model_iter_get_value_at(iter, 1); room_exit->direction_id = g_value_get_int(val); val = gda_data_model_iter_get_value_at(iter, 2); room_exit->destination_room_id = g_value_get_int(val); g_log(G_LOG_DOMAIN, G_LOG_LEVEL_DEBUG, "Loaded exit %d =%d=> %d", room_exit->source_room_id, room_exit->direction_id, room_exit->destination_room_id); *exits = g_slist_prepend(*exits, room_exit); gda_data_model_iter_move_next(iter); } g_object_unref(iter); g_object_unref(sth); return TRUE; }
gboolean wmud_db_load_planet_planes(GSList **planet_planes, GError **err) { GdaStatement *sth = NULL; GdaDataModel *res = NULL; GdaDataModelIter *iter; g_log(G_LOG_DOMAIN, G_LOG_LEVEL_DEBUG, "Loading planet<->plane associations"); if (dbh == NULL) { if (err) { g_set_error(err, WMUD_DB_ERROR, WMUD_DB_ERROR_NOINIT, "Database backend not initialized"); } return FALSE; } sth = gda_sql_parser_parse_string( parser, "SELECT planet_id, plane_id FROM planet_planes", NULL, NULL); res = gda_connection_statement_execute_select(dbh, sth, NULL, NULL); iter = gda_data_model_create_iter(res); gda_data_model_iter_move_next(iter); while (gda_data_model_iter_is_valid(iter)) { const GValue *val; wmudPlanetPlaneAssoc *planet_plane; planet_plane = g_new0(wmudPlanetPlaneAssoc, 1); val = gda_data_model_iter_get_value_at(iter, 0); planet_plane->planet_id = g_value_get_int(val); val = gda_data_model_iter_get_value_at(iter, 1); planet_plane->plane_id = g_value_get_int(val); g_log(G_LOG_DOMAIN, G_LOG_LEVEL_DEBUG, "Loaded planet-plane association %d <> %d", planet_plane->planet_id, planet_plane->plane_id); *planet_planes = g_slist_prepend(*planet_planes, planet_plane); gda_data_model_iter_move_next(iter); } g_object_unref(iter); g_object_unref(sth); return TRUE; }
gboolean wmud_db_load_areas(GSList **areas, GError **err) { GdaStatement *sth = NULL; GdaDataModel *res = NULL; GdaDataModelIter *iter; g_log(G_LOG_DOMAIN, G_LOG_LEVEL_DEBUG, "Loading areas"); if (dbh == NULL) { if (err) { g_set_error(err, WMUD_DB_ERROR, WMUD_DB_ERROR_NOINIT, "Database backend not initialized"); } return FALSE; } sth = gda_sql_parser_parse_string( parser, "SELECT id, name FROM areas", NULL, NULL); res = gda_connection_statement_execute_select(dbh, sth, NULL, NULL); iter = gda_data_model_create_iter(res); gda_data_model_iter_move_next(iter); while (gda_data_model_iter_is_valid(iter)) { const GValue *val; wmudArea *area; area = g_new0(wmudArea, 1); val = gda_data_model_iter_get_value_at(iter, 0); area->id = g_value_get_int(val); val = gda_data_model_iter_get_value_at(iter, 1); area->name = g_strdup(g_value_get_string(val)); g_log(G_LOG_DOMAIN, G_LOG_LEVEL_DEBUG, "Loaded area _%s_", area->name); *areas = g_slist_prepend(*areas, area); gda_data_model_iter_move_next(iter); } g_object_unref(iter); g_object_unref(sth); return TRUE; }
static void iter_row_changed_cb (GdaDataModelIter *iter, gint row, GdaDataAccessWrapper *model) { g_assert (model->priv->rows); /*g_print ("%s(%d)\n", __FUNCTION__, row);*/ if (gda_data_model_iter_is_valid (iter)) { model->priv->iter_row = row; if (model->priv->last_row < row) model->priv->last_row = row; if (! (model->priv->model_access_flags & GDA_DATA_MODEL_ACCESS_CURSOR_BACKWARD) || ! (model->priv->model_access_flags & GDA_DATA_MODEL_ACCESS_CURSOR_FORWARD)) { /* keep the changes in rows */ GdaRow *gda_row; gint tmp; tmp = row; gda_row = g_hash_table_lookup (model->priv->rows, &tmp); if (!gda_row) create_new_row (model); } } }
/** * wmud_db_load_players: * @err: a GError to put error messages in it * * Loads all player records from the database */ gboolean wmud_db_load_players(GError **err) { GdaStatement *sth = NULL; GdaDataModel *res; GdaDataModelIter *iter; GError *local_err = NULL; g_log(G_LOG_DOMAIN, G_LOG_LEVEL_DEBUG, "Loading players"); if (dbh == NULL) { if (err) { g_set_error(err, WMUD_DB_ERROR, WMUD_DB_ERROR_NOINIT, "Database backend not initialized"); } return FALSE; } sth = gda_sql_parser_parse_string( parser, "SELECT id, login, password, email FROM players", NULL, NULL); /* TODO: error checking! */ if ((res = gda_connection_statement_execute_select( dbh, sth, NULL, &local_err)) == NULL) { g_log(G_LOG_DOMAIN, G_LOG_LEVEL_CRITICAL, "Unable to load players: %s", local_err->message); g_set_error(err, WMUD_DB_ERROR, WMUD_DB_ERROR_SELECT_ERROR, "SELECT error: %s", local_err->message); return FALSE; } iter = gda_data_model_create_iter(res); gda_data_model_iter_move_next(iter); while (gda_data_model_iter_is_valid(iter)) { const GValue *val; WmudPlayer *player; player = wmud_player_new(); val = gda_data_model_iter_get_value_at(iter, 0); wmud_player_set_id(player, g_value_get_int(val)); val = gda_data_model_iter_get_value_at(iter, 1); wmud_player_set_player_name(player, g_value_get_string(val)); val = gda_data_model_iter_get_value_at(iter, 2); wmud_player_set_cpassword(player, g_value_get_string(val)); val = gda_data_model_iter_get_value_at(iter, 3); wmud_player_set_email(player, g_value_get_string(val)); g_log(G_LOG_DOMAIN, G_LOG_LEVEL_DEBUG, "Loaded player _%s_", wmud_player_get_player_name(player)); players = g_slist_prepend(players, player); gda_data_model_iter_move_next(iter); } g_object_unref(iter); g_object_unref(sth); g_log(G_LOG_DOMAIN, G_LOG_LEVEL_DEBUG, "Finished loading players"); return TRUE; }
gboolean wmud_db_load_menu(GSList **menu_items, GError **err) { GdaStatement *sth = NULL; GdaDataModel *res = NULL; GdaDataModelIter *iter; g_log(G_LOG_DOMAIN, G_LOG_LEVEL_DEBUG, "Loading menu items"); if (dbh == NULL) { if (err) { g_set_error(err, WMUD_DB_ERROR, WMUD_DB_ERROR_NOINIT, "Database backend not initialized"); } return FALSE; } sth = gda_sql_parser_parse_string( parser, "SELECT id, menuchar, need_active_char, placement, display_text, fnctn FROM menu ORDER BY placement", NULL, NULL); res = gda_connection_statement_execute_select(dbh, sth, NULL, NULL); iter = gda_data_model_create_iter(res); gda_data_model_iter_move_next(iter); while (gda_data_model_iter_is_valid(iter)) { const GValue *val; wmudMenu *menu_item; menu_item = g_new0(wmudMenu, 1); val = gda_data_model_iter_get_value_at(iter, 0); menu_item->id = g_value_get_int(val); val = gda_data_model_iter_get_value_at(iter, 1); menu_item->menuchar = *(g_value_get_string(val)); val = gda_data_model_iter_get_value_at(iter, 2); menu_item->need_active_char = g_value_get_boolean(val); val = gda_data_model_iter_get_value_at(iter, 3); menu_item->placement = g_value_get_int(val); val = gda_data_model_iter_get_value_at(iter, 4); menu_item->text = g_strdup(g_value_get_string(val)); val = gda_data_model_iter_get_value_at(iter, 5); menu_item->func = g_strdup(g_value_get_string(val)); g_log(G_LOG_DOMAIN, G_LOG_LEVEL_DEBUG, "Loaded menu item %d: %s(%c)", menu_item->id, menu_item->text, menu_item->menuchar); *menu_items = g_slist_prepend(*menu_items, menu_item); gda_data_model_iter_move_next(iter); } g_object_unref(iter); g_object_unref(sth); return TRUE; }
gboolean wmud_db_load_rooms(GSList **rooms, GError **err) { GdaStatement *sth = NULL; GdaDataModel *res = NULL; GdaDataModelIter *iter; g_log(G_LOG_DOMAIN, G_LOG_LEVEL_DEBUG, "Loading rooms"); if (dbh == NULL) { if (err) { g_set_error(err, WMUD_DB_ERROR, WMUD_DB_ERROR_NOINIT, "Database backend not initialized"); } return FALSE; } sth = gda_sql_parser_parse_string( parser, "SELECT id, area, name, distant_description, close_description FROM rooms", NULL, NULL); res = gda_connection_statement_execute_select(dbh, sth, NULL, NULL); iter = gda_data_model_create_iter(res); gda_data_model_iter_move_next(iter); while (gda_data_model_iter_is_valid(iter)) { const GValue *val; wmudRoom *room; room = g_new0(wmudRoom, 1); val = gda_data_model_iter_get_value_at(iter, 0); room->id = g_value_get_int(val); val = gda_data_model_iter_get_value_at(iter, 1); room->area_id = g_value_get_int(val); val = gda_data_model_iter_get_value_at(iter, 2); room->name = g_strdup(g_value_get_string(val)); val = gda_data_model_iter_get_value_at(iter, 3); room->distant_description = g_strdup(g_value_get_string(val)); val = gda_data_model_iter_get_value_at(iter, 4); room->close_description = g_strdup(g_value_get_string(val)); g_log(G_LOG_DOMAIN, G_LOG_LEVEL_DEBUG, "Loaded room %d/_%s_", room->area_id, room->name); *rooms = g_slist_prepend(*rooms, room); gda_data_model_iter_move_next(iter); } g_object_unref(iter); g_object_unref(sth); return TRUE; }
gboolean wmud_db_load_directions(GSList **directions, GError **err) { GdaStatement *sth = NULL; GdaDataModel *res = NULL; GdaDataModelIter *iter; GError *local_err = NULL; g_log(G_LOG_DOMAIN, G_LOG_LEVEL_DEBUG, "Loading directions"); if (dbh == NULL) { if (err) { g_set_error(err, WMUD_DB_ERROR, WMUD_DB_ERROR_NOINIT, "Database backend not initialized"); } return FALSE; } sth = gda_sql_parser_parse_string( parser, "SELECT id, short_name, name FROM directions", NULL, NULL); if ((res = gda_connection_statement_execute_select( dbh, sth, NULL, &local_err)) == NULL) { g_set_error(err, WMUD_DB_ERROR, WMUD_DB_ERROR_SELECT_ERROR, "Unable to load directions: %s", local_err->message); return FALSE; } iter = gda_data_model_create_iter(res); gda_data_model_iter_move_next(iter); while (gda_data_model_iter_is_valid(iter)) { const GValue *val; wmudDirection *dir; dir = g_new0(wmudDirection, 1); val = gda_data_model_iter_get_value_at(iter, 0); dir->id = g_value_get_int(val); val = gda_data_model_iter_get_value_at(iter, 1); dir->short_name = g_strdup(g_value_get_string(val)); val = gda_data_model_iter_get_value_at(iter, 2); dir->name = g_strdup(g_value_get_string(val)); g_log(G_LOG_DOMAIN, G_LOG_LEVEL_DEBUG, "Loaded direction _%s_", dir->name); *directions = g_slist_prepend(*directions, dir); gda_data_model_iter_move_next(iter); } g_object_unref(iter); g_object_unref(sth); return TRUE; }