1 files changed, 17 insertions, 1 deletions
diff --git a/importutils/import.py b/importutils/import.py
index e2aa14a..491fb5b 100644
--- a/importutils/import.py
+++ b/importutils/import.py
@@ -1,9 +1,25 @@
+
+# 1. pre-condition : work by year, all files deployed on file system
+# 2. un-gzip all files (by default, into same directory, overriding .gz files)
+# 3. rename all TCSC files to TCSC.dmp (prepare for imp)
+# 4. for each TCSC.dmp file:
+#   4.1. call imp on each single file (guaranteed to be < ~300MB)
+#   4.2. for each table (need to create hard-coded list)
+#       4.2.1. SELECT * FROM table
+#       4.2.2. save aside, or throw into new db
+#   4.3. dump all tables (make room for next iteration)
+
+
 import os
 import sys
+import subprocess
 
 RAW_DATA_BASE_DIR = "/base/dir/location" # update this
 
 def importYear(year):
     yearDir = os.path.join(RAW_DATA_BASE_DIR, str(year))
-    print 
+    print yearDir
+    
+importYear(2005)
+