Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / fpc-pascal / 2011-09

[Patch] New tests for fcl-db export

2 messages · 2 people ·

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Reinier Olislagers

Hi list,

FYI & hopefully implementation:

I've been writing some tests for fcl-db export, that test basic functionality for:
- CSV export
- DBF export
- SimpleXML export

Please find them in Mantis:
20271 [Patch] SimpleXML export: new test for fcl-db

20268 [Patch] CSV export: new test for fcl-db

20163 [Patch] Dbase export: new test for fcl-db
(reopened, contains fixes suggested by Michael Van Canneyt)

They're all set up in a similar way: create a bufdataset with all the field types I can cram in, fill them with some rows of extreme and middle-of-the-road data and try an export.
For e.g. simple xml and csv export, default export formatting settings as well as custom format settings are tested.

In future, they could be extended a bit (e.g. test reading generated csv into a stringlist, reading dbf etc).

I do realise these tests could be combined in a big export test, but it might be an even better idea to incorporate it in the existing dbtestframework.

However, understanding how to work the db testframework to do the export tests for a large amount of different data in the datasets is a bit above the combination of (my skills+my interest in figuring it out), so in the meanwhile my motto is: a test (or 2) is better than no test.

Also, if somebody would be willing to look at my pet patches: 19759 CSV export doesn't quote memo fields
19937 TSQLExporter does not quote memo fields (or blobs)

Thanks,
Reinier

Unknown author
to Reinier Olislagers
Reinier Olislagers wrote 40 lines
Hi list, FYI & hopefully implementation: I've been writing some tests for fcl-db export, that test basic functionality for: - CSV export - DBF export - SimpleXML export Please find them in Mantis: 20271 [Patch] SimpleXML export: new test for fcl-db 20268 [Patch] CSV export: new test for fcl-db 20163 [Patch] Dbase export: new test for fcl-db (reopened, contains fixes suggested by Michael Van Canneyt) They're all set up in a similar way: create a bufdataset with all the field types I can cram in, fill them with some rows of extreme and middle-of-the-road data and try an export. For e.g. simple xml and csv export, default export formatting settings as well as custom format settings are tested. In future, they could be extended a bit (e.g. test reading generated csv into a stringlist, reading dbf etc). I do realise these tests could be combined in a big export test, but it might be an even better idea to incorporate it in the existing dbtestframework. However, understanding how to work the db testframework to do the export tests for a large amount of different data in the datasets is a bit above the combination of (my skills+my interest in figuring it out), so in the meanwhile my motto is: a test (or 2) is better than no test. Also, if somebody would be willing to look at my pet patches: 19759 CSV export doesn't quote memo fields 19937 TSQLExporter does not quote memo fields (or blobs)

I'll have a look at all patches later today.

Michael.