Python getCases Examples

Example #1

File: test_standalone_select.py Project: 4paradigm/OpenMLDB

class TestStandaloneSelect(StandaloneTest):

    # 0，1，2，3，5，7都不pass 剩下都pass   KeyError: 'columns'
    @pytest.mark.parametrize("testCase", getCases(["/function/select/"]))
    @allure.feature("select")
    @allure.story("batch")
    def test_select1(self, testCase):
        print(testCase)
        fedb_executor.build(self.connect, testCase).run()

    @pytest.mark.parametrize("testCase",
                             getCases(["/function/select/test_where.yaml"]))
    @allure.feature("select")
    @allure.story("batch")
    def test_select3(self, testCase):
        print(testCase)
        fedb_executor.build(self.connect, testCase).run()

    #全pass
    @pytest.mark.parametrize("testCase", getCases(["/query/const_query.yaml"]))
    @allure.feature("select")
    @allure.story("batch")
    def test_select2(self, testCase):
        print(testCase)
        fedb_executor.build(self.connect, testCase).run()

Example #2

class TestStandaloneDeploy(StandaloneTest):
    @pytest.mark.parametrize("testCase",
                             getCases(
                                 ["/function/deploy/test_create_deploy.yaml"]))
    @allure.feature("deploy")
    @allure.story("create")
    def test_create(self, testCase):
        print(testCase)
        fedb_executor.build(self.connect, testCase).run()

    @pytest.mark.parametrize("testCase",
                             getCases(
                                 ["/function/deploy/test_show_deploy.yaml"]))
    @allure.feature("deploy")
    @allure.story("show")
    def test_show(self, testCase):
        print(testCase)
        fedb_executor.build(self.connect, testCase).run()

    @pytest.mark.parametrize("testCase",
                             getCases(
                                 ["/function/deploy/test_drop_deploy.yaml"]))
    @allure.feature("deploy")
    @allure.story("drop")
    def test_drop(self, testCase):
        print(testCase)
        fedb_executor.build(self.connect, testCase).run()

Example #3

File: test_standalone_window.py Project: 4paradigm/OpenMLDB

class TestStandaloneWindow(StandaloneTest):

    #都pass
    @pytest.mark.parametrize("testCase", getCases(["/function/window/"]))
    @allure.feature("window")
    @allure.story("batch")
    def test_window1(self, testCase):
        print(testCase)
        fedb_executor.build(self.connect, testCase).run()

    # 13没pass属于正常情况 剩下都pass
    @pytest.mark.parametrize("testCase", getCases(["/function/cluster/"]))
    @allure.feature("window")
    @allure.story("batch")
    def test_window2(self, testCase):
        print(testCase)
        fedb_executor.build(self.connect, testCase).run()

    #都pass
    @pytest.mark.parametrize("testCase", getCases(["/function/test_index_optimized.yaml"]))
    @allure.feature("window")
    @allure.story("batch")
    def test_window3(self, testCase):
        print(testCase)
        fedb_executor.build(self.connect, testCase).run()

Example #4

File: test_express.py Project: dl239/OpenMLDB

class TestExpress(FedbTest):

    @pytest.mark.parametrize("testCase", getCases(["/function/expression/"]))
    @allure.feature("Express")
    @allure.story("batch")
    def test_express(self, testCase):
        fedb_executor.build(self.connect, testCase).run()

Example #5

File: test_standalone_dml.py Project: 4paradigm/OpenMLDB

class TestStandaloneDML(StandaloneTest):

    #全部pass
    @pytest.mark.parametrize("testCase", getCases(["/function/dml/test_insert.yaml"]))
    @allure.feature("dml")
    @allure.story("insert")
    def test_insert(self, testCase):
        print(testCase)
        fedb_executor.build(self.connect, testCase).run()

    #全部pass
    @pytest.mark.parametrize("testCase", getCases(["/function/dml/multi_insert.yaml"]))
    @allure.feature("dml")
    @allure.story("multi_insert")
    def test_insert(self, testCase):
        print(testCase)
        fedb_executor.build(self.connect, testCase).run()

