Commits

Ada Young committed 43607fb

Oops forgot to put in those lines *blush*

Comments (0)

Files changed (1)

         for i in range(len(results)):
             (newsid, timestamp, author, recipient, subject, f_content) = results[i][1:]
             cursor.execute("SELECT newsid FROM org_news WHERE orgid=? AND newsid=?", (orgname, newsid))
+            results = cursor.fetchall()
             if not len(results) > 0: # here we prune results to avoid duplicates
                 import_set.append(newsid, author, recipient, subject, timestamp, f_content, orgid)
         cursor.executemany("""
         INSERT INTO org_news (newsid, author, recipient, subject, timestamp, f_content, orgid) VALUES (?, ?, ?, ?, datetime(?), ?, ?)
         """, import_set) # this line makes the inserts go super fast
-        Note("NewsDB: Imported a total of %d objects." % total_objects)
-    except sqlite3.Error:
+        Note("NewsDB: Imported a total of %d new objects." % len(import_set))
+    except sqlite3.Error as e:
         Note("SQLite error: {0}".format(e.message))
     except:
         Note("NewsDB: Invalid file or the file does not contain a NewsDB pickle object.")
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.