Changeset 10924

Timestamp:

2005-11-23T12:25:36+13:00 (18 years ago)

Author:

jrm21

Message:

updated for sql_query_prime and more hints re CSV files.

File:

• trunk/gsdl/etc/packages/example.dbi (modified) (3 diffs)

trunk/gsdl/etc/packages/example.dbi

@@ -31 +31 @@
 
 # Data Source.
-# This is going to be dependent on which back-end you use.
+# This is going to be dependent on which back-end you use. Note that these
+# strings are case-sensitive.
 # Eg, for postgres, it is "DBI:Pg:dbname=<database>".
 # For mysql, it might look like "DBI:mysql:database=<database>;host=localhost"
@@ -37 +38 @@
 #   'DBI:CSV:f_dir=/path/to/file;csv_quote_char=\";csv_sep_char=    '
 # with an embedded tab character for tab-separated instead of the
-# default comma-separated.
-# Case may be important!
-#
-#$db='';
+# default comma-separated.$db='';
 
 # If you need a username and password to connect to this database,
@@ -48 +46 @@
 #$password='';
 
+# DBI does not allow you to use multiple SQL statements at once. So if
+# you want to execute two statements (for example, to prep the data by
+# creating a temporary table), uncomment and use this as the first statement. 
+#$sql_query_prime = 'CREATE TEMP TABLE foo AS
+# SELECT t1.ID, t2.name
+# FROM table1 AS t1 JOIN table2 AS t2
+# ON t1.ID = t2.ID ';
+
 # sql query required to get your rows out of the database. Each row will
 # become a separate greenstone document.
 #
-#$sql_query = 'SELECT id, name,  data FROM table1 JOIN table2 WHERE something';
+#$sql_query = 'SELECT id, name, data FROM foo JOIN table2 WHERE something';
 # For CSV, the table name is the file name. Eg:
 #$sql_query = 'SELECT * FROM values.txt'
 # CSV may also require DOS '\r\n'-style line endings instead of unix '\n'.
+# It is easier if your data file does not have a dot '.' in it, as that is
+# not a valid character in an SQL table name (although it works for simple
+# SELECTS but not joins).