def createpool(d={}):
"""
create db pool
"""
name = d.get('name', 'AApool')
desc = d.get('desc', name + 'a db pool')
x = "//*[contains (@id, 'htmlCommandButton')]"
g.wait.until(EC.element_to_be_clickable((By.XPATH, x)))\
.send_keys(Keys.RETURN)
x = "//*[contains (@id, 'selectOneCombobox')]"
g.wait.until(EC.element_to_be_clickable((By.XPATH, x))).send_keys(name)
x = "//*[contains (@id, 'zzz13')]"
g.driver.find_element(By.XPATH, x).send_keys(desc)
x = "//*[contains (@id, 'driverNameMenu')]"
g.driver.find_element(By.XPATH, x).\
send_keys( d.get('db_type','SQL Server') )
x = "//*[contains (@id, 'currentDbUrlCtrl')]"
g.driver.find_element(By.XPATH, x)\
.send_keys( d.get('db_url',
'jdbc:wm:sqlserver://*****:*****@id, 'htmlInputText6')]"
g.driver.find_element(By.XPATH,
x).send_keys(d.get('db_user', 'Administrator'))
x = "//*[contains (@id, 'htmlInputSecret')]"
e = g.driver.find_element(By.XPATH, x)
e.clear()
e.send_keys(d.get('db_pass', 'optimize'))
x = "//*[contains (@id, 'htmlCommandButton2')]"
g.driver.find_element(By.XPATH, x).send_keys(Keys.RETURN)
x = "//*[text()='Test Passed!']"
g.wait.until(EC.element_to_be_clickable((By.XPATH, x)))
x = "//*[contains (@id, 'zzz4')]"
g.driver.find_element(By.XPATH, x).send_keys(Keys.RETURN)
#bug1: just created pool put at bottom,
#bug2: pool order link can click 1 time only, then disabled (seen in ff)
#bug1 workaround - renav db page:
g.wait.until(
EC.element_to_be_clickable(
(By.XPATH, "//*/a[text()='My Profile']"))).send_keys(Keys.RETURN)
nav('DatabasePoolConfiguration')
x = "//*[text() = '" + name + "']"
g.wait.until(EC.element_to_be_clickable((By.XPATH, x)))
def ccs(): #TODO - mv t/mws/bvtccs.py
"""
complete ccs configure thing
"""
nav("db")
g.loadenv("db")
createdbpools()
nav("ccs")
g.loadenv("ccs")
create()
nav()
servers()
config()
hosts()
mapservers() #mapallservers() - quick thing
mapendpoints()
mapdbpools()
nav("ccs")
checkserverstatus()
import mws.processanalytics as pa
import bc.g as bc
"""
navigate from PA to BC via process or step on process diagram
"""
try:
proc='DBO_Process'
for r in range(1):
#print ('====='+str(r)+'======')
#get there
ui.navauth('ProcessAnalytics')
ui.nav('ProcessAnalytics')
pa.selectprocess(proc)
pa.selectrange('4 Weeks')
##nav through the process
pa.selectvolumes({'level':'proc','range':'curr','status':'All'})
pa.magglasscheck()
pid = pa.piidlink()
bc.focus()
bc.validatepi(pid)
#bc.validateerrors({'Proc':'3','Step':'0','Stage':'3','Rule':'3'})
bc.close()
#pa.selectvolumes({'level':'proc','range':'curr','status':'All'})
#pid = pa.piidlink('5')
#bc.focus()
import g
import mwsm as m
import mws.dashboards.g as d
import bc.g as bc
try:
m.login()
m.nav('bcadmin')
bc.configure({
'bc-ae-url-text': 'http://localhost:12503',
'bc-ae-uname-text': 'Administrator',
'bc-ae-upass-text': 'manage'
})
except:
g.error()
finally:
g.clean()
'''
x = loadenv('ccs',
{'name':'BVTEnv',
'mapendpoints':{'mwspath':'alta'},
'dls':True
}
)
'''
Third: just run your feature
'''
#run rootcontext feature tests
login()
nav('DefineEnvironments')
ccs.navenv(x)
ccs.modmwspath(x)
ccs.navtab('Configure Servers')
ccs.navconfig('Station Settings')
ccs.toggledls(x.get('dls',True))
ccs.validate()
ccs.finish(x)
ccs.deploy(x,'Deploy Updates')
nav("ClusterSettings")
chroot(x['mapendpoints']['mwspath'])
logout()
#reverse above dls/rootcontext changes
x = {'name':'BVTEnv',
'mapendpoints':{'mwspath':''},
def obe3337():
"""
tests obe-3337
"""
nav('ProcessInstances')
import g
import mwsm as m
import bc.g as bc
import mws.processanalytics as pa
from time import sleep
Keys=g.Keys; EC=g.EC; driver=g.driver
try:
m.navauth('ProcessAnalytics')
m.nav('ProcessAnalytics') #no auth when refreshing page later
for x in range(20):
g.tc('===='+str(x)+'====')
pa.selectprocess('DBO_Process')
pa.selectrange('4 Weeks')
pa.selectvolumes()
pa.piidlink()
bc.focus() #focus in bc
#do bc tests here
bc.close() #focus back on main
pa.selectprocess('DBO_Process')
pa.selectrange('4 Weeks')
g.focus_iframe()
pa.zoomprocdiag(-8)
pa.navstep('Service Task 1')
import mwsm as m
import mws.dashboards.g as d
import bc.g as bc
try:
m.login()
m.server('BVTEnv','Problems')
m.logout()
proc='DBO_Process'
for i in range(1,3):
print(str(i)+"==========")
m.login()
try:
m.nav('ProcessDashboards')
except:
g.tc('','fail','process dashboards link may be missing')
break
try:
d.load()
except:
g.tc('','fail','unable to load dashboard')
break
try:
d.select_proc(proc)
except:
g.tc('','fail','unable to select in dropdown: '+proc)
break
d.select_range('1 hour')
