[fpc-pascal] [Patch] New tests for fcl-db export

michael.vancanneyt at wisa.be michael.vancanneyt at wisa.be
Fri Sep 16 09:49:45 CEST 2011



On Fri, 16 Sep 2011, Reinier Olislagers wrote:

> 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.



More information about the fpc-pascal mailing list