check_meta_store_postgresql.c

/*
 * Copyright (C) 2008 - 2011 Vivien Malerba <malerba@gnome-db.org>
 * Copyright (C) 2018 Daniel Espinosa <esodan@gmail.com>
 *
 * 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 <libgda/libgda.h>
#include <stdio.h>
#include <glib/gstdio.h>
#include "common.h"

extern gchar *dbname;

int 
main(G_GNUC_UNUSED int argc, G_GNUC_UNUSED char ** argv)
{
	GdaConnection *cnc;
	GdaMetaStore *store;
	const gchar *cnc_string = NULL;
	GError *error = NULL;
	gboolean db_created = FALSE;
	const gchar *dbcreate_params = NULL;

	gda_init ();

	/*cnc_string = "DB_NAME=test;HOST=localhost;USERNAME=test;PASSWORD=test1";*/

	cnc_string = g_getenv ("POSTGRESQL_META_CNC");
	if (!cnc_string)
	{
		g_print ("PostgreSQL test not run, please set the POSTGRESQL_META_CNC environment variable \n"
			        "For example 'DB_NAME=$POSTGRES_DB;HOST=postgres;USERNAME=$POSTGRES_USER;PASSWORD=$POSTGRES_PASSWORD'\n");
		return EXIT_SUCCESS;
	}

	dbcreate_params = g_getenv ("POSTGRESQL_DBCREATE_PARAMS");

	if (!dbcreate_params)
	{
		g_print ("PostgreSQL test not run, please set the POSTGRESQL_DBCREATE_PARAMS environment variable \n");
		return EXIT_SUCCESS;
	}

	db_created = test_setup("PostgreSQL", dbcreate_params);

	if (!db_created) {
		g_print ("Can't setup database\n");
		return EXIT_FAILURE;
	}
// Append database name to the connection string
	GString *new_cnc_string = g_string_new(cnc_string);
	g_string_append_printf (new_cnc_string, ";DB_NAME=%s", dbname);

	g_print ("Connection string: %s\n", new_cnc_string->str);
	/* connection try */
	cnc = gda_connection_open_from_string ("PostgreSQL", new_cnc_string->str, NULL, GDA_CONNECTION_OPTIONS_NONE, &error);


	if (!cnc) {
	    g_warning ("Connection no established. Error: %s\n",
		       error && error->message ? error->message : "No error was set");
	    g_clear_error (&error);
	    return EXIT_FAILURE;
	}

	/* Clean everything which might exist in the store */
	gchar *str;
	str = g_strdup_printf ("PostgreSQL://%s", new_cnc_string->str);
	g_string_free (new_cnc_string, TRUE);
	store = gda_meta_store_new (str);
	common_drop_all_tables (store);
	g_object_unref (store);

	/* Test store setup */
	store = gda_meta_store_new (str);
	g_free (str);

	g_print ("STORE: %p, version: %d\n", store, store ? gda_meta_store_get_version (store) : 0);

	/* Tests */
	tests_group_1 (store);
	g_object_unref (store);
	if (db_created) {
		test_finish (cnc);
	}

	g_object_unref (cnc);

	g_print ("Test OK.\n");
	return EXIT_SUCCESS;
}