public void BigInsertTest(int RowsNo = 5000)
{
string keyspaceName = "keyspace" + Guid.NewGuid().ToString("N").ToLower();
Randomm rndm = new Randomm(DateTime.Now.Millisecond);
QueryTools.ExecuteSyncNonQuery(Session, string.Format(@"CREATE KEYSPACE {0}
WITH replication = {{ 'class' : 'SimpleStrategy', 'replication_factor' : 1 }};"
, keyspaceName));
string tableName = "table" + Guid.NewGuid().ToString("N").ToLower();
try
{
QueryTools.ExecuteSyncNonQuery(Session, string.Format(@"CREATE TABLE {0}(
tweet_id uuid,
author text,
body text,
isok boolean,
fval float,
dval double,
PRIMARY KEY(tweet_id))", tableName));
}
catch (AlreadyExistsException)
{
}
StringBuilder longQ = new StringBuilder();
longQ.AppendLine("BEGIN BATCH ");
for (int i = 0; i < RowsNo; i++)
{
longQ.AppendFormat(@"INSERT INTO {0} (
tweet_id,
author,
isok,
body,
fval,
dval)
VALUES ({1},'test{2}',{3},'body{2}',{4},{5});", tableName, Guid.NewGuid().ToString(), i, i % 2 == 0 ? "false" : "true", rndm.NextSingle(), rndm.NextDouble());
}
longQ.AppendLine("APPLY BATCH;");
QueryTools.ExecuteSyncNonQuery(Session, longQ.ToString(), "Inserting...");
QueryTools.ExecuteSyncQuery(Session, string.Format(@"SELECT * from {0};", tableName));
QueryTools.ExecuteSyncNonQuery(Session, string.Format(@"DROP TABLE {0};", tableName));
QueryTools.ExecuteSyncNonQuery(Session, string.Format(@"DROP KEYSPACE {0};", keyspaceName));
}
public void BigInsertTest(int RowsNo = 5000)
{
Randomm rndm = new Randomm(DateTime.Now.Millisecond);
string tableName = "table" + Guid.NewGuid().ToString("N").ToLower();
try
{
Session.Cluster.WaitForSchemaAgreement(
QueryTools.ExecuteSyncNonQuery(Session, string.Format(@"CREATE TABLE {0}(
tweet_id uuid,
author text,
body text,
isok boolean,
fval float,
dval double,
PRIMARY KEY(tweet_id))", tableName))
);
}
catch (AlreadyExistsException)
{
}
StringBuilder longQ = new StringBuilder();
longQ.AppendLine("BEGIN BATCH ");
for (int i = 0; i < RowsNo; i++)
{
longQ.AppendFormat(@"INSERT INTO {0} (
tweet_id,
author,
isok,
body,
fval,
dval)
VALUES ({1},'test{2}',{3},'body{2}',{4},{5});", tableName, Guid.NewGuid().ToString(), i, i % 2 == 0 ? "false" : "true", rndm.NextSingle(), rndm.NextDouble());
}
longQ.AppendLine("APPLY BATCH;");
QueryTools.ExecuteSyncNonQuery(Session, longQ.ToString(), "Inserting...");
QueryTools.ExecuteSyncQuery(Session, string.Format(@"SELECT * from {0};", tableName));
QueryTools.ExecuteSyncNonQuery(Session, string.Format(@"DROP TABLE {0};", tableName));
}
