public static void Init(TestContext context) { const string createKsCql = @"CREATE KEYSPACE Test WITH replication = {'class': 'SimpleStrategy', 'replication_factor' : 1} and durable_writes = 'false';"; const string createTableCql = @"create table Test.BasicFlow (id int primary key, value text, ignored text);"; using(var connection = new CqlConnection(ConnectionString)) { connection.SetConnectionTimeout(0); connection.Open(); try { var createKs = new CqlCommand(connection, createKsCql); createKs.ExecuteNonQuery(); } catch(AlreadyExistsException) { //ignore } try { var createTable = new CqlCommand(connection, createTableCql); createTable.ExecuteNonQuery(); } catch(AlreadyExistsException) { } } }
public static void Init(TestContext context) { const string createConnection = "Server=localhost;username=cassandra;password=cassandra"; const string createKsCql = @"CREATE KEYSPACE LinqTest WITH replication = {'class': 'SimpleStrategy', 'replication_factor' : 1} and durable_writes = 'false';"; const string createTableCql = @"create table linqtest.myvalue (id int primary key, value text, ignored text);"; using (var connection = new CqlConnection(createConnection)) { connection.SetConnectionTimeout(0); connection.Open(); try { var createKs = new CqlCommand(connection, createKsCql); createKs.ExecuteNonQuery(); var createTable = new CqlCommand(connection, createTableCql); createTable.ExecuteNonQuery(); using (var transaction = connection.BeginTransaction()) { transaction.BatchType = CqlBatchType.Unlogged; var insert = new CqlCommand(connection, "insert into linqtest.myvalue (id,value) values(?,?)"); insert.Transaction = transaction; insert.Prepare(); for (int i = 0; i < 10000; i++) { insert.Parameters[0].Value = i; insert.Parameters[1].Value = "Hallo " + i; insert.ExecuteNonQuery(); } transaction.Commit(); } } catch (AlreadyExistsException) { //ignore } } CqlConnection.Shutdown(createConnection); }
public static void Init(TestContext context) { const string createKsCql = @"CREATE KEYSPACE TestUDT WITH replication = {'class': 'SimpleStrategy', 'replication_factor' : 1} and durable_writes = 'false';"; const string createAddressType = @"create type TestUDT.TAddress (street text, number int);"; const string createUserType = @"CREATE type TestUDT.TUser (name text, password blob, address frozen<TAddress>, phones list<text>);"; const string createTableCql = @"create table TestUDT.Members (id int primary key, user frozen<TUser>, comment frozen<tuple<text,text>>);"; const string createTable2Cql = @"create table TestUDT.Groups (id int primary key, members set<frozen<tuple<int, frozen<TUser>>>>);"; using(var connection = new CqlConnection(ConnectionString)) { connection.SetConnectionTimeout(0); connection.Open(); Cassandra210OrUp = string.CompareOrdinal(connection.ServerVersion, "2.1.0") >= 0; if(!Cassandra210OrUp) return; try { var createKs = new CqlCommand(connection, createKsCql); createKs.ExecuteNonQuery(); var createAddress = new CqlCommand(connection, createAddressType); createAddress.ExecuteNonQuery(); var createUser = new CqlCommand(connection, createUserType); createUser.ExecuteNonQuery(); var createTable = new CqlCommand(connection, createTableCql); createTable.ExecuteNonQuery(); var createTable2 = new CqlCommand(connection, createTable2Cql); createTable2.ExecuteNonQuery(); } catch(AlreadyExistsException) { } } }