[chronojump/chronojump-importer] Adds unit test for previous bug.



commit 5c3261892ba92be5886aedc13fa49c1fef7d42b7
Author: Carles Pina i Estany <carles pina cat>
Date:   Sat Sep 24 16:14:08 2016 +0100

    Adds unit test for previous bug.
    
    Database.write raised an exception if a duplicate was found.

 .../chronojump_importer_test.py                    |   18 ++++++++++++++++++
 1 files changed, 18 insertions(+), 0 deletions(-)
---
diff --git a/src/chronojump-importer/chronojump_importer_test.py 
b/src/chronojump-importer/chronojump_importer_test.py
index 8da246e..b4acd9e 100755
--- a/src/chronojump-importer/chronojump_importer_test.py
+++ b/src/chronojump-importer/chronojump_importer_test.py
@@ -230,6 +230,24 @@ class TestDatabase(unittest.TestCase):
         database.close()
         os.remove(filename)
 
+    def test_write(self):
+        filename = tempfile.mktemp(prefix="chronojump_importer_test_write", suffix=".sqlite")
+        open(filename, 'a').close()
+
+        database = chronojump_importer.Database(filename, read_only=False)
+        cursor = database._cursor
+
+        cursor.execute("CREATE TABLE test (uniqueID INTEGER PRIMARY KEY, name TEXT)")
+        cursor.execute("INSERT INTO test (uniqueID, name) VALUES (1, 'john')")
+
+        table = chronojump_importer.Table("test")
+        row = chronojump_importer.Row()
+        row.set(column_name="uniqueID", value="2")
+        row.set(column_name="name", value="john")
+
+        table.insert_row(row)
+
+        database.write(table=table, matches_columns=None, avoids_duplicate_column="name")
 
 if __name__ == '__main__':
     unittest.main(verbosity=2)


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]