A small script for a cron job that will daily fetch the latest cases.

1 files changed, 11 insertions, 0 deletions

diff --git a/daily_run.sh b/daily_run.sh
new file mode 100644
index 0000000..c584b2e
--- /dev/null
+++ b/daily_run.sh
@@ -0,0 +1,11 @@
+#!/bin/bash
+
+#YEAR=$(date +'%y')
+YEAR=13
+PASSWD=$(cat ../mysql_passwd)
+QUERY="SELECT court_case_no FROM cases WHERE court_case_no LIKE 'f-$YEAR-%' ORDER BY id DESC LIMIT 1"
+CASE_NO=$(mysql -u root -p$PASSWD -ss -e "$QUERY" mdcc)
+CASE_ID=${CASE_NO:5}
+START=$(echo $CASE_ID | sed 's/^0*//')
+
+./miami_dade_clerk_courts.py $START $YEAR