Package org.apache.derby.impl.tools.planexporter

Examples of org.apache.derby.impl.tools.planexporter.AccessDatabase

55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
        try{
            if(args.length>4 && args.length<10 ){
                dbURL = args[0];

                AccessDatabase access = new AccessDatabase(dbURL, args[1], args[2]);
               
                if(access.verifySchemaExistance()){
               
                  if(access.initializeDataArray()){
                    access.createXMLFragment();
                    access.markTheDepth();
                    String stmt=access.statement();
                    String time=access.time();
                    access.closeConnection();

                    //advanced XSL feature
                    //possible occurrences are
                    //-adv -xml {path} -xsl {path} or
                    //-adv -xsl {path} -xml {path}
View Full Code Here
817
818
819
820
821
822
823
824
825
826
    }

    public void testPlanExporterSchemaExistence()
  throws Exception
    {
  AccessDatabase access =
        new AccessDatabase(getConnection(), "NoSuchSchema", "nostmt");
  assertTrue( "Unexpectedly thought schema exists",
    ! access.verifySchemaExistance() );
    }
View Full Code Here
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
       * Added by DERBY-4587 to test the generation of XML files
       * from PlanExporter tool.
       */
      String stmt_id="";
      ResultSet rs;
      AccessDatabase access;

      rs = s.executeQuery(
          "select stmt_id from XPLTEST.sysxplain_statements");
      while (rs.next())
      {
        stmt_id = rs.getString(1);
        access =
          new AccessDatabase(s.getConnection(), "XPLTEST", stmt_id);
        if(access.initializeDataArray()){
          access.createXMLFragment();
          access.markTheDepth();

          CreateXMLFile xml_file = new CreateXMLFile(access);
          xml_file.writeTheXMLFile(
              access.statement(),
              access.time(),
              access.getData(),
              SupportFilesSetup.getReadWriteURL(stmt_id + ".xml")
              .getPath(),
              null);
        }
      }
View Full Code Here
794
795
796
797
798
799
800
801
802
803
    }

    public void testPlanExporterSchemaExistence()
  throws Exception
    {
  AccessDatabase access =
        new AccessDatabase(getConnection(), "NoSuchSchema", "nostmt");
  assertTrue( "Unexpectedly thought schema exists",
    ! access.verifySchemaExistance() );
    }
View Full Code Here
803
804
805
806
807
808
809
810
811
812
813
814
    }

    public void testPlanExporterIllegalFileAccess()
  throws Exception
    {
  AccessDatabase access =
        new AccessDatabase(getConnection(), "NoSuchSchema", "nostmt");
      CreateXMLFile xml_file = new CreateXMLFile(access);
  try
  {
        xml_file.writeTheXMLFile("nostmt", "notime", null,
      "/illegal.xml", null);
View Full Code Here
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
        assertEquals(query, rs.getString(2));
        assertFalse(rs.next());
        rs.close();

        // Create the XML file. This used to result in a syntax error.
        AccessDatabase access =
                new AccessDatabase(getConnection(), schema, stmtId);
        assertTrue(access.initializeDataArray());
        access.createXMLFragment();
        access.markTheDepth();
        CreateXMLFile create = new CreateXMLFile(access);
        create.writeTheXMLFile(
                access.statement(),
                access.time(),
                access.getData(),
                SupportFilesSetup.getReadWriteURL(stmtId + ".xml").getPath(),
                null);

        // If we have the required libraries for parsing XML files, verify
        // that the output contains valid data.
View Full Code Here
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
       * Added by DERBY-4587 to test the generation of XML files
       * from PlanExporter tool.
       */
      String stmt_id="";
      ResultSet rs;
      AccessDatabase access;

      rs = s.executeQuery(
          "select stmt_id from XPLTEST.sysxplain_statements");
      while (rs.next())
      {
        stmt_id = rs.getString(1);
        access =
          new AccessDatabase(s.getConnection(), "XPLTEST", stmt_id);
        if(access.initializeDataArray()){
          access.createXMLFragment();
          access.markTheDepth();

          CreateXMLFile xml_file = new CreateXMLFile(access);
          xml_file.writeTheXMLFile(
              access.statement(),
              access.time(),
              access.getData(),
              SupportFilesSetup.getReadWriteURL(stmt_id + ".xml")
              .getPath(),
              null);
        }
      }
View Full Code Here
744
745
746
747
748
749
750
751
752
753
    }

    public void testPlanExporterSchemaExistence()
  throws Exception
    {
  AccessDatabase access =
        new AccessDatabase(getConnection(), "NoSuchSchema", "nostmt");
  assertTrue( "Unexpectedly thought schema exists",
    ! access.verifySchemaExistance() );
    }
View Full Code Here
753
754
755
756
757
758
759
760
761
762
763
764
    }

    public void testPlanExporterIllegalFileAccess()
  throws Exception
    {
  AccessDatabase access =
        new AccessDatabase(getConnection(), "NoSuchSchema", "nostmt");
      CreateXMLFile xml_file = new CreateXMLFile(access);
  try
  {
        xml_file.writeTheXMLFile("nostmt", "notime", null,
      "/illegal.xml", null);
View Full Code Here
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
        assertEquals(query, rs.getString(2));
        assertFalse(rs.next());
        rs.close();

        // Create the XML file. This used to result in a syntax error.
        AccessDatabase access =
                new AccessDatabase(getConnection(), schema, stmtId);
        assertTrue(access.initializeDataArray());
        access.createXMLFragment();
        access.markTheDepth();
        CreateXMLFile create = new CreateXMLFile(access);
        create.writeTheXMLFile(
                access.statement(),
                access.time(),
                access.getData(),
                SupportFilesSetup.getReadWriteURL(stmtId + ".xml").getPath(),
                null);

        // If we have the required libraries for parsing XML files, verify
        // that the output contains valid data.
View Full Code Here
TOP

Related Classes of org.apache.derby.impl.tools.planexporter.AccessDatabase

  • org.apache.derby.tools.PlanExporter
  • org.apache.derbyTesting.functionTests.tests.lang.XplainStatisticsTest
  • java.sql.PreparedStatement
  • java.sql.ResultSet
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.