Home

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; '''