Package com.almworks.sqlite4java

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


         
          if (!currStatement.step()) {
            currStatement.dispose();
            return null;
          }
          int db_id_sg = currStatement.columnInt(0);
          String id_sg = currStatement.columnString(1);
          String name_sg = currStatement.columnString(2);
          String buf = currStatement.columnString(3);
          boolean direct_sg = false;
          if (buf.toLowerCase().equals("true")) {
View Full Code Here


          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)) {
              StorableEdge e = new StorableEdge(db_id_edge, mapVertexes.get(db_source), mapVertexes.get(db_target), id_edge);
View Full Code Here

          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)) {
              StorableEdge e = new StorableEdge(db_id_edge, mapVertexes.get(db_source), mapVertexes.get(db_target), id_edge);
              edges.add(e);
              //add edge attributes
View Full Code Here

          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)) {
              StorableEdge e = new StorableEdge(db_id_edge, mapVertexes.get(db_source), mapVertexes.get(db_target), id_edge);
              edges.add(e);
              //add edge attributes
              request.setLength(0);
View Full Code Here

              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,
                    type_attr);
View Full Code Here

        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

        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

              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);
                  attrs.add(attr);
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.