Python CreateTriggerFunctionSQL Examples

Example #1

File: test_triggers.py Project: mediatum/sqlalchemy-continuum

 def test_trigger_func_non_default_extension_schema(self):
     default_extension_schema = versioning_manager.options["extension_schema"]
     versioning_manager.options["extension_schema"] = "extension"
     trigger_func = str(CreateTriggerFunctionSQL.for_manager(versioning_manager, self.Article))
     assert "OPERATOR(extension.-)" in trigger_func
     assert "OPERATOR(extension.=)" in trigger_func
     assert trigger_func.count("extension.hstore(") == 3
     versioning_manager.options["extension_schema"] = default_extension_schema

Example #2

 def test_trigger_func_non_default_extension_schema(self):
     default_extension_schema = versioning_manager.options[
         "extension_schema"]
     versioning_manager.options["extension_schema"] = "extension"
     trigger_func = str(
         CreateTriggerFunctionSQL.for_manager(versioning_manager,
                                              self.Article))
     assert "OPERATOR(extension.-)" in trigger_func
     assert "OPERATOR(extension.=)" in trigger_func
     assert trigger_func.count("extension.hstore(") == 3
     versioning_manager.options[
         "extension_schema"] = default_extension_schema

Example #3

 def test_trigger_func_default_extension_schema(self):
     trigger_func = str(
         CreateTriggerFunctionSQL.for_manager(versioning_manager,
                                              self.Article))
     assert "OPERATOR(-)" in trigger_func

Example #4

File: test_triggers.py Project: mediatum/sqlalchemy-continuum

 def test_trigger_func_default_extension_schema(self):
     trigger_func = str(CreateTriggerFunctionSQL.for_manager(versioning_manager, self.Article))
     assert "OPERATOR(-)" in trigger_func