[glom] Tests: Added a test of getting field values via the python record[] API.

[Murray Cumming <murrayc src gnome org>]

commit 59c2326b4b48db097f8a1f5eca9aadfbe02c867d
Author: Murray Cumming <murrayc murrayc com>
Date:   Fri Nov 29 12:37:27 2013 +0100

    Tests: Added a test of getting field values via the python record[] API.

 Makefile_tests.am                                  |    8 +
 ..._python_execute_func_with_record_field_types.cc |  186 ++++++++++++++++++++
 2 files changed, 194 insertions(+), 0 deletions(-)
---
diff --git a/Makefile_tests.am b/Makefile_tests.am
index 67d2f2c..fc3f767 100644
--- a/Makefile_tests.am
+++ b/Makefile_tests.am
@@ -344,6 +344,7 @@ check_PROGRAMS += \
        tests/python/test_python_execute_func_date \
        tests/python/test_python_execute_func_change_result_type \
        tests/python/test_python_execute_func_with_record \
+       tests/python/test_python_execute_func_with_record_field_types \
        tests/python/test_python_execute_script \
        tests/test_iso_codes
 #      glom/mode_data/test_flowtablewithfields
@@ -356,6 +357,7 @@ TESTS += \
        tests/python/test_python_execute_func_date \
        tests/python/test_python_execute_func_change_result_type \
        tests/python/test_python_execute_func_with_record \
+       tests/python/test_python_execute_func_with_record_field_types \
        tests/python/test_python_execute_script \
        tests/test_iso_codes
 
@@ -431,6 +433,12 @@ tests_python_test_python_execute_func_with_record_SOURCES = tests/python/test_py
 tests_python_test_python_execute_func_with_record_LDADD = $(tests_ldadd) $(GLOM_LIBS) $(boost_python_libs)
 tests_python_test_python_execute_func_with_record_CPPFLAGS = $(tests_cppflags) $(tests_cppflags_ui)
 
+tests_python_test_python_execute_func_with_record_field_types_SOURCES = 
tests/python/test_python_execute_func_with_record_field_types.cc \
+  glom/python_embed/glom_python.cc \
+  $(sources_test_selfhosting_utils)
+tests_python_test_python_execute_func_with_record_field_types_LDADD = $(tests_ldadd) $(GLOM_LIBS) 
$(boost_python_libs)
+tests_python_test_python_execute_func_with_record_field_types_CPPFLAGS = $(tests_cppflags) 
$(tests_cppflags_ui)
+
 tests_python_test_python_execute_script_SOURCES = tests/python/test_python_execute_script.cc \
   glom/python_embed/glom_python.cc
 tests_python_test_python_execute_script_LDADD = $(tests_ldadd) $(GLOM_LIBS) $(PYTHON_LIBS)
