public void Delete_Poco_NoPrimaryKey()
{
// Get an existing user from the DB that doesn't have a PK attribute defined on the POCO (i.e. InsertUser class)
Guid userId = TestDataHelper.Users[3].UserId;
var userToDelete = CqlClient.Single <InsertUser>("WHERE userid = ?", userId);
userToDelete.Should().NotBeNull();
Action deleteUser = () => CqlClient.Delete(userToDelete);
deleteUser.ShouldThrow <InvalidOperationException>("no PK was specified and the assumed PK of 'id' is not a column on the POCO");
}
public void Delete_Poco_WithCql()
{
// Pick an existing user from the DB and verify they currently exist (sanity check)
Guid userId = TestDataHelper.Users[5].UserId;
var userToDelete = CqlClient.Single <UserWithPrimaryKeyDecoration>("WHERE userid = ?", userId);
userToDelete.Should().NotBeNull();
// Delete using CQL string (no POCO passed here, just CQL + params)
CqlClient.Delete <UserWithPrimaryKeyDecoration>("WHERE userid = ?", userId);
// Verify user is actually deleted
var foundUser = CqlClient.SingleOrDefault <UserWithPrimaryKeyDecoration>("WHERE userid = ?", userId);
foundUser.Should().BeNull();
}
public void Delete_Poco()
{
// Get an existing user from the DB
Guid userId = TestDataHelper.Users[1].UserId;
var userToDelete = CqlClient.Single <UserWithPrimaryKeyDecoration>("WHERE userid = ?", userId);
userToDelete.Should().NotBeNull();
// Delete
CqlClient.Delete(userToDelete);
// Verify user is gone
var foundUser = CqlClient.SingleOrDefault <UserWithPrimaryKeyDecoration>("WHERE userid = ?", userId);
foundUser.Should().BeNull();
}