Package iceprod :: Package server :: Module db :: Class MySQLParamDb
[hide private]
[frames] | no frames]

Class MySQLParamDb

source code

           IceProdDB --+
                       |
core.paramdb.ParamDb --+
                       |
                      MySQLParamDb

Class paramdb uploads parsed IceTrayConfig+Metaproject structure to the parameter database

Instance Methods [hide private]
 
__init__(self)
Constructor
source code
 
new(self)
Create a copy of this instance
source code
 
load(self, metaproject)
load contents of metaproject tree to database
source code
 
download(self) source code
 
adddependencies(self, project, mp, maxrecursion=3)
Recursively add project and its dependencies to metaproject
source code
 
SwitchMetaProject(self, iconfig, id, name, version)
Add selected metaproject to configuration.
source code
 
GetMetaProjects(self) source code
 
GetProjectsSM(self, module, metaproj) source code
 
SetMetaProjectId(self, metaproj) source code
 
GetProjectsMM(self, module, metaproj, modtype='module') source code
 
GetProjects(self, metaproject_id) source code
 
GetProjectDependencies(self, project_id, metaproject_id) source code
 
GetServices(self, project_id) source code
 
GetServicesP(self, name, version) source code
 
GetModules(self, project_id) source code
 
GetModulesP(self, name, version) source code
 
GetIceProdModules(self) source code
 
GetParameters(self, module_id) source code
 
fetch_metaproject_list(self)
retrive IDs for metaprojects in the database
source code
 
fetch_project_list(self, metaproject_id=None)
retrive IDs for projects in the database
source code
 
fetch_project(self, id, table='project')
retrieve project with given id
source code
 
fetch_project_id(self, pname, pversion, table='project')
retrive id for project with matching name, version (there should only be one)
source code
 
fetch_service_id(self, service, pid) source code
 
fetch_module_id(self, module, pid, table='module')
retrive id for module with matching name, and project id (there should only be one)
source code
 
fetch_project_dependencies(self, project_id, metaproject_id)
retrive dependencys for project
source code
 
fetch_modules_from_project_id(self, project_id, table='module')
retrive modules for with a given pid
source code
 
fetch_modules_for_project(self, name, version)
retrive modules for with a project given by name and version
source code
 
fetch_services_for_project(self, name, version)
retrive modules for with a project given by name and version
source code
 
fetch_iceprodmodules(self)
retrive modules for with a project given by name and version
source code
 
fetch_module_parameters(self, module_id)
retrive parameters for with a service/module given by the service/module id
source code
 
fetch_service_parameters(self, service_id)
retrive parameters for with a service/module given by the service/module id
source code
 
load_mp_pivot(self, metaproject)
Load cross-references between meta-projects (1) and projects The purpose of this is provide a way simulatneously for projects to reference which meta-projects they are members of and for meta-projects to list which projects belong to them (many-to-many).
source code
 
load_dependencies(self, project, metaproject)
Load cross-references between projects (1) and depency projects
source code
 
load_projects(self, metaproject)
Load projects to database
source code
 
load_project_dependencies(self, metaproject)
Load project dependencies to database
source code
 
load_metaproject(self, metaproject) source code
 
load_project(self, project, table='project')
Load project to database
source code
 
load_modules(self, project)
Load modules into the database.
source code
 
load_services(self, project)
Load services into the database.
source code
 
load_module(self, module, project, type='module')
Load individual module to database
source code
 
load_service(self, service, project)
Load individual service to database
source code
 
load_iceprodmodules(self, module, project)
Load individual service to database
source code
 
load_params(self, module)
Load parameters for module or service to database
source code
 
insert_omkey(self, omkey, pid) source code
 
insert_omkey_array(self, omkeyvect, pid) source code
 
insert_array(self, values, pid) source code
 
select_array(self, pid) source code
 
select_omkey(self, pid) source code
 
select_omkey_array(self, pid) source code

Inherited from IceProdDB: SetAuthFunc, authenticate, authenticate2, commit, connect, defang, disconnect, execute, fetch_metaproject_id, get, getcursor, insert_id, intcast, isconnected, mkkey, nonify, nullify, ping, rollback, set_auto

Inherited from core.paramdb.ParamDb: loadcache, loadfile

Class Variables [hide private]
  logger = logging.getLogger('MySQLParamDb')
Method Details [hide private]

__init__(self)
(Constructor)

source code 

Constructor

Overrides: core.paramdb.ParamDb.__init__

new(self)

source code 

Create a copy of this instance

Overrides: IceProdDB.new

load(self, metaproject)

source code 

load contents of metaproject tree to database

Parameters:
  • metaproject - metaproject object
Overrides: core.paramdb.ParamDb.load

