public void insertingSingleValuePrepared(Type tp)
{
string cassandraDataTypeName = QueryTools.convertTypeNameToCassandraEquivalent(tp);
string tableName = "table" + Guid.NewGuid().ToString("N");
Session.Cluster.WaitForSchemaAgreement(
QueryTools.ExecuteSyncNonQuery(Session, string.Format(@"CREATE TABLE {0}(
tweet_id uuid PRIMARY KEY,
value {1}
);", tableName, cassandraDataTypeName))
);
List <object[]> toInsert = new List <object[]>(1);
var val = Randomm.RandomVal(tp);
if (tp == typeof(string))
{
val = "'" + val.ToString().Replace("'", "''") + "'";
}
var row1 = new object[2] {
Guid.NewGuid(), val
};
toInsert.Add(row1);
var prep = QueryTools.PrepareQuery(this.Session, string.Format("INSERT INTO {0}(tweet_id, value) VALUES ({1}, ?);", tableName, toInsert[0][0].ToString()));
QueryTools.ExecutePreparedQuery(this.Session, prep, new object[1] {
toInsert[0][1]
});
QueryTools.ExecuteSyncQuery(Session, string.Format("SELECT * FROM {0};", tableName), toInsert);
QueryTools.ExecuteSyncNonQuery(Session, string.Format("DROP TABLE {0};", tableName));
}
public void testCounters()
{
string tableName = "table" + Guid.NewGuid().ToString("N");
try
{
Session.Cluster.WaitForSchemaAgreement(QueryTools.ExecuteSyncNonQuery(Session, string.Format(@"CREATE TABLE {0}(
tweet_id uuid PRIMARY KEY,
incdec counter
);", tableName)));
}
catch (AlreadyExistsException)
{
}
Guid tweet_id = Guid.NewGuid();
Parallel.For(0, 100, i =>
{
QueryTools.ExecuteSyncNonQuery(Session, string.Format(@"UPDATE {0} SET incdec = incdec {2} WHERE tweet_id = {1};", tableName, tweet_id, (i % 2 == 0 ? "-" : "+") + i));
});
QueryTools.ExecuteSyncQuery(Session, string.Format("SELECT * FROM {0};", tableName), new List <object[]> {
new object[2] {
tweet_id, (Int64)50
}
});
QueryTools.ExecuteSyncNonQuery(Session, string.Format("DROP TABLE {0};", tableName));
}
public void createSecondaryIndexTest()
{
string tableName = "table" + Guid.NewGuid().ToString("N").ToLower();
string columns = "tweet_id uuid, name text, surname text";
try
{
Session.Cluster.WaitForSchemaAgreement(
QueryTools.ExecuteSyncNonQuery(Session, string.Format(@"CREATE TABLE {0}(
{1},
PRIMARY KEY(tweet_id)
);", tableName, columns))
);
}
catch (AlreadyExistsException)
{
}
object[] row1 = new object[3] {
Guid.NewGuid(), "Adam", "Małysz"
};
object[] row2 = new object[3] {
Guid.NewGuid(), "Adam", "Miałczyński"
};
List <object[]> toReturn = new List <object[]>(2)
{
row1, row2
};
List <object[]> toInsert = new List <object[]>(2)
{
row1, row2
};
QueryTools.ExecuteSyncNonQuery(Session, string.Format("INSERT INTO {0}(tweet_id, name, surname) VALUES({1},'{2}','{3}');", tableName, toInsert[0][0], toInsert[0][1], toInsert[0][2]));
QueryTools.ExecuteSyncNonQuery(Session, string.Format("INSERT INTO {0}(tweet_id, name, surname) VALUES({1},'{2}','{3}');", tableName, toInsert[1][0], toInsert[1][1], toInsert[1][2]));
int RowsNb = 0;
for (int i = 0; i < RowsNb; i++)
{
toInsert.Add(new object[3] {
Guid.NewGuid(), i.ToString(), "Miałczyński"
});
QueryTools.ExecuteSyncNonQuery(Session, string.Format("INSERT INTO {0}(tweet_id, name, surname) VALUES({1},'{2}','{3}');", tableName, toInsert[i][0], toInsert[i][1], toInsert[i][2]));
}
Session.Cluster.WaitForSchemaAgreement(
QueryTools.ExecuteSyncNonQuery(Session, string.Format("CREATE INDEX ON {0}(name);", tableName))
);
Thread.Sleep(2000);
QueryTools.ExecuteSyncQuery(Session, string.Format("SELECT * FROM {0} WHERE name = 'Adam';", tableName), toReturn);
QueryTools.ExecuteSyncNonQuery(Session, string.Format("DROP TABLE {0};", tableName));
}
public void insertingSingleValue(Type tp)
{
string cassandraDataTypeName = QueryTools.convertTypeNameToCassandraEquivalent(tp);
string tableName = "table" + Guid.NewGuid().ToString("N").ToLower();
try
{
Session.Cluster.WaitForSchemaAgreement(
QueryTools.ExecuteSyncNonQuery(Session, string.Format(@"CREATE TABLE {0}(
tweet_id uuid PRIMARY KEY,
value {1}
);", tableName, cassandraDataTypeName)));
}
catch (AlreadyExistsException)
{
}
List <object[]> toInsert = new List <object[]>(1);
var val = Randomm.RandomVal(tp);
if (tp == typeof(string))
{
val = "'" + val.ToString().Replace("'", "''") + "'";
}
object[] row1 = new object[2] {
Guid.NewGuid(), val
};
toInsert.Add(row1);
bool isFloatingPoint = false;
if (row1[1].GetType() == typeof(string) || row1[1].GetType() == typeof(byte[]))
{
QueryTools.ExecuteSyncNonQuery(Session, string.Format("INSERT INTO {0}(tweet_id,value) VALUES ({1}, {2});", tableName, toInsert[0][0].ToString(), row1[1].GetType() == typeof(byte[]) ? "0x" + Cassandra.CqlQueryTools.ToHex((byte[])toInsert[0][1]) : "'" + toInsert[0][1] + "'"), null); // rndm.GetType().GetMethod("Next" + tp.Name).Invoke(rndm, new object[] { })
}
else
{
if (tp == typeof(Single) || tp == typeof(Double))
{
isFloatingPoint = true;
}
QueryTools.ExecuteSyncNonQuery(Session, string.Format("INSERT INTO {0}(tweet_id,value) VALUES ({1}, {2});", tableName, toInsert[0][0].ToString(), !isFloatingPoint ? toInsert[0][1] : toInsert[0][1].GetType().GetMethod("ToString", new Type[] { typeof(string) }).Invoke(toInsert[0][1], new object[] { "r" })), null);
}
QueryTools.ExecuteSyncQuery(Session, string.Format("SELECT * FROM {0};", tableName), toInsert);
QueryTools.ExecuteSyncNonQuery(Session, string.Format("DROP TABLE {0};", tableName));
}
public void TimestampTest()
{
string tableName = "table" + Guid.NewGuid().ToString("N").ToLower();
Session.Cluster.WaitForSchemaAgreement(
QueryTools.ExecuteSyncNonQuery(Session, string.Format(@"CREATE TABLE {0}(
tweet_id uuid PRIMARY KEY,
ts timestamp
);", tableName)));
QueryTools.ExecuteSyncNonQuery(Session, string.Format("INSERT INTO {0}(tweet_id,ts) VALUES ({1}, '{2}');", tableName, Guid.NewGuid().ToString(), "2011-02-03 04:05+0000"), null);
QueryTools.ExecuteSyncNonQuery(Session, string.Format("INSERT INTO {0}(tweet_id,ts) VALUES ({1}, '{2}');", tableName, Guid.NewGuid().ToString(), 220898707200000), null);
QueryTools.ExecuteSyncNonQuery(Session, string.Format("INSERT INTO {0}(tweet_id,ts) VALUES ({1}, '{2}');", tableName, Guid.NewGuid().ToString(), 0), null);
QueryTools.ExecuteSyncQuery(Session, string.Format("SELECT * FROM {0};", tableName));
QueryTools.ExecuteSyncNonQuery(Session, string.Format("DROP TABLE {0};", tableName));
}
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));
}
public void massivePreparedStatementTest()
{
string tableName = "table" + Guid.NewGuid().ToString("N");
try
{
Session.Cluster.WaitForSchemaAgreement(
QueryTools.ExecuteSyncNonQuery(Session, string.Format(@"CREATE TABLE {0}(
tweet_id uuid PRIMARY KEY,
numb1 double,
numb2 int
);", tableName))
);
}
catch (AlreadyExistsException)
{
}
int numberOfPrepares = 100;
List <object[]> values = new List <object[]>(numberOfPrepares);
List <PreparedStatement> prepares = new List <PreparedStatement>();
Parallel.For(0, numberOfPrepares, i =>
{
var prep = QueryTools.PrepareQuery(Session, string.Format("INSERT INTO {0}(tweet_id, numb1, numb2) VALUES ({1}, ?, ?);", tableName, Guid.NewGuid()));
lock (prepares)
prepares.Add(prep);
});
Parallel.ForEach(prepares, prep =>
{
QueryTools.ExecutePreparedQuery(this.Session, prep, new object[] { (double)Randomm.RandomVal(typeof(double)), (int)Randomm.RandomVal(typeof(int)) });
});
QueryTools.ExecuteSyncQuery(Session, string.Format("SELECT * FROM {0};", tableName));
}
public void checkingOrderOfCollection(string CassandraCollectionType, Type TypeOfDataToBeInputed, Type TypeOfKeyForMap = null, string pendingMode = "")
{
string cassandraDataTypeName = QueryTools.convertTypeNameToCassandraEquivalent(TypeOfDataToBeInputed);
string cassandraKeyDataTypeName = "";
string openBracket = CassandraCollectionType == "list" ? "[" : "{";
string closeBracket = CassandraCollectionType == "list" ? "]" : "}";
string mapSyntax = "";
string randomKeyValue = string.Empty;
if (TypeOfKeyForMap != null)
{
cassandraKeyDataTypeName = QueryTools.convertTypeNameToCassandraEquivalent(TypeOfKeyForMap);
mapSyntax = cassandraKeyDataTypeName + ",";
if (TypeOfKeyForMap == typeof(DateTimeOffset))
{
randomKeyValue = (string)(Randomm.RandomVal(typeof(DateTimeOffset)).GetType().GetMethod("ToString", new Type[] { typeof(string) }).Invoke(Randomm.RandomVal(typeof(DateTimeOffset)), new object[1] {
"yyyy-MM-dd H:mm:sszz00"
}) + "' : '");
}
else
{
randomKeyValue = Randomm.RandomVal(TypeOfDataToBeInputed) + "' : '";
}
}
string tableName = "table" + Guid.NewGuid().ToString("N");
try
{
Session.WaitForSchemaAgreement(
QueryTools.ExecuteSyncNonQuery(Session, string.Format(@"CREATE TABLE {0}(
tweet_id uuid PRIMARY KEY,
some_collection {1}<{2}{3}>
);", tableName, CassandraCollectionType, mapSyntax, cassandraDataTypeName)));
}
catch (AlreadyExistsException)
{
}
Guid tweet_id = Guid.NewGuid();
StringBuilder longQ = new StringBuilder();
longQ.AppendLine("BEGIN BATCH ");
int CollectionElementsNo = 100;
List <Int32> orderedAsInputed = new List <Int32>(CollectionElementsNo);
string inputSide = "some_collection + {1}";
if (CassandraCollectionType == "list" && pendingMode == "prepending")
{
inputSide = "{1} + some_collection";
}
for (int i = 0; i < CollectionElementsNo; i++)
{
var data = i * (i % 2);
longQ.AppendFormat(@"UPDATE {0} SET some_collection = " + inputSide + " WHERE tweet_id = {2};"
, tableName, openBracket + randomKeyValue + data + closeBracket, tweet_id.ToString());
orderedAsInputed.Add(data);
}
longQ.AppendLine("APPLY BATCH;");
QueryTools.ExecuteSyncNonQuery(Session, longQ.ToString(), "Inserting...");
if (CassandraCollectionType == "set")
{
orderedAsInputed.Sort();
orderedAsInputed.RemoveRange(0, orderedAsInputed.LastIndexOf(0));
}
else if (CassandraCollectionType == "list" && pendingMode == "prepending")
{
orderedAsInputed.Reverse();
}
using (var rs = Session.Execute(string.Format("SELECT * FROM {0};", tableName), ConsistencyLevel.Default))
{
int ind = 0;
foreach (var row in rs.GetRows())
{
foreach (var value in row[1] as System.Collections.IEnumerable)
{
Assert.True(orderedAsInputed[ind] == (int)value);
ind++;
}
}
}
QueryTools.ExecuteSyncQuery(Session, string.Format("SELECT * FROM {0};", tableName));
QueryTools.ExecuteSyncNonQuery(Session, string.Format("DROP TABLE {0};", tableName));
}
public void insertingSingleCollectionPrepared(string CassandraCollectionType, Type TypeOfDataToBeInputed, Type TypeOfKeyForMap = null)
{
string cassandraDataTypeName = QueryTools.convertTypeNameToCassandraEquivalent(TypeOfDataToBeInputed);
string cassandraKeyDataTypeName = "";
string mapSyntax = "";
object valueCollection = null;
int Cnt = 10;
if (CassandraCollectionType == "list" || CassandraCollectionType == "set")
{
var openType = CassandraCollectionType == "list"? typeof(List <>) : typeof(HashSet <>);
var listType = openType.MakeGenericType(TypeOfDataToBeInputed);
valueCollection = Activator.CreateInstance(listType);
var addM = listType.GetMethod("Add");
for (int i = 0; i < Cnt; i++)
{
var randomValue = Randomm.RandomVal(TypeOfDataToBeInputed);
addM.Invoke(valueCollection, new object[] { randomValue });
}
}
else if (CassandraCollectionType == "map")
{
cassandraKeyDataTypeName = QueryTools.convertTypeNameToCassandraEquivalent(TypeOfKeyForMap);
mapSyntax = cassandraKeyDataTypeName + ",";
var openType = typeof(SortedDictionary <,>);
var dicType = openType.MakeGenericType(TypeOfKeyForMap, TypeOfDataToBeInputed);
valueCollection = Activator.CreateInstance(dicType);
var addM = dicType.GetMethod("Add");
for (int i = 0; i < Cnt; i++)
{
RETRY:
try
{
var randomKey = Randomm.RandomVal(TypeOfKeyForMap);
var randomValue = Randomm.RandomVal(TypeOfDataToBeInputed);
addM.Invoke(valueCollection, new object[] { randomKey, randomValue });
}
catch
{
goto RETRY;
}
}
}
string tableName = "table" + Guid.NewGuid().ToString("N").ToLower();
try
{
Session.WaitForSchemaAgreement(
QueryTools.ExecuteSyncNonQuery(Session, string.Format(@"CREATE TABLE {0}(
tweet_id uuid PRIMARY KEY,
some_collection {1}<{2}{3}>
);", tableName, CassandraCollectionType, mapSyntax, cassandraDataTypeName))
);
}
catch (AlreadyExistsException)
{
}
Guid tweet_id = Guid.NewGuid();
var prepInsert = QueryTools.PrepareQuery(Session, string.Format("INSERT INTO {0}(tweet_id,some_collection) VALUES (?, ?);", tableName));
Session.Execute(prepInsert.Bind(tweet_id, valueCollection).SetConsistencyLevel(ConsistencyLevel.Quorum));
QueryTools.ExecuteSyncQuery(Session, string.Format("SELECT * FROM {0};", tableName));
QueryTools.ExecuteSyncNonQuery(Session, string.Format("DROP TABLE {0};", tableName));
}
public void insertingSingleCollection(string CassandraCollectionType, Type TypeOfDataToBeInputed, Type TypeOfKeyForMap = null)
{
string cassandraDataTypeName = QueryTools.convertTypeNameToCassandraEquivalent(TypeOfDataToBeInputed);
string cassandraKeyDataTypeName = "";
string openBracket = CassandraCollectionType == "list" ? "[" : "{";
string closeBracket = CassandraCollectionType == "list" ? "]" : "}";
string mapSyntax = "";
var randomValue = Randomm.RandomVal(TypeOfDataToBeInputed);
if (TypeOfDataToBeInputed == typeof(string))
{
randomValue = "'" + randomValue.ToString().Replace("'", "''") + "'";
}
string randomKeyValue = string.Empty;
if (TypeOfKeyForMap != null)
{
cassandraKeyDataTypeName = QueryTools.convertTypeNameToCassandraEquivalent(TypeOfKeyForMap);
mapSyntax = cassandraKeyDataTypeName + ",";
if (TypeOfKeyForMap == typeof(DateTimeOffset))
{
randomKeyValue = "'" + (string)(Randomm.RandomVal(typeof(DateTimeOffset)).GetType().GetMethod("ToString", new Type[] { typeof(string) }).Invoke(Randomm.RandomVal(typeof(DateTimeOffset)), new object[1] {
"yyyy-MM-dd H:mm:sszz00"
}) + "'");
}
else if (TypeOfKeyForMap == typeof(string))
{
randomKeyValue = "'" + Randomm.RandomVal(TypeOfDataToBeInputed).ToString().Replace("'", "''") + "'";
}
else
{
randomKeyValue = Randomm.RandomVal(TypeOfDataToBeInputed).ToString();
}
}
string tableName = "table" + Guid.NewGuid().ToString("N").ToLower();
try
{
Session.WaitForSchemaAgreement(
QueryTools.ExecuteSyncNonQuery(Session, string.Format(@"CREATE TABLE {0}(
tweet_id uuid PRIMARY KEY,
some_collection {1}<{2}{3}>
);", tableName, CassandraCollectionType, mapSyntax, cassandraDataTypeName))
);
}
catch (AlreadyExistsException)
{
}
Guid tweet_id = Guid.NewGuid();
QueryTools.ExecuteSyncNonQuery(Session, string.Format("INSERT INTO {0}(tweet_id,some_collection) VALUES ({1}, {2});", tableName, tweet_id.ToString(), openBracket + randomKeyValue + (string.IsNullOrEmpty(randomKeyValue) ? "" : " : ") + randomValue + closeBracket));
StringBuilder longQ = new StringBuilder();
longQ.AppendLine("BEGIN BATCH ");
int CollectionElementsNo = 100;
var rval = Randomm.RandomVal(TypeOfDataToBeInputed);
for (int i = 0; i < CollectionElementsNo; i++)
{
var val = rval;
if (TypeOfDataToBeInputed == typeof(string))
{
val = "'" + val.ToString().Replace("'", "''") + "'";
}
longQ.AppendFormat(@"UPDATE {0} SET some_collection = some_collection + {1} WHERE tweet_id = {2};"
, tableName, openBracket + randomKeyValue + (string.IsNullOrEmpty(randomKeyValue) ? "" : " : ") + val + closeBracket, tweet_id.ToString());
}
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));
}
public void ExceedingCassandraType(Type toExceed, Type toExceedWith, bool sameOutput = true)
{
string cassandraDataTypeName = QueryTools.convertTypeNameToCassandraEquivalent(toExceed);
string tableName = "table" + Guid.NewGuid().ToString("N").ToLower();
try
{
Session.Cluster.WaitForSchemaAgreement(QueryTools.ExecuteSyncNonQuery(Session, string.Format(@"CREATE TABLE {0}(
tweet_id uuid PRIMARY KEY,
label text,
number {1}
);", tableName, cassandraDataTypeName)));
}
catch (AlreadyExistsException)
{
}
var Minimum = toExceedWith.GetField("MinValue").GetValue(this);
var Maximum = toExceedWith.GetField("MaxValue").GetValue(this);
object[] row1 = new object[3] {
Guid.NewGuid(), "Minimum", Minimum
};
object[] row2 = new object[3] {
Guid.NewGuid(), "Maximum", Maximum
};
List <object[]> toInsert_and_Check = new List <object[]>(2)
{
row1, row2
};
if (toExceedWith == typeof(Double) || toExceedWith == typeof(Single))
{
Minimum = Minimum.GetType().GetMethod("ToString", new Type[] { typeof(string) }).Invoke(Minimum, new object[1] {
"r"
});
Maximum = Maximum.GetType().GetMethod("ToString", new Type[] { typeof(string) }).Invoke(Maximum, new object[1] {
"r"
});
if (!sameOutput) //for ExceedingCassandra_FLOAT() test case
{
toInsert_and_Check[0][2] = Single.NegativeInfinity;
toInsert_and_Check[1][2] = Single.PositiveInfinity;
}
}
try
{
QueryTools.ExecuteSyncNonQuery(Session, string.Format("INSERT INTO {0}(tweet_id, label, number) VALUES ({1}, '{2}', {3});", tableName, toInsert_and_Check[0][0], toInsert_and_Check[0][1], Minimum), null);
QueryTools.ExecuteSyncNonQuery(Session, string.Format("INSERT INTO {0}(tweet_id, label, number) VALUES ({1}, '{2}', {3});", tableName, toInsert_and_Check[1][0].ToString(), toInsert_and_Check[1][1], Maximum), null);
}
catch (InvalidQueryException)
{
if (!sameOutput && toExceed == typeof(Int32)) //for ExceedingCassandra_INT() test case
{
QueryTools.ExecuteSyncNonQuery(Session, string.Format("DROP TABLE {0};", tableName));
Assert.True(true);
return;
}
}
QueryTools.ExecuteSyncQuery(Session, string.Format("SELECT * FROM {0};", tableName), toInsert_and_Check);
QueryTools.ExecuteSyncNonQuery(Session, string.Format("DROP TABLE {0};", tableName));
}