Example #6

File: test_window.py Project: dl239/OpenMLDB

class TestWindow(FedbTest):
    @pytest.mark.parametrize("testCase",
                             getCases(
                                 ["/function/cluster/", "/function/window/"]))
    @allure.feature("Window")
    @allure.story("batch")
    def test_window(self, testCase):
        fedb_executor.build(self.connect, testCase).run()

Example #7

File: test_function.py Project: dl239/OpenMLDB

class TestFunction(FedbTest):
    @pytest.mark.parametrize("testCase",
                             getCases(
                                 ["/function/function/test_calculate.yaml"]))
    @allure.feature("Function")
    @allure.story("batch")
    def test_function(self, testCase):
        fedb_executor.build(self.connect, testCase).run()

Example #8

File: test_standalone_outin.py Project: 4paradigm/OpenMLDB

class TestStanaaloneOutIn(StandaloneTest):

    #有问题 单机版目前没法测
    @pytest.mark.parametrize("testCase", getCases(["/function/out_in/test_out_in.yaml"]))
    @allure.feature("out-in")
    @allure.story("out-in")
    def test_function(self, testCase):
        print(testCase)
        fedb_executor.build(self.connect, testCase).run()

Example #9

class TestStandaloneFunction(StandaloneTest):

    #testcase 7 8 剩下都pass  AssertionError: actual:32767,expect:None;actual_type:<class 'list'>,expect_type:<class 'list'>    0411测试全pass 用db.create_engine进行连接
    @pytest.mark.parametrize("testCase", getCases(["/function/function"]))
    @allure.feature("function")
    @allure.story("batch")
    def test_function(self, testCase):
        print(testCase)
        fedb_executor.build(self.connect, testCase).run()

Example #10

File: test_standalone_multidb.py Project: 4paradigm/OpenMLDB

class TestStandaloneMultiDB(StandaloneTest):

    # 2,3,4,8 pass 要重写创建db
    @pytest.mark.parametrize("testCase",
                             getCases(["/function/multiple_databases/"]))
    @allure.feature("multidb")
    @allure.story("batch")
    def test_select(self, testCase):
        print(testCase)
        fedb_executor.build(self.connect, testCase).run()

Example #11

File: test_standalone_groupby_v040.py Project: 4paradigm/OpenMLDB

class TestStandaloneGroupbyV040(StandaloneTest):

    #11 没pass 因为排序没排好 但是是OK的
    @pytest.mark.parametrize("testCase",
                             getCases(["/function/v040/test_groupby.yaml"]))
    @allure.feature("groupby")
    @allure.story("batch")
    def test_window1(self, testCase):
        print(testCase)
        fedb_executor.build(self.connect, testCase).run()

Example #12

class TestStandaloneExpressV040(StandaloneTest):

    # 32 33 34 35也pass 之前因为//导致的  因为dataprovider 剩下都pass
    @pytest.mark.parametrize("testCase",
                             getCases(["/function/v040/test_like.yaml"]))
    @allure.feature("expression")
    @allure.story("batch")
    def test_express(self, testCase):
        print(testCase)
        fedb_executor.build(self.connect, testCase).run()

Example #13

class TestSelect(FedbTest):
    @pytest.mark.parametrize("testCase",
                             getCases([
                                 "/function/select/test_select_sample.yaml",
                                 "/function/select/test_sub_select.yaml"
                             ]))
    @allure.feature("SelectTest")
    @allure.story("batch")
    def test_create(self, testCase):
        fedb_executor.build(self.connect, testCase).run()

Example #14

File: test_standalone_function_v040.py Project: 4paradigm/OpenMLDB

