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