This repository has been archived by the owner on Feb 28, 2022. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 5
Home
Ali Adabi edited this page Jun 17, 2015
·
2 revisions
Welcome to the Backend wiki! **How to get log info in the landing zone? '''sudo service landingzone stop sudo su landingzone cd landingzone -log 2'''
*You can run the following at the psql prompt to get the deltas for Panel3 on device with serial number 4junejune41981june and save them to a CSV: ''' \copy (WITH results AS (SELECT time, data, ROW_NUMBER() over() FROM data_raw WHERE serial = 4junejune41981june AND device = 'Panel3' ORDER BY time ASC) SELECT r2.time, r2.data - r1.data AS data FROM results r1, results r2 WHERE r1.row_number = r2.row_number - 1 ORDER BY r2.time ASC) To 'delta_test.csv' With CSV; '''