Main Page | Directories | File List | File Members
pvss_tfc » FwInstall » source » fwGenericExternalHandler » GEHExample » PVSSconfDBAPI » include

PVSSConfDBAPI.h File Reference


Functions

int PVSSDBConnexion (string server, string usr, string pwd, string ErrMess)
int PVSSDBDeconnexion (string ErrMess)
string PVSSGetDeviceTypeRow (string dtype)
string PVSSGetDeviceRow_devicename (string dname)
string PVSSGetHWDeviceRow_serialnb (string serialnb)
string PVSSGetFunctionalDeviceStatus (string dname)
string PVSSGetHWDeviceStatus (string serialnb)
string PVSSGetFunctionalBoardCpntStatus (string cpntname)
string PVSSGetHWBoardCpntStatus (string serialnb, int snbid)
string PVSSGetHWLastFunctionalDevice (string serialnb)
string PVSSGetHWLastFunctionalBoardCpntName (string serialnb, int snbid)
string PVSSGetFunctionalDeviceLastHW (string functional_name)
string PVSSGetFunctionalBoardCpntNameLastHW (string functional_name)
string PVSSGetDeviceRow_devid (int dID)
string PVSSGetBoardCpntRow_cpntname (string cpntname)
string PVSSGetBoardCpntRow_cpntid (int cpntid)
string PVSSGetHWCpntRow_serialnb (string serialnb)
string PVSSGetHWCpntRow_snbid (int snbid)
string PVSSGetPortRow_pid (int dID)
string PVSSGetPortRow_devid (int devID, string pt_nb, int port_way, string port_type)
string PVSSGetMacroConnectivityRow_lkid (int lkID)
string PVSSGetMicroConnectivityRow_lkid (int lkID)
string PVSSGetMacroConnectivityRow_node (int nodeID, string pt_nb, int port_way, string port_type)
string PVSSGetMacroConnectivityRow_nodename (string nodename, string pt_nb, int port_way, string port_type)
string PVSSGetMicroConnectivityRow_node (int nodeID, int port_nb, int way)
string PVSSGetIPInfoRow (string IPadd)
string PVSSGetLkTypeRow_lkname (string lkname)
string PVSSGetLkTypeRow_lknb (int lktypeID)
dyn_int PVSSGetDeviceIDsPerTypes (string dtype, string ErrMess)
int PVSSGetDeviceNamesPerType (string dtype, dyn_string &devicename_list, dyn_int &deviceid_list)
dyn_string PVSSGetFreeDeviceNamesPerType (string dtype)
dyn_int PVSSGetLkFromDevID (int node_from, string ErrMess)
dyn_int PVSSGetLkToDevID (int node_to, string ErrMess)
dyn_int PVSSGetPortIDPerDevID (int devid, string ErrMess)
dyn_string PVSSGetMacAddPerDevID (int devid)
string PVSSInsertDeviceType (string sysname, string dtype, int nbinput, int nboutput, string description, string rgbcolor, int last_rows)
string PVSSInsertFunctionalDevice (string sysname, string dname, string dtype, int node, int promiscuous_mode, string serialnb, string hwtype, string responsible, string location, string comments, int last_rows)
string PVSSInsertPort (string dname, string pt_nb, string pt_type, int port_way, string bia, string ipname, string ipadd, string subnet, string macadd, int pxibooting, int speed, string phy, int admin_status, int last_rows)
string PVSSInsertSimpleLinkType (string lktype_name, int last_rows)
string PVSSInsertMacroLink (string node_from, string node_to, string port_from, string port_typefrom, string port_to, string port_typeto, string link_type_name, int bidirectional_link, string link_info, int last_rows)
string PVSSInsertCompositeLinkType (string lktype_name, dyn_string lktype_list, int last)
string PVSSInsertMultipleDeviceTypes (string sysname, string dtype, int nbinput, int nboutput, string description, string rgbcolor, int first_rows, int last_rows)
string PVSSInsertMultipleFunctionalDevices (string sysname, string dname, string dtype, int node, int promiscuous_mode, string serialnb, string hwtype, string responsible, string location, string comments, int first_rows, int last_rows)
string PVSSInsertMultiplePorts (string dname, string pt_nb, string pt_type, int port_way, string bia, string ipname, string ipadd, string subnet, string macadd, int pxibooting, int speed, string phy, int admin_status, int first_rows, int last_rows)
string PVSSInsertMultipleSparePorts (string serialnb, string pt_nb, string pt_type, int port_way, string bia, string macadd, int first_rows, int last_rows)
string PVSSInsertSparePort (string serialnb, string pt_nb, string pt_type, int port_way, string bia, string macadd, int last_rows)
string PVSSInsertMultipleSimpleLinkTypes (string sysname, string lktype_name, int first_rows, int last_rows)
string PVSSInsertMultipleMacroLinks (string node_from, string node_to, string port_from, string port_typefrom, string port_to, string port_typeto, string link_type_name, int bidirectional_link, string link_info, int first_rows, int last_rows)
string PVSSInsertMultipleMicroLinks (string node_from, string node_to, string port_from, string port_to, string link_type_name, int bidirectional_link, int first_rows, int last_rows)
string PVSSInsertMultipleCompositeLinkTypes (string lktype_name, dyn_string lktype_list, int first_rows, int last_rows)
int PVSSCreateTableSchema (string &ErrMess)
int PVSSDropTableSchema (string &ErrMess)
int PVSSGetConnectivityBetweenDevices (string dfrom, string dto, dyn_string &nfrom_list, dyn_string &pfrom_list, dyn_int &pwayfrom_list, dyn_string &nto_list, dyn_string &pto_list, dyn_int &pwayto_list, dyn_int &pid_list, dyn_stirng &lkinfo_list, string &ErrMess)
int PVSSGetConnOutBetweenDeviceDeviceType (string dfrom, string dtype, int devtype_given, dyn_string &pfrom_list, string &ErrMess)
int PVSSGetDetailedConnectivityBetweenDevices (string dfrom, string dto, dyn_string &nfrom_list, dyn_string &pfrom_list, dyn_int &pwayfrom_list, dyn_string &nto_list, dyn_string &pto_list, dyn_int &pwayto_list, dyn_int &pid_list, dyn_int &lkpos_list, dyn_stirng &lkinfo_list, string &ErrMess)
int PVSSGetMicroConnectFromPortid (int mboardportid_from, int mboardportid_to, string cpntname, dyn_string &nfrom_list, string &lastlkfrom_list, string &lastlkto_list, dyn_string &nto_list, dyn_int &pid_list, dyn_int &lkpos_list, string &ErrMess)
int PVSSGetMicroConnectToCpntType (int mboardportid_from, int cpnttype_given, string cpnttype, dyn_string &nfrom_list, string &lastlkfrom_list, string &lastlkto_list, dyn_string &nto_list, dyn_int &pid_list, dyn_int &lkpos_list, string &ErrMess)
int PVSSGetMicroConnectBetweenBoardCpntAndMotherBoard (string cpnt_from, int mboard_pid, dyn_string &nfrom_list, string &lastlkfrom_list, string &lastlkto_list, dyn_string &nto_list, dyn_int &pid_list, dyn_int &lkpos_list, string &ErrMess)
int PVSSGetPortPerSubsystem (string dfrom, string subsystem_name, dyn_string &pfrom_list, string &ErrMess)
string PVSSGetDeviceName_deviceid (int deviceid)
int PVSSGetDeviceID_devicename (string devicename, string &ErrMess)
int PVSSGetDetailedConnBetweenDeviceDevType (string dfrom, string dto_type, int dto_typegiven, dyn_string &nfrom_list, dyn_string &pfrom_list, dyn_int &pwayfrom_list, dyn_string &nto_list, dyn_string &pfrom_list, dyn_string &pto_list, dyn_int &pwayto_list, dyn_int &pid_list, dyn_int &lkpos_list, dyn_string &lkinfo_list, string &ErrMess)
dyn_string PVSSGetDestinationNamePerDevPort (string devname, string ptnb, string port_type)
int PVSSCreateRoutingTable (string devicename, int roundtrip, string &ErrMess) int PVSSCreateDestinationTable(string devicename
int int string &ErrMess string PVSSGetCpntName_cpntid (int cpntid)
int PVSSGetCpntID_cpntname (string cpntname, string &ErrMess)
int PVSSGetStatusSubsystem (dyn_string &subsystemname, dyn_int &subsystemstatus)
int PVSSUpdateMultipleDeviceActive (string devicename, int active, int first_rows, int last_rows, string ErrMess)
int PVSSUpdateMultipleDeviceActiveByType (string devicetype, int active, int dtype_given, int last_rows, string ErrMess)
dyn_string PVSSGetBoardCpntPerType (string cpnttype)
dyn_string PVSSGetDeviceNamesPerLocation (string location)
dyn_string PVSSGetFunctionalDeviceByStatus (string systemname, string device_status)
dyn_string PVSSGetHWDeviceByStatus (TextVar *systemname, TextVar *device_status)
dyn_string PVSSGetHWBoardCpntByStatus (string cpnt_status)
dyn_string PVSSGetHistoryOfHWDevice (string serialnb, string min_date, string max_date)
dyn_string PVSSGetHistoryOfHWBoardCpnt (string serialnb, int hw_snbid, string min_date, string max_date)
dyn_string PVSSGetHistoryOfFunctionalDevice (string functional_name, string min_date, string max_date)
dyn_string PVSSGetHistoryOfFunctionalBoardCpntName (string functional_cpntname, string min_date, string max_date)
dyn_string PVSSGetLkTypeDecomposition_lknb (int linktype_nb)
dyn_string PVSSGetCpntNamesPerBoard (string motherboardname)
dyn_string PVSSGetSpareHWPerLocation (string location)
dyn_string PVSSGetSpareHWCpntPerLocation (string location)
dyn_string PVSSGetSpareHWPerType (string hwtype)
dyn_string PVSSGetSpareHWCpntPerType (string hwtype)
dyn_int PVSSGetMicroLkFromCpntID (int cpntid_from, int motherboard, string ErrMess)
dyn_int PVSSGetMicroLkToCpntID (int cpntid_to, int motherboard, string ErrMess)
string PVSSInsertTestFunctionalDevice (string location, dyn_string ipaddList, dyn_string ipnameList, dyn_string subnetList, dyn_string portnbList, dyn_string port_typeList, dyn_int port_wayList, int last_rows)
string PVSSInsertSpareDevice (string hwname, string hwtype, string serialnb, string responsible, string location, string comments, int last_rows)
string PVSSInsertMultipleSpareDevices (string hwname, string hwtype, string serialnb, string responsible, string location, string comments, int first_rows, int last_rows)
string PVSSInsertMultipleBoardCpnts (string cpntname, string cpnttype, int replacable, string motherboardname, string serialnb, string hwtype, string responsible, string location, string comments, int first_rows, int last_rows)
string PVSSUpdateMultiplePorts (string devicename, string port_nb, string port_type, int port_way, int pxi_booting, int speed, string phy, int first_rows, int last_rows)
string PVSSUpdateMultiplePortStatuses (string devicename, string port_nb, string port_type, int port_way, int admin_status, int first_rows, int last_rows)
string PVSSUpdateMultipleAttributeMacIPs (string ip_add, string subnet_mask, string ipname, int first_rows, int last_rows)
string PVSSUpdateMultipleIPAddresses (string ip_add, string oldip_add, int first_rows, int last_rows)
string PVSSUpdateMultipleCompositeLinkTypes (string link_name, string simple_lk_list, int first_rows, int last_rows)
string PVSSUpdateMultipleLinkTypeNames (string old_link_name, string link_name, int first_rows, int last_rows)
string PVSSUpdateMultipleDeviceTypeAttributes (string devicetype, string description, int nbrofinput, int nbrofoutput, string rgbcolor, int first_rows, int last_rows)
string PVSSUpdateMultipleDeviceTypes (string devicetype_old, string devicetype, int first_rows, int last_rows)
string PVSSUpdateMultipleDTypeDevices (string devicename, stirng devicetype, int first_rows, int last_rows)
string PVSSUpdateMultipleDevNamesDevices (string devicename_old, string devicename, int first_rows, int last_rows)
string PVSSUpdateMultipleDeviceSystemList (string devicename, string new_systemList, int first_rows, int last_rows)
string PVSSUpdateMultipleDeviceNodeUsedByType (string devicetype, int nodeused, int devtype_given, int last_rows)
string PVSSUpdateMultipleDeviceNodeUsed (string devicetype, int nodeused, int first_rows, int last_rows)
string PVSSUpdateMultipleAttributesDevices (string devicename, int node, int promiscuous_mode, string location, int first_rows, int last_rows)
string PVSSUpdateMultipleLkTypeLinks (string node_from, string node_to, string port_nbrfrom, string port_nbrto, string port_typefrom, string port_typeto, string link_type, int first_rows, int last_rows)
string PVSSUpdateMultipleLkInfoLinks (string node_from, string node_to, string port_nbrfrom, string port_nbrto, string port_typefrom, string port_typeto, string link_info, int first_rows, int last_rows)
string PVSSUpdateMultipleLkUsedLinks (string node_from, string node_to, string port_nbrfrom, string port_nbrto, string port_typefrom, string port_typeto, int lkused, int first_rows, int last_rows)
string PVSSUpdateMultipleBidirectionalLinks (string node_from, string node_to, string port_nbrfrom, string port_typefrom, string port_nbrto, string port_typeto, int bidirectional_link_used, int first_rows, int last_rows)
string PVSSReplaceFunctionalDevice (string functional_name, string new_status, string new_location, string user_comments, string status_datechange, string serialnb_replacement, string replace_date)
string PVSSReplaceFunctionalBoardCpnt (string cpnt_name, string new_status, string new_location, string user_comments, string status_datechange, string serialnb_replacement, string replace_date)
string PVSSUpdateHWDeviceStatus (string serialnb, string new_status, string new_location, string user_comments, string status_datechange, string functional_replacement)
string PVSSUpdateHWBoardCpntStatus (string serialnb, string new_status, string new_location, string user_comments, string status_datechange, string functional_cpntname)
string PVSSSetToTestUseStatus (string functional_name, string user_comments, string status_datechange, string serialnb_replacement, string testdevice_name, string replace_date)
string PVSSDeletePortRow (int portid)
string PVSSDeleteLinkRow (int linkid, int macro_link)
string PVSSSwapTwoDevices (string functional_devname1, string functional_devname2, string comments)
int PVSSLoadRoutingTable (string switch_name, dyn_string &destinname_list, dyn_string &nextport_list, dyn_string &ipnext_list, dyn_string &ipdestin_list, dyn_string &subnetnext_list, dyn_string &macaddnext_list, string ErrMess)

Variables

int int roundtrip

Function Documentation

int PVSSCreateRoutingTable (  string  devicename,
int  roundtrip,
string &  ErrMess
) 
 

create the destination table given a devicename .

Parameters:
devicename : name of the device 1 (ex. SWITCH_00)
roundtrip : max path length
ErrMess : error message in case of failure
Returns:
0 if successful

int PVSSCreateTableSchema (  string &  ErrMess  ) 
 

create the tables, indexes and constraints in your DB schema

Parameters:
ErrMess : error message in case of failure
Returns:
0 if it is successful

int PVSSDBConnexion (  string  server,
string  usr,
string  pwd,
string  ErrMess
) 
 

Connect to the database taking 3 arguments and returning an integer value.

Parameters:
server : name of the database.
usr : user login.
pwd : user password.
ErrMess : return the ErrorMessage in case of failure (otherwise NO_ERRORS in + fct name)
Returns:
0 if the disconnection is successful

int PVSSDBDeconnexion (  string  ErrMess  ) 
 

Disconnect from the database a dummy argument and returning an integer value.

Parameters:
ErrMess : return the ErrorMessage in case of failure (otherwise NO_ERRORS in + fct name)
Returns:
0 if the disconnection is successful

string PVSSDeleteLinkRow (  int  linkid,
int  macro_link
) 
 

delete a link returning a string .

Parameters:
linkid : linkid you want to delete
macro_link : 1 if it's a macro link you want to delete, 0 if it's a micro link
Returns:
"Successful deletion" if it is successful,

string PVSSDeletePortRow (  int  portid  ) 
 

delete a port row returning a string .

Parameters:
portid : portid you want to delete. it will also delete all the links which start from or end at this port
Returns:
"Successful deletion" if it is successful,

int PVSSDropTableSchema (  string &  ErrMess  ) 
 

drop the tables, indexes and constraints in your DB schema The user shoudl it with caution

Parameters:
ErrMess : error message in case of failure
Returns:
0 if it is successful

dyn_string PVSSGetBoardCpntPerType (  string  cpnttype  ) 
 

Get the list of board cpnt of the given cpnt type,

Parameters:
cpnttype : name of cpnt type
Returns:
the list of cpnt names concatenated with the cpnt id. Presneted as follows cpntname|cpntid. Or the error message if not successful

string PVSSGetBoardCpntRow_cpntid (  int  cpntid  ) 
 

Get the row of the given cpntID ,

Parameters:
cpntid : cpntID of the board cpnt
Returns:
case of success formatted as follows |db_column_name (db_column_type):db_column_value|

db_column_type is I for int and C for char*

the error message if not successful

string PVSSGetBoardCpntRow_cpntname (  string  cpntname  ) 
 

Get the row of the given board cpnt name ,

Parameters:
cpntname : name of the board cpnt
Returns:
case of success formatted as follows |db_column_name (db_column_type):db_column_value|

db_column_type is I for int and C for char*

the error message if not successful

int PVSSGetConnectivityBetweenDevices (  string  dfrom,
string  dto,
dyn_string &  nfrom_list,
dyn_string &  pfrom_list,
dyn_int &  pwayfrom_list,
dyn_string &  nto_list,
dyn_string &  pto_list,
dyn_int &  pwayto_list,
dyn_int &  pid_list,
dyn_stirng &  lkinfo_list,
string &  ErrMess
) 
 

Get the path (just the first and last link details) between dev_from and dev_to

Parameters:
dfrom : name of the device 1 (ex. THOR_00)
dto : name of the device 2 (ex. ECAL_L1FE06_00_00)
nfrom_list : list of the devices which start the link
pfrom_list : list of the port from numbers and port type formatted as follows port_nb|port_type
pwayfrom_list : list of the port way from
nto_list : list of the devices which end the link
pto_list : list of the port from numbers and port type formatted as follows port_nb|port_type
pwayto_list : list of the port way to
pid_list : list of the pathid
lkinfo_list : list of the info related to the given link
ErrMess : error message in case of failure
Returns:
0 if it is successful

int PVSSGetConnOutBetweenDeviceDeviceType (  string  dfrom,
string  dtype,
int  devtype_given,
dyn_string &  pfrom_list,
string &  ErrMess
) 
 

Get the port nbs out between dev_from and devtype

Parameters:
dfrom : name of the device 1 (ex. THOR_00)
dtype : name of a devicetype (ex. ECAL_L1FE)
devtype_given : 1 if you give the device type, 0 if it's the fixed part
pfrom_list : list of the port from numbers and port type port_nb|port_way|port_type
ErrMess : error message in case of failure
Returns:
0 if it is successful

int PVSSGetCpntID_cpntname (  string  cpntname,
string &  ErrMess
) 
 

give the corresponding functional board cpnt id

Parameters:
cpntname : name of the fctnal board cpnt
ErrMess : error message in case of failure
Returns:
the cpntid if it's successful>0, else means error

int int string& ErrMess string PVSSGetCpntName_cpntid (  int  cpntid  ) 
 

give the corresponding functional board cpnt name .

Parameters:
cpntid : of the fctnal board cpnt name
Returns:
the Error message

dyn_string PVSSGetCpntNamesPerBoard (  string  motherboardname  ) 
 

Get the list of functional board cpnt names located at the given motherboard, returning a vector of strings.

Parameters:
motherboardname : motherboadrname
Returns:
the list of board cpnt names

dyn_string PVSSGetDestinationNamePerDevPort (  string  devname,
string  ptnb,
string  port_type
) 
 

Get the possible destination given a devicename,port nb (way=2) .

Parameters:
devname : name of the device 1 (ex. THOR_00)
ptnb : port_nb
port_type,: type of the port
Returns:
the list of possible destination which can be reached from this port if it is successful, the error message as first entry otherwise

int PVSSGetDetailedConnBetweenDeviceDevType (  string  dfrom,
string  dto_type,
int  dto_typegiven,
dyn_string &  nfrom_list,
dyn_string &  pfrom_list,
dyn_int &  pwayfrom_list,
dyn_string &  nto_list,
dyn_string &  pfrom_list,
dyn_string &  pto_list,
dyn_int &  pwayto_list,
dyn_int &  pid_list,
dyn_int &  lkpos_list,
dyn_string &  lkinfo_list,
string &  ErrMess
) 
 

Get the path details between dev_from and dev_to (device type), .

Parameters:
dfrom : name of the device 1 (ex. THOR_00)
dto_type : name of the device type (ex. ECAL_L1FE)
dto_typegiven : 1 if it's a device type, 0 if it's the beginning of the devicename ,i.e like dto%
nfrom_list : list of the devices which start the link
pfrom_list : list of the port from numbers formatted as follows port_nb|port_type
pwayfrom_list : list of the port way from
nto_list : list of the devices which end the link
pto_list : list of the port to numbers formatted as follows port_nb|port_type
pwayto_list : list of the port way to
pid_list : list of the pathid
lkpos_list : position of the link in the path (start with 1)
lkinfo_list : list of the info related to the given link
ErrMess : error message in case of failure NB: the i-th entry of the nfrom_list,pfrom_list,nto_list,pto_list,pathid_list and link_pos_list corresponds to one link of the path
Returns:
0 if it is successful

int PVSSGetDetailedConnectivityBetweenDevices (  string  dfrom,
string  dto,
dyn_string &  nfrom_list,
dyn_string &  pfrom_list,
dyn_int &  pwayfrom_list,
dyn_string &  nto_list,
dyn_string &  pto_list,
dyn_int &  pwayto_list,
dyn_int &  pid_list,
dyn_int &  lkpos_list,
dyn_stirng &  lkinfo_list,
string &  ErrMess
) 
 

Get the path details between dev_from and dev_to

Parameters:
dfrom : name of the device 1 (ex. THOR_00)
dto : name of the device 2 (ex. ECAL_L1FE06_00_00)
nfrom_list : list of the devices which start the link
pfrom_list : list of the port from numbers and port type formatted as follows port_nb|port_type
pwayfrom_list : list of the port way from
nto_list : list of the devices which end the link
pto_list : list of the port from numbers and port type formatted as follows port_nb|port_type
pwayto_list : list of the port way to
pid_list : list of the pathid
lkpos_list : position of the link in the path (start with 1)
lkinfo_list : list of the info related to the given link
ErrMess : error message in case of failure NB: the i-th entry of the nfrom_list,pfrom_list,nto_list,pto_list,pathid_list and link_pos_list corresponds to one link of the path
Returns:
0 if it is successful

int PVSSGetDeviceID_devicename (  string  devicename,
string &  ErrMess
) 
 

Get the deviceid of the given devicename , .

Parameters:
devicename : case sensitive
ErrMess : error message in case of failure
Returns:
deviceid (>0) if it is successful,-1 otherwise

dyn_int PVSSGetDeviceIDsPerTypes (  string  dtype,
string  ErrMess
) 
 

Get the list of deviceID of the given device type,

Parameters:
dtype : device type name
ErrMess : return the ErrorMessage in case of failure (otherwise NO_ERRORS in + fct name)
Returns:
the list of the deviceIDs,twice -1 otherwise

string PVSSGetDeviceName_deviceid (  int  deviceid  ) 
 

Get the devicename of the given deviceid

Parameters:
deviceid : deviceid (>0)
Returns:
devicename if it is successful, the error message otherwise

dyn_string PVSSGetDeviceNamesPerLocation (  string  location  ) 
 

Get the list of functional device names located at the given location,

Parameters:
location : location (exact name of a prefix)
Returns:
the list of devicenames or the ErrorMessage if not successful

int PVSSGetDeviceNamesPerType (  string  dtype,
dyn_string &  devicename_list,
dyn_int &  deviceid_list
) 
 

Get the list of deviceNames of the given device type,

Parameters:
dtype : device type name
devicename_list : list of the device names
deviceid_list : list of the deviceID
Returns:
0 if it's successful

string PVSSGetDeviceRow_devicename (  string  dname  ) 
 

Get the row of the given device name ,

Parameters:
dname : device name: case sensitive.
Returns:
if successful formatted as follows |db_column_name (db_column_type):db_column_value|

the error message if not successful

string PVSSGetDeviceRow_devid (  int  dID  ) 
 

Get the row of the given deviceID of the device ,

Parameters:
dID : deviceID of the device
Returns:
case of success formatted as follows |db_column_name (db_column_type):db_column_value|

db_column_type is I for int and C for char*

the error message if not successful

string PVSSGetDeviceTypeRow (  string  dtype  ) 
 

Get the row of the given device type ,

Parameters:
dtype : device type name: case sensitive.
Returns:
formatted as follows |db_column_name (db_column_type):db_column_value|

db_column_type is I for int and C for char*

the error message if not successful

dyn_string PVSSGetFreeDeviceNamesPerType (  string  dtype  ) 
 

Get the list of free deviceNames of the given device type,

Parameters:
dtype : device type name
Returns:
the Error Message in the first entry of the vector

string PVSSGetFunctionalBoardCpntNameLastHW (  string  functional_name  ) 
 

Get the last hw serialnb which occupies the given functional name ,

Parameters:
functional_name : functional name of the board cpnt: case sensitive.
Returns:
the error message if not successful, If it's successful the resul is formatted at follows serialnb|snbid

string PVSSGetFunctionalBoardCpntStatus (  string  cpntname  ) 
 

Get the status of the given functional board cpnt ,

Parameters:
cpntname : functional board cpnt name: case sensitive.
Returns:
the error message if not successful

dyn_string PVSSGetFunctionalDeviceByStatus (  string  systemname,
string  device_status
) 
 

Get the list of functional device names which have the given status, filtered by system name

Parameters:
systemname : list of subsystem, if several separate them with coma. if all, put "all"
device_status : status of the device (either IN_USE or NONE)
Returns:
the list of devicenames

string PVSSGetFunctionalDeviceLastHW (  string  functional_name  ) 
 

Get the last hw serialnb which occupies the given functional name ,

Parameters:
functional_name : functional name of the device: case sensitive.
Returns:
the error message if not successful

string PVSSGetFunctionalDeviceStatus (  string  dname  ) 
 

Get the status of the given functional device ,

Parameters:
dname : functional device name: case sensitive.
Returns:
the error message if not successful

dyn_string PVSSGetHistoryOfFunctionalBoardCpntName (  string  functional_cpntname,
string  min_date,
string  max_date
) 
 

Get the history of a hw serialnb filtered by system name

Parameters:
functional_cpntname : functional_cpntname of the cpnt_name
min_date : min date formatted as follows YY/MM/DD/HH24/MM/SS. Put "none", if not
max_date : max date formatted as follows YY/MM/DD/HH24/MM/SS. Put "none", if not
Returns:
the history presented as follows cpntname|serialnb|snbid|status|date of change|location

dyn_string PVSSGetHistoryOfFunctionalDevice (  string  functional_name,
string  min_date,
string  max_date
) 
 

Get the history of a functional_name device filtered by system name

Parameters:
functional_name : functional_name of the device
min_date : min date formatted as follows YY/MM/DD/HH24/MM/SS
max_date : max date formatted as follows YY/MM/DD/HH24/MM/SS
Returns:
the hsitory presented as follows devicename|serialnb|status|date of change|location

dyn_string PVSSGetHistoryOfHWBoardCpnt (  string  serialnb,
int  hw_snbid,
string  min_date,
string  max_date
) 
 

Get the history of a hw serialnb filtered by system name

Parameters:
serialnb : serialnb of the hw. Put "none" if you provide a hw_snbid
hw_snbid : hw_snbid. Put -1 if you have provide a serialnb
min_date : min date formatted as follows YY/MM/DD/HH24/MM/SS. Put "none", if not
max_date : max date formatted as follows YY/MM/DD/HH24/MM/SS. Put "none", if not
Returns:
the history presented as follows cpntname|serialnb|snbid|status|date of change|location

dyn_string PVSSGetHistoryOfHWDevice (  string  serialnb,
string  min_date,
string  max_date
) 
 

Get the history of a hw serialnb filtered by system name

Parameters:
serialnb : serialnb of the hw
min_date : min date formatted as follows YY/MM/DD/HH24/MM/SS
max_date : max date formatted as follows YY/MM/DD/HH24/MM/SS
Returns:
the history presented as follows devicename|serialnb|status|date of change|location

dyn_string PVSSGetHWBoardCpntByStatus (  string  cpnt_status  ) 
 

Get the list of hw serialnb of hw board cpnt which have the given status,

Parameters:
cpnt_status : status of the device (either IN_USE, TEST,EXT_TES,IN_REPAIR,DESTROYED,SPARE)
Returns:
the list of devicenames presented as follows serialnb|snbid

string PVSSGetHWBoardCpntStatus (  string  serialnb,
int  snbid
) 
 

Get the status of the given hw serialnb ,

Parameters:
serialnb : serialnb of the board cpnt name: case sensitive. Put "none" if there is not.
snbid : snbid of the board cpnt . case where there is no serialnb. Put -1 if you have provided a serialnb
Returns:
the error message if not successful

string PVSSGetHWCpntRow_serialnb (  string  serialnb  ) 
 

Get the row of the given board cpnt serialnb ,

Parameters:
serialnb : serialnb of the hw cpnt
Returns:
case of success formatted as follows |db_column_name (db_column_type):db_column_value|

db_column_type is I for int and C for char*

the error message if not successful

string PVSSGetHWCpntRow_snbid (  int  snbid  ) 
 

Get the row of the given board cpnt snbid ,

Parameters:
snbid : snbid of the hw cpnt
Returns:
case of success formatted as follows |db_column_name (db_column_type):db_column_value|

db_column_type is I for int and C for char*

the error message if not successful

dyn_string PVSSGetHWDeviceByStatus (  TextVar *  systemname,
TextVar *  device_status
) 
 

Get the list of hw serialnb which have the given status, filtered by system name

Parameters:
systemname : list of subsystem, if several separate them with coma. if all, put "all"
device_status : status of the device (either IN_USE, TEST,EXT_TES,IN_REPAIR,DESTROYED,SPARE)
Returns:
the list of hw serialnb

string PVSSGetHWDeviceRow_serialnb (  string  serialnb  ) 
 

Get the row of the given hw device name ,

Parameters:
serialnb : hw device name: case sensitive.
Returns:
if successful formatted as follows |db_column_name (db_column_type):db_column_value|

the error message if not successful

string PVSSGetHWDeviceStatus (  string  serialnb  ) 
 

Get the status of the given hw device ,

Parameters:
serialnb : serialnb of the hw: case sensitive.
Returns:
the error message if not successful

string PVSSGetHWLastFunctionalBoardCpntName (  string  serialnb,
int  snbid
) 
 

Get the last functional board cpnt name which was occupied by the given hw serialnb ,

Parameters:
serialnb : serialnb of the board cpnt name: case sensitive. Put "none" if there is not.
snbid : snbid of the board cpnt . case where there is no serialnb. Put -1 if you have provided a serialnb
Returns:
the error message if not successful

string PVSSGetHWLastFunctionalDevice (  string  serialnb  ) 
 

Get the last functional device name which was occupied by the given hw serialnb ,

Parameters:
serialnb : hw serialnb : case sensitive.
Returns:
the error message if not successful

string PVSSGetIPInfoRow (  string  IPadd  ) 
 

Get the IP info row

Parameters:
IPadd : IP address about which you want to get some info
Returns:
formatted as follows |db_column_name (db_column_type):db_column_value|

db_column_type is I for int and C for char*

the error message if not successful

dyn_int PVSSGetLkFromDevID (  int  node_from,
string  ErrMess
) 
 

Get the list of LkID which start from the given deviceID,

Parameters:
node_from : deviceID
ErrMess : return the ErrorMessage in case of failure (otherwise NO_ERRORS in + fct name)
Returns:
the list of linkIDs, twice -1 otherwise

dyn_int PVSSGetLkToDevID (  int  node_to,
string  ErrMess
) 
 

Get the list of LkID which end at the given deviceID,

Parameters:
node_to : deviceID
ErrMess : return the ErrorMessage in case of failure (otherwise NO_ERRORS in + fct name)
Returns:
the list of linkIDs, twice -1 otherwise

dyn_string PVSSGetLkTypeDecomposition_lknb (  int  linktype_nb  ) 
 

Get the list of link types which compose the given lktypeID

Parameters:
linktype_nb : lktypeid you want to decompsoe
Returns:
the list of lktype and lktypeid formatted as follows lktypename|lktypeID

string PVSSGetLkTypeRow_lkname (  string  lkname  ) 
 

Get the link type row ,

Parameters:
lkname :link type name about which you want to get some info
Returns:
formatted as follows |db_column_name (db_column_type):db_column_value|

db_column_type is I for int and C for char*

the error message if not successful

string PVSSGetLkTypeRow_lknb (  int  lktypeID  ) 
 

Get the link type row ,

Parameters:
lktypeID :linktypeID about which you want to get some info
Returns:
formatted as follows |db_column_name (db_column_type):db_column_value|

db_column_type is I for int and C for char*

the error message if not successful

dyn_string PVSSGetMacAddPerDevID (  int  devid  ) 
 

Get the list of port_nbr|port_way|port_type|macaddress|ipaddress of the given deviceID,

Parameters:
devid : deviceID
Returns:
the error message if not successful in case of failure as first entry

the different ethernet adds in a dyn_string,

string PVSSGetMacroConnectivityRow_lkid (  int  lkID  ) 
 

Get the macro link row ,

Parameters:
lkID : lkID of the link
Returns:
formatted as follows |db_column_name (db_column_type):db_column_value|

db_column_type is I for int and C for char*

the error message if not successful

string PVSSGetMacroConnectivityRow_node (  int  nodeID,
string  pt_nb,
int  port_way,
string  port_type
) 
 

Get the macro link row ,

Parameters:
nodeID : nodeID of the device
pt_nb : port nb of the device
port_way : 1 if it's input, 2 if it's output (ref. data flow)
port_type : type of the port
Returns:
formatted as follows |db_column_name (db_column_type):db_column_value|

db_column_type is I for int and C for char*

the error message if not successful

string PVSSGetMacroConnectivityRow_nodename (  string  nodename,
string  pt_nb,
int  port_way,
string  port_type
) 
 

Get the macro link row ,

Parameters:
nodename : functional name of the device
pt_nb : port nb of the device
port_way : 1 if it's input, 2 if it's output (ref. data flow)
port_type : type of the port
Returns:
formatted as follows |db_column_name (db_column_type):db_column_value|

db_column_type is I for int and C for char*

the error message if not successful

int PVSSGetMicroConnectBetweenBoardCpntAndMotherBoard (  string  cpnt_from,
int  mboard_pid,
dyn_string &  nfrom_list,
string &  lastlkfrom_list,
string &  lastlkto_list,
dyn_string &  nto_list,
dyn_int &  pid_list,
dyn_int &  lkpos_list,
string &  ErrMess
) 
 

Get the path (just the first and last link details) between cpntname and mboard_pid (board cpnt)

Parameters:
cpnt_from : board cpnt. it will start the micro path
mboard_pid : portid of the motherboard. it ends the path
nfrom_list : list of the cpnts which start the link (separated by '\0') and for the first link we have cpntname|port_nbr|port_type|port_way
lastlkfrom_list : details which start the last link cpntname|port_nbr|port_type|port_way
lastlkto_list : details which ends the last link cpntname|port_nbr|port_type|port_way
nto_list : list of the cpnts which end the link concatenation of cpntname|port_nbr and for the last link we have cpntname|port_nbr|port_type|port_way
pid_list : list of the pathid
lkpos_list : position of the link in the path (start with 1)
ErrMess : error message in case of failure
Returns:
0 if it is successful

int PVSSGetMicroConnectFromPortid (  int  mboardportid_from,
int  mboardportid_to,
string  cpntname,
dyn_string &  nfrom_list,
string &  lastlkfrom_list,
string &  lastlkto_list,
dyn_string &  nto_list,
dyn_int &  pid_list,
dyn_int &  lkpos_list,
string &  ErrMess
) 
 

Get the path between mboardportid_from and (mboardportid_to or cpntname) (board cpnt)

Parameters:
mboardportid_from : portid_from of the motherboard. it will start the micro path
mboardportid_to : portid of the motherboard. Put 0 if you provide a board cpnt name
cpntname : put "none" if you provide a mboardportid_to
nfrom_list : list of the cpnts which start the link (separated by '\0') and for the first link we have cpntname|port_nbr|port_type|port_way
lastlkfrom_list : details which start the last link cpntname|port_nbr|port_type|port_way
lastlkto_list : details which ends the last link cpntname|port_nbr|port_type|port_way
nto_list : list of the cpnts which end the link concatenation of cpntname|port_nbr and for the last link we have cpntname|port_nbr|port_type|port_way
pid_list : list of the pathid
lkpos_list : position of the link in the path (start with 1)
ErrMess : error message in case of failure
Returns:
0 if it is successful

string PVSSGetMicroConnectivityRow_lkid (  int  lkID  ) 
 

Get the micro link row ,

Parameters:
lkID : lkID of the link
Returns:
formatted as follows |db_column_name (db_column_type):db_column_value|

db_column_type is I for int and C for char*

the error message if not successful

string PVSSGetMicroConnectivityRow_node (  int  nodeID,
int  port_nb,
int  way
) 
 

Get the micro link row ,

Parameters:
nodeID : cpntID of the board cpnt
port_nb : port nb of the board cpnt
way : 1 if it's input, 2 if it's output (ref. data flow)
Returns:
formatted as follows |db_column_name (db_column_type):db_column_value|

db_column_type is I for int and C for char*

the error message if not successful

int PVSSGetMicroConnectToCpntType (  int  mboardportid_from,
int  cpnttype_given,
string  cpnttype,
dyn_string &  nfrom_list,
string &  lastlkfrom_list,
string &  lastlkto_list,
dyn_string &  nto_list,
dyn_int &  pid_list,
dyn_int &  lkpos_list,
string &  ErrMess
) 
 

Get the path between mboardportid_from and cpnttype (board cpnt)

Parameters:
mboardportid_from : portid_from of the motherboard. it will start the micro path
cpnttype : cpnt type
cpnttype_given : 1 if you have given a cpnt type, 0 if it should be consider as like 'cpnttype'
nfrom_list : list of the cpnts which start the link (separated by '\0') and for the first link we have cpntname|port_nbr|port_type|port_way
lastlkfrom_list : details which start the last link cpntname|port_nbr|port_type|port_way
lastlkto_list : details which ends the last link cpntname|port_nbr|port_type|port_way
nto_list : list of the cpnts which end the link concatenation of cpntname|port_nbr and for the last link we have cpntname|port_nbr|port_type|port_way
pid_list : list of the pathid
lkpos_list : position of the link in the path (start with 1)
ErrMess : error message in case of failure
Returns:
0 if it is successful

dyn_int PVSSGetMicroLkFromCpntID (  int  cpntid_from,
int  motherboard,
string  ErrMess
) 
 

Get the list of micro LkID which starts from the given cpntID, returning a vector of int.

Parameters:
cpntid_from : cpntID which starts the link. Put -1 if you want to get the list of lkids which starts from your motherboard
motherboard : id of motherboard (=deviceid of a logical device). Put -1 if you want to get the list of lkids which starts from a cpntboard
ErrMess : we put the error message
Returns:
the list of micro linkIDs,

dyn_int PVSSGetMicroLkToCpntID (  int  cpntid_to,
int  motherboard,
string  ErrMess
) 
 

Get the list of micro LkID which ends at the given cpntID, returning a vector of int.

Parameters:
cpntid_to : cpntID which ends the link. Put -1 if you want to get the list of lkids which ends from your motherboard
motherboard : id of motherboard (=deviceid of a Functional device). Put -1 if you want to get the list of lkids which ends from a cpntboard
ErrMess : we put the error message
Returns:
the list of micro linkIDs,

dyn_int PVSSGetPortIDPerDevID (  int  devid,
string  ErrMess
) 
 

Get the list of portID of the given deviceID,

Parameters:
devid : deviceID
ErrMess : return the ErrorMessage in case of failure (otherwise NO_ERRORS in + fct name)
Returns:
twice -1 if error otherwise a list of the portID

int PVSSGetPortPerSubsystem (  string  dfrom,
string  subsystem_name,
dyn_string &  pfrom_list,
string &  ErrMess
) 
 

Get the port nb out between dev_from and the subsystem (mainly used for partioning), returning an integer value

Parameters:
dfrom : name of the device 1 (ex. THOR_00)
subsystem_name : name of the subsystem
pfrom_list : list of the port from numbers and port type formatted as follows port_nb|port_way|port_type
ErrMess : error message in case of failure
Returns:
0 if it is successful

string PVSSGetPortRow_devid (  int  devID,
string  pt_nb,
int  port_way,
string  port_type
) 
 

Get the port row ,

Parameters:
devID : deviceID of the device
pt_nb : port nb of the device
port_way : 1 if it's input, 2 if it's output (ref. data flow)
port_type : type of the port
Returns:
if it is successful formatted as follows |db_column_name (db_column_type):db_column_value|

if it is successful db_column_type is I for int and C for char*

the error message if not successful

string PVSSGetPortRow_pid (  int  dID  ) 
 

Get the port row

Parameters:
dID : portID of the device
Returns:
case of success formatted as follows |db_column_name (db_column_type):db_column_value|

db_column_type is I for int and C for char*

the error message if not successful

dyn_string PVSSGetSpareHWCpntPerLocation (  string  location  ) 
 

Get the list of spare hw snbid (automatic nb generated by the DB) concatenated with the serialnb and the hwname (functional name) if it exists (equals to 'none' if it's null) located at the given location, returning a vector of strings.

Parameters:
location : location
Returns:
the list of hw cpnt names presentend as follows snbid|serialnb|hwname

dyn_string PVSSGetSpareHWCpntPerType (  string  hwtype  ) 
 

Get the list of spare hw snbid (automatic nb generated by the DB) concatenated with the serialnb and the hwname (functional name) if it exists (equals to 'none' if it's null) located at the given location, returning a vector of strings.

Parameters:
hwtype : name of the hwtype
Returns:
the list of cpnt name spresented as follows : snbid|serialnb|hwname

dyn_string PVSSGetSpareHWPerLocation (  string  location  ) 
 

Get the list of spare hw serialnb concatenated with the hwname if it exists (equals to 'none' if it's null) located at the given location, returning a vector of strings.

Parameters:
location : location
Returns:
the list of serial nb and hwname. if hwname is null, we put "none". Presented as follows serialnb|hwname

dyn_string PVSSGetSpareHWPerType (  string  hwtype  ) 
 

Get the list of spare hw serialnb concatenated with the hwname if it exists (equals to 'none' if it's null) of the given hwtype, returning a vector of strings.

Parameters:
hwtype :
Returns:
the list of spare hw serialnb. Presented as follows serialnb|hwname. If hwname is null, we put 'none'

int PVSSGetStatusSubsystem (  dyn_string &  subsystemname,
dyn_int &  subsystemstatus
) 
 

give the status of a subsystem (running or not) .

Parameters:
subsystemname : list of the subsystems you want to know the status . put "ALL" if you want all of them
subsystemstatus : list of the corresponding status
Returns:
0 if it's successful, else means error (error =first entry of subsystemname

string PVSSInsertCompositeLinkType (  string  lktype_name,
dyn_string  lktype_list,
int  last
) 
 

Insert a Composite Link Type

Parameters:
lktype_name : name of the link type (such as "Mixed_Data")
lktype_list : name of the link types which compose the composite links
last : 1 if it's your CompositeLinkType last insert (save it into the database), 0 otherwise
Returns:
"Successful insertion" if it is successful, "Error ..." otherwise

string PVSSInsertDeviceType (  string  sysname,
string  dtype,
int  nbinput,
int  nboutput,
string  description,
string  rgbcolor,
int  last_rows
) 
 

Insert a device type .

Parameters:
sysname : name of the subsystem. if there are many. Separate then with a coma
dtype : name of the devicetype
nbinput : nb of input ports
nboutput : nb of output ports
rgbcolor : color in RGB reference used for display
description : some description about the component max size 500 characters.
last_rows : 1 if it's your last insert (save it into the database), 0 otherwise
Returns:
"Successful insertion" if it is successful, "Error ..." otherwise

string PVSSInsertFunctionalDevice (  string  sysname,
string  dname,
string  dtype,
int  node,
int  promiscuous_mode,
string  serialnb,
string  hwtype,
string  responsible,
string  location,
string  comments,
int  last_rows
) 
 

Insert a functional device (and also insert info in the hw device and in history)

Parameters:
sysname : name of the subsystem. if there are many. Separate then with a coma
dname : name of the device
dtype : name of the devicetype
node : 1 if it's a host node (usually starts or ends a path such as L1FEs) , 0 otherwise.
promiscuous_mode : 1 if put in this mode (default mode), 0 otherwise
serialnb : serialnb of the hw device which occupies this fct
hwtype : hw type
responsible : name of the responsible
location : location of the functional device
comments : comments
last_rows : 1 if it's your last insert (save it into the database), 0 otherwise
Returns:
"Successful insertion" if it is successful, "Error ..." otherwise

string PVSSInsertMacroLink (  string  node_from,
string  node_to,
string  port_from,
string  port_typefrom,
string  port_to,
string  port_typeto,
string  link_type_name,
int  bidirectional_link,
string  link_info,
int  last_rows
) 
 

Insert a macro Link

Parameters:
node_from : name of the device starting the link
node_to : name of the device ending the link
port_from : port nb of the device from
port_typefrom : port type of the device from
port_to : port type of the device to
port_typeto : port type of the device to
link_type_name : name of the link type
bidirectional_link : 1 if it's a bidirectional link, 0 otherwise
link_info : information about the link (max. size 1000 characters)
last_rows,: 1 if it's your last insert (save it into the database), 0 otherwise
Returns:
"Successful insertion" if it is successful, "Error ..." otherwise

string PVSSInsertMultipleBoardCpnts (  string  cpntname,
string  cpnttype,
int  replacable,
string  motherboardname,
string  serialnb,
string  hwtype,
string  responsible,
string  location,
string  comments,
int  first_rows,
int  last_rows
) 
 

Insert multiple board cpnts returning a string .

Parameters:
cpntname : Functional name of the cpnt (even if it's a spare cpnt, put its function name in the board)
cpnttype : name of the cpnttype
replacable : 1 if it's replacable on its own , 0 otherwise.
motherboardname : Put "none", if you insert a spare board cpnt. otherwise the name (Functional device name) where the board cpnt sits
serialnb : serial_nb of the cpnt
hwtype :hardware type : this one should be the same as you declared for your spare (to manage spare cpnt)
responsible :guy responsible for this hw
comments : some comments about the hw (max.1000 characters)
location : Serialnb nb of the board in which your board cpnt sits. If it's just a spare, which is not located on a board, put the location (building, shelves..)
first_rows : 1 if it's your first MultipleCpnt insert (save it into the database), 0 otherwise
last_rows : 1 if it's your MultipleCpnt last insert (save it into the database), 0 otherwise Maximum in one go: 10000 rows.( we force the insert)
Returns:
"Successful insertion" if it is successful,
Exceptions:
CONFDBEXCEPTION 

string PVSSInsertMultipleCompositeLinkTypes (  string  lktype_name,
dyn_string  lktype_list,
int  first_rows,
int  last_rows
) 
 

Insert multiple Composite Link Types

Parameters:
lktype_name : name of the link type (such as "Mixed_Data")
lktype_list : name of the link types which compose the composite links
first_rows : 1 if it's your CompositeLinkType first insert (save it into the database), 0 otherwise
last_rows,: 1 if it's your CompositeLinkType last insert (save it into the database), 0 otherwise
Returns:
"Successful insertion" if it is successful, "Error ..." otherwise

string PVSSInsertMultipleDeviceTypes (  string  sysname,
string  dtype,
int  nbinput,
int  nboutput,
string  description,
string  rgbcolor,
int  first_rows,
int  last_rows
) 
 

Insert multiple device types .

Parameters:
sysname : name of the subsystem. if there are many. Separate then with a coma
dtype : name of the devicetype
nbinput : nb of input ports
nboutput : nb of output ports
rgbcolor : color in RGB reference used for display
description : some description about the component max size 500 characters.
first_rows : 1 if it's your first insert (save it into the database), 0 otherwise
last_rows : 1 if it's your last insert (save it into the database), 0 otherwise
Returns:
"Successful insertion" if it is successful, "Error ..." otherwise

string PVSSInsertMultipleFunctionalDevices (  string  sysname,
string  dname,
string  dtype,
int  node,
int  promiscuous_mode,
string  serialnb,
string  hwtype,
string  responsible,
string  location,
string  comments,
int  first_rows,
int  last_rows
) 
 

Insert multiple functional devices (and also insert info in the hw device and in history)

Parameters:
sysname : name of the subsystem. if there are many. Separate then with a coma
dname : name of the device
dtype : name of the devicetype
node : 1 if it's a host node (usually starts or ends a path such as L1FEs) , 0 otherwise.
promiscuous_mode : 1 if put in this mode (default mode), 0 otherwise
serialnb : serialnb of the hw device which occupies this fct
hwtype : hw type
responsible : name of the responsible
location : location of the functional device
comments : comments
first_rows : 1 if it's your first insert (save it into the database), 0 otherwise
last_rows : 1 if it's your last insert (save it into the database), 0 otherwise
Returns:
"Successful insertion" if it is successful, "Error ..." otherwise

string PVSSInsertMultipleMacroLinks (  string  node_from,
string  node_to,
string  port_from,
string  port_typefrom,
string  port_to,
string  port_typeto,
string  link_type_name,
int  bidirectional_link,
string  link_info,
int  first_rows,
int  last_rows
) 
 

Insert multiple macro Links

Parameters:
node_from : name of the device starting the link
node_to : name of the device ending the link
port_from : port nb of the device from
port_typefrom : port type of the device from
port_to : port type of the device to
port_typeto : port type of the device to
link_type_name : name of the link type
bidirectional_link : 1 if it's a bidirectional link, 0 otherwise
link_info : link_info about the link (max. 1000 char.)
first_rows : 1 if it's your first insert (save it into the database), 0 otherwise
last_rows,: 1 if it's your last insert (save it into the database), 0 otherwise
Returns:
"Successful insertion" if it is successful, "Error ..." otherwise

string PVSSInsertMultipleMicroLinks (  string  node_from,
string  node_to,
string  port_from,
string  port_to,
string  link_type_name,
int  bidirectional_link,
int  first_rows,
int  last_rows
) 
 

Insert multiple micro Links

Parameters:
node_from : name of the device starting the link
node_to : name of the device ending the link
port_from : port nb of the device from
port_to : port type of the device to
link_type_name : name of the link type
bidirectional_link : 1 if it's a bidirectional link, 0 otherwise
first_rows : 1 if it's your first insert (save it into the database), 0 otherwise
last_rows,: 1 if it's your last insert (save it into the database), 0 otherwise
Returns:
"Successful insertion" if it is successful, "Error ..." otherwise

string PVSSInsertMultiplePorts (  string  dname,
string  pt_nb,
string  pt_type,
int  port_way,
string  bia,
string  ipname,
string  ipadd,
string  subnet,
string  macadd,
int  pxibooting,
int  speed,
string  phy,
int  admin_status,
int  first_rows,
int  last_rows
) 
 

Insert multiple Ports,

Parameters:
dname : name of the device
pt_nb : port nb of the device
pt_type : type of the port. Put "" if there is not
port_way : 1 if it's an input, 2 if it's an output. (way of flow is defined using data path. from the detector to the farm nodes)
bia : burnt internal address. Put "" if none.
ipname : Put "" if none.
ipadd : Put "" if none.
subnet : Put "" if none.
macadd : Put "" if none.
pxibooting : (0 or 1), 1 if the port allows pxi booting
speed : speed of the port
admin_status : 1 if the status is OK
phy,: possible values :"SX","T","SL"
first_rows : 1 if it's your first insert (save it into the database), 0 otherwise
last_rows : 1 if it's your last insert (save it into the database), 0 otherwise
Returns:
"Successful insertion" if it is successful, "Error ..." otherwise

string PVSSInsertMultipleSimpleLinkTypes (  string  sysname,
string  lktype_name,
int  first_rows,
int  last_rows
) 
 

Insert multiple Simple Link Type

Parameters:
sysname : name of the system name
lktype_name : name of the link type
first_rows : 1 if it's your first insert (save it into the database), 0 otherwise
last_rows : 1 if it's your SimpleLinkType last insert (save it into the database), 0 otherwise
Returns:
"Successful insertion" if it is successful, "Error ..." otherwise

string PVSSInsertMultipleSpareDevices (  string  hwname,
string  hwtype,
string  serialnb,
string  responsible,
string  location,
string  comments,
int  first_rows,
int  last_rows
) 
 

Insert multiple spare devices returning a string .

Parameters:
hwname : name of the hw. Put a name it will be easier for to trace your spare hw. For ex. Spare_board1
hwtype : name of the hwtype. It will be used to count the nb of spare by hwtype. Useful for spare management.
serialnb : serialnb of the hw.
responsible : for the device
comments : comments on the device
location : location of the device (same conv. if inserted in the equipment DB)
first_rows : 1 if it's your first insert (save it into the database), 0 otherwise
last_rows : 1 if it's your last insert (save it into the database), 0 otherwise
Returns:
"Successful insertion" if it is successful,

string PVSSInsertMultipleSparePorts (  string  serialnb,
string  pt_nb,
string  pt_type,
int  port_way,
string  bia,
string  macadd,
int  first_rows,
int  last_rows
) 
 

Insert multiple spare Ports for spare devices which have a mac address only otherwise don't need,

Parameters:
serialnb : serialnb of the hw
pt_nb : port nb of the device
pt_type : type of the port. Put "" if there is not
port_way : 1 if it's an input, 2 if it's an output. (way of flow is defined using data path. from the detector to the farm nodes)
bia : burnt internal address. Put "" if none.
macadd : Put "" if none.
first_rows : 1 if it's your first insert (save it into the database), 0 otherwise
last_rows : 1 if it's your last insert (save it into the database), 0 otherwise
Returns:
"Successful insertion" if it is successful, "Error ..." otherwise

string PVSSInsertPort (  string  dname,
string  pt_nb,
string  pt_type,
int  port_way,
string  bia,
string  ipname,
string  ipadd,
string  subnet,
string  macadd,
int  pxibooting,
int  speed,
string  phy,
int  admin_status,
int  last_rows
) 
 

Insert Ports,

Parameters:
dname : name of the device
pt_nb : port nb of the device
pt_type : type of the port. Put "" if there is not
port_way : 1 if it's an input, 2 if it's an output. (way of flow is defined using data path. from the detector to the farm nodes)
bia : burnt internal address. Put "" if none.
ipname : Put "" if none.
ipadd : Put "" if none.
subnet : Put "" if none.
macadd : Put "" if none.
pxibooting : (0 or 1), 1 if the port allows pxi booting
speed : speed of the port
admin_status : 1 if the status is OK
phy,: possible values :"SX","T","SL"
last_rows : 1 if it's your last insert (save it into the database), 0 otherwise
Returns:
"Successful insertion" if it is successful, "Error ..." otherwise

string PVSSInsertSimpleLinkType (  string  lktype_name,
int  last_rows
) 
 

Insert a Simple Link Type,

Parameters:
lktype_name : name of the link type
last_rows : 1 if it's your last insert (save it into the database), 0 otherwise
Returns:
"Successful insertion" if it is successful, "Error ..." otherwise

string PVSSInsertSpareDevice (  string  hwname,
string  hwtype,
string  serialnb,
string  responsible,
string  location,
string  comments,
int  last_rows
) 
 

Insert a spare device returning a string .

Parameters:
hwname : name of the hw. Put a name it will be easier for to trace your spare hw. For ex. Spare_board1
hwtype : name of the hwtype. It will be used to count the nb of spare by hwtype. Useful for spare management.
serialnb : serialnb of the hw.
responsible : for the device
comments : comments on the device
location : location of the device (same conv. if inserted in the equipment DB)
last_rows : 1 if it's your last insert (save it into the database), 0 otherwise
Returns:
"Successful insertion" if it is successful,

string PVSSInsertSparePort (  string  serialnb,
string  pt_nb,
string  pt_type,
int  port_way,
string  bia,
string  macadd,
int  last_rows
) 
 

Insert a spare Ports for spare devices which have a mac address only otherwise don't need,

Parameters:
serialnb : serialnb of the hw
pt_nb : port nb of the device
pt_type : type of the port. Put "" if there is not
port_way : 1 if it's an input, 2 if it's an output. (way of flow is defined using data path. from the detector to the farm nodes)
bia : burnt internal address. Put "" if none.
macadd : Put "" if none.
last_rows : 1 if it's your last insert (save it into the database), 0 otherwise
Returns:
"Successful insertion" if it is successful, "Error ..." otherwise

string PVSSInsertTestFunctionalDevice (  string  location,
dyn_string  ipaddList,
dyn_string  ipnameList,
dyn_string  subnetList,
dyn_string  portnbList,
dyn_string  port_typeList,
dyn_int  port_wayList,
int  last_rows
) 
 

Insert a test Functional device (used as test boards for local tets) returning a string . their name is automatically given TEST_BOARD_nbr Put all the value which are not null first..

Parameters:
location : where these tests boards are sit
ipaddList : list of the ip address : (same order to enable the association between mac, port nbr, port_type and port way
subnetList : list of the subnet (same order to enable the association between mac, port nbr, port_type and port way)
ipnameList : list of the ipname list, (same order to enable the association between mac, port nbr, port_type and port way);
portnbList : list of portnb (same order to enable the association between mac, port nbr, port_type and port way)
port_typeList : list of portype (same order to enable the association between mac, port nbr, port_type and port way)
port_wayList : list of port_way (1 if it's an input, 2 if it's an output)
last_rows : 1 if it's your last insert (save it into the database), 0 otherwise
Returns:
"Successful insertion" if it is successful,

int PVSSLoadRoutingTable (  string  switch_name,
dyn_string &  destinname_list,
dyn_string &  nextport_list,
dyn_string &  ipnext_list,
dyn_string &  ipdestin_list,
dyn_string &  subnetnext_list,
dyn_string &  macaddnext_list,
string  ErrMess
) 
 

Load the routing table of a switch (used for the DAQ)

Parameters:
switch_name : name of the switch
destinname_list : list of the destination name
ipdestin_list : list of the ipaddress destination
nextport_list : list of the port to which the packet will be forwarded(concatenation of port_nbr|port_type|port_way).
ipnext_list : list of the ip address of the next hop
subnetnext_list : list of the subnet mask of the next hop
macaddnext_list : list of the mac address of the next hop (for the arp table)
ErrMess : error message
Returns:
0 if it is successful (if not the error message is put at the first entry of ipaddress

string PVSSReplaceFunctionalBoardCpnt (  string  cpnt_name,
string  new_status,
string  new_location,
string  user_comments,
string  status_datechange,
string  serialnb_replacement,
string  replace_date
) 
 

replace a board cpnt (should be replacable on its own ) which occupied the functional board cpnt ftc. (initial state of the board cpnt:IN_USE) returning an integer value. IF THE BOARD CPNT STATUS CHANGE IMPLIES ALSO THE STATUS CHANGE OF THE MOTHERBOARD, USE ReplaceLogicalDevice function, NOT THIS ONE.

Parameters:
cpnt_name : name of the functional board cpnt
new_status : new status of the board which was occupying this fct : IN_REPAIR,DESTROYED,SPARE, EXT_TEST
new_location : new location of the board cpnt
user_comments : comments to explain why this replacement. Put "none", if you the default one :"status change in functional device with name %s " or
status_datechange : date of the status change of the board formatted as YY/MM/DD/HH24/MI/SS
serialnb_replacement : serialnb which replaces this cpnt board (must be already declared as SPARE, otherwise won't work). if none.
replace_date : date of the replacement formatted as YY/MM/DD/HH24/MI/SS
Returns:
"Successful update" if it is successful,

string PVSSReplaceFunctionalDevice (  string  functional_name,
string  new_status,
string  new_location,
string  user_comments,
string  status_datechange,
string  serialnb_replacement,
string  replace_date
) 
 

replace the board which occupied the functional device. (initial state of the board:IN_USE) returning an integer value.

Parameters:
functional_name : name of the functional device
new_status : new status of the board which was occupying this fct : IN_REPAIR,DESTROYED,SPARE, EXT_TEST
new_location : new location of the board
user_comments : comments to explain why this replacement. Put "none", if you the default one :"status change in functional device with name %s " or
status_datechange : date of the status change of the board formatted as functional
serialnb_replacement : serialnb which replaces this devices (must be already declared as SPARE, otherwise won't work). if none, put "none".
replace_date : date of the replacement formatted as functional
Returns:
"Successful update" if it is successful,

string PVSSSetToTestUseStatus (  string  functional_name,
string  user_comments,
string  status_datechange,
string  serialnb_replacement,
string  testdevice_name,
string  replace_date
) 
 

replace the board which occupied the functional device. (initial state of the board:IN_USE) returning an integer value.

Parameters:
functional_name : name of the functional device
user_comments : comments to explain why this replacement
status_datechange : date of the status change of the board formatted as YY/MM/DD/HH24/MM/SS
replace_date : date of the replacement formatted as YY/MM/DD/HH24/MM/SS
testdevice_name : name of the test board used for testing
serialnb_replacement : serialnb which replaces this devices (must be already declared as SPARE). if none, put "none".
Returns:
"Successful update" if it is successful,

string PVSSSwapTwoDevices (  string  functional_devname1,
string  functional_devname2,
string  comments
) 
 

Swap two devices returning an integer value.

Parameters:
functional_devname1 : functional name of the device 1
functional_devname2 : functional name of the device 2
comments : put "none" if you want to put the default comment which is "Swapping functional_devicename1 and functional_devicename1", otherwise, it will append your comment to the default.
Returns:
"Successful update" if it is successful,

string PVSSUpdateHWBoardCpntStatus (  string  serialnb,
string  new_status,
string  new_location,
string  user_comments,
string  status_datechange,
string  functional_cpntname
) 
 

update a hw cpnt status whose initial status is not IN_USE to any status IN_USE,SPARE,DESTROYED,EXT_TEST.returning an integer value.

Parameters:
serialnb : serialnb of your hw
new_status : new status of the board which was occupying this fct : IN_USE,IN_REPAIR,DESTROYED,SPARE, EXT_TEST
new_location : new location of the board if new_device_status!='IN_USE' . If new_device_status=IN_USE. Put "none"
user_comments : comments to explain why this replacement. Put "none", if you the default one :"status change in functional device with name %s " or
status_datechange : date of the status change of the board formatted as YY/MM/DD/HH24/MI/SS
functional_cpntname : functional_name which will be occupied by the given serialnb. This is only available for new_device_status=IN_USE status and there should be no serial nb which already occupies this functional devicename otherwise use Replace fct.
Returns:
"Successful update" if it is successful,

string PVSSUpdateHWDeviceStatus (  string  serialnb,
string  new_status,
string  new_location,
string  user_comments,
string  status_datechange,
string  functional_replacement
) 
 

update a hw device status whose initial status is not IN_USE to any status IN_USE,SPARE,DESTROYED,EXT_TEST.returning an integer value. update to TEST status makes sense only when the initial status of the device is IN_USE...So not in this context

Parameters:
serialnb : serialnb of your hw
new_status : new status of the board which was occupying this fct : IN_USE,IN_REPAIR,DESTROYED,SPARE, EXT_TEST
new_location : new location of the board if new_device_status!='IN_USE' . If new_device_status=IN_USE. Put "none"
user_comments : comments to explain why this replacement. Put "none", if you the default one :"status change in functional device with name %s " or
status_datechange : date of the status change of the board formatted as functional
functional_replacement : functional_name which will be occupied by the given serialnb. This is only available for new_device_status=IN_USE status and there should be no serial nb which already occupies this functional devicename otherwise use Replace fct.
Returns:
"Successful update" if it is successful,

string PVSSUpdateMultipleAttributeMacIPs (  string  ip_add,
string  subnet_mask,
string  ipname,
int  first_rows,
int  last_rows
) 
 

Update MAC entries, returning an integer value.

Parameters:
ip_add : key entry : you want to update the info about this IPaddress
subnet_mask : new value : put "" or "none" if no changes
ipname : new value : put "" or "none" if no changes
first_rows : 1 if it's your first MacIP insert (save it into the database), 0 otherwise
last_rows : 1 if it's your last MacIP insert (save it into the database), 0 otherwise
Returns:
"Successful update" if it is successful,

string PVSSUpdateMultipleAttributesDevices (  string  devicename,
int  node,
int  promiscuous_mode,
string  location,
int  first_rows,
int  last_rows
) 
 

Update a device returning an integer value.

Parameters:
devicename : new value of the devicename, if nothing you put none (lower case)
node : new value of node 1 if it's a host node (usually starts or ends a path such as L1FEs) , 0 otherwise.Put -1 not to change the value
promiscuous_mode : new value of prom.mode 1 if put in this mode (default mode), 0 otherwise. Put -1 not to change the value
location : new value of the uuid of the device if nothing you put none (lower case)
first_rows : 1 if it's your first UpdateMultipleDeviceSystemList update (save it into the database), 0 otherwise
last_rows : 1 if it's your UpdateMultipleDeviceSystemList last update (save it into the database), 0 otherwise
Returns:
"Successful update" if it is successful,

string PVSSUpdateMultipleBidirectionalLinks (  string  node_from,
string  node_to,
string  port_nbrfrom,
string  port_typefrom,
string  port_nbrto,
string  port_typeto,
int  bidirectional_link_used,
int  first_rows,
int  last_rows
) 
 

Update bidirectional link field for a given link returning an integer value. either you give node_from,pfrom or node_to,pto.

Parameters:
node_from : name of the device starting the link: put "none" if you give node_to
node_to : name of the device ending the link: put "none" if you give node_from
port_nbrfrom : port nb of the device from
port_nbrto : port nb of the device to
port_typefrom : port nb of the device from: put "none" if it doesn't exist or if you provide about the node_to
port_typeto : port nb of the device to:put "none" if it doesn't exist or if you provide about the node_from
bidirectional_link_used : 1 if it's a bidirectional link, 0 otherwise
first_rows : 1 if it's your first UpdateMultipleDeviceSystemList update (save it into the database), 0 otherwise
last_rows : 1 if it's your UpdateMultipleDeviceSystemList last update (save it into the database), 0 otherwise
Returns:
"Successful update" if it is successful,

string PVSSUpdateMultipleCompositeLinkTypes (  string  link_name,
string  simple_lk_list,
int  first_rows,
int  last_rows
) 
 

Update a Composite Link Type, returning an integer value.Not to used...

Parameters:
link_name : the link type name you want to modify.
simple_lk_list : name of the link types which compose the composite link, separated by "," (all of them)
simple_lk_list :ex. Mixed_Data is composed of HLT_Data and L1_Data, so simple_lk_list="HLT_Data,L1_Data"
simple_lk_list : put none if the link type is no longer a composite link type
first_rows : 1 if it's your CompositeLinkType first insert (save it into the database), 0 otherwise
last_rows : 1 if it's your CompositeLinkType last insert (save it into the database), 0 otherwise
Returns:
"Successful update" if it is successful,

int PVSSUpdateMultipleDeviceActive (  string  devicename,
int  active,
int  first_rows,
int  last_rows,
string  ErrMess
) 
 

update the active param of a functional device 1=active, 0 not active .

Parameters:
devicename : name of the device you want to change the active status
active : 1 to be active, 0 to release it
first_rows : 1 if it's your first insert (save it into the database), 0 otherwise
last_rows : 1 if it's your last insert (save it into the database), 0 otherwise
ErrMess : Error Message given
Returns:
0 if it's successful, else means error

int PVSSUpdateMultipleDeviceActiveByType (  string  devicetype,
int  active,
int  dtype_given,
int  last_rows,
string  ErrMess
) 
 

update the active param of a functional device 1=active, 0 not active .

Parameters:
devicetype : type of the device you want to change the active status
active : 1 to be active, 0 to release it
dtype_given : 1 if you give a device type, 0 if you want to select devicename which have the prefix devicetype
last_rows : 1 if it's your last insert (save it into the database), 0 otherwise
ErrMess : Error Message given
Returns:
0 if it's successful, else means error

string PVSSUpdateMultipleDeviceNodeUsed (  string  devicetype,
int  nodeused,
int  first_rows,
int  last_rows
) 
 

Update the nodeused of a given devicetype returning an integer value.

Parameters:
devicetype : type of the functional device
nodeused : 1 if it's used, 0 otherwise
first_rows : 1 if it's your first UpdateMultipleDeviceSystemList update (save it into the database), 0 otherwise
last_rows : 1 if it's your UpdateMultipleDeviceSystemList last update (save it into the database), 0 otherwise
Returns:
"Successful update" if it is successful,

string PVSSUpdateMultipleDeviceNodeUsedByType (  string  devicetype,
int  nodeused,
int  devtype_given,
int  last_rows
) 
 

Update the nodeused of a given devicetype returning an integer value.

Parameters:
devicetype : type of the functional device
nodeused : 1 if it's used, 0 otherwise
devtype_given : 1 if it's a devicetype, 0 otherwise
last_rows : 1 if it's your UpdateMultipleDeviceNodeUsedByType last update (save it into the database), 0 otherwise
Returns:
"Successful update" if it is successful,

string PVSSUpdateMultipleDeviceSystemList (  string  devicename,
string  new_systemList,
int  first_rows,
int  last_rows
) 
 

Update the systemlist of a given devicename returning an integer value.

Parameters:
devicename : name of the functional device
new_systemList : new list of the subsystems to which the device belongs to, elt separated by a coma
first_rows : 1 if it's your first UpdateMultipleDeviceSystemList update (save it into the database), 0 otherwise
last_rows : 1 if it's your UpdateMultipleDeviceSystemList last update (save it into the database), 0 otherwise
Returns:
"Successful update" if it is successful,

string PVSSUpdateMultipleDeviceTypeAttributes (  string  devicetype,
string  description,
int  nbrofinput,
int  nbrofoutput,
string  rgbcolor,
int  first_rows,
int  last_rows
) 
 

Update the devicetype returning an integer value.

Parameters:
devicetype : name of the devicetype you want to update
description : new value of the description, if nothing you put "" or none (lower case)
nbrofinput : new value of nbrofinput: put -1 if you don't want to change it
nbrofoutput : new value of nbrofoutput: put -1 if you don't want to change it
rgbcolor : new value of the rgbcolor of the devicetypefor display if nothing you put "" or none (lower case)
first_rows : 1 if it's your first MultipleDevice update (save it into the database), 0 otherwise
last_rows : 1 if it's your MultipleDevice last update (save it into the database), 0 otherwise
Returns:
"Successful update" if it is successful,

string PVSSUpdateMultipleDeviceTypes (  string  devicetype_old,
string  devicetype,
int  first_rows,
int  last_rows
) 
 

Update the devicetype returning an integer value.

Parameters:
devicetype_old : name of the devicetype you want to update
devicetype : new value of the devicetype,
first_rows : 1 if it's your first MultipleDevice update (save it into the database), 0 otherwise
last_rows : 1 if it's your MultipleDevice last update (save it into the database), 0 otherwise
Returns:
"Successful update" if it is successful,

string PVSSUpdateMultipleDevNamesDevices (  string  devicename_old,
string  devicename,
int  first_rows,
int  last_rows
) 
 

Update the devicename field of a device (typically when there is a mistyping) returning an integer value.

Parameters:
devicename_old : name of the device you want to update
devicename : new value of the devicename. can't be NULL!
first_rows : 1 if it's your first MultipleDevNamesDevices update (save it into the database), 0 otherwise
last_rows : 1 if it's your MultipleDevNamesDevices last update (save it into the database), 0 otherwise
Returns:
"Successful update" if it is successful,

string PVSSUpdateMultipleDTypeDevices (  string  devicename,
stirng  devicetype,
int  first_rows,
int  last_rows
) 
 

Update the devicetype field of a device :make sure that the devicetype exists 1 returning an integer value.

Parameters:
devicename : name of the device you want to update
devicetype : new value of the devicetype,
first_rows : 1 if it's your first MultipleDTypeDevices update (save it into the database), 0 otherwise
last_rows : 1 if it's your MultipleDTypeDevices last update (save it into the database), 0 otherwise
Returns:
"Successful update" if it is successful,

string PVSSUpdateMultipleIPAddresses (  string  ip_add,
string  oldip_add,
int  first_rows,
int  last_rows
) 
 

Update MAC entries, returning an integer value.

Parameters:
ip_add : new ip address entry .
oldip_add : value of ip address entry you want to modify.
first_rows : 1 if it's your first MacIP insert (save it into the database), 0 otherwise
last_rows : 1 if it's your last MacIP insert (save it into the database), 0 otherwise
Returns:
"Successful update" if it is successful,

string PVSSUpdateMultipleLinkTypeNames (  string  old_link_name,
string  link_name,
int  first_rows,
int  last_rows
) 
 

Update a Link Type Name (due to mistyping error), returning an integer value.

Parameters:
old_link_name : value of the link type name you want to modify
link_name : value of the new link type
first_rows : 1 if it's your SimpleLinkType first insert (save it into the database), 0 otherwise
last_rows : 1 if it's your SimpleLinkType last insert (save it into the database), 0 otherwise
Returns:
"Successful update" if it is successful,

string PVSSUpdateMultipleLkInfoLinks (  string  node_from,
string  node_to,
string  port_nbrfrom,
string  port_nbrto,
string  port_typefrom,
string  port_typeto,
string  link_info,
int  first_rows,
int  last_rows
) 
 

Update the link info of a Link returning an integer value. give either nfrom,pfrom or nto,pto

Parameters:
node_from : name of the device starting the link. Put "none" if giving node_to
node_to : name of the device ending the link. Put "none" if giving node_from
port_nbrfrom : port nb of the device from
port_nbrto : port nb of the device to
port_typefrom : port nb of the device from
port_typeto : port nb of the device to
link_info : new info related with the link
first_rows : 1 if it's your first UpdateMultipleDeviceSystemList update (save it into the database), 0 otherwise
last_rows : 1 if it's your UpdateMultipleDeviceSystemList last update (save it into the database), 0 otherwise
Returns:
"Successful update" if it is successful,

string PVSSUpdateMultipleLkTypeLinks (  string  node_from,
string  node_to,
string  port_nbrfrom,
string  port_nbrto,
string  port_typefrom,
string  port_typeto,
string  link_type,
int  first_rows,
int  last_rows
) 
 

Update the link type of a Link returning an integer value. give either nfrom,pfrom or nto,pto

Parameters:
node_from : name of the device starting the link. Put "none" if giving node_to
node_to : name of the device ending the link. Put "none" if giving node_from
port_nbrfrom : port nb of the device from
port_nbrto : port nb of the device to
port_typefrom : port nb of the device from
port_typeto : port nb of the device to
link_type : name of the link type
first_rows : 1 if it's your first UpdateMultipleDeviceSystemList update (save it into the database), 0 otherwise
last_rows : 1 if it's your UpdateMultipleDeviceSystemList last update (save it into the database), 0 otherwise
Returns:
"Successful update" if it is successful,

string PVSSUpdateMultipleLkUsedLinks (  string  node_from,
string  node_to,
string  port_nbrfrom,
string  port_nbrto,
string  port_typefrom,
string  port_typeto,
int  lkused,
int  first_rows,
int  last_rows
) 
 

Update the lkused field of a Link returning an integer value. you give either node_from,portnbrfrom or node_to,pto

Parameters:
node_from : name of the device starting the link. Put "none" if you give node_to
node_to : name of the device ending the link. Put "none" if you give node_to
port_nbrfrom : port nb of the device from
port_nbrto : port nb of the device to
port_typefrom : port nb of the device from
port_typeto : port nb of the device to
lkused : 1 if the link is used in the configuration, 0 otherwise
first_rows : 1 if it's your first UpdateMultipleDeviceSystemList update (save it into the database), 0 otherwise
last_rows : 1 if it's your UpdateMultipleDeviceSystemList last update (save it into the database), 0 otherwise
Returns:
"Successful update" if it is successful,

string PVSSUpdateMultiplePorts (  string  devicename,
string  port_nb,
string  port_type,
int  port_way,
int  pxi_booting,
int  speed,
string  phy,
int  first_rows,
int  last_rows
) 
 

Upadte Multiple Ports, returning an integer value.

Parameters:
devicename : name of the device which will be updated
port_nb : port nb of the device to update
port_way : specify the way of the port to update :1 if the port is an input and 2 if it's an output
port_type : specify the type of the port of the device to update. Put "" if there is none.
speed : new value of speed of the port: PUT -1 to keep the same value
pxi_booting : new value of pxi_booting 1 if the port is the pxi_booting one, 0 otherwise. Put a value different from 1 or 0 to keep the same value.
phy,: new value of phy possible values :"SX","T","SL". if no changes put ""
first_rows : 1 if it's your first Port insert (save it into the database), 0 otherwise
last_rows : 1 if it's your last Port insert (save it into the database), 0 otherwise
Returns:
"Successful update" if it is successful,

string PVSSUpdateMultiplePortStatuses (  string  devicename,
string  port_nb,
string  port_type,
int  port_way,
int  admin_status,
int  first_rows,
int  last_rows
) 
 

Upadte Multiple Ports status, returning an integer value.

Parameters:
devicename : name of the device which will be updated
port_nb : port nb of the device to update
port_way : specify the way of the port to update :1 if the port is an input and 2 if it's an output
port_type : specify the type of the port of the device to update. Put "" if there is none.
admin_status : new value of speed of the port: PUT -1 to keep the same value
first_rows : 1 if it's your first Port insert (save it into the database), 0 otherwise
last_rows : 1 if it's your last Port insert (save it into the database), 0 otherwise
Returns:
0 if it is successful

Variable Documentation

int int roundtrip
 

Generated on Mon May 8 11:30:04 2006 for lbconfDB by  doxygen 1.4.4