public void Insert_With_Nulls_Test()
{
var table = new Table <InsertNullTable>(GetSession((_, __) => {}), new MappingConfiguration());
var row = new InsertNullTable {
Key = 101, Value = null
};
var cqlInsert = table.Insert(row);
var cql = cqlInsert.GetCqlAndValues(out object[] values);
TestHelper.VerifyInsertCqlColumns("InsertNullTable", cql, new[] { "Key", "Value" },
new object[] { row.Key, row.Value }, values);
}
public void Insert_Without_Nulls_With_Table_Test()
{
var table = new Table <InsertNullTable>(GetSession((_, __) => {}), new MappingConfiguration(), "tbl1");
var row = new InsertNullTable {
Key = 110, Value = null
};
var cqlInsert = table.Insert(row, false);
var cql = cqlInsert.GetCqlAndValues(out object[] values);
TestHelper.VerifyInsertCqlColumns("tbl1", cql, new[] { "Key" },
new object[] { 110 }, values);
}
public void InsertNullTest()
{
var table = SessionExtensions.GetTable <InsertNullTable>(null);
var row = new InsertNullTable()
{
Key = 1, Value = null
};
var cqlInsert = table.Insert(row);
var cql = cqlInsert.ToString();
Assert.That(cql, Is.EqualTo("INSERT INTO \"InsertNullTable\"(\"Key\", \"Value\") VALUES (1, null)"));
}
public void Insert_Without_Nulls_Test()
{
var table = new Table <InsertNullTable>(GetSession((_, __) => {}), new MappingConfiguration());
var row = new InsertNullTable {
Key = 102, Value = null
};
var cqlInsert = table.Insert(row, false);
var cql = cqlInsert.GetCqlAndValues(out object[] values);
Assert.AreEqual("INSERT INTO InsertNullTable (Key) VALUES (?)", cql);
TestHelper.VerifyInsertCqlColumns("InsertNullTable", cql, new[] { "Key" },
new object[] { row.Key }, values);
}
public void Insert_Without_Nulls_With_Table_And_Keyspace_Name_Test()
{
var table = new Table <InsertNullTable>(null, new MappingConfiguration(), "tbl1", "ks100");
var row = new InsertNullTable {
Key = 102, Value = null
};
var cqlInsert = table.Insert(row, false);
object[] values;
var cql = cqlInsert.GetCqlAndValues(out values);
TestHelper.VerifyInsertCqlColumns("ks100.tbl1", cql, new[] { "Key" },
new object[] { 102 }, values);
}
public void Insert_Without_Nulls_With_Table_Test()
{
var table = new Table <InsertNullTable>(null, new MappingConfiguration(), "tbl1");
var row = new InsertNullTable {
Key = 110, Value = null
};
var cqlInsert = table.Insert(row, false);
object[] values;
var cql = cqlInsert.GetCqlAndValues(out values);
Assert.AreEqual("INSERT INTO tbl1 (Key) VALUES (?)", cql);
Assert.AreEqual(1, values.Length);
Assert.AreEqual(110, values[0]);
}
public void Insert_With_Nulls_Test()
{
var table = new Table <InsertNullTable>(null, new MappingConfiguration());
var row = new InsertNullTable {
Key = 101, Value = null
};
var cqlInsert = table.Insert(row);
object[] values;
var cql = cqlInsert.GetCqlAndValues(out values);
Assert.AreEqual("INSERT INTO InsertNullTable (Key, Value) VALUES (?, ?)", cql);
Assert.AreEqual(2, values.Length);
Assert.AreEqual(row.Key, values[0]);
Assert.AreEqual(row.Value, values[1]);
}
public void InsertNullTest()
{
var table = SessionExtensions.GetTable <InsertNullTable>(null);
var row = new InsertNullTable()
{
Key = 101, Value = null
};
var cqlInsert = table.Insert(row);
object[] values;
var cql = cqlInsert.GetCqlAndValues(out values);
Assert.AreEqual("INSERT INTO \"InsertNullTable\" (\"Key\", \"Value\") VALUES (?, ?)", cql);
Assert.AreEqual(2, values.Length);
Assert.AreEqual(101, values[0]);
Assert.AreEqual(null, values[1]);
}
public void Insert_IfNotExists_Without_Nulls_With_Timestamp_Test()
{
var table = new Table <InsertNullTable>(GetSession((_, __) => {}), new MappingConfiguration());
var row = new InsertNullTable {
Key = 104, Value = null
};
var timestamp = DateTimeOffset.UtcNow;
var cqlInsert = table.Insert(row, false);
cqlInsert.IfNotExists();
cqlInsert.SetTimestamp(timestamp);
var cql = cqlInsert.GetCqlAndValues(out object[] values);
var expectedTimestamp = (timestamp - new DateTimeOffset(1970, 1, 1, 0, 0, 0, 0, TimeSpan.Zero)).Ticks / 10;
TestHelper.VerifyInsertCqlColumns("InsertNullTable", cql, new[] { "Key" },
new object[] { 104, expectedTimestamp }, values, "IF NOT EXISTS USING TIMESTAMP ?");
}
public void Insert_IfNotExists_Without_Nulls_With_Timestamp_Test()
{
var table = new Table <InsertNullTable>(null, new MappingConfiguration());
var row = new InsertNullTable {
Key = 104, Value = null
};
var timestamp = DateTimeOffset.UtcNow;
var cqlInsert = table.Insert(row, false);
cqlInsert.IfNotExists();
cqlInsert.SetTimestamp(timestamp);
object[] values;
var cql = cqlInsert.GetCqlAndValues(out values);
Assert.AreEqual("INSERT INTO InsertNullTable (Key) VALUES (?) IF NOT EXISTS USING TIMESTAMP ?", cql);
Assert.AreEqual(2, values.Length);
Assert.AreEqual(104, values[0]);
Assert.AreEqual((timestamp - new DateTimeOffset(1970, 1, 1, 0, 0, 0, 0, TimeSpan.Zero)).Ticks / 10, values[1]);
}
public void Insert_IfNotExists_With_Ttl_And_Timestamp_Test()
{
var table = new Table <InsertNullTable>(null, new MappingConfiguration());
var row = new InsertNullTable {
Key = 103, Value = null
};
var timestamp = DateTimeOffset.UtcNow;
var cqlInsert = table.Insert(row);
cqlInsert.IfNotExists();
cqlInsert.SetTTL(86401);
cqlInsert.SetTimestamp(timestamp);
object[] values;
var cql = cqlInsert.GetCqlAndValues(out values);
var expectedTimestamp = (timestamp - new DateTimeOffset(1970, 1, 1, 0, 0, 0, 0, TimeSpan.Zero)).Ticks / 10;
TestHelper.VerifyInsertCqlColumns("InsertNullTable", cql, new[] { "Key", "Value" },
new object[] { 103, null, 86401, expectedTimestamp }, values, "IF NOT EXISTS USING TTL ? AND TIMESTAMP ?");
}
public void Insert_IfNotExists_Without_Nulls_With_Timestamp_Test()
{
var table = new Table<InsertNullTable>(null, new MappingConfiguration());
var row = new InsertNullTable { Key = 104, Value = null };
var timestamp = DateTimeOffset.UtcNow;
var cqlInsert = table.Insert(row, false);
cqlInsert.IfNotExists();
cqlInsert.SetTimestamp(timestamp);
object[] values;
var cql = cqlInsert.GetCqlAndValues(out values);
Assert.AreEqual("INSERT INTO InsertNullTable (Key) VALUES (?) IF NOT EXISTS USING TIMESTAMP ?", cql);
Assert.AreEqual(2, values.Length);
Assert.AreEqual(104, values[0]);
Assert.AreEqual((timestamp - new DateTimeOffset(1970, 1, 1, 0, 0, 0, 0, TimeSpan.Zero)).Ticks / 10, values[1]);
}
public void Insert_Without_Nulls_With_Table_Test()
{
var table = new Table<InsertNullTable>(null, new MappingConfiguration(), "tbl1");
var row = new InsertNullTable { Key = 110, Value = null };
var cqlInsert = table.Insert(row, false);
object[] values;
var cql = cqlInsert.GetCqlAndValues(out values);
Assert.AreEqual("INSERT INTO tbl1 (Key) VALUES (?)", cql);
Assert.AreEqual(1, values.Length);
Assert.AreEqual(110, values[0]);
}
public void Insert_With_Nulls_Test()
{
var table = new Table<InsertNullTable>(null, new MappingConfiguration());
var row = new InsertNullTable { Key = 101, Value = null };
var cqlInsert = table.Insert(row);
object[] values;
var cql = cqlInsert.GetCqlAndValues(out values);
Assert.AreEqual("INSERT INTO InsertNullTable (Key, Value) VALUES (?, ?)", cql);
Assert.AreEqual(2, values.Length);
Assert.AreEqual(101, values[0]);
Assert.AreEqual(null, values[1]);
}
public void InsertNullTest()
{
var table = SessionExtensions.GetTable<InsertNullTable>(null);
var row = new InsertNullTable() { Key = 1, Value = null };
var cqlInsert = table.Insert(row);
var cql = cqlInsert.ToString();
Assert.That(cql, Is.EqualTo("INSERT INTO \"InsertNullTable\"(\"Key\", \"Value\") VALUES (1, null)"));
}
public void InsertNullTest()
{
var table = SessionExtensions.GetTable<InsertNullTable>(null);
var row = new InsertNullTable() { Key = 101, Value = null };
var cqlInsert = table.Insert(row);
object[] values;
var cql = cqlInsert.GetCqlAndValues(out values);
Assert.AreEqual("INSERT INTO \"InsertNullTable\" (\"Key\", \"Value\") VALUES (?, ?)", cql);
Assert.AreEqual(2, values.Length);
Assert.AreEqual(101, values[0]);
Assert.AreEqual(null, values[1]);
}
