Пример #1
0
    def testEnvironment(self):
        noora_dir = os.path.dirname(noora.__file__)
        current_dir = os.path.abspath('.')

        properties = dict()
        properties["noora.dir"] = noora_dir
        properties["current.dir"] = current_dir

        executable = {}
        executable['script'] = File("exec_get_environment.sql")
        executable['host'] = "elsevierdb4.c07v9zv3jhxs.eu-west-1.rds.amazonaws.com,1433"
        executable['user'] = "******"
        executable['password'] = "******"
        executable['database'] = "ElsevierDB"

        connector = MssqlConnector()
        connector.execute(executable, properties)
Пример #2
0
 def __init__(self):
     Plugin.__init__(self, "drop", MssqlConnector())
Пример #3
0
    def testMssqlConnector(self):
        noora_dir = os.path.dirname(noora.__file__)
        current_dir = os.path.abspath('.')

        properties = dict()
        properties["noora.dir"] = noora_dir
        properties["current.dir"] = current_dir

        executable = {}
        executable['script'] = File("drop_application_properties_s.sql")
        executable['host'] = "elsevierdb4.c07v9zv3jhxs.eu-west-1.rds.amazonaws.com,1433"
        executable['user'] = "******"
        executable['password'] = "******"
        executable['database'] = "ElsevierDB"

        connector = MssqlConnector()
        connector.execute(executable, properties)


        executable = {}
        executable['script'] = File("application_properties_s.sql")
        executable['host'] = "elsevierdb4.c07v9zv3jhxs.eu-west-1.rds.amazonaws.com,1433"
        executable['user'] = "******"
        executable['password'] = "******"
        executable['database'] = "ElsevierDB"

        connector = MssqlConnector()
        connector.execute(executable, properties)

        executable = {}
        executable['script'] = File("drop_application_properties.sql")
        executable['host'] = "elsevierdb4.c07v9zv3jhxs.eu-west-1.rds.amazonaws.com,1433"
        executable['user'] = "******"
        executable['password'] = "******"
        executable['database'] = "ElsevierDB"

        connector = MssqlConnector()
        connector.execute(executable, properties)


        executable = {}
        executable['script'] = File("application_properties.sql")
        executable['host'] = "elsevierdb4.c07v9zv3jhxs.eu-west-1.rds.amazonaws.com,1433"
        executable['user'] = "******"
        executable['password'] = "******"
        executable['database'] = "ElsevierDB"

        connector = MssqlConnector()
        connector.execute(executable, properties)

        executable = {}
        executable['script'] = File("drop_app_prop.sql")
        executable['host'] = "elsevierdb4.c07v9zv3jhxs.eu-west-1.rds.amazonaws.com,1433"
        executable['user'] = "******" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             "" \
                             ""
        executable['password'] = "******"
        executable['database'] = "ElsevierDB"

        connector = MssqlConnector()
        connector.execute(executable, properties)


        executable = {}
        executable['script'] = File("app_prop.sql")
        executable['host'] = "elsevierdb4.c07v9zv3jhxs.eu-west-1.rds.amazonaws.com,1433"
        executable['user'] = "******"
        executable['password'] = "******"
        executable['database'] = "ElsevierDB"

        connector = MssqlConnector()
        connector.execute(executable, properties)
Пример #4
0
 def __init__(self):
     Plugin.__init__(self, "recreate", MssqlConnector())
Пример #5
0
 def __init__(self):
     Plugin.__init__(self, "update", MssqlConnector())