Created
October 29, 2013 02:05
-
-
Save selenamarie/7208066 to your computer and use it in GitHub Desktop.
finding busted json
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
for i in `seq 1 59`; do | |
num=$i | |
num2=$(($i+1)) | |
psql breakpad -c "SELECT 1 from raw_crashes where json_object_field_text(raw_crash, 'AdapterVendorID') is not NULL and json_object_field_text(raw_crash, 'AdapterDeviceID') is NOT NULL and date_processed >= '2013-10-26 17:09:${num}+00'::timestamptz AND date_processed <= '2013-10-26 17:09:${num2}+00'::timestamptz" | |
echo $i | |
done |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment