| 1788 | |
| 1789 | @classmethod |
| 1790 | def insert_data(cls, connection): |
| 1791 | UserKeyword, User, Keyword, Singular = ( |
| 1792 | cls.classes.UserKeyword, |
| 1793 | cls.classes.User, |
| 1794 | cls.classes.Keyword, |
| 1795 | cls.classes.Singular, |
| 1796 | ) |
| 1797 | |
| 1798 | session = Session(connection) |
| 1799 | words = (class="st">"quick", class="st">"brown", class="st">"fox", class="st">"jumped", class="st">"over", class="st">"the", class="st">"lazy") |
| 1800 | for ii in range(16): |
| 1801 | user = User(class="st">"user%d" % ii) |
| 1802 | |
| 1803 | if ii % 2 == 0: |
| 1804 | user.singular = Singular( |
| 1805 | value=(class="st">"singular%d" % ii) if ii % 4 == 0 else None |
| 1806 | ) |
| 1807 | session.add(user) |
| 1808 | for jj in words[(ii % len(words)) : ((ii + 3) % len(words))]: |
| 1809 | k = Keyword(jj) |
| 1810 | user.keywords.append(k) |
| 1811 | if ii % 2 == 0: |
| 1812 | user.singular.keywords.append(k) |
| 1813 | user.user_keywords[-1].value = class="st">"singular%d" % ii |
| 1814 | |
| 1815 | orphan = Keyword(class="st">"orphan") |
| 1816 | orphan.user_keyword = UserKeyword(keyword=orphan, user=None) |
| 1817 | session.add(orphan) |
| 1818 | |
| 1819 | keyword_with_nothing = Keyword(class="st">"kwnothing") |
| 1820 | session.add(keyword_with_nothing) |
| 1821 | |
| 1822 | session.commit() |
| 1823 | cls.u = user |
| 1824 | cls.kw = user.keywords[0] |
| 1825 | |
| 1826 | class="cm"># TODO: this is not the correct pattern, use session per test |
| 1827 | cls.session = Session(testing.db) |
| 1828 | |
| 1829 | def _query_equivalent(self, q_proxy, q_direct): |
| 1830 | self._equivalent(q_proxy.statement, q_direct.statement) |