ltpda-connection-manager: README annotate

annotate README @ 1:c4b57991935a

Tell emacs to use org mode for this file.

author	Daniele Nicolodi <daniele@science.unitn.it>
date	Sun, 23 May 2010 22:06:57 +0200
parents	d5fef23867bb
children	b71833fb33ef

rev	line source
0 d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	1 * Requirements
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	2
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	3 1. Provide an interface for the user to insert connection
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	4 credentials: server hostname, database name, user name and
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	5 password.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	6
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	7 2. Avoid that the user has to enter those information too often,
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	8 like when retrieving many objects from the repository. This is
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	9 done caching the credentials for a configurable amount of time
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	10
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	11 3. Provide understandable error messages.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	12
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	13 4. Track open connections, and avoid excessive proliferation of open
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	14 connections to the database, due to miss behaving user functions.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	15
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	16 This is all about managing connections, so I would propose to call
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	17 this component LTPDAConnectionManager.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	18
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	19
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	20 * Interface definition
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	21
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	22 ** LTPDAConnectionManager()
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	23
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	24 Isntantiates a singleton class managing credentials and connections.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	25
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	26 Credentials are cached. Credentials, except password are cached
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	27 forever, passwords are cached for a configurable amount of time.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	28
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	29 Connections are tracked putting each handed out connection into a
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	30 list. When a new connection is requested, or when requested via a
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	31 dedicated method, the connection list is walked and closed
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	32 connections are removed from it. When the connection number exceeds
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	33 a configurable maximum, no more connection are instantiated.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	34
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	35 The singleton clas is implemented as an handle matlab class that
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	36 stores an handle to itself in appdata storage. When the class is
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	37 instantiates it returns an handle to the copy referenced in
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	38 appdata.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	39
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	40 *** appdataKey
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	41
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	42 Static mehod that returns the key used to store the handle to
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	43 instance data in appdata.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	44
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	45 *** credentialsExpiry
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	46
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	47 Property. Taken from user preferences. Time after which the
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	48 credentials are not valid anymore.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	49
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	50 *** maxConnectionsNumber
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	51
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	52 Property. Taken from user preferences. The maximum number of
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	53 connections that can be open at the same time toward the same
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	54 host.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	55
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	56 *** cachePassword
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	57
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	58 Property. Taken from user preferences. Defines if password should
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	59 be cached along with other database access credentials. It may
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	60 take the values:
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	61
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	62 0. passwords are not cached,
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	63 1. passwords are always cached,
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	64 2. ask if the users desires to cache the given password.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	65
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	66 *** connect(hostname, database, username, password)
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	67
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	68 Try to connect to the database with the given credentials. If the
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	69 connection attempt fails with an 'access denied' error, prompt the
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	70 user for username using the given username as default, and
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	71 password. Present the option to cache password. Cache username and
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	72 password accordingly to user choice. Do not cache passwords by
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	73 default.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	74
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	75 Return an object implementing the java.sql.Connection interface,
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	76 representing a connection to the given database, with the given
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	77 credentials.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	78
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	79 Connection errors, other than access denied are reported as
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	80 fatal exceptions. User hitting the cancel button on input forms is
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	81 reported as an 'user canceled' exception.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	82
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	83 *** connect(hostname, database, username)
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	84
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	85 Search the credentials cache for user password. If it is not
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	86 found, or the connection attempt fails with an access denied
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	87 error, prompt the user for username, using the given username as
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	88 default, and password. Present the option to cache password. Try
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	89 to connect to the database with the given credentials. When the
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	90 connections succeeds, cache username and password accordingly to
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	91 user choice.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	92
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	93 Return an object implementing the java.sql.Connection interface,
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	94 representing a connection to the given database, with the given
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	95 credentials.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	96
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	97 Errors, other than acces denied, are reported as fatal
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	98 exceptions. User hitting the cancel button on input forms is
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	99 reported as an 'user canceled' exception. Access denied errors are
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	100 catched and credentials are asked again.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	101
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	102 *** connect(hostname, database)
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	103
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	104 Search the credentials cache looking for usernames and passwords
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	105 for accessing the given database. If credentials are not found,
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	106 there is more than one set of credentials matching, or the
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	107 connection attempt fails with an 'acces denied' error, prompt the
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	108 user for username and password. Present the option to cache
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	109 password. When the connections succeeds, cache username and
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	110 password accordingly to user choice.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	111
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	112 Return an object implementing the java.sql.Connection interface,
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	113 representing a connection to the given database, with the given
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	114 credentials.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	115
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	116 Errors, other than acces denied, are reported as fatal
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	117 exceptions. User hitting the cancel button on input forms is
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	118 reported as an 'user canceled' exception. Access denied errors are
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	119 catched and credentials are asked again.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	120
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	121 *** connect()
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	122
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	123 Make the user choose between a list of hostname-database-username
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	124 tuples obtained from the credentials cache, and the possibility of
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	125 entering a hostname and a database. Then proceed as in the case of
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	126 the call to connect(hostname, database).
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	127
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	128 The list of hostname-database pairs can be initialized with data
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	129 from the LTPDA toolbox preferences or witj the add() method.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	130
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	131 *** connect(plist)
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	132
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	133 Same as the previous calls but taking parameters from PLIST.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	134
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	135 If PLIST has a 'connection' parameter, and if this is a valid java
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	136 object, implementing the java.sql.Connection, return it instead of
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	137 creating a new connection. If the object does not fulfill the
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	138 requirements throw a meaningful error.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	139
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	140 *** count()
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	141
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	142 Return the number of open connections in the connection pool. It
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	143 has the side effect of removing from the pool any close connection.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	144
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	145 *** close(ids)
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	146
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	147 Close connections with the given IDs in the connections pool. If no
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	148 ID is given close all connection.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	149
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	150 *** clear()
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	151
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	152 Clear credentials cache.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	153
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	154 *** add(credentials)
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	155
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	156 Add the given credentials to the cache.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	157
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	158
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	159 ** Utilities
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	160
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	161 *** utils.jmysql
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	162
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	163 Collection of utility functions for interfacing to a database from
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	164 a pure matlab environment. Except connect() all the functions take
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	165 a java object implementing java.sql.Connection as first parameter.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	166
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	167 *** utils.jmysql.connect(hostname, database, username, password)
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	168
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	169 Return an object implementing the java.sql.Connection interface,
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	170 representing a connection to the given database, with the given
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	171 credentials.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	172
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	173 Throw an error if the connection fails.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	174
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	175 This function can be used when the programmer wants full controll
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	176 on the connection, stepping aside of the connection manager.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	177
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	178 Should not be used in toolbox functions or by the toolbox users.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	179
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	180 *** utils.jmysql.execute(conn, query, varargin)
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	181
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	182 Execute the query QUERY, with the parameters specified in VARARGIN
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	183 through the connection CONN. Returns the results in a 2d cell
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	184 array. See the actual implementation.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	185
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	186 QUERY is a string, CONN is a java object implementing
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	187 java.sql.Connection, VARARGIN can contain any base matlab type. we
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	188 can think about introducing the marshalling for time() objects
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	189 into SQL strings.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	190
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	191 See current implementation in CVS.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	192
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	193 *** plist.REPOSITORY_CREDENTIALS_PLIST
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	194
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	195 Static method that returns a default plist that specifies the
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	196 credentials required to connect to a repository. Should be
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	197 combined in the default plist of the ltpda methods that require
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	198 a connection to the database. Those parameters are:
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	199
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	200 hostname - Server hostname
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	201 database - Database name
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	202 username - User login name
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	203 password - Password
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	204
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	205 In addition to those any ltpda method requiring a database
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	206 connection should accept a 'connection' parameter in his plist. An
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	207 open connection can be provided though this parameter. The caller
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	208 is responsible of closing the connection once it is done with it.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	209
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	210
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	211 * Examples
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	212
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	213 function out = useless(a, b, plist)
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	214
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	215 % obtain a database connection
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	216 cm = LTPDAConnectionManager();
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	217 conn = cm.connect(pl)
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	218
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	219 % ask the database to sum A and B
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	220 out = utils.jmysql.execute(conn, 'SELECT ?+?', a, b);
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	221
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	222 % out is a cell array containing A + B
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	223 disp out{1};
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	224
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	225 % check who is in charge of the connection
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	226 if conn ~= find(pl, 'connection')
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	227 % close connection
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	228 conn.close()
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	229 end
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	230
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	231 end
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	232
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	233 This function can be used as follows:
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	234
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	235 - useless(1, 2)
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	236
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	237 Will ask the user for hostname, database, username, password.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	238
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	239 - useless(1, 2, plist('hostname', 'localhost', 'database', 'test'))
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	240
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	241 Will ask the user for username and password.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	242
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	243 - useless(1, 2, plist('hostname', 'localhost', 'database', 'test', 'username', 'daniele'))
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	244
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	245 Will ask the user for password.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	246
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	247 - useless(1, 2, plist('hostname', 'localhost', 'database', 'test', 'username', 'daniele', 'password', 'passwd'))
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	248
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	249 Will not ask the user.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	250
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	251 - conn = utils.jmysql.conn('localhost', 'test', 'daniele', 'passwd')
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	252 useless(1, 2, plist('connection', conn));
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	253 useless(3, 4, plist('connection', conn));
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	254 conn.close();
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	255
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	256 Anything is asked to the user. The connection is provided by the
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	257 user and should not be closed inside the function. This is
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	258 usefull for continuously running automated processes.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	259
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	260
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	261 This code is a stupid example of connections not being closed properly:
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	262
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	263 pl = plist('hostname', 'localhost', 'database', 'test', 'username', 'daniele', 'password', 'passwd');
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	264 cm = LTPDAConnectionManager();
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	265 cm.maxConnectionsNumber = 20;
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	266 for kk = 1:100
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	267 conn{kk} = cm.connect(pl);
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	268 end
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	269
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	270 It should fail at iteration 21 with an error similat to
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	271
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	272 ### too many connections open to 'localhost'
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	273
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	274
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	275 * Use cases
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	276
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	277 ** Interactive usage
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	278
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	279 A connection can be obtained from the connection manager in the
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	280 following ways, requiring user interaction:
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	281
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	282 1. Open a connection without providing any credential.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	283
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	284 A. If there are cached credentials show a list of (hostname,
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	285 database, username) touple, give the possibiity to chose between
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	286 any of those and creating a new one.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	287
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	288 B. If there are no cached credentials for the (hostname,
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	289 database, username) touple, or the user choses 'new' in the
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	290 previeus step, a dialog box asks the user for hostname and
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	291 database. The hostname field is an editable drop down lists
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	292 populated with data from the user preferences and cached
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	293 credentials. ADVANCED: the database filed is an editable drop
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	294 down list, when the user presses the drop down button, a list of
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	295 databases is fetch from the server.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	296
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	297 C. If there are cached credentials for the (hostname, database,
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	298 username) touple go to E.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	299
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	300 D. A dialog box asks the user for username and password and
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	301 gives the option to remember credentials. Username field is an
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	302 editable drop down populated with usernames from the credentials
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	303 cache, the username last entered username this (hostname,
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	304 database) pair is the default. The provided username is cached
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	305 into the credential cache.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	306
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	307 E. Connection to the database it attempt. If the connection
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	308 fails go back to C. If the connection succeds and the user
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	309 selected the 'store credentials' options save the password in
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	310 the credentials cache.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	311
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	312 F. Return the connection to the caller.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	313
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	314 2. Open a connection providing hostname and database.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	315
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	316 A. If there are cached credentials go to 1.E.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	317
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	318 B. If there are no cached credentials go to 1.D.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	319
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	320 3. Open a connection providing hostname, database, username.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	321
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	322 A. If there are cached credentials for the (hostname, database,
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	323 username) touple go to 1.E.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	324
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	325 A. If there are no cached credentials for the (hostname, database,
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	326 username) touple go to 1.D.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	327
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	328 4. Open a connection providing hostname, database, username, password.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	329
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	330 A. Go to 1.E.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	331
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	332 ** Non interactive usage
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	333
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	334 A connection can be obtained without requiring user interaction in
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	335 the following ways:
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	336
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	337 1. Known good credendials can be provided to the connection manager
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	338 connect() method. If called with four arguments it will not
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	339 require user interaction if it connects successfully to the
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	340 database.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	341
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	342 2. Known good credentials can be added to the cache with the connection
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	343 manager add() method. Any call to the connection manager
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	344 connect() method specifying at least hostname and database
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	345 matching the ones inserted in the cache, will then use the
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	346 cached credentials. User interaction is required if the
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	347 connection fails.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	348
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	349 3. A connection can be obtained with the utils.jmysql.connect()
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	350 function and given to the ltpda methods requiring a database
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	351 connection with the 'connection' plist parameter. In this way
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	352 the caller has full control on the connection.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	353
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	354 ** Functions chaining
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	355
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	356 In the case where a procedure needs to call several ltpda methods
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	357 requiring database access, it is recommended that the connection is
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	358 created in the outermost function, and passed to called functions
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	359 using the 'connection' plist parameter.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	360
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	361 This avoids to query the user for connection credentials more than
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	362 once during the executing of the same procedure, even when password
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	363 caching is disabled. It also avoids the performance penalty of
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	364 connecting multiple times to the server.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	365
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	366 ** Multiple users scenario
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	367
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	368 Consider the case where two users are sharing the same matlab
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	369 instance. The two users must be able to interleave the creation of
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	370 database connections, each one with his own credentials. This can
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	371 be accomplished in different ways:
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	372
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	373 1. If the interleaving of the operations of two users is frequent,
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	374 the connection manager can be configured, via the user
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	375 preferences, to never cache passwords. The users will be always
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	376 queried for their credentials.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	377
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	378 If procedures are well written, each one should not require to
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	379 enter user credentials more than once.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	380
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	381 2. If the interleaving of the two users is not so frequent, the
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	382 connection manager can be configured, via the user preferences,
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	383 to cache passwords for a short time.
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	384
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	385 3. The connection manager can be tricked into creating multiple
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	386 user profiles for the same database connection. For example:
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	387
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	388 cm = LTPDAConnectionManager();
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	389 cm.add(credentials('host', 'db', 'user1');
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	390 cm.add(credentials('host', 'db', 'user2');
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	391
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	392 Password caching can be enabled. The connection manager will
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	393 make the user decide which credentials to use. However the use
d5fef23867bb First workig implementation. Daniele Nicolodi <daniele@science.unitn.it> parents: diff changeset	394 of the user own credentials is not enforced.
1 c4b57991935a Tell emacs to use org mode for this file. Daniele Nicolodi <daniele@science.unitn.it> parents: 0 diff changeset	395
c4b57991935a Tell emacs to use org mode for this file. Daniele Nicolodi <daniele@science.unitn.it> parents: 0 diff changeset	396
c4b57991935a Tell emacs to use org mode for this file. Daniele Nicolodi <daniele@science.unitn.it> parents: 0 diff changeset	397 # Local Variables:
c4b57991935a Tell emacs to use org mode for this file. Daniele Nicolodi <daniele@science.unitn.it> parents: 0 diff changeset	398 # mode: org
c4b57991935a Tell emacs to use org mode for this file. Daniele Nicolodi <daniele@science.unitn.it> parents: 0 diff changeset	399 # End:

Mercurial > hg > ltpda-connection-manager

annotate README @ 1:c4b57991935a