File: test15.py

package info (click to toggle)
mysql-gui-tools 5.0r12-1
  • links: PTS
  • area: main
  • in suites: lenny
  • size: 105,540 kB
  • ctags: 50,897
  • sloc: sql: 348,439; pascal: 285,780; cpp: 94,578; ansic: 90,768; objc: 33,761; sh: 25,629; xml: 10,924; yacc: 10,755; java: 9,986; php: 2,806; python: 2,068; makefile: 1,945; perl: 3
file content (94 lines) | stat: -rw-r--r-- 2,918 bytes parent folder | download | duplicates (3)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
# Name: 22593_available_privs_disappear
# Target: windows
##

ClickObject(PATH("MainForm.SidebarPnl.AdminTreeView"), offset=(68, 87))
Delay(1)
ClickObject(PATH("MainForm.SidebarPnl.SubTreePnl.SubTreePnl.UserTreeView"), offset=(80, 66), button=3)
Delay(1)
ClickObject(PATH("MainForm.SidebarPnl.SubTreePnl.SubTreePnl.UserTreeView"), offset=(105, 79))
Delay(1)
Type('a')
Delay(1)
ClickObject(PATH("MainForm.DockPnl.UserPnl.Panel3.BottomBtnPnl.ApplyChangesBtn"), offset=(28, 10))
Delay(2)
ClickObject(PATH("MainForm.SidebarPnl.SubTreePnl.SubTreePnl.UserTreeView"), offset=(84, 163), button=3)
Delay(1)
ClickObject(PATH("MainForm.SidebarPnl.SubTreePnl.SubTreePnl.UserTreeView"), offset=(102, 174))
Delay(1)
Type('b')
Delay(1)
ClickObject(PATH("MainForm.DockPnl.UserPnl.Panel3.BottomBtnPnl.ApplyChangesBtn"), offset=(23, 7))
Delay(2)
ClickObject(PATH("MainForm.DockPnl.UserPnl.UserPageControl"), offset=(225, 12))
Delay(1)
ClickObject(PATH("MainForm.SidebarPnl.SubTreePnl.SubTreePnl.UserTreeView"), offset=(30, 27))
Delay(1)
ClickObject(PATH("MainForm.DockPnl.UserPnl.UserPageControl.SchemataPrivSheet.SchemaPrivSchemataFrame.CatalogVST"), offset=(59, 11))

ok = 0

try:
  ListItemPosAtRow(PATH("MainForm.DockPnl.UserPnl.UserPageControl.SchemataPrivSheet.SchemaPrivAvailListView"), 0)
  ok = ok + 1
except:
  pass

try:
  ListItemPosAtRow(PATH("MainForm.DockPnl.UserPnl.UserPageControl.SchemataPrivSheet.SchemaPrivAssignedListView"), 0)
  ok = ok + 1
except:
  pass

if (ok == 0):
  Abort("Privilege lists are empty")

Delay(1)
ClickObject(PATH("MainForm.SidebarPnl.SubTreePnl.SubTreePnl.UserTreeView"), offset=(28, 43))
Delay(1)
ClickObject(PATH("MainForm.DockPnl.UserPnl.UserPageControl.SchemataPrivSheet.SchemaPrivSchemataFrame.CatalogVST"), offset=(44, 10))
Delay(1)

ok = 0
try:
  ListItemPosAtRow(PATH("MainForm.DockPnl.UserPnl.UserPageControl.SchemataPrivSheet.SchemaPrivAvailListView"), 0)
  ok = ok + 1
except:
  pass

try:
  ListItemPosAtRow(PATH("MainForm.DockPnl.UserPnl.UserPageControl.SchemataPrivSheet.SchemaPrivAssignedListView"), 0)
  ok = ok + 1
except:
  pass

if (ok == 0):
  Abort("Privilege lists are empty")


ClickObject(PATH("MainForm.SidebarPnl.SubTreePnl.SubTreePnl.UserTreeView"), offset=(27, 24))
Delay(1)
ClickObject(PATH("MainForm.DockPnl.UserPnl.UserPageControl.SchemataPrivSheet.SchemaPrivSchemataFrame.CatalogVST"), offset=(50, 9))
Delay(1)

ok = 0
try:
  ListItemPosAtRow(PATH("MainForm.DockPnl.UserPnl.UserPageControl.SchemataPrivSheet.SchemaPrivAvailListView"), 0)
  ok = ok + 1
except:
  pass

try:
  ListItemPosAtRow(PATH("MainForm.DockPnl.UserPnl.UserPageControl.SchemataPrivSheet.SchemaPrivAssignedListView"), 0)
  ok = ok + 1
except:
  pass

if (ok == 0):
  Abort("Privilege lists are empty")


MyConnect({"user":"root","host":"localhost"})

MyQuery("DROP USER A") 
MyQuery("DROP USER B")