public void PurgeDataset(string identityId, string datasetName)
{
lock (sqlite_lock)
{
this.DeleteDataset(identityId, datasetName);
SQLiteStatement stmt = null;
try
{
stmt = db.Prepare(
DatasetColumns.BuildDelete(
DatasetColumns.IDENTITY_ID + " = @whereIdentityId AND " +
DatasetColumns.DATASET_NAME + " = @whereDatasetName"
));
stmt.BindText(1, identityId);
stmt.BindText(2, datasetName);
stmt.Step();
}
finally
{
stmt.FinalizeStm();
}
}
}
public void WipeData()
{
lock (sqlite_lock)
{
db.Exec(DatasetColumns.BuildDelete(null));
db.Exec(RecordColumns.BuildDelete(null));
}
}
public override void WipeData()
{
lock (SQLiteDatabase.SQLiteLock)
{
db.Exec(DatasetColumns.BuildDelete(null));
db.Exec(RecordColumns.BuildDelete(null));
}
}
/// <summary>
/// Wipes all locally cached data including dataset metadata and records. All
/// opened dataset handler should not perform further operations to avoid
/// inconsistent state.
/// </summary>
public void WipeData()
{
lock (sqlite_lock)
{
string query1 = DatasetColumns.BuildDelete(null);
string query2 = RecordColumns.BuildDelete(null);
ExecuteMultipleHelper(new List <Statement>()
{
new Statement {
Query = query1
}, new Statement {
Query = query2
}
});
}
}
/// <summary>
/// This is different from <see cref="DeleteDataset(String,String)"/>. Not only does it
/// clears all records in the dataset, it also remove it from metadata table.
/// It won't be visible in <see cref="GetDatasetMetadata(String,String)"/>.
/// </summary>
/// <param name="identityId">Identity identifier.</param>
/// <param name="datasetName">Dataset name.</param>
public void PurgeDataset(string identityId, string datasetName)
{
lock (sqlite_lock)
{
string query = DatasetColumns.BuildDelete(
DatasetColumns.IDENTITY_ID + " = @whereIdentityId AND " +
DatasetColumns.DATASET_NAME + " = @whereDatasetName "
);
Statement s1 = new Statement
{
Query = query,
Parameters = new string[] { identityId, datasetName }
};
DeleteDataset(identityId, datasetName, new List <Statement>()
{
s1
});
}
}
