File: test_composite_keys.py

package info (click to toggle)
python-sqlalchemy-utils 0.41.2-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 1,252 kB
  • sloc: python: 13,566; makefile: 141
file content (83 lines) | stat: -rw-r--r-- 1,977 bytes parent folder | download | duplicates (2)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
import pytest
import sqlalchemy as sa

from sqlalchemy_utils import generic_relationship

from ..generic_relationship import GenericRelationshipTestCase


@pytest.fixture
def incrementor():
    class Incrementor:
        value = 1
    return Incrementor()


@pytest.fixture
def Building(Base, incrementor):
    class Building(Base):
        __tablename__ = 'building'
        id = sa.Column(sa.Integer, primary_key=True)
        code = sa.Column(sa.Integer, primary_key=True)

        def __init__(self):
            incrementor.value += 1
            self.id = incrementor.value
            self.code = incrementor.value
    return Building


@pytest.fixture
def User(Base, incrementor):
    class User(Base):
        __tablename__ = 'user'
        id = sa.Column(sa.Integer, primary_key=True)
        code = sa.Column(sa.Integer, primary_key=True)

        def __init__(self):
            incrementor.value += 1
            self.id = incrementor.value
            self.code = incrementor.value
    return User


@pytest.fixture
def Event(Base):
    class Event(Base):
        __tablename__ = 'event'
        id = sa.Column(sa.Integer, primary_key=True)

        object_type = sa.Column(sa.Unicode(255))
        object_id = sa.Column(sa.Integer, nullable=False)
        object_code = sa.Column(sa.Integer, nullable=False)

        object = generic_relationship(
            object_type, (object_id, object_code)
        )
    return Event


@pytest.fixture
def init_models(Building, User, Event):
    pass


class TestGenericRelationship(GenericRelationshipTestCase):

    def test_set_manual_and_get(self, session, Event, User):
        user = User()

        session.add(user)
        session.commit()

        event = Event()
        event.object_id = user.id
        event.object_type = type(user).__name__
        event.object_code = user.code

        assert event.object is None

        session.add(event)
        session.commit()

        assert event.object == user