Package com.almworks.sqlite4java

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

519
520
521
522
523
524
525
526
527
528
529
              directed = true;
            } else {
              directed = false;
            }
            id = subgraphStatement.columnString(1);
            name = subgraphStatement.columnString(2);
          }
          subgraphStatement.dispose();

          //vertexes-----------------------
          ArrayList<StorableVertex>listVertex = new ArrayList<StorableVertex>();
View Full Code Here
533
534
535
536
537
538
539
540
541
542
543
                "from com_subgraph_vertex s1, vertex s2 " +
                "where s1.db_id_subgraph = " + Integer.valueOf(id_subgraph).toString() + " and s2.db_id = s1.db_id_vertex;";
          vertexStatement = connection.prepare(request,false);
          while(vertexStatement.step()) {
            int db_id_vertex = vertexStatement.columnInt(0);
            String id_vertex = vertexStatement.columnString(1);
            Integer db_id_innder_graph = (Integer)vertexStatement.columnValue(2);
            StorableVertex v = new StorableVertex(db_id_vertex, id_vertex);
            v.setInnerGraph(db_id_innder_graph);
            listVertex.add(v);
            //attributes-----------------
View Full Code Here
546
547
548
549
550
551
552
553
554
555
556
                      "from com_vertex_attribute s1, attribute s2 " +
                      "where s1.db_id_vertex = " + Integer.valueOf(db_id_vertex).toString() + " and s2.db_id = s1.db_id_attribute;";
            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));
            }
            attrStatement.dispose();
View Full Code Here
547
548
549
550
551
552
553
554
555
556
557
                      "where s1.db_id_vertex = " + Integer.valueOf(db_id_vertex).toString() + " and s2.db_id = s1.db_id_attribute;";
            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));
            }
            attrStatement.dispose();
View Full Code Here
548
549
550
551
552
553
554
555
556
557
558
            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));
            }
            attrStatement.dispose();

          }
View Full Code Here
565
566
567
568
569
570
571
572
573
574
575
                    "from com_subgraph_edge s1, edge s2 " +
                    "where s1.db_id_subgraph = " + Integer.valueOf(id_subgraph).toString() + " and s2.db_id = s1.db_id_edge;";
          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) {
              StorableVertex source = null, target = null;
              for(StorableVertex bufVertex : listVertex) {
View Full Code Here
590
591
592
593
594
595
596
597
598
599
600
                          "from com_edge_attribute s1, attribute s2 " +
                          "where s1.db_id_edge = " + Integer.valueOf(db_id_edge).toString() + " and s2.db_id = s1.db_id_attribute;";
                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));
                }
                attrStatement.dispose();
View Full Code Here
591
592
593
594
595
596
597
598
599
600
601
                          "where s1.db_id_edge = " + Integer.valueOf(db_id_edge).toString() + " and s2.db_id = s1.db_id_attribute;";
                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));
                }
                attrStatement.dispose();
View Full Code Here
592
593
594
595
596
597
598
599
600
601
602
                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));
                }
                attrStatement.dispose();

              } else {
View Full Code Here
617
618
619
620
621
622
623
624
625
626
627
                "where s1.db_id = " + Integer.valueOf(graphId).toString() + ";";
        graphStatement = connection.prepare(request,false);
        StorableGraph sg = null;
        if(graphStatement.step()) {
          Integer rootKey = graphStatement.columnInt(1);
          String name = graphStatement.columnString(2);
          sg = new StorableGraph(graphId, name, subGraphs, rootKey);
        } else {
          sg = new StorableGraph(graphId, "Untitle", subGraphs, null);
        }
        graphStatement.dispose();
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.