openmolecules.org Forum: Functionality

Home » DataWarrior » Functionality » Database Access

Show: Today's Messages :: Show Polls :: Message Navigator

Database Access [message #205]

Fri, 04 November 2016 16:39

sawildman
Messages: 1
Registered: November 2016
Location: University of Wisconsin

Junior Member

I would like to use the "Retrieve Data from Custom URL" feature to access an in-house database that is significantly more complicated than the examples.
I currently access this database with a bash script that involves
1. Setting an access key
2. Calling curl to initiate the data export
3. Waiting for the export to finish (calling curl to monitor progress)
4. Calling curl to actually retrieve the data export
Each of these curl calls requires the access key to be included

Is there a way to set all of this into a DataWarrior macro, or to use a macro to call my bash script?

Scott

Report message to a moderator

Re: Database Access [message #207 is a reply to message #205]

Sun, 06 November 2016 00:06

thomas
Messages: 179
Registered: June 2014

Senior Member

If you can't put the process into one URL, the "Retrieve Data from Custom URL" won't do it.
Calling a bash script from DataWarrior is not possible either. But possibly you could automate the process
by changing and extending your bash script such that the last curl call writes the data into a defined file
and the next bash command launches DataWarrior with the filename as parameter.

Thomas

Report message to a moderator

Previous Topic:	Select columns to hide/show
Next Topic:	Using Set Value Range option

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Feb 23 16:54:14 CET 2019

Total time taken to generate the page: 0.00371 seconds