A simple (too simple?) patch to support SSL connections with MySQL.
Use the following syntax to use it:
mysql://user:[EMAIL PROTECTED]/db?ssl_ca=<path-to-ca-file>
Tested with SA from svn, mysql-5.0.27, python-2.4.4 and MySQL-
python-1.2.1.
- Terje
Index: lib/sqlalchemy/databases/mysql.py
===================================================================
--- lib/sqlalchemy/databases/mysql.py (revisjon 2530)
+++ lib/sqlalchemy/databases/mysql.py (arbeidskopi)
@@ -293,8 +293,21 @@
# note: these two could break SA Unicode type
util.coerce_kw_type(opts, 'use_unicode', bool)
util.coerce_kw_type(opts, 'charset', str)
- # TODO: what about options like "ssl", "cursorclass" and
"conv" ?
+ # ssl
+ ssl_opts = ['key', 'cert', 'ca', 'capath', 'cipher']
+ for opt in ssl_opts:
+ util.coerce_kw_type(opts, 'ssl_' + opt, str)
+ # ssl_ca option is required to use ssl
+ if 'ssl_ca' in opts.keys():
+ # ssl arg must be a dict
+ ssl = {}
+ for opt in ssl_opts:
+ if 'ssl_' + opt in opts.keys():
+ ssl[opt] = opts['ssl_' + opt]
+ del opts['ssl_' + opt]
+ opts['ssl'] = ssl
+ # TODO: what about options like "cursorclass" and "conv" ?
client_flag = opts.get('client_flag', 0)
if self.dbapi is not None:
try:
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
