Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support DBI specific schema handling #383

Open
eblondel opened this issue Apr 30, 2024 · 1 comment
Open

Support DBI specific schema handling #383

eblondel opened this issue Apr 30, 2024 · 1 comment
Assignees
Labels
Milestone

Comments

@eblondel
Copy link
Collaborator

eblondel commented Apr 30, 2024

Methods develop so far are essentially based on the default schema considered with the DBI connection. In many cases, as it is recommmended, users used specific schemas. Areas where code needs to be refactored include:

  • software specification. Need to define a schema property (not specifically a DB connection parameter)
  • handlers (entity, contact, dictionary)
    • entity_handler_dbi
    • entity_handler_dbi_df
    • entity_handler_dbi_geometry_columns
    • contact_handler_dbi
    • dictionary_handler_dbi
  • entity enrichment
    • entity$enrichWithData,
    • entity$enrichSpatialCoverageFromDB
    • create_geoflow_data_from_dbi (to check)
  • writeWorkflowJobDataResource
  • actions
    • sf_write_generic (calling writeWorkflowJobDataResource)
    • sf_write_dbi (calling writeWorkflowJobDataResource)
    • geosapi_publish_ogc_services (for DB Postgis datastore on-the-fly creation with geosapi)
@eblondel eblondel added the enhancement New feature or request label Apr 30, 2024
@eblondel eblondel added this to the 1.0 milestone Apr 30, 2024
@eblondel eblondel self-assigned this Apr 30, 2024
@eblondel
Copy link
Collaborator Author

eblondel commented Feb 4, 2025

This ticket targets essentially Postgres / Postgis database.
As first investigation it appears, that we could simply support the "option" arg to dbConnect to specify one or more schemas on the search path, without having to rewrite specific codes.
eg
"-c search_path=myschema" (for a single schema)
"-c search_path=hibou,public" (for multiple schemas)

This approach is particularly important as it may be needed to query two or more schemas in the same connection / geoflow.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant