private static Record SqliteStmtToRecord(ISQLiteStatement stmt) { return(new Record(stmt.GetText(RecordColumns.KEY), stmt.DataType(RecordColumns.VALUE) == SQLiteType.NULL ? null : stmt.GetText(RecordColumns.VALUE), stmt.GetInteger(RecordColumns.SYNC_COUNT), new DateTime(long.Parse(stmt.GetText(RecordColumns.LAST_MODIFIED_TIMESTAMP), CultureInfo.InvariantCulture.NumberFormat), DateTimeKind.Utc), stmt.DataType(RecordColumns.LAST_MODIFIED_BY) == SQLiteType.NULL ? string.Empty : stmt.GetText(RecordColumns.LAST_MODIFIED_BY), new DateTime(long.Parse(stmt.GetText(RecordColumns.DEVICE_LAST_MODIFIED_TIMESTAMP), CultureInfo.InvariantCulture.NumberFormat), DateTimeKind.Utc), stmt.GetInteger(RecordColumns.MODIFIED) == 1)); }
private static DatasetMetadata SqliteStmtToDatasetMetadata(ISQLiteStatement stmt) { return(new DatasetMetadata( stmt.DataType(RecordColumns.DATASET_NAME) == SQLiteType.NULL ? string.Empty : stmt.GetText(DatasetColumns.DATASET_NAME), new DateTime(long.Parse(stmt.GetText(DatasetColumns.CREATION_TIMESTAMP))), new DateTime(long.Parse(stmt.GetText(DatasetColumns.LAST_MODIFIED_TIMESTAMP))), stmt.DataType(DatasetColumns.LAST_MODIFIED_BY) == SQLiteType.NULL ? string.Empty : stmt.GetText(DatasetColumns.LAST_MODIFIED_BY), stmt.GetInteger(DatasetColumns.STORAGE_SIZE_BYTES), stmt.GetInteger(DatasetColumns.RECORD_COUNT) )); }
public List <GV.DATA_INFO_STRING> GetDataRecord(SQLiteConnection conn, string sql) { List <GV.DATA_INFO_STRING> entries = new List <GV.DATA_INFO_STRING>(); using (ISQLiteStatement dbState = GV.connection.Prepare(sql)) { while (dbState.Step() == SQLiteResult.ROW) { entries.Add( new GV.DATA_INFO_STRING { Key = dbState.GetInteger(0), ID = dbState.GetText(1), EventType = dbState.GetText(2), EventTime = dbState.GetText(3), Cadence = dbState.GetText(4), Power = dbState.GetText(5), Resistance = dbState.GetText(6), HandleP = dbState.GetText(7), SaddleP = dbState.GetText(8), PedalLeftP = dbState.GetText(9), PedalLeftAcc = dbState.GetText(10), PeadlLeftGyro = dbState.GetText(11), PeadlRightP = dbState.GetText(12), PedalRightAcc = dbState.GetText(13), PeadlRightGyro = dbState.GetText(14), CrankAcc = dbState.GetText(15), CrankGyro = dbState.GetText(16) }); } } return(entries.ToList <GV.DATA_INFO_STRING>()); }
public long LookupSoupEntryId(string soupName, string fieldPath, string fieldValue) { lock (smartlock) { DBHelper db = Database; string soupTableName = db.GetSoupTableName(soupName); if (String.IsNullOrWhiteSpace(soupTableName)) { throw new SmartStoreException("Soup: " + soupName + " does not exist"); } string columnName = db.GetColumnNameForPath(soupName, fieldPath); using (ISQLiteStatement statement = db.Query(soupTableName, new[] { IdCol }, String.Empty, String.Empty, columnName + " = ?", fieldValue)) { if (statement.DataCount > 1) { throw new SmartStoreException(String.Format( "There are more than one soup elements where {0} is {1}", fieldPath, fieldValue)); } if (statement.DataCount == 1) { return(statement.GetInteger(0)); } } return(-1); // not found } }
/// <summary> /// 조회된 한 로우에 대한 데이터를 생성한다. /// </summary> /// <param name="stmt">DB 구문 객체</param> /// <returns>파일 정보</returns> private StorageItemInfo GetRowData(ISQLiteStatement stmt) { return(new StorageItemInfo() { Path = stmt.GetText("PATH"), SubType = (SubType)stmt.GetInteger("FOLDER_TYPE"), Name = stmt.GetText("NAME"), RootPath = stmt.GetText("ROOT_PATH"), FalToken = stmt.GetText2("FAL_TOKEN") }); }
/// <summary> /// 조회된 한 로우에 대한 데이터를 생성한다. /// </summary> /// <param name="stmt">DB 구문 객체</param> /// <returns>파일 정보</returns> private FolderInfo GetRowData(ISQLiteStatement stmt) { return(new FolderInfo() { Type = (FolderType)stmt.GetInteger("FOLDER_TYPE"), Level = stmt.GetInteger2("LEVEL"), Name = stmt.GetText("NAME"), Path = stmt.GetText("PATH"), FalToken = stmt.GetText2("FAL_TOKEN"), Passcode = stmt.GetText2("PASSCODE") }); }
private string GetSoupTableNameFromDb(string soupName) { using ( ISQLiteStatement stmt = Query(SmartStore.SoupNamesTable, new[] { SmartStore.IdCol }, String.Empty, String.Empty, SmartStore.SoupNamePredicate, soupName)) { if (stmt.DataCount == 0) { return(null); } return(SmartStore.GetSoupTableName(stmt.GetInteger(SmartStore.IdCol))); } }
public long GetNextId(string tableName) { using (ISQLiteStatement prog = _sqlConnection.Prepare((SeqSelect))) { prog.Bind(1, tableName); SQLiteResult result = prog.Step(); long data = 0; if (prog.DataCount > 0) { data = prog.GetInteger(0); } return(data + 1); } }
public long CountRawCountQuery(string countSql, params string[] args) { using (ISQLiteStatement prog = _sqlConnection.Prepare((countSql))) { if (args != null) { for (int i = 0; i < args.Length; i++) { prog.Bind(i + 1, args[i]); } } SQLiteResult result = prog.Step(); if (result == SQLiteResult.ROW) { return(prog.GetInteger(0)); } } return(0); }
/// <summary> /// Helper to retrieve data. /// </summary> /// <param name="statement"></param> /// <param name="position"></param> /// <returns></returns> private object GetObject(ISQLiteStatement statement, int position) { try { return(statement.GetText(position)); } catch (Exception) { } try { return(statement.GetInteger(position)); } catch (Exception) { } try { return(statement.GetFloat(position)); } catch (Exception) { } return(null); }
/// <summary> /// Helper to retrieve data. /// </summary> /// <param name="statement"></param> /// <param name="position"></param> /// <returns></returns> private object GetObject(ISQLiteStatement statement, int position) { try { return statement.GetText(position); } catch (Exception) { } try { return statement.GetInteger(position); } catch (Exception) { } try { return statement.GetFloat(position); } catch (Exception) { } return null; }
private static Record SqliteStmtToRecord(ISQLiteStatement stmt) { return new Record(stmt.GetText(RecordColumns.KEY), stmt.GetText(RecordColumns.VALUE), stmt.GetInteger(RecordColumns.SYNC_COUNT), new DateTime(long.Parse(stmt.GetText(RecordColumns.LAST_MODIFIED_TIMESTAMP))), stmt.DataType(RecordColumns.LAST_MODIFIED_BY) == SQLiteType.NULL ? string.Empty : stmt.GetText(RecordColumns.LAST_MODIFIED_BY), new DateTime(long.Parse(stmt.GetText(RecordColumns.DEVICE_LAST_MODIFIED_TIMESTAMP))), stmt.GetInteger(RecordColumns.MODIFIED) == 1); }
private static DatasetMetadata SqliteStmtToDatasetMetadata(ISQLiteStatement stmt) { return new DatasetMetadata( stmt.DataType(RecordColumns.DATASET_NAME) == SQLiteType.NULL ?string.Empty:stmt.GetText(DatasetColumns.DATASET_NAME), new DateTime(long.Parse(stmt.GetText(DatasetColumns.CREATION_TIMESTAMP))), new DateTime(long.Parse(stmt.GetText(DatasetColumns.LAST_MODIFIED_TIMESTAMP))), stmt.DataType(DatasetColumns.LAST_MODIFIED_BY) == SQLiteType.NULL ? string.Empty : stmt.GetText(DatasetColumns.LAST_MODIFIED_BY), stmt.GetInteger(DatasetColumns.STORAGE_SIZE_BYTES), stmt.GetInteger(DatasetColumns.RECORD_COUNT) ); }