Changeset 9183

Timestamp:

May 12, 2011, 8:35:35 AM (14 years ago)

Author:

rick

Message:

Whoops forgot about 0 entries to import.

File:

• src/django_gheat/gheat/management/commands/import_droidstumbler.py (modified) (1 diff)

src/django_gheat/gheat/management/commands/import_droidstumbler.py

@@ -91 +91 @@
   # Make sure to include closing newline
   if show_progres: output.write("%s\n" % meting_count)
+
+  # Bulk Import data if possible
   if bulk_import:
-    sql = "INSERT INTO gheat_meting (`meetrondje_id`, `accespoint_id`, `lat`, `lng`, `signaal`) VALUES %s" % ','.join(sql_values)
-    cursor.execute(sql)
-    transaction.commit_unless_managed()
+    if len(sql_values) == 0:
+      logging.warn("No data to import")
+    else:
+      try:
+        sql = "INSERT INTO gheat_meting (`meetrondje_id`, `accespoint_id`, `lat`, `lng`, `signaal`) VALUES %s" % ','.join(sql_values)
+        cursor.execute(sql)
+        transaction.commit_unless_managed()
+      except IntegrityError, e:
+        logging.error("Unable to import - %s" %  e)
+        pass
 
   return (len(ap_cache), new_ap_count, meting_count, len(meting_pool) - meting_count)