本文整理汇总了Python中setup.atest函数的典型用法代码示例。如果您正苦于以下问题：Python atest函数的具体用法？Python atest怎么用？Python atest使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了atest函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的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)
开发者ID:ChiragBhalgami，项目名称:tests，代码行数:17，代码来源:tcase_vt.py
示例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)
开发者ID:ChiragBhalgami，项目名称:tests，代码行数:19，代码来源:tcase_vt.py
示例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)
开发者ID:ChiragBhalgami，项目名称:tests，代码行数:19，代码来源:tcase_vt.py
示例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)
开发者ID:ChiragBhalgami，项目名称:tests，代码行数:19，代码来源:tcase_vt.py
示例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)
开发者ID:ChiragBhalgami，项目名称:tests，代码行数:19，代码来源:tcase_vt.py
示例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)
开发者ID:ChiragBhalgami，项目名称:tests，代码行数:19，代码来源:tcase_vt.py
示例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)
开发者ID:ChiragBhalgami，项目名称:tests，代码行数:19，代码来源:tcase_vt.py
示例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)
开发者ID:ChiragBhalgami，项目名称:tests，代码行数:19，代码来源:tcase_vt.py
示例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)
开发者ID:ChiragBhalgami，项目名称:tests，代码行数:19，代码来源:tcase_vt.py
示例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)
开发者ID:ChiragBhalgami，项目名称:tests，代码行数:19，代码来源:tcase_vt.py
示例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)
开发者ID:ChiragBhalgami，项目名称:tests，代码行数:19，代码来源:tcase_vt.py
示例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)
开发者ID:ChiragBhalgami，项目名称:tests，代码行数:19，代码来源:tcase_vt.py
示例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)
开发者ID:ChiragBhalgami，项目名称:tests，代码行数:20，代码来源:tcase_joins.py
示例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)
开发者ID:ChiragBhalgami，项目名称:tests，代码行数:21，代码来源:tcase_vt.py
示例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)
开发者ID:ChiragBhalgami，项目名称:tests，代码行数:21，代码来源:tcase_vt.py
示例16: test058
def test058(desc="""VT109"""):
global _testmgr
global _testlist
global _dci
if not _testmgr.testcase_begin(_testlist): return
defs.testid = """VT109"""
stmt = """prepare s1 from
select a.seqno,
b.seqno,
a.real1,
b.real1
FROM vt_wm000 a
FULL OUTER JOIN
vt_wm001 b
ON a.real1 = b.real1
WHERE (a.real1 < 3 and a.smin1 < 123) or
( b.real1 < 4 and a.real1 > 1 )
ORDER BY a.seqno, b.seqno, a.smin1, b.smin1 ;"""
output = _dci.cmdexec(stmt)
setup.atest()
_testmgr.testcase_end(desc)
开发者ID:ChiragBhalgami，项目名称:tests，代码行数:21，代码来源:tcase_vt.py
示例17: test015
def test015(desc="""J017"""):
global _testmgr
global _testlist
global _dci
if not _testmgr.testcase_begin(_testlist): return
defs.testid = """J017"""
stmt = """prepare s1 from SELECT seqno, smin1 ,inte1, lint1 , deci1
FROM
wm000 t1
FULL OUTER JOIN
(select *
from wm_vw_000 RIGHT JOIN wm_vw_001
ON wm_vw_000.n0sq = wm_vw_001.n1sq
) as t2
on t1.seqno = t2.n1sq
where t1.seqno < 4
order by seqno, smin1 ,inte1, lint1 , deci1 ;"""
output = _dci.cmdexec(stmt)
setup.atest()
# -----Union---------
_testmgr.testcase_end(desc)
开发者ID:ChiragBhalgami，项目名称:tests，代码行数:22，代码来源:tcase_joins.py
示例18: test023
def test023(desc="""A223"""):
global _testmgr
global _testlist
global _dci
if not _testmgr.testcase_begin(_testlist): return
defs.testid = """A223"""
stmt = """prepare s1 from
SELECT a.seqno,
b.seqno,
a.char1,
b.char1
FROM wm000 a
FULL OUTER JOIN
wm001 b
ON a.char1 = b.char1
FULL OUTER JOIN
vt_wm000 c
ON a.char1 = c.char1
ORDER BY a.seqno,b.seqno,a.char1,b.char1;"""
output = _dci.cmdexec(stmt)
setup.atest()
_testmgr.testcase_end(desc)
开发者ID:ChiragBhalgami，项目名称:tests，代码行数:22，代码来源:tcase_vt.py
示例19: test025
def test025(desc="""A225"""):
global _testmgr
global _testlist
global _dci
if not _testmgr.testcase_begin(_testlist): return
defs.testid = """A225"""
stmt = """prepare s1 from
SELECT n0sq,
n1sq,
seqno,
n0s1
FROM wm_vw_000 a
FULL OUTER JOIN
wm_vw_001 b
ON a.n0sq = n1sq
FULL OUTER JOIN
vt_wm000 c
ON a.n0sq = c.seqno
ORDER BY n0sq,n1sq,seqno,n0s1;"""
output = _dci.cmdexec(stmt)
setup.atest()
_testmgr.testcase_end(desc)
开发者ID:ChiragBhalgami，项目名称:tests，代码行数:22，代码来源:tcase_vt.py
示例20: test036
def test036(desc="""A236"""):
global _testmgr
global _testlist
global _dci
if not _testmgr.testcase_begin(_testlist): return
defs.testid = """A236"""
stmt = """prepare s1 from
SELECT a.n0sq,
b.n1sq,
a.n0v1,
b.n1v1
FROM wm_vw_000 a
FULL OUTER JOIN
wm_vw_001 b
ON a.n0v1 = b.n1v1
FULL OUTER JOIN
vt_wm000 c
ON a.n0v1 = c.vchr1
ORDER BY a.n0sq,b.n1sq,a.n0v1,b.n1v1 ;"""
output = _dci.cmdexec(stmt)
setup.atest()
_testmgr.testcase_end(desc)
开发者ID:ChiragBhalgami，项目名称:tests，代码行数:22，代码来源:tcase_vt.py
注：本文中的setup.atest函数示例由纯净天空整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。 |
客服电话
APP下载
官方微信
请发表评论