repository SQL question

Classic Servoy
1

Can list all the method names in a solution using the following SQL?

SELECT servoy_element_properties.property_value FROM servoy_elements, servoy_element_properties, 
       servoy_object_types, servoy_solutions, servoy_content_spec 
WHERE servoy_elements.solution_id = servoy_solutions.solution_id          AND 
      servoy_elements.element_id  = servoy_element_properties.element_id  AND 
      servoy_elements.object_type_id = servoy_object_types.object_type_id AND 
      servoy_content_spec.object_type_id  = servoy_object_types.object_type_id  AND  
      servoy_content_spec.content_id  = servoy_element_properties.content_id  AND  
      servoy_object_types.name = 'METHODS' AND  
      servoy_solutions.solution_name = 'mod_functions_v2' AND  
      servoy_content_spec.property_name = 'name'

Also can I write an update statement like this to append a string in the beginning of all the method names.

UPDATE servoy_elements, servoy_element_properties, 
       servoy_object_types, servoy_solutions, servoy_content_spec 
SET servoy_element_properties.property_value = 'mod_functions_v2_' + servoy_element_properties.property_value 
WHERE servoy_elements.solution_id = servoy_solutions.solution_id          AND 
      servoy_elements.element_id  = servoy_element_properties.element_id  AND 
      servoy_elements.object_type_id = servoy_object_types.object_type_id AND 
      servoy_content_spec.object_type_id  = servoy_object_types.object_type_id  AND  
      servoy_content_spec.content_id  = servoy_element_properties.content_id  AND  
      servoy_object_types.name = 'METHODS' AND  
      servoy_solutions.solution_name = 'mod_functions_v2' AND  
      servoy_content_spec.property_name = 'name'

I affraid by using the above repository update SQL I might messup my repository.

Please help. This would make my work a lot easier.

Thanks

2

Hi Hameed,

I would not do what you are trying to do here. You are messing with the basics of your Servoy solution. When something goes wrong in whatever way you have messed your solution up forever…

3

Hi Marcel,

Thanks for your advice. But my question to servoy guys is that the above SQL is valid or is it missing anything to do what I have intended.

By the way, your outline plugin should be able to do this. When you are going to release beta version of it.

Thanks!

4

Yes it will be able to do this. I hope to release somewhere in the very near future but I can not give you any release date yet.