Hi, Thank you for response. I would like to inform you that , for testing that code I am using pytest only. What i am facing is, it is worked properly till Sqlalchemy version 1.3.15. When I upgraded the Sqlalchemy version to 1.3.17 ,mentioned piece of code is failing at import level itself. ''from sqlalchemy. testing import fixtures",unable to import fixtures into my file to test my code. So how can I import fixtures in latest versions of sqlalchemy for testing my code.
Thank you. Sai Rohith Yerramilli On Saturday, December 11, 2021 at 10:17:15 PM UTC+5:30 Mike Bayer wrote: > 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+...@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/ea1d00f1-a63c-4389-ae7a-80a7b30424dan%40googlegroups.com.
