search

web2py / pydal

A pure Python Database Abstraction Layer
BSD 3-Clause "New" or "Revised" License
497 stars 140 forks source link

PyDAL for Azure MySQL #712

Open rogeriosantosluz opened 1 year ago

rogeriosantosluz commented 1 year ago

Hi I'd like to suugest two things to make PyDAL work with MySQL Azure:

  1. Adjust REGEX_URI on MySQL class to accept user with "@", required for Azure MySQL connections "^(?P<user>[^:]+)(:(?P<password>[^@]*))?" will work
  2. Make uriargs accept an extra argument called ssl_ca that will point to DigiCertGlobalRootG2.crt self.driver_args["ssl"] = {"ssl-ca": ssl_ca} mysql.txt

Thank you

mdipierro commented 4 days ago

Wow. I ignored this for one year and I feel bad. I would be happy to support this. Any chance you could make a PR and help test it.