diff options
author | Jürg Billeter <j@bitron.ch> | 2010-03-23 13:41:31 +0100 |
---|---|---|
committer | Philip Van Hoof <philip@codeminded.be> | 2010-03-24 18:06:32 +0100 |
commit | 9dfbd6124e11bfccef522cd4bc3b9fcb9239a0cc (patch) | |
tree | e861ddf6981e80ceaaa9def2c248984a1e1cbd24 /utils | |
parent | 7970decb9e77341ab4b2cc5fbd8e72892b2c1773 (diff) | |
download | tracker-9dfbd6124e11bfccef522cd4bc3b9fcb9239a0cc.tar.gz |
Disable old tracker-fts test
Diffstat (limited to 'utils')
-rw-r--r-- | utils/Makefile.am | 3 | ||||
-rw-r--r-- | utils/tracker-fts/.gitignore | 1 | ||||
-rw-r--r-- | utils/tracker-fts/Makefile.am | 25 | ||||
-rw-r--r-- | utils/tracker-fts/tracker-fts-test.c | 115 |
4 files changed, 1 insertions, 143 deletions
diff --git a/utils/Makefile.am b/utils/Makefile.am index 8a58d6845..bec1ba288 100644 --- a/utils/Makefile.am +++ b/utils/Makefile.am @@ -4,5 +4,4 @@ SUBDIRS = \ gtk-sparql \ lyrics \ services \ - playlists \ - tracker-fts + playlists diff --git a/utils/tracker-fts/.gitignore b/utils/tracker-fts/.gitignore deleted file mode 100644 index ecd52e135..000000000 --- a/utils/tracker-fts/.gitignore +++ /dev/null @@ -1 +0,0 @@ -tracker-fts-test diff --git a/utils/tracker-fts/Makefile.am b/utils/tracker-fts/Makefile.am deleted file mode 100644 index 538433ecb..000000000 --- a/utils/tracker-fts/Makefile.am +++ /dev/null @@ -1,25 +0,0 @@ -include $(top_srcdir)/Makefile.decl - -noinst_PROGRAMS = tracker-fts-test - -INCLUDES = \ - -DG_LOG_DOMAIN=\"Tracker\" \ - -DPKGLIBDIR=\""$(libdir)/tracker-$(TRACKER_API_VERSION)"\" \ - -I$(top_srcdir)/src \ - $(WARN_CFLAGS) \ - $(GLIB2_CFLAGS) \ - $(GTHREAD_CFLAGS) \ - $(PANGO_CFLAGS) \ - $(SQLITE3_CFLAGS) - -tracker_fts_test_SOURCES = \ - tracker-fts-test.c - -tracker_fts_test_LDADD = \ - $(top_builddir)/src/libtracker-common/libtracker-common.la \ - $(top_builddir)/src/libtracker-fts/libtracker-fts.la \ - $(top_builddir)/src/libstemmer/libstemmer.la \ - $(SQLITE3_LIBS) \ - $(GTHREAD_LIBS) \ - $(PANGO_LIBS) \ - $(GLIB2_LIBS) diff --git a/utils/tracker-fts/tracker-fts-test.c b/utils/tracker-fts/tracker-fts-test.c deleted file mode 100644 index 95be11336..000000000 --- a/utils/tracker-fts/tracker-fts-test.c +++ /dev/null @@ -1,115 +0,0 @@ -/* - * Copyright (C) 2008, Mr Jamie McCracken (jamiemcc@gnome.org) - * Copyright (C) 2008, Nokia - * - * This library 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 library 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 library; if not, write to the - * Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, - * Boston, MA 02110-1301, USA. - */ - -#include <stdio.h> -#include <stdlib.h> - -#include <sqlite3.h> - -#include <libtracker-fts/tracker-fts.h> - -#include <glib.h> -#include <glib/gstdio.h> -#include <glib-object.h> - -static gint -callback (void *NotUsed, - gint argc, - gchar **argv, - gchar **azColName) -{ - gint i; - - for (i = 0; i < argc; i++) { - printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL"); - } - - printf("\n"); - - return 0; -} - -static void -exec_sql (sqlite3 *db, - const gchar *sql) -{ - gchar *zErrMsg; - gint rc; - - rc = sqlite3_exec (db, sql , callback, 0, &zErrMsg); - - if (rc != SQLITE_OK) { - g_printerr ("SQL error: %s\n", zErrMsg); - sqlite3_free (zErrMsg); - } -} - -int -main (int argc, char **argv) -{ - sqlite3 *db; - gint rc; - gboolean db_exists = FALSE; - gchar *sql; - - g_type_init (); - g_thread_init (NULL); - - if (argc != 2) { - g_printerr ("Usage: %s MATCH_TERM\n", argv[0]); - g_printerr ("EG: %s stew\n", argv[0]); - return EXIT_FAILURE; - } - - g_unlink ("/tmp/test.db"); - db_exists = g_file_test ("/tmp/test.db", G_FILE_TEST_EXISTS); - - rc = sqlite3_open ("/tmp/test.db", &db); - if (rc) { - g_printerr ("Can't open database: %s\n", sqlite3_errmsg(db)); - sqlite3_close(db); - return EXIT_FAILURE; - } - - if (tracker_fts_init (db) != SQLITE_OK) { - fprintf(stderr, "SQL error\n"); - } - - if (!db_exists) { - exec_sql (db, "create virtual table recipe using trackerfts (cat, col_default, col_1, col_2)"); - exec_sql (db, "insert into recipe (cat, col_default, col_1, col_2) values (3, 'broccoli stew stew stew', 'broccoli,peppers,cheese and tomatoes', 'mix them all up and have fun')"); - exec_sql (db, "insert into recipe (cat, col_default, col_1, col_2) values (4, 'pumpkin stew stew stew', 'pumpkin,onions,garlic and celery', 'spread them thinly')"); - exec_sql (db, "insert into recipe (cat, col_default, col_1, col_2) values (2, 'broccoli pie stew', 'broccoli,cheese,onions and flour.', 'mash em up')"); - exec_sql (db, "insert into recipe (cat, col_default, col_1, col_2) values (7, 'stew pumpkin pie stew', 'pumpkin,sugar,flour and butter.', 'spread them all thinly')"); - exec_sql (db, "insert into recipe (cat, col_default, col_1, col_2) values (6, 'stew pumpkin pie stew', 'pumpkin,sugar,flour and butter.', 'mash and spread')"); - } - // sql = g_strdup_printf ("select cat, count (*) from recipe where recipe match '%s' group by Cat", argv[1]); - // exec_sql (db, sql); - // g_free (sql); - sql = g_strdup_printf ("select rowid, cat, col_default, col_1, col_2, offsets(recipe), rank(recipe) from recipe where recipe match '%s' and Cat<8 order by rank(recipe) desc", argv[1]); - exec_sql (db, sql); - g_free (sql); - - - sqlite3_close(db); - - return EXIT_SUCCESS; -} - |