loading tool values from other databases
Dear Galaxy Developers I wish to write set of tools for Galaxy Community; tools will use Postgresql/MySQL database (other than the default galaxy database). Tool's dropdown boxes will load values from the database on the fly. I had a look at tool configuration at Galaxy WiKi and I can't seems to track the right configuration. What's the best way to approach that? Other solution I was thinking to open a new web app in galaxy_main iframe, however, that seems to involve creating new controller. My aim is achieve this by minimal modification to core code. Reference to any existing similar tool will certainly help. Any other guidance will be appreciated (keep in mind I am a newbie). Thanks. Mat
Hi Mat may I refer to a similar question from last year which I answered, see: http://tinyurl.com/6uom4uo I never got a reply, but I still think this is a valid and easy way to implement a solution for your problem without modification to core code. Regards, Hans On 02/02/2012 01:17 PM, Matloob Khushi wrote:
Dear Galaxy Developers
I wish to write set of tools for Galaxy Community; tools will use Postgresql/MySQL database (other than the default galaxy database). Tool’s dropdown boxes will load values from the database on the fly. I had a look at tool configuration at Galaxy WiKi and I can’t seems to track the right configuration. What’s the best way to approach that?
Other solution I was thinking to open a new web app in galaxy_main iframe, however, that seems to involve creating new controller. My aim is achieve this by minimal modification to core code. Reference to any existing similar tool will certainly help. Any other guidance will be appreciated (keep in mind I am a newbie). Thanks.
Mat
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at:
Thanks Hans This was helpful, I appreciate your response. However, it loads values when the tool gets reloaded (either by Galaxy restarting or from admin interface). My tool could load different values, in the dropdown, every time it is get called based on the logged in user or if the database table has changed...! Any thought on this; any point to code example or reference to existing tool will be very helpful. Regards Mat -----Original Message----- From: Hans-Rudolf Hotz [mailto:hrh@fmi.ch] Sent: Friday, 3 February 2012 2:21 AM To: Matloob Khushi Cc: galaxy-dev@lists.bx.psu.edu Subject: Re: [galaxy-dev] loading tool values from other databases Hi Mat may I refer to a similar question from last year which I answered, see: http://tinyurl.com/6uom4uo I never got a reply, but I still think this is a valid and easy way to implement a solution for your problem without modification to core code. Regards, Hans On 02/02/2012 01:17 PM, Matloob Khushi wrote:
Dear Galaxy Developers
I wish to write set of tools for Galaxy Community; tools will use Postgresql/MySQL database (other than the default galaxy database). Tool's dropdown boxes will load values from the database on the fly. I had a look at tool configuration at Galaxy WiKi and I can't seems to track the right configuration. What's the best way to approach that?
Other solution I was thinking to open a new web app in galaxy_main iframe, however, that seems to involve creating new controller. My aim is achieve this by minimal modification to core code. Reference to any existing similar tool will certainly help. Any other guidance will be appreciated (keep in mind I am a newbie). Thanks.
Mat
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at:
----- No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.1913 / Virus Database: 2112/4780 - Release Date: 02/01/12
On 02/04/2012 03:28 AM, Matloob Khushi wrote:
Thanks Hans This was helpful, I appreciate your response. However, it loads values when the tool gets reloaded (either by Galaxy restarting or from admin interface).
Just to clarify, it loads the data on the fly every time the tool gets called. There is no need to restart Galaxy or reload the tool via the admin interface. It does work. We are using this quick and dirty trick for several of our self-written tools. Regards, Hans
My tool could load different values, in the dropdown, every time it is get called based on the logged in user or if the database table has changed...!
Any thought on this; any point to code example or reference to existing tool will be very helpful.
Regards Mat -----Original Message----- From: Hans-Rudolf Hotz [mailto:hrh@fmi.ch] Sent: Friday, 3 February 2012 2:21 AM To: Matloob Khushi Cc: galaxy-dev@lists.bx.psu.edu Subject: Re: [galaxy-dev] loading tool values from other databases
Hi Mat
may I refer to a similar question from last year which I answered, see:
I never got a reply, but I still think this is a valid and easy way to implement a solution for your problem without modification to core code.
Regards, Hans
On 02/02/2012 01:17 PM, Matloob Khushi wrote:
Dear Galaxy Developers
I wish to write set of tools for Galaxy Community; tools will use Postgresql/MySQL database (other than the default galaxy database). Tool's dropdown boxes will load values from the database on the fly. I had a look at tool configuration at Galaxy WiKi and I can't seems to track the right configuration. What's the best way to approach that?
Other solution I was thinking to open a new web app in galaxy_main iframe, however, that seems to involve creating new controller. My aim is achieve this by minimal modification to core code. Reference to any existing similar tool will certainly help. Any other guidance will be appreciated (keep in mind I am a newbie). Thanks.
Mat
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at:
----- No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.1913 / Virus Database: 2112/4780 - Release Date: 02/01/12
participants (2)
-
Hans-Rudolf Hotz -
Matloob Khushi