class TestStandaloneFunctionV040(StandaloneTest):

    # 16，17pass啦  Syntax error: Illegal escape sequence: \% [at 2:7]   (1,'\\\%a_b',1590738990000L); 全都pass
    @pytest.mark.parametrize("testCase",
                             getCases(["/function/v040/test_like_match.yaml"]))
    @allure.feature("function")
    @allure.story("like_match")
    def test_express1(self, testCase):
        print(testCase)
        fedb_executor.build(self.connect, testCase).run()

    #全部pass
    @pytest.mark.parametrize("testCase",
                             getCases(["/function/v040/test_udaf.yaml"]))
    @allure.feature("function")
    @allure.story("udaf")
    def test_express2(self, testCase):
        print(testCase)
        fedb_executor.build(self.connect, testCase).run()

Example #15

File: test_standalone_express.py Project: 4paradigm/OpenMLDB

class TestStandaloneExpress(StandaloneTest):

    # testcase 71 72 73 74 75 76没pass 剩下都pass
    #assert actual == value, 'actual:{},expect:{}'.format(actual, value)
    #AssertionError: actual:id bigint,expect:id:bigint
    @pytest.mark.parametrize("testCase", getCases(["/function/expression"]))
    @allure.feature("expression")
    @allure.story("batch")
    def test_express(self, testCase):
        print(testCase)
        fedb_executor.build(self.connect, testCase).run()

Example #16

File: test_ddl.py Project: dl239/OpenMLDB

class TestDDL(FedbTest):
    @pytest.mark.parametrize("testCase",
                             getCases(["/function/ddl/test_create.yaml"]))
    @allure.feature("DDL")
    @allure.story("create")
    def test_create(self, testCase):
        print(testCase)
        fedb_executor.build(self.connect, testCase).run()

    @pytest.mark.parametrize("testCase",
                             getCases(["/function/dml/test_insert.yaml"]))
    @allure.feature("DDL")
    @allure.story("insert")
    def test_insert(self, testCase):
        fedb_executor.build(self.connect, testCase).run()

    @pytest.mark.parametrize("testCase",
                             getCases(["/function/ddl/test_ttl.yaml"]))
    @allure.feature("DDL")
    @allure.story("ttl")
    def test_ttl(self, testCase):
        fedb_executor.build(self.connect, testCase).run()

Example #17

class TestStandaloneLastjoin(StandaloneTest):

    #全部pass
    @pytest.mark.parametrize("testCase",
                             getCases([
                                 "/function/join/",
                                 "/function/cluster/window_and_lastjoin.yaml"
                             ]))
    @allure.feature("lastjoin")
    @allure.story("batch")
    def test_function(self, testCase):
        print(testCase)
        fedb_executor.build(self.connect, testCase).run()

Example #18

class TestStandaloneDDL(StandaloneTest):
    @pytest.mark.parametrize("testCase",
                             getCases(["/function/ddl/test_create.yaml"]))
    @allure.feature("DDL")
    @allure.story("create")
    def test_create(self, testCase):
        print(testCase)
        fedb_executor.build(self.connect, testCase).run()

    #全pass
    @pytest.mark.parametrize("testCase",
                             getCases(["/function/ddl/test_ttl.yaml"]))
    @allure.feature("DDL")
    @allure.story("ttl")
    def test_ttl(self, testCase):
        fedb_executor.build(self.connect, testCase).run()

    #有问题
    @pytest.mark.parametrize("testCase",
                             getCases(["/function/ddl/test_options.yaml"]))
    @allure.feature("DDL")
    @allure.story("ttl")
    def test_options(self, testCase):
        fedb_executor.build(self.connect, testCase).run()

Example #19

File: test_lastjoin.py Project: dl239/OpenMLDB

class TestLatJoin(FedbTest):
    @pytest.mark.parametrize("testCase", getCases(["/function/join/"]))
    @allure.feature("Lastjoin")
    @allure.story("batch")
    def test_lastjoin(self, testCase):
        fedb_executor.build(self.connect, testCase).run()