angusdev commented on PR #265: URL: https://github.com/apache/commons-csv/pull/265#issuecomment-1258595192
Tested the behaviour of import and export are consistent. Test case: export csv/tsv from PostgreSQL, read by commons-cvs and write to new csv/tsv, import to PostgreSQL, export csv/tsv again. compare the 1st and 2nd export file ```sql drop table COMMONS_CSV_PSQL_TEST; create table COMMONS_CSV_PSQL_TEST (ID INTEGER, COL1 VARCHAR, COL2 VARCHAR, COL3 VARCHAR, COL4 VARCHAR); insert into COMMONS_CSV_PSQL_TEST select 1, 'abc', 'test line 1' || chr(10) || 'test line 2', null, ''; insert into COMMONS_CSV_PSQL_TEST select 2, 'xyz', '\b:' || chr(8) || ' \n:' || chr(10) || ' \r:' || chr(13), 'a', 'b'; insert into COMMONS_CSV_PSQL_TEST values (3, 'a', 'b,c,d', '"quoted"', 'e'); copy COMMONS_CSV_PSQL_TEST to '/tmp/psql.csv' with (FORMAT CSV); copy COMMONS_CSV_PSQL_TEST to '/tmp/psql.tsv'; ``` use commons-csv to read '/tmp/psql.csv' and write to '/tmp/outpsql.csv', same for 'psql.tsv' ```sql truncate table COMMONS_CSV_PSQL_TEST; copy COMMONS_CSV_PSQL_TEST(ID, COL1, COL2, COL3, COL4) from '/tmp/outpsql.csv' with (FORMAT CSV); copy COMMONS_CSV_PSQL_TEST to '/tmp/psql2.csv' with (FORMAT CSV); truncate table COMMONS_CSV_PSQL_TEST; copy COMMONS_CSV_PSQL_TEST(ID, COL1, COL2, COL3, COL4) from '/tmp/outpsql.tsv'; copy COMMONS_CSV_PSQL_TEST to '/tmp/psql2.tsv'; ``` diff /tmp/psql.csv /tmp/psql2.csv (no difference) diff /tmp/psql.tsv /tmp/psql2.tsv (no difference) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
