Package com.almworks.sqlite4java

Examples of com.almworks.sqlite4java.SQLiteStatement.step()

690
691
692
693
694
695
696
697
698
699
700
          try {         
            request = "select s2.db_id, s2.name, s2.value, s2.value_type " +
                      "from com_vertex_attribute s1, attribute s2 " +
                      "where s1.db_id_vertex = " + Integer.valueOf(db_id_vertex).toString() + " and s1.db_id_attribute = s2.db_id;";
            attrStatement = connection.prepare(request,false);
            while(attrStatement.step()) {
              int db_id_attr = attrStatement.columnInt(0);
              String db_name = attrStatement.columnString(1);
              String db_value = attrStatement.columnString(2);
              String db_type = attrStatement.columnString(3);
              v.addStorableAttribute(new StorableAttribute(db_id_attr, db_name, db_value, db_type));
View Full Code Here
714
715
716
717
718
719
720
721
722
723
724
        request = "select s2.db_id, s2.id, s2.db_id_source, db_id_target " +
                  "from com_subgraph_edge s1, edge s2 " +
                  "where s1.db_id_subgraph = " + Integer.valueOf(id_subgraph).toString() + " and s1.db_id_edge = s2.db_id;";
        edgeStatement = connection.prepare(request,false);
        while(edgeStatement.step()) {
          int db_id_edge = edgeStatement.columnInt(0);
          String id_edge = edgeStatement.columnString(1);
          Integer db_id_source = (Integer)edgeStatement.columnValue(2);
          Integer db_id_target = (Integer)edgeStatement.columnValue(3);
          if(db_id_source != null && db_id_target != null) {
View Full Code Here
739
740
741
742
743
744
745
746
747
748
749
              try {
                request = "select s2.db_id, s2.name, s2.value, s2.value_type " +
                          "from com_edge_attribute s1, attribute s2 " +
                          "where s1.db_id_edge = " + Integer.valueOf(db_id_edge).toString() + " and s1.db_id_attribute = s2.db_id;";
                attrStatement = connection.prepare(request,false);
                while(attrStatement.step()) {
                  int db_id_attr = attrStatement.columnInt(0);
                  String db_name = attrStatement.columnString(1);
                  String db_value = attrStatement.columnString(2);
                  String db_type = attrStatement.columnString(3);
                  e.addStorableAttribute(new StorableAttribute(db_id_attr, db_name, db_value,db_type));
View Full Code Here
801
802
803
804
805
806
807
808
809
810
811
          request.append("select s1.db_id, s1.id, s1.name, s1.directed from subgraph s1, com_subgraph_vertex s2 where s1.db_id = s2.db_id_subgraph and s2.db_id_vertex = ");
          request.append(vertexId.get(0));
          request.append(";");
          SQLiteStatement currStatement = connection.prepare(request.toString(), false);
         
          if (!currStatement.step()) {
            currStatement.dispose();
            return null;
          }
          int db_id_sg = currStatement.columnInt(0);
          String id_sg = currStatement.columnString(1);
View Full Code Here
823
824
825
826
827
828
829
830
831
832
833
          request.append(db_id_sg);
          request.append(";");
         
          ArrayList<StorableEdge>edges = new ArrayList<StorableEdge>();
          currStatement = connection.prepare(request.toString(), false);
          while (currStatement.step()) {
            int db_id_edge = currStatement.columnInt(0);
            String id_edge = currStatement.columnString(1);
            int db_source = currStatement.columnInt(2);
            int db_target = currStatement.columnInt(3);
            if(vertexId.contains(db_source) && vertexId.contains(db_target)) {
View Full Code Here
838
839
840
841
842
843
844
845
846
847
848
              request.append("select s1.db_id, s1.name, s1.value, s1.value_type from attribute s1, com_edge_attribute s2 where s1.db_id = s2.db_id_attribute and s2.db_id_edge = ");
              request.append(db_id_edge);
              request.append(";");
             
              SQLiteStatement resultAttribute = connection.prepare(request.toString(), false);
              while (resultAttribute.step()) {
                int db_id_attr = resultAttribute.columnInt(0);
                String name_attr = resultAttribute.columnString(1);
                String value_attr = resultAttribute.columnString(2);
                String type_attr = resultAttribute.columnString(3);
                StorableAttribute attr = new StorableAttribute(db_id_attr, name_attr, value_attr,
View Full Code Here
873
874
875
876
877
878
879
880
881
882
883
  public synchronized List<List<Object>> executeSQLRequest(final String request) {
    SQLiteJob<List<List<Object>>> job = this.currConnection.execute(new SQLiteJob<List<List<Object>>>() {
      protected List<List<Object>> job(SQLiteConnection connection) throws Throwable {
        SQLiteStatement currStatement = connection.prepare(request, false);
        List<List<Object>> datas = new ArrayList<List<Object>>();
        while (currStatement.step()) {
          ArrayList<Object> row = new ArrayList<Object>();
          for (int i = 0; i < currStatement.columnCount(); i++) {
            row.add(currStatement.columnValue(i));
          }
          datas.add(row);
View Full Code Here
906
907
908
909
910
911
912
913
914
915
916
       
        String request = "select * " +
                         "from graph s1 " +
                         "where s1.db_id = " + Integer.valueOf(graphId).toString() + ";";
        currStatement = connection.prepare(request,false);
        if(currStatement.step()) {
          Integer a = currStatement.columnInt(1); 
          currStatement.dispose();
          return a;
        }
        return null;
View Full Code Here
932
933
934
935
936
937
938
939
940
941
942
      protected StorableVertex job(SQLiteConnection connection) throws Throwable {
        String request = "select s1.db_id, s1.id, s1.db_id_inner_graph " + "from vertex s1 "
            + "where s1.db_id = " + Integer.valueOf(vertexId).toString() + ";";
        SQLiteStatement currStatement = connection.prepare(request, false);
        StorableVertex v = null;
        if (currStatement != null && currStatement.step()) {
          int db_id = currStatement.columnInt(0);
          String id = currStatement.columnString(1);
          Integer db_id_inner_graph = (Integer) currStatement.columnValue(2);
          v = new StorableVertex(db_id, id);
          v.setInnerGraph(db_id_inner_graph);
View Full Code Here
961
962
963
964
965
966
967
968
969
970
971
                  + Integer.valueOf(vertexId).toString() + " and s2.db_id = s1.db_id_attribute;";

              SQLiteStatement currStatement = connection.prepare(request);
              List<StorableAttribute> attrs = new ArrayList<StorableAttribute>();
              if (currStatement != null) {
                while (currStatement.step()) {
                  int db_id_attr = currStatement.columnInt(0);
                  String name = currStatement.columnString(1);
                  String value = currStatement.columnString(2);
                  String type = currStatement.columnString(3);
                  StorableAttribute attr = new StorableAttribute(db_id_attr, name, value, type);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.