Feature/add special schema support

[jmkerloch]

ref #55

• update definition of table and schema name to use SQL formatting to get quoted values if needed (use of %I format option) (internal/data/db_sql.go)

• update return of notification for listener:

  • add use of %I SQL formatting to get quoted value for schema and table name
  • update eventNotification struct to get formatted Id

• fix creation and drop of trigger in listener to avoid issue with special schema and table name (internal/data/listener.go)

• add tests with special schema / table / column names

[github-actions[bot]]

Package	Line Rate	Health
github.com/CrunchyData/pg_featureserv/internal/api	89%	✔
github.com/CrunchyData/pg_featureserv/internal/conf	54%	❌
github.com/CrunchyData/pg_featureserv/internal/cql	67%	➖
github.com/CrunchyData/pg_featureserv/internal/data	62%	➖
github.com/CrunchyData/pg_featureserv/internal/service	68%	➖
github.com/CrunchyData/pg_featureserv/internal/ui	82%	✔
github.com/CrunchyData/pg_featureserv	22%	❌
Summary	69% (6050 / 8767)	➖

Minimum allowed line rate is 60%

[benoitdm-oslandia]

You will do the same for table field names in this PR or in another one?

[jmkerloch]

You will do the same for table field names in this PR or in another one?

I'm working on the update for table name and column name. This should be available soon.

[sonarcloud[bot]]

Kudos, SonarCloud Quality Gate passed!   

0 Bugs
0 Vulnerabilities
0 Security Hotspots
3 Code Smells

No Coverage information
0.0% Duplication