Changeset 34499 for main

Timestamp:

2020-10-20T11:30:26+13:00 (4 years ago)

Author:

davidb

Message:

More robust naming scheme

File:

• main/trunk/model-sites-dev/cambridge-museum/collect/waikato-independent/pre-import/MSAccessToCSV/src/main/java/org/greenstone/accessdb/MSAccessToCSV.java (moved) (moved from main/trunk/model-sites-dev/cambridge-museum/collect/waikato-independent/pre-import/MSAccessToCSV/src/main/java/org/greenstone/accessdb/TableToCSV.java ) (4 diffs)

main/trunk/model-sites-dev/cambridge-museum/collect/waikato-independent/pre-import/MSAccessToCSV/src/main/java/org/greenstone/accessdb/MSAccessToCSV.java

@@ -4 +4 @@
 import java.io.OutputStreamWriter;
 
-public class TableToCSV
+public class MSAccessToCSV extends JDBCBase
 {
+    /*
     
     final static String TABLE_NAME = "WAIKATO_INDEPENDENT";
@@ -67 +68 @@
     }
 
-
-    public static void accessTableToCSVFile(Connection connection, String table_name, String csv_filename)
+    */
+    
+    public static void msAccessTableToCSVFile(Connection connection, String table_name, String csv_filename)
     {
     try {
@@ -140 +142 @@
     public static void main( String[] args )
     {
-         
-        //String databaseURL = "jdbc:ucanaccess://d:/cygwin64/home/davidb/research/code-unmanaged/cambridge-museum/waikato-independent-db/Waikato Independent.accdb";
-    String databaseURL = "jdbc:ucanaccess://Waikato Independent.accdb";
-        
-    System.out.println("Opening: '" + databaseURL + "' ...");
+
+    /* Note:
+
+       If needing to load via a absolute filename on Windows, example for this is:
+          "jdbc:ucanaccess://d:/cygwin64/home/<USERNAME>/.../waikato-independent-db/Waikato Independent.accdb"
+    */
+
+    // Assuming database is relative to directory where script is run from:
+    String inputDatabaseURI = "jdbc:ucanaccess://Waikato Independent.accdb";
+        
+    System.out.println("Opening: '" + inputDatabaseURI + "' ...");
     
-        try (Connection connection = DriverManager.getConnection(databaseURL)) {
+        try (Connection connection = DriverManager.getConnection(inputDatabaseURI)) {
         System.out.println("... connnected");
 
@@ -157 +165 @@
         String csv_filename = TABLE_NAME + ".csv";
         
-        accessTableToCSVFile(connection, TABLE_NAME, csv_filename);
+        msAccessTableToCSVFile(connection, TABLE_NAME, csv_filename);