X-Git-Url: https://git.phdru.name/?p=sqlconvert.git;a=blobdiff_plain;f=tests%2Ftest_mysql2postgres.py;h=971970cdd612306d76f90468fc367e4a8d6f3cb5;hp=b81c6bf4245797900b38c6730c54dbf0753cfa59;hb=6d906e2f335699348bf44a653ca708b522a99d85;hpb=aff066ceefb79333878baaf7c16e0a2206d26c5d diff --git a/tests/test_mysql2postgres.py b/tests/test_mysql2postgres.py index b81c6bf..971970c 100644 --- a/tests/test_mysql2postgres.py +++ b/tests/test_mysql2postgres.py @@ -19,11 +19,12 @@ CREATE TABLE test ( def test_mysql2postgres_string(): connection.query(create_postgres_test_table) - parsed = parse("insert into test (id, test_str) " - "values (1, '\"te\\'st\\\"')")[0] + parsed = parse("insert into test (id, test_str) values " + "(1, '\"te\\'st\\\"\\n')")[0] unescape_strings(parsed) query = tlist2str(parsed) - assert query == u"INSERT INTO test (id, test_str) VALUES (1, '\"te''st\"')" + assert query == u"INSERT INTO test (id, test_str) VALUES " \ + u"(1, '\"te''st\"\n')" connection.query(query) test_str = connection.queryOne("SELECT test_str FROM test WHERE id=1")[0] - assert test_str == u"\"te'st\"" + assert test_str == u"\"te'st\"\n"