Search code examples
pythonmysqlsqlalchemysqlobject

How to make mysql connection that requires CA-CERT with sqlalchemy or SQLObject

I would like to connect to a MySQL database that requires ca-cert. I can do it with MySQLdb like below:

MySQLdb.connect(host = self.host,
                port = self.port,
                unix_socket = self.unix_socket,
                user = self.user,                                
                passwd = self.passwd,
                db = self.db,
                ssl = { 'cert': self.sslcert,
                        'key': self.sslkey,
                         'ca': self.sslca }

How do I do the same think in SQLAlchemy or SQLObject?

Thanks, peter

Solution

  • create_engine() in SQLAlchemy has a connect_args parameter:

    connect_args – a dictionary of options which will be passed directly to the DBAPI’s connect() method as additional keyword arguments.