summaryrefslogtreecommitdiff
path: root/tests/backends/postgresql/test_introspection.py
blob: cfa801a77f7ab953f6cb1f3305a39418ce30ef04 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
import unittest

from django.db import connection
from django.test import TestCase

from ..models import Person


@unittest.skipUnless(connection.vendor == 'postgresql', "Test only for PostgreSQL")
class DatabaseSequenceTests(TestCase):
    def test_get_sequences(self):
        cursor = connection.cursor()
        seqs = connection.introspection.get_sequences(cursor, Person._meta.db_table)
        self.assertEqual(
            seqs,
            [{'table': Person._meta.db_table, 'column': 'id', 'name': 'backends_person_id_seq'}]
        )
        cursor.execute('ALTER SEQUENCE backends_person_id_seq RENAME TO pers_seq')
        seqs = connection.introspection.get_sequences(cursor, Person._meta.db_table)
        self.assertEqual(
            seqs,
            [{'table': Person._meta.db_table, 'column': 'id', 'name': 'pers_seq'}]
        )