Added some tests for SQLAlchemyModelFactory

1 files changed, 134 insertions, 0 deletions

diff --git a/tests/test_alchemy.py b/tests/test_alchemy.py
new file mode 100644
index 0000000..a1d8576
--- /dev/null
+++ b/tests/test_alchemy.py
@@ -0,0 +1,134 @@
+# -*- coding: utf-8 -*-
+# Copyright (c) 2013 Romain Command&
+#
+# Permission is hereby granted, free of charge, to any person obtaining a copy
+# of this software and associated documentation files (the "Software"), to deal
+# in the Software without restriction, including without limitation the rights
+# to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
+# copies of the Software, and to permit persons to whom the Software is
+# furnished to do so, subject to the following conditions:
+#
+# The above copyright notice and this permission notice shall be included in
+# all copies or substantial portions of the Software.
+#
+# THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
+# IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
+# FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
+# AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
+# LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
+# OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
+# THE SOFTWARE.
+
+"""Tests for factory_boy/SQLAlchemy interactions."""
+
+import factory
+from .compat import unittest
+
+
+try:
+    import sqlalchemy
+except ImportError:
+    sqlalchemy = None
+
+if sqlalchemy:
+    from factory import SQLAlchemyModelFactory
+    from .alchemyapp import models
+else:
+
+    class Fake(object):
+        FACTORY_SESSION = None
+
+    models = Fake()
+    models.StandardModel = Fake()
+    models.NonIntegerPk = Fake()
+    models.session = Fake()
+    SQLAlchemyModelFactory = Fake
+
+
+class StandardFactory(SQLAlchemyModelFactory):
+    FACTORY_FOR = models.StandardModel
+    FACTORY_SESSION = models.session
+
+    id = factory.Sequence(lambda n: n)
+    foo = factory.Sequence(lambda n: u'foo%d' % n)
+
+
+class NonIntegerPkFactory(SQLAlchemyModelFactory):
+    FACTORY_FOR = models.NonIntegerPk
+    FACTORY_SESSION = models.session
+
+    id = factory.Sequence(lambda n: u'foo%d' % n)
+
+
+@unittest.skipIf(sqlalchemy is None, "SQLalchemy not installed.")
+class SQLAlchemyPkSequenceTestCase(unittest.TestCase):
+
+    def setUp(self):
+        super(SQLAlchemyPkSequenceTestCase, self).setUp()
+        StandardFactory.reset_sequence()
+        NonIntegerPkFactory.FACTORY_SESSION.rollback()
+
+    def test_pk_first(self):
+        std = StandardFactory.build()
+        self.assertEqual(u'foo1', std.foo)
+
+    def test_pk_many(self):
+        std1 = StandardFactory.build()
+        std2 = StandardFactory.build()
+        self.assertEqual(u'foo1', std1.foo)
+        self.assertEqual(u'foo2', std2.foo)
+
+    def test_pk_creation(self):
+        std1 = StandardFactory.create()
+        self.assertEqual(u'foo1', std1.foo)
+        self.assertEqual(1, std1.id)
+
+        StandardFactory.reset_sequence()
+        std2 = StandardFactory.create()
+        self.assertEqual(u'foo2', std2.foo)
+        self.assertEqual(2, std2.id)
+
+    def test_pk_force_value(self):
+        std1 = StandardFactory.create(id=10)
+        self.assertEqual(u'foo1', std1.foo)  # sequence was set before pk
+        self.assertEqual(10, std1.id)
+
+        StandardFactory.reset_sequence()
+        std2 = StandardFactory.create()
+        self.assertEqual(u'foo11', std2.foo)
+        self.assertEqual(11, std2.id)
+
+
+@unittest.skipIf(sqlalchemy is None, "SQLalchemy not installed.")
+class SQLAlchemyNonIntegerPkTestCase(unittest.TestCase):
+    def setUp(self):
+        super(SQLAlchemyNonIntegerPkTestCase, self).setUp()
+        NonIntegerPkFactory.reset_sequence()
+        NonIntegerPkFactory.FACTORY_SESSION.rollback()
+
+    def test_first(self):
+        nonint = NonIntegerPkFactory.build()
+        self.assertEqual(u'foo1', nonint.id)
+
+    def test_many(self):
+        nonint1 = NonIntegerPkFactory.build()
+        nonint2 = NonIntegerPkFactory.build()
+
+        self.assertEqual(u'foo1', nonint1.id)
+        self.assertEqual(u'foo2', nonint2.id)
+
+    def test_creation(self):
+        nonint1 = NonIntegerPkFactory.create()
+        self.assertEqual(u'foo1', nonint1.id)
+
+        NonIntegerPkFactory.reset_sequence()
+        nonint2 = NonIntegerPkFactory.build()
+        self.assertEqual(u'foo1', nonint2.id)
+
+    def test_force_pk(self):
+        nonint1 = NonIntegerPkFactory.create(id='foo10')
+        self.assertEqual(u'foo10', nonint1.id)
+
+        NonIntegerPkFactory.reset_sequence()
+        nonint2 = NonIntegerPkFactory.create()
+        self.assertEqual(u'foo1', nonint2.id)