Package com.almworks.sqlite4java

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


        protected CrawlSummary job(SQLiteConnection db) throws SQLiteException {
          SQLiteStatement stmt = db.prepare("SELECT crawlstarted, crawlfinished, inprogress, fsid FROM Crawls WHERE crawlid = ?");
          try {
            stmt.bind(1, crawlid);
            if (stmt.step()) {
              return new CrawlSummary(FSAnalyzer.this, crawlid, stmt.columnString(0), stmt.columnString(1), "True".equals(stmt.columnString(2)), stmt.columnLong(3));
            } else {
              return null;
            }
          } finally {
            stmt.dispose();
View Full Code Here


        protected TypeSummaryData job(SQLiteConnection db) throws SQLiteException {
          SQLiteStatement stmt = db.prepare("SELECT typelabel FROM Types WHERE typeid = ?");
          try {
            stmt.bind(1, typeid);
            if (stmt.step()) {
              return new TypeSummaryData(typeid, stmt.columnString(0));
            } else {
              return null;
            }
          } finally {
            stmt.dispose();
View Full Code Here

        protected String job(SQLiteConnection db) throws SQLiteException {
          SQLiteStatement stmt = db.prepare("SELECT property FROM Configs WHERE propertyname=?");
          try {
            stmt.bind(1, propertyName);
            if (stmt.step()) {
              return stmt.columnString(0);
            } else {
              return null;
            }
          } finally {
            stmt.dispose();
View Full Code Here

          try {
            List<TypeGuessSummary> tgslist = null;           
            while (stmt.step()) {
              int i = 0;
              long fid = stmt.columnLong(i++);
              String typelabel = stmt.columnString(i++);
              long schemaid = stmt.columnLong(i++);
              long crawlid = stmt.columnLong(i++);
              String fname = stmt.columnString(i++);
              String owner = stmt.columnString(i++);
              String groupowner = stmt.columnString(i++);
View Full Code Here

              int i = 0;
              long fid = stmt.columnLong(i++);
              String typelabel = stmt.columnString(i++);
              long schemaid = stmt.columnLong(i++);
              long crawlid = stmt.columnLong(i++);
              String fname = stmt.columnString(i++);
              String owner = stmt.columnString(i++);
              String groupowner = stmt.columnString(i++);
              String permissions = stmt.columnString(i++);
              long size = stmt.columnLong(i++);
              String modified = stmt.columnString(i++);
View Full Code Here

              long fid = stmt.columnLong(i++);
              String typelabel = stmt.columnString(i++);
              long schemaid = stmt.columnLong(i++);
              long crawlid = stmt.columnLong(i++);
              String fname = stmt.columnString(i++);
              String owner = stmt.columnString(i++);
              String groupowner = stmt.columnString(i++);
              String permissions = stmt.columnString(i++);
              long size = stmt.columnLong(i++);
              String modified = stmt.columnString(i++);
              String path = stmt.columnString(i++);
View Full Code Here

              String typelabel = stmt.columnString(i++);
              long schemaid = stmt.columnLong(i++);
              long crawlid = stmt.columnLong(i++);
              String fname = stmt.columnString(i++);
              String owner = stmt.columnString(i++);
              String groupowner = stmt.columnString(i++);
              String permissions = stmt.columnString(i++);
              long size = stmt.columnLong(i++);
              String modified = stmt.columnString(i++);
              String path = stmt.columnString(i++);
View Full Code Here

              long schemaid = stmt.columnLong(i++);
              long crawlid = stmt.columnLong(i++);
              String fname = stmt.columnString(i++);
              String owner = stmt.columnString(i++);
              String groupowner = stmt.columnString(i++);
              String permissions = stmt.columnString(i++);
              long size = stmt.columnLong(i++);
              String modified = stmt.columnString(i++);
              String path = stmt.columnString(i++);

              if (ts == null) {
View Full Code Here

              String fname = stmt.columnString(i++);
              String owner = stmt.columnString(i++);
              String groupowner = stmt.columnString(i++);
              String permissions = stmt.columnString(i++);
              long size = stmt.columnLong(i++);
              String modified = stmt.columnString(i++);
              String path = stmt.columnString(i++);

              if (ts == null) {
                ts = new TypeSummary(FSAnalyzer.this, typeid);
                ts.addCachedData(new TypeSummaryData(typeid, typelabel));
View Full Code Here

              String owner = stmt.columnString(i++);
              String groupowner = stmt.columnString(i++);
              String permissions = stmt.columnString(i++);
              long size = stmt.columnLong(i++);
              String modified = stmt.columnString(i++);
              String path = stmt.columnString(i++);

              if (ts == null) {
                ts = new TypeSummary(FSAnalyzer.this, typeid);
                ts.addCachedData(new TypeSummaryData(typeid, typelabel));
                tgslist = new ArrayList<TypeGuessSummary>();
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.