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 [email protected].
> 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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/b51b1f40-e703-4d70-a175-35210a85bb28n%40googlegroups.com.
