From 6ade866da16e436466ceee18b9c556da97b38a3c Mon Sep 17 00:00:00 2001 From: ioguix Date: Sat, 16 Feb 2008 20:40:13 +0000 Subject: [PATCH] add some constraints and domain tests --- selenium/tests/TestSuite.html | 6 +- selenium/tests/constraints.php | 335 +++++++++++++++++++++++++++++++++ selenium/tests/domain.php | 197 +++++++++++++++++++ 3 files changed, 535 insertions(+), 3 deletions(-) create mode 100644 selenium/tests/constraints.php create mode 100644 selenium/tests/domain.php diff --git a/selenium/tests/TestSuite.html b/selenium/tests/TestSuite.html index b1d4495f..3f6a4a84 100644 --- a/selenium/tests/TestSuite.html +++ b/selenium/tests/TestSuite.html @@ -12,7 +12,7 @@ Create schema - Create domain + Create/Alter/Drop domain Create/Alter/Drop tables @@ -21,10 +21,10 @@ Create/Alter/Drop sequence - Create FK + Create/Drop Constraints - Add/Alter/Drop a column + Create/Alter/Drop a column Create/Alter/Drop a view diff --git a/selenium/tests/constraints.php b/selenium/tests/constraints.php new file mode 100644 index 00000000..3df96f53 --- /dev/null +++ b/selenium/tests/constraints.php @@ -0,0 +1,335 @@ + + + + +New Test + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Create/Drop constraints
clickAndWaitlink=
clickAndWaitlink=
clickAndWaitlink=
clickAndWaitlink=public
clickAndWaitlink=
clickAndWaitlink=student
clickAndWaitlink=
clickAndWaitlink=
typenamestudent_id_promo_fk
addSelectionTableColumnListlabel=id_promo
clickadd
selecttargetlabel=promo
selecttargetlabel=promo
clickAndWait//input[@value='Add']
addSelectionTableColumnListlabel=id
clickadd
selectupd_actionlabel=CASCADE
selectdel_actionlabel=RESTRICT
clickAndWait//input[@value='Add']
assertText//p[@class='message']
clickAndWaitlink=
typenamefk_to_drop
addSelectionTableColumnListlabel=id_promo
clickadd
selecttargetlabel=promo
selecttargetlabel=promo
clickAndWait//input[@value='Add']
addSelectionTableColumnListlabel=id
clickadd
selectupd_actionlabel=CASCADE
selectdel_actionlabel=RESTRICT
clickAndWait//input[@value='Add']
assertText//p[@class='message']
clickAndWaitlink=
typenamecheck_to_drop
typedefinitionextract(year from birthday) < 2000
clickAndWaitok
assertText//p[@class='message']
clickAndWaitlink=
typenameunique_to_drop
addSelectionTableColumnListlabel=name
clickadd
clickAndWait//input[@value='']
assertText//p[@class='message']
clickAndWait//tr/td/pre[text()='PRIMARY KEY (id)']/../../td/a[text()='']
clickAndWaitdrop
assertText//p[@class='message']
clickAndWaitlink=
typenamestudent_pk
addSelectionTableColumnListlabel=id
clickadd
clickAndWait//input[@value='Add']
assertText//p[@class='message']
clickAndWait//tr/td[text()='fk_to_drop']/../td/a[text()='']
clickAndWaitdrop
assertText//p[@class='message']
clickAndWait//tr/td[text()='unique_to_drop']/../td/a[text()='']
clickAndWaitdrop
assertText//p[@class='message']
clickAndWait//tr/td[text()='check_to_drop']/../td/a[text()='']
clickAndWaitdrop
assertText//p[@class='message']
+ + diff --git a/selenium/tests/domain.php b/selenium/tests/domain.php new file mode 100644 index 00000000..a196f34d --- /dev/null +++ b/selenium/tests/domain.php @@ -0,0 +1,197 @@ + + + + +New Test + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Create/Edit/Drop Domain
clickAndWaitlink=
clickAndWaitlink=
clickAndWaitlink=
clickAndWaitlink=public
clickAndWaitlink=
clickAndWaitlink=
typedomnameyear
selectdomtypelabel=integer
typedomcheckVALUE >= 1901 AND VALUE <= 2155
clickAndWait//input[@value='Create']
assertText//p[@class='message']
clickAndWaitlink=
clickAndWaitlink=
typedomnametest_to_drop
selectdomtypelabel=integer
clickAndWait//input[@value='Create']
assertText//p[@class='message']
clickAndWait//tr/td/a[text()='test_to_drop']/../../td/a[text()='']
clickdomnotnull
typedomdefault2008
selectdomownerlabel=ppa_tests_user
clickAndWaitalter
assertText//p[@class='message']
clickAndWaitlink=
typenameyear_min
typedefinitionVALUE >= 1901
clickAndWaitadd
assertText//p[@class='message']
clickAndWait//tr/td[text()='year_min']/../td/a[text()='']
clickAndWaitdrop
assertText//p[@class='message']
clickAndWaitlink=
clickAndWait//tr/td/a[text()='test_to_drop']/../../td/a[text()='']
clickAndWaitdrop
assertText//p[@class='message']
+ + -- 2.39.5