Ticket #1291 (new wish)

Opened 18 months ago

Connect to a mysql using a unix_socket

Reported by: jarnavat Owned by:
Milestone: 2.6 Component: other
Severity: minor Keywords: Mysql unix_socket
Cc: Blocking:
Blocked By:

Description

Hello,

I have just registered because I just downloaded orange and I would like to connect to a local mysql using a unix socket. But I couldn't.

And I just take a look into your really nice code, and added two lines in Orange/data/sql.py to be able to connect to a mysql using a unix_socket. And I would like to share this lines with you:

def _connection(uri):

. . .

if path:

dbArgDict[argTransdatabase?] = path[1:]

if schema == 'mysql' and args and args.has_key('unix_socket'):

dbArgDictunix_socket? = args.get('unix_socket')

return (quirks, dbmod.connect(dbArgDict))

Those lines make posible to use a connection string like the next one and be able toconnect to the mysql database. 'mysql://root:@localhost/users?unix_socket=/usr/local/zend/mysql/tmp/mysql.sock'

I don't know If you will consider to add this lines onto your code, but I will keep them on my local copy because help me to use orange.

Thanks a lot for your work

Jordi

Attachments

sql.py Download (16.5 KB) - added by jarnavat 18 months ago.

Change History

Changed 18 months ago by jarnavat

Note: See TracTickets for help on using tickets.