public ValueTask <int> DeleteByPathAsync(IDbTransaction transaction, string path) { return(transaction.ExecuteNonQueryAsync( () => DeleteByPathCommand, $"{nameof(DatabaseTable)}/{nameof(DeleteByPathCommand)}/{TableName}", path)); }
/// <summary> /// TODO: use sqlite returning statement. /// https://github.com/ericsink/SQLitePCL.raw/issues/416. /// </summary> /// <param name="transaction">The transaction.</param> /// <param name="startsWith">The start string to deleted.</param> public ValueTask <int> DeleteByStartsWithAsync(IDbTransaction transaction, string startsWith) { return(transaction.ExecuteNonQueryAsync( () => DeleteByStartsWithPathCommand, $"{nameof(DatabaseTable)}/{nameof(DeleteByStartsWithPathCommand)}/{TableName}", SqliteTransaction.EscapeLikeContent(startsWith) + "%")); }
public async ValueTask <bool> DeletePropertyOnFileUpdated(IDbTransaction transaction, long target) { return(await transaction.ExecuteNonQueryAsync( () => DeletePropertyByTargetAndFeatureCommand, $"{nameof(DatabaseTable)}/{nameof(DeletePropertyByTargetAndFeatureCommand)}/{TableName}", target, PropertyFeature.AutoDeleteWhenFileUpdate) != 0); }
public async ValueTask <bool> DeleteProperty(IDbTransaction transaction, long target, string key) { return(await transaction.ExecuteNonQueryAsync( () => DeletePropertyByTargetAndKeyCommand, $"{nameof(DatabaseTable)}/{nameof(DeletePropertyByTargetAndKeyCommand)}/{TableName}", target, key) != 0); }
public ValueTask <int> UpdateStatsByIdAsync( IDbTransaction transaction, long id, string contentTag) { return(transaction.ExecuteNonQueryAsync( () => UpdateStatsByIdCommand, $"{nameof(DatabaseTable)}/{nameof(UpdateStatsByIdCommand)}/{TableName}", id, contentTag)); }