List of columnLong() Examples

Examples of columnLong()

com.almworks.sqlite4java.SQLiteStatement.columnLong()
g/c3ref/column_blob.html">sqlite3_column_int64

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

        protected Long job(SQLiteConnection db) throws SQLiteException {
          SQLiteStatement stmt = db.prepare("SELECT fsid FROM Filesystems WHERE fsname = ?");
          try {
            stmt.bind(1, fsuri.toString());
            if (stmt.step()) {
              long resultId = stmt.columnLong(0);
              return resultId;
            } else {
              return -1L;
            }
          } finally {

View Full Code Here

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

          protected Long job(SQLiteConnection db) throws SQLiteException {
            SQLiteStatement stmt = db.prepare("SELECT crawlid from Crawls WHERE fsid = ? AND inprogress = 'True'");
            try {
              stmt.bind(1, fsid);
              if (stmt.step()) {
                return stmt.columnLong(0);
              } else {
                return -1L;
              }
            } finally {
              stmt.dispose();

View Full Code Here

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

        protected Long job(SQLiteConnection db) throws SQLiteException {
          SQLiteStatement stmt = db.prepare("SELECT crawlid from Crawls WHERE fsid = ? AND inprogress = 'False' ORDER BY crawlid DESC LIMIT 1");
          try {
            stmt.bind(1, fsid);
            if (stmt.step()) {
              return stmt.columnLong(0);
            } else {
              return -1L;
            }
          } finally {
            stmt.dispose();

View Full Code Here

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

        protected Long job(SQLiteConnection db) throws SQLiteException {
          SQLiteStatement stmt = db.prepare("SELECT typeid FROM Types WHERE typelabel = ?");
          try {
            stmt.bind(1, typeLabel);
            if (stmt.step()) {
              long resultId = stmt.columnLong(0);
              return resultId;
            } else {
              return -1L;
            }
          } finally {

View Full Code Here

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

        protected Long job(SQLiteConnection db) throws SQLiteException {
          final SQLiteStatement stmt = db.prepare("SELECT schemaid FROM Schemas WHERE schemarepr = ? AND schemasrcdescription = ?");
          try {
            stmt.bind(1, schemaIdentifier).bind(2, schemaDesc);
            if (stmt.step()) {
              long resultId = stmt.columnLong(0);
              return resultId;
            } else {
              return -1L;
            }
          } finally {

View Full Code Here

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

          List<SchemaSummary> output = new ArrayList<SchemaSummary>();          
          SQLiteStatement stmt = db.prepare(schemaInfoQuery);
          
          try {
            while (stmt.step()) {
              long schemaId = stmt.columnLong(0);
              output.add(new SchemaSummary(FSAnalyzer.this, schemaId));
            }
          } catch (SQLiteException se) {
            se.printStackTrace();
          } finally {

View Full Code Here

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

            SchemaSummaryData ssd = null;
            SchemaSummary ss = null;
            long lastSchemaId = -1L;
            List<TypeGuessSummary> tgslist = null;
            while (stmt.step()) {
              long schemaid = stmt.columnLong(0);
              String schemarepr = stmt.columnString(1);
              String schemasrcdescription = stmt.columnString(2);
              long fid = stmt.columnLong(3);
              long typeid = stmt.columnLong(4);
              long crawlid = stmt.columnLong(5);

View Full Code Here

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

            List<TypeGuessSummary> tgslist = null;
            while (stmt.step()) {
              long schemaid = stmt.columnLong(0);
              String schemarepr = stmt.columnString(1);
              String schemasrcdescription = stmt.columnString(2);
              long fid = stmt.columnLong(3);
              long typeid = stmt.columnLong(4);
              long crawlid = stmt.columnLong(5);
              String fname = stmt.columnString(6);
              String owner = stmt.columnString(7);
              String groupowner = stmt.columnString(8);

View Full Code Here

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

            while (stmt.step()) {
              long schemaid = stmt.columnLong(0);
              String schemarepr = stmt.columnString(1);
              String schemasrcdescription = stmt.columnString(2);
              long fid = stmt.columnLong(3);
              long typeid = stmt.columnLong(4);
              long crawlid = stmt.columnLong(5);
              String fname = stmt.columnString(6);
              String owner = stmt.columnString(7);
              String groupowner = stmt.columnString(8);
              String permissions = stmt.columnString(9);

View Full Code Here

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

              long schemaid = stmt.columnLong(0);
              String schemarepr = stmt.columnString(1);
              String schemasrcdescription = stmt.columnString(2);
              long fid = stmt.columnLong(3);
              long typeid = stmt.columnLong(4);
              long crawlid = stmt.columnLong(5);
              String fname = stmt.columnString(6);
              String owner = stmt.columnString(7);
              String groupowner = stmt.columnString(8);
              String permissions = stmt.columnString(9);
              long size = stmt.columnLong(10);

View Full Code Here

0 1 2 3 4

TOP

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.