/// <summary>
/// Second part of the integration test.
/// </summary>
/// <remarks>
/// Due to some issues running 2 Cassandra containers, one after the other,
/// in the same test context, we merge the integration tests to only use one container.
/// My guess, a possible Cassandra driver issue.
/// </remarks>
public static void Run_all_Cassandra_integration_tests_work(CassandraFixture dbContainer)
{
// Arrange
var cnn = dbContainer.CreateDbConnection();
var wcnn = new WrappedConnection(cnn).AssertDatabaseServerType(DBMS.Cassandra);
var db = DatabaseHelperFactory.GetDatabaseHelper(DBMS.Cassandra, wcnn);
string keyspaceName = "my_keyspace_2";
Schema keyspace = new CassandraKeyspace(keyspaceName, CassandraKeyspace.CreateSimpleStrategy(1), wcnn);
// Assert
keyspace.AssertIsNotExists();
keyspace.AssertCreation();
keyspace.AssertExists();
keyspace.AssertIsEmpty();
//Lock & Unlock
//..Applicaiton level: return true if the cluster lock keyspace/table is not present
Assert.True(db.TryAcquireApplicationLock());
wcnn.ExecuteNonQuery("create keyspace cluster_lock with replication = { 'class' : 'SimpleStrategy','replication_factor' : '1' }; ");
Assert.True(db.TryAcquireApplicationLock()); //Still true, table is missing
wcnn.ExecuteNonQuery("create table cluster_lock.lock (locked int, primary key(locked))");
Assert.True(db.TryAcquireApplicationLock()); //Still true, lock is not present
wcnn.ExecuteNonQuery("insert into cluster_lock.lock (locked) values (1) using TTL 3600");
Assert.False(db.TryAcquireApplicationLock());
wcnn.ExecuteNonQuery("drop keyspace cluster_lock");
Assert.True(db.TryAcquireApplicationLock());
Assert.True(db.ReleaseApplicationLock());
Assert.True(db.ReleaseApplicationLock());
db.AssertMetadataTableCreation(keyspaceName, "evolve_change_log")
.AssertMetadataTableLockEx() //..Table level: lock implemented with LWT on evolve metadata table
.AssertSchemaIsDroppableWhenNewSchemaFound(keyspaceName)
.AssertVersionedMigrationSave()
//.AssertVersionedMigrationChecksumUpdate()
.AssertRepeatableMigrationSave();
keyspace.AssertIsNotEmpty();
keyspace.Erase();
keyspace.AssertIsEmpty();
keyspace.Drop();
keyspace.AssertIsNotExists();
db.AssertCloseConnection();
}