| 66 | self.assertEqual(deleted_comment["text"], "") |
| 67 | |
| 68 | def test_wordpress(self): |
| 69 | xml = join(dirname(__file__), "wordpress.xml") |
| 70 | xxx = tempfile.NamedTemporaryFile() |
| 71 | |
| 72 | db = SQLite3(xxx.name, conf) |
| 73 | WordPress(db, xml).migrate() |
| 74 | |
| 75 | self.assertEqual(db.threads["/2014/test/"]["title"], "Hello, World…") |
| 76 | self.assertEqual(db.threads["/2014/test/"]["id"], 1) |
| 77 | |
| 78 | self.assertEqual(db.threads["/?p=4"]["title"], "...") |
| 79 | self.assertEqual(db.threads["/?p=4"]["id"], 2) |
| 80 | |
| 81 | self.assertEqual(len(db.execute("SELECT id FROM threads").fetchall()), 2) |
| 82 | self.assertEqual(len(db.execute("SELECT id FROM comments").fetchall()), 8) |
| 83 | |
| 84 | first = db.comments.get(1) |
| 85 | self.assertEqual(first["author"], "Ohai") |
| 86 | self.assertEqual(first["text"], "Erster!1") |
| 87 | self.assertEqual(first["remote_addr"], "82.119.20.0") |
| 88 | |
| 89 | second = db.comments.get(2) |
| 90 | self.assertEqual(second["author"], "Tester") |
| 91 | self.assertEqual(second["text"], "Zweiter.") |
| 92 | |
| 93 | for i in (3, 4, 5): |
| 94 | self.assertEqual(db.comments.get(i)["parent"], second["id"]) |
| 95 | |
| 96 | # Ensure newlines in wordpress translate to two newlines in isso, to render the same |
| 97 | multiline = db.comments.get(6) |
| 98 | self.assertIn("multiple lines: \nWordPress", multiline["text"]) |
| 99 | |
| 100 | last = db.comments.get(7) |
| 101 | self.assertEqual(last["author"], "Letzter :/") |
| 102 | self.assertEqual(last["parent"], None) |
| 103 | |
| 104 | def test_generic(self): |
| 105 | filepath = join(dirname(__file__), "generic.json") |