Mercurial > hg > LGDataverses

diff scripts/api/download/dbquery @ 10:a50cf11e5178

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Rewrite LGDataverse completely upgrading to dataverse4.0
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Tue, 08 Sep 2015 17:00:21 +0200
parents
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/scripts/api/download/dbquery	Tue Sep 08 17:00:21 2015 +0200
@@ -0,0 +1,13 @@
+#!/bin/sh
+if [ -z "$1" ]; then
+  echo "No start date in YYYY-MM-DD format provided."
+  exit 1
+else
+  if [ -z "$2" ]; then
+    echo "No end date in YYYY-MM-DD format provided."
+    exit 1
+  fi
+  START_DATE=$1
+  END_DATE=$2
+fi
+psql -h $DB_SERVER -U $DB_USER -p $DB_PORT $DB_NAME -F $'\t' --no-align --pset footer -c "select dvobject.id, dvobject.createdate, dvobject.owner_id, datafile.* from dvobject, datafile where dvobject.id=datafile.id and dvobject.dtype='DataFile' and dvobject.createdate>to_date('$START_DATE','YYYY-MM-DD') and dvobject.createdate<to_date('$END_DATE','YYYY-MM-DD') order by dvobject.createdate asc;" > files.tsv