Changeset 35 for trunk/npemap.org.uk/scripts/freethepostcode.org-importer

Timestamp:

Oct 13, 2006, 11:36:41 AM (14 years ago)

Author:

Nick Burch

Message:

Finish the import script

File:

• trunk/npemap.org.uk/scripts/freethepostcode.org-importer/importer.py (modified) (4 diffs)

trunk/npemap.org.uk/scripts/freethepostcode.org-importer/importer.py

@@ -40 +40 @@
 sth.execute(sql, ftp_source_name)
 ids = sth.fetchall()
+sth.close()
 if len(ids) == 1:
         for id in (ids):
@@ -103 +104 @@
 counts = sth.fetchall()
 count = counts[0][0]
+sth.close()
 
 print "There are currently %d entries in the database from freethepostcode.org" % count
@@ -108 +110 @@
 print "Are you sure you wish to remove the old entries, to add new ones?"
 confirm = raw_input("")
+print ""
 
 if confirm == "y" or confirm == "yes":
@@ -121 +124 @@
 sth = dbh.cursor()
 sth.execute(sql, ftp_source)
+print "Deleted %d entries" % sth.rowcount
+sth.close()
+dbh.commit()
 
 
 # Add the latest list to the database
+sql = "INSERT INTO postcodes (outward, inward, raw_postcode, easting, northing, source) VALUES (%s, %s, %s, %s, %s, %s)"
+sth = dbh.cursor()
+worked = 0
+for postcode in postcodes:
+        sth.execute(sql, (postcode["outer"], postcode["inner"], postcode["raw"], postcode["easting"], postcode["northing"], ftp_source))
+        worked = worked + sth.rowcount
+print "Added %d entries" % worked
 
 
+# All done
+sth.close()
+dbh.commit()
+dbh.close()