ReadModelSqlGenerator Column Prefix and Suffix - Not Used in Select Query

[VladislavRybnikov]

Hi!

I am using PostgreSQL read models and discovered an issue with the column names.

STR

1. I created all tables with double-quoted values for table and column names using FluentMigrator (this is the default FluentMigrator PostgreSQl configuration).
2. I registered PostgreSql readModels using ConfigurePostgreSql and UsePostgreSqlReadModel
3. I added [PostgreSqlReadModelIdentityColumn] attribute to ReadModel's property Id

AR
When working with read models I am receiving an error from PostgreSQL that column id does not exists

ER
Should work well with such configuration by default OR should be configured by registering custom ReadModelSqlGenerator:

internal sealed class CustomPostgresReadModelSqlGenerator : ReadModelSqlGenerator
{
    public CustomPostgresReadModelSqlGenerator()
        : base(new ReadModelSqlGeneratorConfiguration(
            tableQuotedIdentifierPrefix: "\"",
            tableQuotedIdentifierSuffix: "\"",
            columnQuotedIdentifierPrefix: "\"",
            columnQuotedIdentifierSuffix: "\""))
    {
    }
}

But even registration of this custom ReadModelSqlGenerator does not help, because probably there is a bug in ReadModelSqlGenerator.

EventFlow/Source/EventFlow.Sql/ReadModels/ReadModelSqlGenerator.cs

Line 105 in cf4287b

sql = $"SELECT * FROM {tableName} WHERE {identityColumn} = @EventFlowReadModelId";

- on this line prefix and suffix - not used at all, so probably it is a bug, because they are used here -

EventFlow/Source/EventFlow.Sql/ReadModels/ReadModelSqlGenerator.cs

Line 149 in cf4287b

sql = $"UPDATE {tableName} SET {updateColumns} WHERE {Configuration.ColumnQuotedIdentifierPrefix}{identityColumn}{Configuration.ColumnQuotedIdentifierSuffix} = @{identityColumn} {versionCheck}";

.

Also, there is a question, why columnQuotedIdentifierPrefix: "\"" and columnQuotedIdentifierSuffix: "\"" - not used by default for PostgreSql configuration?

[github-actions]

Hello there!

We hope you are doing well. We noticed that this issue has not seen any activity in the past 90 days.
We consider this issue to be stale and will be closing it within the next seven days.

If you still require assistance with this issue, please feel free to reopen it or create a new issue.

Thank you for your understanding and cooperation.

Best regards,
EventFlow