Package com.almworks.sqlite4java

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


            long lastFid = -1L;
            List<TypeGuessSummary> tgslist = null;
            while (stmt.step()) {
              long fid = stmt.columnLong(0);
              long crawlid = stmt.columnLong(1);
              String fname = stmt.columnString(2);
              String owner = stmt.columnString(3);
              String groupowner = stmt.columnString(4);
              String permissions = stmt.columnString(5);
              long size = stmt.columnLong(6);
              String modified = stmt.columnString(7);
View Full Code Here


            List<TypeGuessSummary> tgslist = null;
            while (stmt.step()) {
              long fid = stmt.columnLong(0);
              long crawlid = stmt.columnLong(1);
              String fname = stmt.columnString(2);
              String owner = stmt.columnString(3);
              String groupowner = stmt.columnString(4);
              String permissions = stmt.columnString(5);
              long size = stmt.columnLong(6);
              String modified = stmt.columnString(7);
              String path = stmt.columnString(8);
View Full Code Here

            while (stmt.step()) {
              long fid = stmt.columnLong(0);
              long crawlid = stmt.columnLong(1);
              String fname = stmt.columnString(2);
              String owner = stmt.columnString(3);
              String groupowner = stmt.columnString(4);
              String permissions = stmt.columnString(5);
              long size = stmt.columnLong(6);
              String modified = stmt.columnString(7);
              String path = stmt.columnString(8);
              long schemaid = stmt.columnLong(9);
View Full Code Here

              long fid = stmt.columnLong(0);
              long crawlid = stmt.columnLong(1);
              String fname = stmt.columnString(2);
              String owner = stmt.columnString(3);
              String groupowner = stmt.columnString(4);
              String permissions = stmt.columnString(5);
              long size = stmt.columnLong(6);
              String modified = stmt.columnString(7);
              String path = stmt.columnString(8);
              long schemaid = stmt.columnLong(9);
              long typeid = stmt.columnLong(10);
View Full Code Here

              String fname = stmt.columnString(2);
              String owner = stmt.columnString(3);
              String groupowner = stmt.columnString(4);
              String permissions = stmt.columnString(5);
              long size = stmt.columnLong(6);
              String modified = stmt.columnString(7);
              String path = stmt.columnString(8);
              long schemaid = stmt.columnLong(9);
              long typeid = stmt.columnLong(10);

              // We get a tuple for every typeguess.
View Full Code Here

              String owner = stmt.columnString(3);
              String groupowner = stmt.columnString(4);
              String permissions = stmt.columnString(5);
              long size = stmt.columnLong(6);
              String modified = stmt.columnString(7);
              String path = stmt.columnString(8);
              long schemaid = stmt.columnLong(9);
              long typeid = stmt.columnLong(10);

              // We get a tuple for every typeguess.
              // There could be more than one typeguess for each unique file
View Full Code Here

          List<Path> output = new ArrayList<Path>();         
          SQLiteStatement stmt = db.prepare(filenameForCrawlQuery);
          try {
            stmt.bind(1, crawlid).bind(2, isDir);
            while (stmt.step()) {
              output.add(new Path(stmt.columnString(0), stmt.columnString(1)));
            }
          } catch (SQLiteException se) {
            se.printStackTrace();
          } finally {
            stmt.dispose();
View Full Code Here

          List<Path> output = new ArrayList<Path>();         
          SQLiteStatement stmt = db.prepare(filenameForCrawlQuery);
          try {
            stmt.bind(1, crawlid).bind(2, isDir);
            while (stmt.step()) {
              output.add(new Path(stmt.columnString(0), stmt.columnString(1)));
            }
          } catch (SQLiteException se) {
            se.printStackTrace();
          } finally {
            stmt.dispose();
View Full Code Here

          String fname = null;
          SQLiteStatement stmt = db.prepare("SELECT Types.typelabel, Files.path, Files.fname FROM Types, TypeGuesses, Files WHERE TypeGuesses.fid = ? AND Files.fid = TypeGuesses.fid AND Types.typeid = TypeGuesses.typeid");
          try {
            stmt.bind(1, fid);
            if (stmt.step()) {
              identifier = stmt.columnString(0);
              path = stmt.columnString(1);
              fname = stmt.columnString(2);
            }
          } finally {
            stmt.dispose();
View Full Code Here

          SQLiteStatement stmt = db.prepare("SELECT Types.typelabel, Files.path, Files.fname FROM Types, TypeGuesses, Files WHERE TypeGuesses.fid = ? AND Files.fid = TypeGuesses.fid AND Types.typeid = TypeGuesses.typeid");
          try {
            stmt.bind(1, fid);
            if (stmt.step()) {
              identifier = stmt.columnString(0);
              path = stmt.columnString(1);
              fname = stmt.columnString(2);
            }
          } finally {
            stmt.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.