Deveel.Data.DeleteTests.SetNullOnDeleteConstraintCheck C# (CSharp) Method

        public void SetNullOnDeleteConstraintCheck()
        {
            var query = CreateQuery(CreateAdminSession(Database));

            var tableName = ObjectName.Parse("APP.test_table");
            var expr = SqlExpression.Parse("last_name = 'Provenzano'");

            var count = query.Delete(tableName, expr);
            query.Commit();

            Assert.AreEqual(2, count);

            query = CreateQuery(CreateAdminSession(Database));

            var linkedTable = query.Access().GetTable(ObjectName.Parse("APP.test_table2"));
            var rows = linkedTable.GetIndex(0).SelectEqual(Field.Integer(1));
            var value = linkedTable.GetValue(rows.First(), 1);

            Assert.IsTrue(Field.IsNullField(value));
        }