[db-api/configuration] simplify db-api and configuration so that all the connection information is in the repository url, closes #2521848 eg no more specific option of pyro ns host, group, etc. This also fixes broken ZMQ sources. Changes: * dropped pyro-ns-host, pyro-instance-id, pyro-ns-group from client side config, in favor of repository-uri. No migration done, supposing there is **no web-only config** in the wild. Also stop discovering the connection method through the repo_method class attribute of the configuration, varying according to the configuration class. This is a first step on the way to a simpler configuration handling. Notice those pyro options are still available for repository only / all-in-one configurations as they are needed to configure the pyro server. * stop telling connection method using ConnectionProperties, this is so boring. Also, drop _cnxtype from Connection and cnxtype from Session. The former is replaced by a is_repo_in_memory property and the later is totaly useless. * deprecate in_memory_cnx which becomes useless, use _repo_connect instead

     1

from yams import schema2sql as y2sql

     2

     3

dbhelper = repo.system_source.dbhelper

     4

rdefdef = schema['CWSource'].rdef('name')

     5

attrtype = y2sql.type_from_constraints(dbhelper, rdefdef.object, rdefdef.constraints).split()[0]

     6

     7

cursor = session.cnxset['system']

     8

sql('UPDATE entities SET asource = source WHERE asource is NULL')

     9

dbhelper.change_col_type(cursor, 'entities', 'asource', attrtype, False)

    10

dbhelper.change_col_type(cursor, 'entities', 'source', attrtype, False)

    11

dbhelper.change_col_type(cursor, 'deleted_entities', 'source', attrtype, False)