public void ExecuteNonQueryInsertAndSelectTest() { _connection.Open(); var cmd = _connection.CreateCommand(); string keyspaceName = "keyspace_ado_1"; cmd.CommandText = string.Format(TestUtils.CREATE_KEYSPACE_SIMPLE_FORMAT, keyspaceName, 3); cmd.ExecuteNonQuery(); _connection.ChangeDatabase(keyspaceName); string tableName = "table_ado_1"; cmd.CommandText = string.Format(@" CREATE TABLE {0}( tweet_id uuid, author text, body text, isok boolean, PRIMARY KEY(tweet_id))", tableName); cmd.ExecuteNonQuery(); var longQ = new StringBuilder(); longQ.AppendLine("BEGIN BATCH "); int RowsNo = 300; for (int i = 0; i < RowsNo; i++) { longQ.AppendFormat(@" INSERT INTO {0} (tweet_id, author, isok, body) VALUES ({1},'test{2}',{3},'body{2}');", tableName, Guid.NewGuid(), i, i % 2 == 0 ? "false" : "true"); } longQ.AppendLine("APPLY BATCH;"); cmd.CommandText = longQ.ToString(); cmd.ExecuteNonQuery(); cmd.CommandText = string.Format(@"SELECT * from {0} LIMIT 10000;", tableName); var reader = cmd.ExecuteReader(); var counter = 0; while (reader.Read()) { Assert.AreEqual(4, reader.FieldCount); counter++; } Assert.AreEqual(RowsNo, counter); cmd.CommandText = string.Format(@"DROP TABLE {0};", tableName); cmd.ExecuteNonQuery(); cmd.CommandText = string.Format(@"DROP KEYSPACE {0};", keyspaceName); cmd.ExecuteNonQuery(); }
public void CommandExecuteReaderUsesSyncExecute() { var connection = new CqlConnection(); var sessionMock = new Mock <ISession>(); var rowset = new RowSet(); sessionMock .Setup(s => s.Execute(It.IsAny <string>(), It.IsAny <ConsistencyLevel>())) .Returns(rowset) .Verifiable(); connection.ManagedConnection = sessionMock.Object; var cmd = (CqlCommand)connection.CreateCommand(); cmd.CommandText = "INSERT INTO dummy_cf (a,b) VALUES (1,2)"; var reader = cmd.ExecuteReader(); reader.Dispose(); sessionMock.Verify(); }
public void complexTest() { connection.Open(); var cmd = connection.CreateCommand(); string keyspaceName = "keyspace" + Guid.NewGuid().ToString("N").ToLower(); cmd.CommandText = string.Format(@"CREATE KEYSPACE {0} WITH replication = {{ 'class' : 'SimpleStrategy', 'replication_factor' : 1 }};" , keyspaceName); cmd.ExecuteNonQuery(); connection.ChangeDatabase(keyspaceName); string tableName = "table" + Guid.NewGuid().ToString("N").ToLower(); cmd.CommandText = string.Format(@"CREATE TABLE {0}( tweet_id uuid, author text, body text, isok boolean, PRIMARY KEY(tweet_id))", tableName); cmd.ExecuteNonQuery(); StringBuilder longQ = new StringBuilder(); longQ.AppendLine("BEGIN BATCH "); int RowsNo = 2000; for (int i = 0; i < RowsNo; i++) { longQ.AppendFormat(@"INSERT INTO {0} ( tweet_id, author, isok, body) VALUES ({1},'test{2}',{3},'body{2}');", tableName, Guid.NewGuid().ToString(), i, i % 2 == 0 ? "false" : "true"); } longQ.AppendLine("APPLY BATCH;"); cmd.CommandText = longQ.ToString(); cmd.ExecuteNonQuery(); cmd.CommandText = string.Format(@"SELECT * from {0} LIMIT 10000;", tableName); var reader = cmd.ExecuteReader(); while (reader.Read()) { for (int i = 0; i < reader.FieldCount; i++) { Console.Write(reader.GetValue(i).ToString() + "|"); } Console.WriteLine(); } cmd.CommandText = string.Format(@"DROP TABLE {0};", tableName); cmd.ExecuteNonQuery(); cmd.CommandText = string.Format(@"DROP KEYSPACE {0};", keyspaceName); cmd.ExecuteNonQuery(); }
public void ExecuteNonQueryInsertAndSelectTest() { _connection.Open(); var cmd = _connection.CreateCommand(); string keyspaceName = "keyspace_ado_1"; cmd.CommandText = string.Format(TestUtils.CreateKeyspaceSimpleFormat, keyspaceName, 3); cmd.ExecuteNonQuery(); VerifyStatement( QueryType.Query, $"CREATE KEYSPACE \"{keyspaceName}\" WITH replication = {{ 'class' : 'SimpleStrategy', 'replication_factor' : {3} }}", 1); _connection.ChangeDatabase(keyspaceName); VerifyStatement(QueryType.Query, $"USE \"{keyspaceName}\"", 1); string tableName = "table_ado_1"; cmd.CommandText = string.Format("CREATE TABLE {0} (tweet_id uuid,author text,body text,isok boolean,PRIMARY KEY(tweet_id))", tableName); cmd.ExecuteNonQuery(); VerifyStatement( QueryType.Query, $"CREATE TABLE {tableName} (tweet_id uuid,author text,body text,isok boolean,PRIMARY KEY(tweet_id))", 1); var longQ = new StringBuilder(); longQ.AppendLine("BEGIN BATCH "); var guids = Enumerable.Range(0, 300).Select(i => Guid.NewGuid()).ToArray(); int RowsNo = 300; for (int i = 0; i < RowsNo; i++) { longQ.AppendFormat("INSERT INTO {0} (tweet_id, author, isok, body) VALUES ({1},'test{2}',{3},'body{2}');", tableName, guids[i], i, i % 2 == 0 ? "false" : "true"); } longQ.AppendLine("APPLY BATCH;"); cmd.CommandText = longQ.ToString(); cmd.ExecuteNonQuery(); VerifyStatement( QueryType.Query, longQ.ToString(), 1); TestCluster.PrimeFluent( b => b.WhenQuery($"SELECT * from {tableName} LIMIT 10000;") .ThenRowsSuccess( new[] { "tweet_id", "author", "body", "isok" }, r => r.WithRows(guids.Select((guid, idx) => new object[] { guid, $"test{idx}", $"body{idx}", idx % 2 != 0 }).ToArray()))); cmd.CommandText = string.Format(@"SELECT * from {0} LIMIT 10000;", tableName); var reader = cmd.ExecuteReader(); var counter = 0; while (reader.Read()) { Assert.AreEqual(4, reader.FieldCount); counter++; } Assert.AreEqual(RowsNo, counter); }