Difference between revisions of "lazdbexport"
m (→Example: Fix Wiki link markup) |
m (Remove self-referencing page link) |
||
Line 1: | Line 1: | ||
{{lazdbexport}} | {{lazdbexport}} | ||
− | '''lazdbexport''' is a package that supplies components to facilitate database export. It is delivered with lazarus and may be installed by using [Package|Install/Uninstall packages]. After install the components are accessible via the | + | '''lazdbexport''' is a package that supplies components to facilitate database export. It is delivered with lazarus and may be installed by using [Package|Install/Uninstall packages]. After install the components are accessible via the Data Export tab. |
It provides a template class for descendants that can provide export of datasets. | It provides a template class for descendants that can provide export of datasets. | ||
Also included are various ready-made descendants for: | Also included are various ready-made descendants for: |
Revision as of 04:26, 18 July 2020
│
English (en) │
français (fr) │
lazdbexport is a package that supplies components to facilitate database export. It is delivered with lazarus and may be installed by using [Package|Install/Uninstall packages]. After install the components are accessible via the Data Export tab. It provides a template class for descendants that can provide export of datasets. Also included are various ready-made descendants for:
icon | Component | Description |
---|---|---|
TCSVExporter | CSV | |
TFixedlengthExporter | Fixed length | |
TSQLExporter | SQL | |
TXMLXSDExporter | XML/XSD | |
TSimpleXMLExporter | XML | |
TSimpleJSONExporter | json | |
TFPDbfExport | dbf | |
TTeXExporter | TeX | |
TRTFExporter | RTF | |
TStandardExportFormats | ||
TFPDataExporter |
As indicated, developers can write their own export classes using the export framework. An example of this is the Excel/spreadsheet format exporter in FPSpreadsheet
Import
There is no corresponding import to dataset code in FPC/Lazarus, but there is third party code like dbimport (https://bitbucket.org/reiniero/smalltools/src, directory dbimport).
DbImport is used in the LazSQLX and TurboBird database management tools for importing CSV (like) data into datasets.
Another form of import is the use of TSQLScript; an exported database with TSQLExporter can be imported with the use of TSQLScript.
Example
See the examples in your FPC source directory $(fpcdir)\source\packages\fcl-db\tests (see Running FPC database tests), specifically testdbexport.pas.