Page MenuHomeDevCentral

Import FANTOIR file into PostgreSQL db
ClosedPublic

Authored by dereckson on Jan 9 2023, 02:12.
Tags
None
Referenced Files
F24410354: D2729.id6917.diff
Thu, Feb 19, 18:42
F24410268: D2729.id6917.diff
Thu, Feb 19, 18:34
F24400337: D2729.diff
Thu, Feb 19, 01:11
F24400144: D2729.diff
Thu, Feb 19, 00:45
F24399346: D2729.id6918.diff
Wed, Feb 18, 23:17
F24399171: D2729.id6918.diff
Wed, Feb 18, 22:55
Unknown Object (File)
Tue, Feb 17, 10:06
Unknown Object (File)
Mon, Feb 16, 16:05
Subscribers
None

Details

Summary

Create a PostgreSQL table in the specified database
and import a FANTOIR database file.

Ref T1750.

Test Plan

Run against FANTOIR1022 file

Diff Detail

Lint
No Lint Coverage
Unit
No Test Coverage
Branch
main
Build Status
Buildable 4315
Build 4582: arc lint + arc unit

Event Timeline

dereckson created this revision.

Creation date can be unknown, add code_fantoir to help cross data with other db, fix last line record parsing

Switch to subcommands pattern (like git), so we can extend it

Extract run_multiple_queries method to the db module. We can't easily move the create_table function, as it needs schema-dependant replacement.

fantoir2db is now fantoir-datasource

This revision is now accepted and ready to land.Jan 12 2023, 05:00