/ - Diff - Metacat - Ecoinformatics Redmine

           <input type="radio" name="subaction" value="delete"> Remove this server<br>
           <input type="radio" name="subaction" value="add"> Add this server<br>
           <input type="radio" name="subaction" value="list"> List the current servers<br>
           <input size="30" name="server" >
           <input size="30" name="server" > <br>Replicate To (1 or 0)?:
           <input size="2" name="replicate">
           <br><br>
           <input type="submit" value="Submit">
         </form>

       serverid      NUMBER(20),
       server        VARCHAR2(512),
       last_checked  DATE,
       replicate     NUMBER(1),
       CONSTRAINT xml_replication_pk PRIMARY KEY (serverid)
     );
-...
     END;
+    /
     INSERT INTO xml_replication (serverid, server) VALUES ('1', 'localhost');
     INSERT INTO xml_replication (serverid, server, replicate) VALUES ('1', 'localhost', '0');
     /*
      * Nodes -- table to store XML Nodes (both elements and attributes)

           PreparedStatement pstmt;
           if(subaction.equals("add"))
+          {
             String replicate = ((String[])params.get("replicate"))[0];
             String server = ((String[])params.get("server"))[0];
             pstmt = conn.prepareStatement("insert into xml_replication (server, " +
                     "last_checked) values ('" + server + "', to_date(" +
                     "'01/01/00', 'MM/DD/YY'))");
                     "last_checked, replicate) values ('" + server + "', to_date(" +
                     "'01/01/00', 'MM/DD/YY'), '" + replicate + "')");
             pstmt.execute();
             out.println("server " + server + " added");
             out.println("server " + server + " added");
+          }
           else if(subaction.equals("delete"))
+          {
-...
+          {
             response.setContentType("text/html");
             out.println("<html><body><table border=\"1\">");
             out.println("<tr><td><b>server</b></td><td><b>last_checked</b></td></tr>");
             out.println("<tr><td><b>server</b></td><td><b>last_checked</b></td><td>");
             out.println("<b>replicate</b></td></tr>");
             pstmt = conn.prepareStatement("select * from xml_replication");
             pstmt.execute();
             ResultSet rs = pstmt.getResultSet();
-...
             while(tablehasrows)
+            {
               out.println("<tr><td>" + rs.getString(2) + "</td><td>");
               out.println(rs.getString(3) + "</td></tr>");
               out.println(rs.getString(3) + "</td><td>");
               out.println(rs.getString(4) + "</td></tr>");
               tablehasrows = rs.next();
+            }
             out.println("</table></body></html>");
-...
+      {
         //System.out.println("in handleforcereplicaterequest");
         String server = ((String[])params.get("server"))[0];
         if(!(replToServer(server)))
         { //do not get the server's new document if we are not replicating from there
           return;
+        }
         //the server that the request came from
         String docid = ((String[])params.get("docid"))[0];
         //the docid of the document to get
-...
           //e.printStackTrace(System.out);
+        }
+      }
       /**
        * Returns true if the replicate field for server in xml_replication is 1.
        * Returns false otherwise
        */
       public static boolean replToServer(String server)
+      {
         try
+        {
           Connection conn = util.openDBConnection();
           PreparedStatement pstmt = conn.prepareStatement("select replicate from " +
                                     "xml_replication where server like '" +
                                     server + "'");
           pstmt.execute();
           ResultSet rs = pstmt.getResultSet();
           boolean tablehasrows = rs.next();
           if(tablehasrows)
+          {
             int i = rs.getInt(1);
             if(i == 1)
+            {
               return true;
+            }
             else
+            {
               return false;
+            }
+          }
+        }
         catch(Exception e)
+        {
           System.out.println("error in replToServer: " + e.getMessage());
+        }
         return false;
         //the default if this server does not exist is to not replicate to it.
+      }
+    }

         PreparedStatement pstmt;
         try
+        {
           pstmt = conn.prepareStatement("select server, last_checked from " +
                                         "xml_replication");
           pstmt = conn.prepareStatement("select server, last_checked, replicate " +
                                         "from xml_replication");
           pstmt.execute();
           ResultSet rs = pstmt.getResultSet();
           boolean tableHasRows = rs.next();
           while(tableHasRows)
+          {
             String server = rs.getString(1);
             String last_checked = rs.getString(2);
             if(!server.equals("localhost"))
+            {
               sl.put(server, last_checked);
             if(rs.getInt(3) == 1)
             {//only put the server in the list if the replicate flag is true
               String server = rs.getString(1);
               String last_checked = rs.getString(2);
               if(!server.equals("localhost"))
+              {
                 sl.put(server, last_checked);
+              }
+            }
             tableHasRows = rs.next();
             tableHasRows = rs.next();
+          }
+        }
         catch(Exception e)

Project

General

Profile

Metacat

Revision 629

Added by berkley about 24 years ago