text: ##########################################################################
  #
  # pgAdmin 4 - PostgreSQL Tools
  #
  # Copyright (C) 2013 - 2018, The pgAdmin Development Team
  # This software is released under the PostgreSQL Licence
  #
  ##########################################################################
  
  import os
  
  from regression.python_test_utils.sql_template_test_base import SQLTemplateTestBase
  from regression.python_test_utils.template_helper import file_as_template
  
  
  class TestTriggerNodesSql(SQLTemplateTestBase):
      scenarios = [
          ('Test Trigger Nodes SQL file', dict())
      ]
  
      def __init__(self):
          super(TestTriggerNodesSql, self).__init__()
          self.table_id = -1
  
      def test_setup(self, connection, cursor):
          cursor.execute("SELECT pg_class.oid AS table_id "
                         "FROM pg_class "
                         "WHERE pg_class.relname='test_table'")
          self.table_id = cursor.fetchone()[0]
  
      def generate_sql(self, version):
          template_file = self.get_template_file(version, "nodes.sql")
          template = file_as_template(template_file)
          sql = template.render(tid=self.table_id)
  
          return sql
  
      def assertions(self, fetch_result, descriptions):
          self.assertEqual(0, len(fetch_result))
  
      @staticmethod
      def get_template_file(version, filename):
          return os.path.join(os.path.dirname(__file__), "..", "templates", "trigger", "sql", version, filename)
  