openmolecules.org

 
Home » DataWarrior » Functionality » Database Access
Database Access [message #205] Fri, 04 November 2016 16:39 Go to next message
sawildman is currently offline  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
Re: Database Access [message #207 is a reply to message #205] Sun, 06 November 2016 00:06 Go to previous message
thomas is currently offline  thomas
Messages: 646
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
Previous Topic: Select columns to hide/show
Next Topic: Using Set Value Range option
Goto Forum:
  


Current Time: Thu Mar 28 14:22:03 CET 2024

Total time taken to generate the page: 0.08197 seconds