Changeset 34903

Timestamp:

2021-02-19T17:38:54+13:00 (3 years ago)

Author:

davidb

Message:

Rolled back to r34900

Location:

gs2-extensions/tipple-bridge/trunk/src

Files:

• COMPILE.sh (deleted)
• RUN.sh (deleted)
• src/main/java/sqlCli.java (modified) (4 diffs)

gs2-extensions/tipple-bridge/trunk/src/src/main/java/sqlCli.java

@@ -47 +47 @@
     String dbName;
 
+    //project id - it should be required right?
+    //if they omit, the query would come up empty.
+    @Option(names = {"--projectID"}, description = "ID number of the project")
+    String projectID;
+
     @Option(names = {"--host"}, description = "Type of host e.g. localhost ",
             required = true, defaultValue = "localhost")
@@ -70 +75 @@
         //else we're good to go.
        // databaseConnect(userName, password, port, dbName, projectID, jsonOutputFile, host);
-        int status = databaseConnect(userName, password, port, dbName, jsonOutputFile, host);
+        int status = databaseConnect(userName, password, port, dbName, projectID, jsonOutputFile, host);
         return status;
     }
@@ -81 +86 @@
 
     private static int databaseConnect(String user, String pass, int port, String dbName,
-                                         String fileName, String host){
+                                        String projectID, String fileName, String host){
         Connection conn;
         Statement stmt;
@@ -117 +122 @@
              */
 
-           // String sql = "SELECT name, id, typeId, created from td_ContentItem where projectId="+projectID;
-
-            String sql = "SELECT  cItem.name, cItem.created, mFile.path\n" +
-                    "FROM td_ManagedFile AS mFile, td_ContentItem AS cItem, td_ContentItem_MediaItem AS cMediaItem, td_MediaItem AS mItem\n" +
-                    "WHERE\n" +
-                    "cItem.id = cMediaItem.contentItemId \n" +
-                    "and cMediaItem.mediaItemId = mItem.id\n" +
-                    "And mItem.fileId = mFile.id\n" +
-                    "ORDER BY mFile.projectId;\n";
+            String sql = "SELECT name, id, typeId, created from td_ContentItem where projectId="+projectID;
+/*
+            String sql = "select td_Document.id, td_Document.content " +
+                    "from td_Document, td_ContentItem, td_ContentItem_Document " +
+                    "where td_ContentItem.projectId=" + projectID + " and td_ContentItem.id =
+                    td_ContentItem_Document.ContentItemId " +
+                    "and td_ContentItem_Document.documentId = td_Document.id;";
+*/
             ResultSet myResult = stmt.executeQuery(sql);
             ResultSetMetaData resultMetaData = myResult.getMetaData();