Exemplo n.º 1
0
        static bool CheckDrop()
        {
            //make a drop statement for a index
            //delete this index before delete the table, return true
            DropStatement test_drop_index = new DropStatement();

            test_drop_index.TargetType = DropTarget.Index;
            test_drop_index.IndexName  = "index_for_student_id";
            bool test4 = icatalog.TryDropStatement(test_drop_index);

            // Console.WriteLine("Delete Index1, expecting true:");
            // Console.WriteLine(test4);
            Debug.Assert(test4 == true);

            //make a drop statement for a table
            //delete this table and its assotiated indices, return true
            DropStatement test_drop_table = new DropStatement();

            test_drop_table.TargetType = DropTarget.Table;
            test_drop_table.TableName  = "Student";
            bool test3 = icatalog.TryDropStatement(test_drop_table);

            // Console.WriteLine("Delete table, expecting true:");
            // Console.WriteLine(test3);
            Debug.Assert(test3 == true);

            //make a drop statement for a index
            //delete this
            DropStatement test_drop_index2 = new DropStatement();

            test_drop_index2.TargetType = DropTarget.Index;
            test_drop_index2.IndexName  = "index2";
            bool test5 = icatalog.TryDropStatement(test_drop_index2);

            // Console.WriteLine("Delete index2 after deleting table, expecting false:");
            // Console.WriteLine(test5);
            Debug.Assert(test5 == false);

            return(true);
        }