adddependencies(self, project, mp, maxrecursion=3)

source code 

Recursively add project and its dependencies to metaproject

Overrides: core.paramdb.ParamDb.adddependencies

SwitchMetaProject(self, iconfig, id, name, version)

source code 

Add selected metaproject to configuration. Import modules and their parameters.

Overrides: core.paramdb.ParamDb.SwitchMetaProject

GetMetaProjects(self)

source code 
Overrides: core.paramdb.ParamDb.GetMetaProjects

GetProjectsSM(self, module, metaproj)

source code 
Overrides: core.paramdb.ParamDb.GetProjectsSM

SetMetaProjectId(self, metaproj)

source code 
Overrides: core.paramdb.ParamDb.SetMetaProjectId

GetProjectsMM(self, module, metaproj, modtype='module')

source code 
Overrides: core.paramdb.ParamDb.GetProjectsMM

GetProjects(self, metaproject_id)

source code 
Overrides: core.paramdb.ParamDb.GetProjects

GetProjectDependencies(self, project_id, metaproject_id)

source code 
Overrides: core.paramdb.ParamDb.GetProjectDependencies

GetServices(self, project_id)

source code 
Overrides: core.paramdb.ParamDb.GetServices

GetServicesP(self, name, version)

source code 
Overrides: core.paramdb.ParamDb.GetServicesP

GetModules(self, project_id)

source code 
Overrides: core.paramdb.ParamDb.GetModules

GetModulesP(self, name, version)

source code 
Overrides: core.paramdb.ParamDb.GetModulesP

GetParameters(self, module_id)

source code 
Overrides: core.paramdb.ParamDb.GetParameters

fetch_project_list(self, metaproject_id=None)

source code 

retrive IDs for projects in the database

Parameters:
  • metaproject_id - table_id of metaproject

fetch_project(self, id, table='project')

source code 

retrieve project with given id

Parameters:
  • id - primary key of project
  • table - table to query (project or metaprojects)

fetch_project_id(self, pname, pversion, table='project')

source code 

retrive id for project with matching name, version (there should only be one)

Parameters:
  • pname - name of project to query
  • pversion - tuple representing the major,minor,patch version
  • table - table to query (project or metaprojects)

fetch_module_id(self, module, pid, table='module')

source code 

retrive id for module with matching name, and project id (there should only be one)

Parameters:
  • module - module to query

fetch_project_dependencies(self, project_id, metaproject_id)

source code 

retrive dependencys for project

Parameters:
  • project_id - id of project @return array of project names

fetch_modules_from_project_id(self, project_id, table='module')

source code 

retrive modules for with a given pid

Parameters:
  • project_id - id of project

fetch_modules_for_project(self, name, version)

source code 

retrive modules for with a project given by name and version

Parameters:
  • name - name of project
  • version - version tuple

fetch_services_for_project(self, name, version)

source code 

retrive modules for with a project given by name and version

Parameters:
  • name - name of project
  • version - version tuple

fetch_module_parameters(self, module_id)

source code 

retrive parameters for with a service/module given by the service/module id

Parameters:
  • module_id - primary key in modules table on db

fetch_service_parameters(self, service_id)

source code 

retrive parameters for with a service/module given by the service/module id

Parameters:
  • service_id - primary key in services table on db

load_mp_pivot(self, metaproject)

source code 

Load cross-references between meta-projects (1) and projects The purpose of this is provide a way simulatneously for projects to reference which meta-projects they are members of and for meta-projects to list which projects belong to them (many-to-many).

Parameters:
  • metaproject - Metaproject object

load_dependencies(self, project, metaproject)

source code 

Load cross-references between projects (1) and depency projects

Parameters:
  • project - Project object

load_projects(self, metaproject)

source code 

Load projects to database

Parameters:
  • metaproject - MetaProject object

load_project_dependencies(self, metaproject)

source code 

Load project dependencies to database

Parameters:
  • metaproject - MetaProject object

load_project(self, project, table='project')

source code 

Load project to database

Parameters:
  • project - the project to be loaded
  • table - table to which project should be loaded

load_modules(self, project)

source code 

Load modules into the database.

Parameters:
  • project - Project object

load_services(self, project)

source code 

Load services into the database.

Parameters:
  • project - Project object

load_module(self, module, project, type='module')

source code 

Load individual module to database

Parameters:
  • module - object to load

load_service(self, service, project)

source code 

Load individual service to database

Parameters:
  • service - object to load

load_iceprodmodules(self, module, project)

source code 

Load individual service to database

Parameters:
  • module - object to load

load_params(self, module)

source code 

Load parameters for module or service to database

Parameters:
  • module - object whose parameter will be loaded