sqlobject - w3toppers.com

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

To use SSL certs with SQLAlchemy and MySQLdb, use the following python code: db_connect_string=’mysql://<user>:<pswd>@<db server>:3306/<database>’ ssl_args = {‘ssl’: {‘cert’:’/path/to/client-cert’, ‘key’:’/path/to/client-key’, ‘ca’:’/path/to/ca-cert’}} create_engine(db_connect_string, connect_args=ssl_args)

Remove duplicates in list of object with Python

The set(list_of_objects) will only remove the duplicates if you know what a duplicate is, that is, you’ll need to define a uniqueness of an object. In order to do that, you’ll need to make the object hashable. You need to define both __hash__ and __eq__ method, here is how: http://docs.python.org/glossary.html#term-hashable Though, you’ll probably only need … Read more