Method setUpClass

tests/test_special.py:20–39

(cls)

    @classmethod
    def setUpClass(cls):
        try:
            # create the database objects to test upon
            client = create_mssql_cli_client()
            list(client.execute_query('CREATE DATABASE {0};'.format(cls.database)))
            list(client.execute_query('CREATE TABLE {0} (a int, b varchar(25));'
                                      .format(cls.table1)))
            list(client.execute_query('CREATE TABLE {0} (x int, y varchar(25), z bit);'
                                      .format(cls.table2)))
            list(client.execute_query('CREATE VIEW {0} as SELECT a from {1};'
                                      .format(cls.view, cls.table1)))
            list(client.execute_query('CREATE SCHEMA {0};'.format(cls.schema)))
            list(client.execute_query('CREATE INDEX {0} ON {1} (x);'.format(cls.index, cls.table2)))
            list(client.execute_query('CREATE FUNCTION {0}() \
                                       RETURNS TABLE AS RETURN (select 1 as number);'
                                      .format(cls.function)))
            list(client.execute_query('CREATE LOGIN {0} WITH PASSWORD=\'yoloC123445!\''
                                      .format(cls.login)))
        finally:
            shutdown(client)

    @classmethod
    def tearDownClass(cls):