not expected to work right now unless you run pytest and you have the appropriate project layout installed as documented at https://github.com/sqlalchemy/sqlalchemy/blob/main/README.dialects.rst
On Sat, Dec 11, 2021, at 3:49 AM, sairohith yerramilli wrote: > Hi > > from sqlalchemy.testing import fixtures, AssertsCompiledSQL > from sqlalchemy.sql.functions import ReturnTypeFromArgs > from sqlalchemy import select > from sqlalchemy.sql import column > > > class isnull(ReturnTypeFromArgs): > name = 'isnull' > > class TestFunction(fixtures.TestBase,AssertsCompiledSQL): > > __dialect__ = 'mssql+mxodbc' > > > def test_null_concat(self): > self.assert_compile(select([isnull(column('spam'), '') + > > isnull(column('spamspam'), '').label("bothcols"), ]), > "SELECT > isnull(spam, :isnull_1) + " > > "isnull(spamspam, :isnull_2) AS anon_1") > > This piece of code is working good in SQLAlchemy 1.3.15 version and below > but failing in above versions. > Getting issue when importing "from sqlalchemy.testing import fixtures". > > Thank you. > > > On Thursday, December 9, 2021 at 11:00:58 PM UTC+5:30 Mike Bayer wrote: >> __ >> these fixtures are only for use within a pytest test suite that is using >> SQLAlchemy's plugins. is this for a third party dialect project? >> >> >> >> On Thu, Dec 9, 2021, at 9:42 AM, sairohith yerramilli wrote: >>> Hi >>> I am facing an issue when importing fixtures from sqlalchemy in version >>> 1.3.16 and above. >>> When i am trying to import fixtures from sqlalchemy >>> i.e "from sqlachemy.testing import fixtures" it throwing me an attribute >>> error says 'NoneType' object has no attribute 'fixture' >>> >>> This change in behavior is observed from this commit : >>> 7c4512cbeb1cf9e4e988e833589ddc6377b5e525 >>> >>> I am unable to import fixtures with those commit changes. >>> >>> So can you help me in importing fixture in the upgraded versions of >>> SQLAlchemy. >>> >>> I have attached a screenshot for your reference >>> >>> Thank you. >>> >>> Sai Rohith Yerramilli >>> >>> >>> >>> -- >>> SQLAlchemy - >>> The Python SQL Toolkit and Object Relational Mapper >>> >>> http://www.sqlalchemy.org/ >>> >>> To post example code, please provide an MCVE: Minimal, Complete, and >>> Verifiable Example. See http://stackoverflow.com/help/mcve for a full >>> description. >>> --- >>> You received this message because you are subscribed to the Google Groups >>> "sqlalchemy" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to sqlalchemy+...@googlegroups.com. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/sqlalchemy/cf898e96-b78a-4aa4-9a19-4e966007234cn%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/sqlalchemy/cf898e96-b78a-4aa4-9a19-4e966007234cn%40googlegroups.com?utm_medium=email&utm_source=footer>. >>> >>> >>> *Attachments:* >>> * import errror.PNG >> > > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/b51b1f40-e703-4d70-a175-35210a85bb28n%40googlegroups.com > > <https://groups.google.com/d/msgid/sqlalchemy/b51b1f40-e703-4d70-a175-35210a85bb28n%40googlegroups.com?utm_medium=email&utm_source=footer>. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/1aefed12-e055-4a9e-871d-7b8786923665%40www.fastmail.com.