summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--tests/__init__.py1
-rw-r--r--tests/alchemyapp/__init__.py0
-rw-r--r--tests/alchemyapp/models.py47
-rw-r--r--tests/test_alchemy.py134
4 files changed, 182 insertions, 0 deletions
diff --git a/tests/__init__.py b/tests/__init__.py
index 1529e21..9960382 100644
--- a/tests/__init__.py
+++ b/tests/__init__.py
@@ -8,3 +8,4 @@ from .test_django import *
from .test_fuzzy import *
from .test_using import *
from .test_utils import *
+from .test_alchemy import *
diff --git a/tests/alchemyapp/__init__.py b/tests/alchemyapp/__init__.py
new file mode 100644
index 0000000..e69de29
--- /dev/null
+++ b/tests/alchemyapp/__init__.py
diff --git a/tests/alchemyapp/models.py b/tests/alchemyapp/models.py
new file mode 100644
index 0000000..e0193d4
--- /dev/null
+++ b/tests/alchemyapp/models.py
@@ -0,0 +1,47 @@
+# -*- 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.
+
+
+"""Helpers for testing SQLAlchemy apps."""
+
+from sqlalchemy import Column, Integer, Unicode, create_engine
+from sqlalchemy.ext.declarative import declarative_base
+from sqlalchemy.orm import scoped_session, sessionmaker
+
+session = scoped_session(sessionmaker())
+engine = create_engine('sqlite://')
+session.configure(bind=engine)
+Base = declarative_base()
+
+
+class StandardModel(Base):
+ __tablename__ = 'StandardModelTable'
+
+ id = Column(Integer(), primary_key=True)
+ foo = Column(Unicode(20))
+
+
+class NonIntegerPk(Base):
+ __tablename__ = 'NonIntegerPk'
+
+ id = Column(Unicode(20), primary_key=True)
+
+Base.metadata.create_all(engine)
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)