test_ecpg.py

import unittest

from pgsanity import ecpg

class TestEcpg(unittest.TestCase):
    def test_simple_success(self):
        text = u"EXEC SQL select a from b;"
        (success, msg) = ecpg.check_syntax(text)
        self.assertTrue(success)

    def test_simple_failure(self):
        text = u"EXEC SQL garbage select a from b;"
        (success, msg) = ecpg.check_syntax(text)
        self.assertFalse(success)
        self.assertEqual('line 1: ERROR: unrecognized data type name "garbage"', msg)

    def test_empty_sql_okay(self):
        text = u"EXEC SQL ;"
        (success, msg) = ecpg.check_syntax(text)
        self.assertTrue(success)

    def test_parse_error_simple(self):
        error = '/tmp/tmpLBKZo5.pgc:1: ERROR: unrecognized data type name "garbage"'
        expected = 'line 1: ERROR: unrecognized data type name "garbage"'
        self.assertEqual(expected, ecpg.parse_error(error))

    def test_parse_error_comments(self):
        error = '/tmp/tmpLBKZo5.pgc:5: ERROR: syntax error at or near "//"'
        expected = 'line 5: ERROR: syntax error at or near "--"'
        self.assertEqual(expected, ecpg.parse_error(error))