Tag Results

Items tagged with "sql" (7)

Note: some items may not be visible to you, due to viewing permissions.

Files (1)

Uploader

Alexey Mints

View

Download

fits/votable to SQL converter

Created: 2013-12-05 11:53:20 | Last updated: 2013-12-19 10:24:00

Credits: Alexey Mints

License: Creative Commons Attribution-Share Alike 3.0 Unported License

Simple python script to convert Fits file or VO-table to SQL database.Optimized for PostgreSQL, but easily modified for anything else.So far only SQL-script preparation is done. You can execute the output Yourself.

File type: text/x-python

Comments: 0 | Viewed: 68 times | Downloaded: 48 times

Tags:

Workflows (6)

Taverna 1

Uploader

Andrea Wiggins

DOI Files (1)

Download

This workflow generates additional files required for handling DOI creation: the DOI URL mapping required for the DOI deposit, and a set of sql update statements to insert the DOIs into an eprints database. Note that it is extremely important for this workflow to use the same CSV file as was used with the DOI record generator, as well as the same seed number.

Created: 2009-06-05

Credits: Andrea Wiggins

Attributions: DOI Record Generator

Taverna 2

Uploader

Helen Hulme

Example of Execute_SQL_Query with parameters (1)

Download

This workflow connects to a mysql on localhost, queries the "world" database which is one of the test databases on MySQL 5.5, queries it about which countries have Dutch as a language, and emits answers in both Lists and in xml. This workflow is intended as an example to help you see the syntax for the various inputs to this local service beanshell. see: http://www.mygrid.org.uk/dev/wiki/display/taverna/Execute+SQL+Query for instructions on jars, dependencies etc. The jar used he...

Created: 2012-03-16 | Last updated: 2012-03-16

Credits: Helen Hulme

Taverna 2

Uploader

Susana

Example of jdbc (1)

Download

No description

Created: 2012-05-24 | Last updated: 2012-05-24

Taverna 2

Uploader

Anja Le Blanc

Number of features in a month in a year (1)

Download

Returns the number of features in a HFC catalogue which occured in a month in a year given as inputs.

Created: 2012-08-21

Credits: Anja Le Blanc

Taverna 2

Uploader

Anja Le Blanc

Sort 1000 fastest CMEs from a given list a... (1)

Download

The fastest 1000 CME of the input list are bined in categories by factor of 10 according to their pa_width value. List must contain fields v and pa_width. Output VOTable with the counts in the categories.