internal DatasetMetadata GetMetadataHelper(string identityId, string datasetName) { string query = DatasetColumns.BuildQuery( DatasetColumns.IDENTITY_ID + " = @identity_id AND " + DatasetColumns.DATASET_NAME + " = @dataset_name " ); DatasetMetadata metadata = null; var stmt = ExecuteQuery(query, identityId, datasetName); try { while (Sqlite3.sqlite3_step(stmt) == Sqlite3.SQLITE_ROW) { metadata = SqliteStmtToDatasetMetadata(stmt); } } finally { if (stmt != null) { Sqlite3.sqlite3_finalize(stmt); } } return(metadata); }
public long GetLastSyncCount(string identityId, string datasetName) { long lastSyncCount = 0; lock (sqlite_lock) { SQLiteStatement stmt = null; try { stmt = db.Prepare( DatasetColumns.BuildQuery( DatasetColumns.IDENTITY_ID + " = @whereIdentityId AND " + DatasetColumns.DATASET_NAME + " = @whereDatasetName" )); stmt.BindText(1, identityId); stmt.BindText(2, datasetName); if (stmt.Read()) { lastSyncCount = stmt.Fields[DatasetColumns.LAST_SYNC_COUNT].INTEGER; } } finally { stmt.FinalizeStm(); } return(lastSyncCount); } }
public List <DatasetMetadata> GetDatasetMetadata(string identityId) { lock (sqlite_lock) { List <DatasetMetadata> datasets = new List <DatasetMetadata>(); SQLiteStatement stmt = null; try { stmt = db.Prepare(DatasetColumns.BuildQuery( DatasetColumns.IDENTITY_ID + " = @whereIdentityId" )); stmt.BindText(1, identityId); while (stmt.Read()) { datasets.Add(this.SqliteStmtToDatasetMetadata(stmt)); } } finally { stmt.FinalizeStm(); } return(datasets); } }
private DatasetMetadata GetMetadataInternal(string identityId, string datasetName) { lock (SQLiteDatabase.SQLiteLock) { SQLiteStatement stmt = null; try { stmt = db.Prepare(DatasetColumns.BuildQuery( DatasetColumns.IDENTITY_ID + " = '" + identityId + "' AND " + DatasetColumns.DATASET_NAME + " = '" + datasetName + "'" )); DatasetMetadata metadata = null; while (stmt.Read()) { metadata = this.SqliteStmtToDatasetMetadata(stmt); } return(metadata); } finally { stmt.FinalizeStm(); } } }
/// <summary> /// Gets a list of dataset's metadata information. /// </summary> /// <returns>a list of dataset metadata</returns> /// <param name="identityId">Identity identifier.</param> /// <exception cref="DataStorageException"></exception> public List <DatasetMetadata> GetDatasetMetadata(string identityId) { lock (sqlite_lock) { string query = DatasetColumns.BuildQuery( DatasetColumns.IDENTITY_ID + " = @whereIdentityId " ); return(GetDatasetMetadataHelper(query, identityId)); } }
/// <summary> /// Retrieves the last sync count. This sync count is a counter that /// represents when the last sync happened. The counter should be updated on /// a successful sync. /// </summary> /// <returns>The last sync count.</returns> /// <param name="identityId">Identity identifier.</param> /// <param name="datasetName">Dataset name.</param> public long GetLastSyncCount(string identityId, string datasetName) { lock (sqlite_lock) { string query = DatasetColumns.BuildQuery( DatasetColumns.IDENTITY_ID + " = @whereIdentityId AND " + DatasetColumns.DATASET_NAME + " = @whereDatasetName " ); return(GetLastSyncCountHelper(query, identityId, datasetName)); } }
internal DatasetMetadata GetMetadataHelper(string identityId, string datasetName) { string query = DatasetColumns.BuildQuery( DatasetColumns.IDENTITY_ID + " = @identity_id AND " + DatasetColumns.DATASET_NAME + " = @dataset_name " ); DatasetMetadata metadata = null; using (var sqliteStatement = connection.Prepare(query)) { BindData(sqliteStatement, identityId, datasetName); while (sqliteStatement.Step() == SQLiteResult.ROW) { metadata = SqliteStmtToDatasetMetadata(sqliteStatement); } } return(metadata); }
internal DatasetMetadata GetMetadataHelper(string identityId, string datasetName) { string query = DatasetColumns.BuildQuery( DatasetColumns.IDENTITY_ID + " = @identityId AND " + DatasetColumns.DATASET_NAME + " = @datasetName " ); DatasetMetadata metadata = null; using (var command = new SQLiteCommand(connection)) { command.CommandText = query; BindData(command, identityId, datasetName); using (var reader = command.ExecuteReader()) { if (reader.HasRows && reader.Read()) { metadata = SqliteStmtToDatasetMetadata(reader); } } } return(metadata); }
internal DatasetMetadata GetMetadataHelper(string identityId, string datasetName) { string query = DatasetColumns.BuildQuery( DatasetColumns.IDENTITY_ID + " = @identityId AND " + DatasetColumns.DATASET_NAME + " = @datasetName " ); DatasetMetadata metadata = null; try { connection = new SqliteConnection("URI=file:" + filePath); connection.Open(); using (var command = new SqliteCommand(connection)) { command.CommandText = query; BindData(command, identityId, datasetName); using (var reader = command.ExecuteReader()) { if (reader.HasRows && reader.Read()) { metadata = DatasetMetadataFromReader(reader); } } } } finally { if (connection != null) { connection.Close(); connection.Dispose(); } } return(metadata); }