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);
}