diff --git a/tests/python/test_python_execute_func_with_record_field_types.cc 
b/tests/python/test_python_execute_func_with_record_field_types.cc
new file mode 100644
index 0000000..e080c04
--- /dev/null
+++ b/tests/python/test_python_execute_func_with_record_field_types.cc
@@ -0,0 +1,186 @@
+/* Glom
+ *
+ * Copyright (C) 2010 Openismus GmbH
+ *
+ * This program is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU General Public License as
+ * published by the Free Software Foundation; either version 2 of the
+ * License, or (at your option) any later version.
+ *
+ * This program is distributed in the hope that it will be useful, but
+ * WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+ * General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public
+ * License along with this program; if not, write to the
+ * Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
+ * Boston, MA 02110-1301 USA.
+ */
+
+#include "tests/test_selfhosting_utils.h"
+#include <glom/libglom/init.h>
+#include <glom/libglom/connectionpool.h>
+#include <glom/python_embed/glom_python.h>
+#include <libglom/data_structure/glomconversions.h>
+#include <libglom/utils.h>
+#include <libglom/db_utils.h>
+#include <glibmm/convert.h>
+#include <glibmm/miscutils.h>
+#include <boost/python.hpp>
+#include <iostream>
+
+template <typename FieldType>
+static Gnome::Gda::Value get_field_result(const Glom::Document& document,
+  const Glib::RefPtr<Gnome::Gda::Connection>& gda_connection,
+  const Glib::ustring& table_name,
+  const Glom::sharedptr<const Glom::Field>& primary_key_field,
+  const Gnome::Gda::Value& primary_key_value,
+  const Glom::type_map_fields field_values,
+  const Glib::ustring& field_name, const FieldType& expected_value)
+{
+  const Glib::ustring calculation = "return record[\"" + field_name + "\"]";
+
+  const GType expected_value_gtype = Gnome::Gda::Value(expected_value).get_value_type();
+
+  //Execute a python function:
+  Gnome::Gda::Value value;
+  Glib::ustring error_message;
+  try
+  {
+    value = Glom::glom_evaluate_python_function_implementation(
+      Glom::Field::get_glom_type_for_gda_type(expected_value_gtype),
+      calculation, field_values,
+      &document, table_name,
+      primary_key_field, primary_key_value,
+      gda_connection,
+      error_message);
+  }
+  catch(const std::exception& ex)
+  {
+    std::cerr << G_STRFUNC << ": Exception: " << ex.what() << std::endl;
+    return value;
+  }
+  catch(const boost::python::error_already_set& ex)
+  {
+    std::cerr << G_STRFUNC << ": Exception: boost::python::error_already_set" << std::endl;
+    return value;
+  }
+
+  //std::cout << "type=" << g_type_name(value.get_value_type()) << std::endl;
+
+  //Check that there was no python error:
+  if(!error_message.empty())
+  {
+    std::cerr << G_STRFUNC << ": Python error: " << error_message << std::endl;
+    return value;
+  }
+
+  return value;
+}
+
+static bool test(Glom::Document::HostingMode hosting_mode)
+{
+  //Connect to a Glom database
+  Glom::Document document;
+  const bool recreated = 
+    test_create_and_selfhost_from_example("example_smallbusiness.glom", document, hosting_mode);
+  if(!recreated)
+  {
+    std::cerr << G_STRFUNC << ": Recreation failed." << std::endl;
+    return false;
+  }
+
+  Glom::ConnectionPool* connection_pool = Glom::ConnectionPool::get_instance();
+  Glom::sharedptr<Glom::SharedConnection> connection = connection_pool->connect();
+  g_assert(connection);
+
+  const Glib::RefPtr<Gnome::Gda::Connection> gda_connection = connection->get_gda_connection();
+  g_assert(connection->get_gda_connection());
+
+
+  //Some python code just to exercise our PyGlomRecord API:
+  const Glib::ustring table_name = "products";
+  const Glom::sharedptr<const Glom::Field> primary_key_field =
+    document.get_field_primary_key(table_name);
+  if(!primary_key_field)
+  {
+    std::cerr << G_STRFUNC << ": Failure: primary_key_field is empty." << std::endl;
+    return false;
+  }
+
+  const Gnome::Gda::Value primary_key_value(2);
+
+  const Glom::type_map_fields field_values =
+    Glom::DbUtils::get_record_field_values(&document,
+      table_name,
+      primary_key_field,
+      primary_key_value);
+  if(field_values.empty())
+  {
+    std::cerr << G_STRFUNC << ": field_values was empty: " << std::endl;
+    return false;
+  }
+
+  // Text:
+  {
+    //Check that the python function returns the expected field values for the record:
+    const Glib::ustring expected_value = "Widget";
+    const Gnome::Gda::Value value = get_field_result(document, gda_connection,
+      table_name, primary_key_field, primary_key_value, field_values,
+      "name", expected_value);
+
+    //Check that the return value is of the expected type:
+    if(value.get_value_type() != G_TYPE_STRING)
+    {
+      std::cerr << G_STRFUNC << ": Unexpected value type: " << g_type_name( value.get_value_type()) << " 
instead of " << g_type_name(G_TYPE_STRING) << std::endl;
+      return false;
+    }
+
+    //Check that the return value is of the expected value:
+    if(value.get_string() != expected_value)
+    {
+      std::cerr << G_STRFUNC << ": Unexpected value: " << value.to_string() << " instead of " << 
expected_value << std::endl;
+      return false;
+    }
+  }
+
+  // Numeric:
+  {
+    //Check that the python function returns the expected field values for the record:
+    const double expected_value = (double)3.50f;
+    const Gnome::Gda::Value value = get_field_result(document, gda_connection,
+      table_name, primary_key_field, primary_key_value, field_values,
+      "price", expected_value);
+
+    //Check that the return value is of the expected type:
+    if(value.get_value_type() != GDA_TYPE_NUMERIC)
+    {
+      std::cerr << G_STRFUNC << ": Unexpected value type: " << g_type_name( value.get_value_type()) << " 
instead of " << g_type_name(GDA_TYPE_NUMERIC) << std::endl;
+      return false;
+    }
+
+    //Check that the return value is of the expected value:
+    const double value_double = Glom::Conversions::get_double_for_gda_value_numeric(value);
+    if(value_double != expected_value)
+    {
+      std::cerr << G_STRFUNC << ": Unexpected value: " << value_double << " instead of " << expected_value 
<< std::endl;
+      return false;
+    }
+  }
+
+  test_selfhosting_cleanup();
+
+  return true;
+}
+
+int main()
+{
+  Glom::libglom_init();
+  
+  const int result = test_all_hosting_modes(sigc::ptr_fun(&test));
+
+  Glom::libglom_deinit();
+
+  return result;
+}