本文整理汇总了Python中setup.atest函数的典型用法代码示例。如果您正苦于以下问题：Python atest函数的具体用法？Python atest怎么用？Python atest使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了atest函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: test001
def test001(desc="""A201"""):
global _testmgr
global _testlist
global _dci
if not _testmgr.testcase_begin(_testlist): return
defs.testid = """A201"""
stmt = """prepare s1 from
SELECT a.seqno,
b.seqno
FROM wm000 a
FULL OUTER JOIN
wm001 b
ON a.seqno = b.seqno
ORDER BY a.seqno,b.seqno;"""
output = _dci.cmdexec(stmt)
setup.atest()
_testmgr.testcase_end(desc)示例2: test052
def test052(desc="""VT103"""):
global _testmgr
global _testlist
global _dci
if not _testmgr.testcase_begin(_testlist): return
defs.testid = """VT103"""
stmt = """prepare s1 from
select a.seqno,
b.seqno,
a.inte1,
b.inte1
FROM vt_wm000 a
FULL OUTER JOIN vt_wm001 b
ON a.inte1 = b.inte1
WHERE (a.inte1 > 3 and a.smin1 < 123) or b.inte1 = 2
ORDER BY a.seqno, b.seqno, a.inte1, b.inte1;"""
output = _dci.cmdexec(stmt)
setup.atest()
_testmgr.testcase_end(desc)示例3: test039
def test039(desc="""A239"""):
global _testmgr
global _testlist
global _dci
if not _testmgr.testcase_begin(_testlist): return
defs.testid = """A239"""
stmt = """prepare s1 from
SELECT seqno, smin1,inte1
FROM (SELECT inte1 FROM wm000) a(i)
FULL OUTER JOIN
( SELECT inte1 FROM wm001) b(i)
ON a.i = b.i
FULL OUTER JOIN
vt_wm000 c
ON a.i = c.inte1
ORDER BY seqno, smin1,inte1;"""
output = _dci.cmdexec(stmt)
setup.atest()
_testmgr.testcase_end(desc)示例4: test047
def test047(desc="""A247"""):
global _testmgr
global _testlist
global _dci
if not _testmgr.testcase_begin(_testlist): return
defs.testid = """A247"""
stmt = """prepare s1 from
SELECT seqno, smin1,char1
FROM ( SELECT char1 FROM wm000) a(c)
FULL OUTER JOIN
( SELECT char1 FROM wm001) b(c)
ON a.c = b.c
FULL OUTER JOIN
vt_wm000 c
ON a.c = c.char1
ORDER BY seqno, smin1,char1;"""
output = _dci.cmdexec(stmt)
setup.atest()
_testmgr.testcase_end(desc)示例5: test048
def test048(desc="""A248"""):
global _testmgr
global _testlist
global _dci
if not _testmgr.testcase_begin(_testlist): return
defs.testid = """A248"""
stmt = """prepare s1 from
SELECT seqno, smin1,vchr1
FROM ( SELECT vchr1 FROM wm000) a(v)
FULL OUTER JOIN
( SELECT vchr1 FROM wm001) b(v)
ON a.v = b.v
FULL OUTER JOIN
vt_wm000 c
ON a.v = c.vchr1
ORDER BY seqno, smin1,vchr1;"""
output = _dci.cmdexec(stmt)
setup.atest()
_testmgr.testcase_end(desc)示例6: test042
def test042(desc="""A242"""):
global _testmgr
global _testlist
global _dci
if not _testmgr.testcase_begin(_testlist): return
defs.testid = """A242"""
stmt = """prepare s1 from
SELECT seqno, smin1,deci1
FROM ( SELECT deci1 FROM wm000) a(d)
FULL OUTER JOIN
( SELECT deci1 FROM wm001) b(d)
ON a.d = b.d
FULL OUTER JOIN
vt_wm000 c
ON a.d = c.deci1
ORDER BY seqno, smin1,deci1 ;"""
output = _dci.cmdexec(stmt)
setup.atest()
_testmgr.testcase_end(desc)示例7: test040
def test040(desc="""A240"""):
global _testmgr
global _testlist
global _dci
if not _testmgr.testcase_begin(_testlist): return
defs.testid = """A240"""
stmt = """prepare s1 from
SELECT seqno, smin1,lint1
FROM ( SELECT lint1 FROM wm000) a(l)
FULL OUTER JOIN
( SELECT lint1 FROM wm001) b(l)
ON a.l = b.l
FULL OUTER JOIN
vt_wm000 c
ON a.l = c.lint1
ORDER BY seqno, smin1,lint1 ;"""
output = _dci.cmdexec(stmt)
setup.atest()
_testmgr.testcase_end(desc)示例8: test004
def test004(desc="""A204"""):
global _testmgr
global _testlist
global _dci
if not _testmgr.testcase_begin(_testlist): return
defs.testid = """A204"""
stmt = """prepare s1 from
SELECT a.seqno,
b.seqno,
a.lint1,
b.lint1
FROM vt_wm000 a
FULL OUTER JOIN
vt_wm001 b
ON a.lint1 = b.lint1
ORDER BY a.seqno,b.seqno,a.lint1,b.lint1;"""
output = _dci.cmdexec(stmt)
setup.atest()
_testmgr.testcase_end(desc)示例9: test044
def test044(desc="""A244"""):
global _testmgr
global _testlist
global _dci
if not _testmgr.testcase_begin(_testlist): return
defs.testid = """A244"""
stmt = """prepare s1 from
SELECT seqno, smin1,flot1
FROM ( SELECT flot1 FROM wm000) a(f)
FULL OUTER JOIN
( SELECT flot1 FROM wm001) b(f)
ON a.f = b.f
FULL OUTER JOIN
vt_wm000 c
ON a.f = c.flot1
ORDER BY seqno, smin1,flot1;"""
output = _dci.cmdexec(stmt)
setup.atest()
_testmgr.testcase_end(desc)示例10: test045
def test045(desc="""A245"""):
global _testmgr
global _testlist
global _dci
if not _testmgr.testcase_begin(_testlist): return
defs.testid = """A245"""
stmt = """prepare s1 from
SELECT seqno, smin1,real1
FROM ( SELECT real1 FROM wm000) a(r)
FULL OUTER JOIN
( SELECT real1 FROM wm001) b(r)
ON a.r = b.r
FULL OUTER JOIN
vt_wm000 c
ON a.r = c.real1
ORDER BY seqno, smin1,real1;"""
output = _dci.cmdexec(stmt)
setup.atest()
_testmgr.testcase_end(desc)示例11: test043
def test043(desc="""A243"""):
global _testmgr
global _testlist
global _dci
if not _testmgr.testcase_begin(_testlist): return
defs.testid = """A243"""
stmt = """prepare s1 from
SELECT seqno, smin1,pict1
FROM (SELECT pict1 FROM wm000) a(p)
FULL OUTER JOIN
( SELECT pict1 FROM wm001) b(p)
ON a.p = b.p
FULL OUTER JOIN
vt_wm000 c
ON a.p = c.pict1
ORDER BY seqno, smin1,pict1;"""
output = _dci.cmdexec(stmt)
setup.atest()
_testmgr.testcase_end(desc)示例12: test041
def test041(desc="""A241"""):
global _testmgr
global _testlist
global _dci
if not _testmgr.testcase_begin(_testlist): return
defs.testid = """A241"""
stmt = """prepare s1 from
SELECT seqno, smin1,nume1
FROM ( SELECT nume1 FROM wm000) a(n)
FULL OUTER JOIN
( SELECT nume1 FROM wm001) b(n)
ON a.n = b.n
FULL OUTER JOIN
vt_wm000 c
ON a.n = c.nume1
ORDER BY seqno, smin1,nume1 ;"""
output = _dci.cmdexec(stmt)
setup.atest()
_testmgr.testcase_end(desc)示例13: test001
def test001(desc="""J001"""):
global _testmgr
global _testlist
global _dci
if not _testmgr.testcase_begin(_testlist): return
defs.testid = """J001"""
stmt = """prepare s1 from SELECT seqno, smin1 ,inte1, lint1 , deci1
FROM
wm000 t1
FULL OUTER JOIN
(select *
from wm_vw_000 natural join wm_vw_001
) as t2
on t1.seqno = t2.n1sq
order by seqno, smin1 ,inte1, lint1 , deci1;"""
output = _dci.cmdexec(stmt)
setup.atest()
#--------------------------
_testmgr.testcase_end(desc)示例14: test059
def test059(desc="""VT110"""):
global _testmgr
global _testlist
global _dci
if not _testmgr.testcase_begin(_testlist): return
defs.testid = """VT110"""
stmt = """prepare s1 from
select a.seqno,
b.seqno,
a.dblp1,
b.dblp1
FROM vt_wm000 a
FULL OUTER JOIN
vt_wm001 b
ON a.dblp1 = b.dblp1
WHERE (a.dblp1 > 8 and a.smin1 < 123) or
(b.dblp1 < 1 or a.dblp1 <> 0 )
ORDER BY a.seqno, b.seqno, a.smin1, b.smin1 ;"""
output = _dci.cmdexec(stmt)
setup.atest()
_testmgr.testcase_end(desc)示例15: test060
def test060(desc="""VT111"""):
global _testmgr
global _testlist
global _dci
if not _testmgr.testcase_begin(_testlist): return
defs.testid = """VT111"""
stmt = """prepare s1 from
select a.seqno,
b.seqno,
a.char1,
b.char1
FROM vt_wm000 a
FULL OUTER JOIN
vt_wm001 b
ON a.char1 = b.char1
WHERE (a.char1 > '8' and a.smin1 < 1023) or
( b.char1 <= '1' or a.char1 <> '0' )
ORDER BY a.seqno, b.seqno, a.smin1, b.smin1 ;"""
output = _dci.cmdexec(stmt)
setup.atest()
_testmgr.testcase_end(desc)