Changes between Version 3 and Version 4 of Software/eAM/aInventory/fScheduler

Timestamp:

Jun 24, 2013, 2:26:03 PM (11 years ago)

Author:

Olivera Tosic

Comment:

—

Software/eAM/aInventory/fScheduler

@@ -32 +32 @@
  * Make domain active in scheduler database i.e set status to 'a':
 {{{
-Update newScheduler.resources set status='a' where name = '<old_testbed_name>';
+Update newScheduler.resources set status='a' where name = '<old_name>';
 }}}
 * Change name and description:
-
 {{{
-Update newScheduler.resources set name='<new_testbed_name>', notes='node3-3 i node4-10' where name = '<old_testbed_name>';
+Update newScheduler.resources set name='<new_name>', notes='node3-3 i node4-10' where name = '<old_name>';
 }}}
 
 or with one statement
 {{{
-Update newScheduler.resources set status='a', name='<new_testbed_name>', notes='node3-3 i node4-10' where name ='<old_testbed_name>';
+Update newScheduler.resources set status='a', name='<new_name>', notes='node3-3 i node4-10' where name ='<old_name>';
 }}}
 
 ==== Inventory database ====
+* Change name
+It's not possible to change resource name using inventory service. This can be done directly into database. Anytime you can delete resource with <old_name> and create new one. To change resource name run flowing script:
+{{{
+UPDATE inventory54.resource SET name='<new_name>' where name='<old_name>';
+}}}
 
+* Make it active, i.e set INF_status to 1
+{{{
+ wget -qO- 'http://new.orbit-lab.org:5054/attribute_modify?name=<new_name&attribute=INF_status&value=1
+}}}
+* Change description 
+{{{
+ wget -qO- 'http://new.orbit-lab.org:5054/attribute_modify?name=<new_name>&attribute=INF_description&value=<new_description>
+}}}
+
+==== Define list of nodes ====
+
+* Delete old list of nodes  - currently, there is no possibility to do it trough service, it has to be done into database directly
+{{{
+DELETE FROM inventory54.relations WHERE subject_id=(SELECT id FROM inventory54.resources where name='<new_name>');
+}}}
+Pay attention, <new_name> is used because name is already changed. If you this before changing the name, than use <old_name>.
+* Add nodes  - do the flowing for each node that belongs to resource i.e. testbed
+{{{
+ wget -qO- 'http://new.orbit-lab.org:5054/relation_add?parent=<new_name>&child=<node_name>
+}}}