Django 3.2 works with SQL Anywhere

[former_SQLA_member1694984]

Hi all,

I am using Django 3.2 , could I use Django with Sql Anywhere ?

Thanks in advance

[Vlad]

Never tried this. If this is just Python, probably you can start with this thread: https://sqlanywhere-forum.sap.com/questions/36133/connecting-to-sql17-from-python

[VolkerBarth]

While Django as such is certainly supported and is also used by this very site AFAIK, I think Armin's question is about support for Django 3.2.

(I don't know...)

[Vlad]

ok, then I am stupid. Understood his question wrong. I'd say.... it is not that difficult to install SA + Django and give them a try 🙂

[Breck_Carter]

Try asking graeme.perrow at sap.com

[former_SQLA_member1694984]

Hi all , Thank you very much for your responses.

Using DOS cmd I install the engine for SQL Anywhere 16, running this comand: pip install sqlany-django The engine is installed OK

In Django file settings.py in the variable DATABASES , I copy the definition of my database:

    DATABASES = {
      'default' : {
      'ENGINE': 'sqlany_django',
      'NAME': 'django',
      'USER': 'dba',
      'PASSWORD': 'sql',
      'HOST': 'localhost',
      'PORT': '2644',
      }
    }

And always receive the same error:

File "C:\\Users\\armin\\AppData\\Local\\Programs\\Python\\Python310\\lib\\site-packages\\sqlany_django\\base.py", line 48, in <module> 

    Database.register_converter(Database.DT_DECIMAL, util.typecast_decimal)
AttributeError: module 'django.db.backends.utils' has no attribute 'typecast_decimal'

What I'm doing wrong, Thanks in advance Armin

[VolkerBarth]

I don't use Django but from my limited understanding, it seems that Django 2.x dropped/modified that attribute, see here for a similiar Firebird change.

I would suspect that the sqlany-django package would need to be adapted, as well. Hopefully @Graeme is listening...

---

Of course you could verify that claim with also trying to use Django 1.x which is supported by sqlany-django according to the package docs.