Skip to content

Instantly share code, notes, and snippets.

@selenamarie
Created October 29, 2013 02:05
Show Gist options
  • Save selenamarie/7208066 to your computer and use it in GitHub Desktop.
Save selenamarie/7208066 to your computer and use it in GitHub Desktop.
finding busted json
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