locode saving record postgresql

[tiptopweb]

Hello,
Here is an issue with locode using postgresql (myget v6.0.3)
Possibly an issue between "Id" and "id"
It is happening for all tables
This is the project discussed in Discord, I am using PostgreSqlNamingStrategy (that is NOT converting names to lowercase)
Maybe locode is not taking this into account when saving?

[Layoric]

The default PostgreSqlNamingStrategy does indeed convert to lower case + underscore as seen here. Are you overriding with a custom one? Could you share SQL naming strategy, annotated request DTOs and schema for one of the tables where you have this problem?

[tiptopweb]

There are no DTOs
The autogen code is :

public class ConfigureAutoQuery : IHostingStartup
    {
        public void Configure(IWebHostBuilder builder) => builder
            .ConfigureAppHost(appHost => {

                var skipTables = new List<string> {
                    "UserAuth",
                    "UserAuthDetail",
                    "UserAuthRole",
                    ...
                };

                appHost.Plugins.Add(new AutoQueryFeature {
                    MaxLimit = 1000,
                    IncludeTotal = true,
                    GenerateCrudServices = new GenerateCrudServices {
                        CreateServices = {
                            new CreateCrudServices() { Schema = "public" },
                            new CreateCrudServices() { Schema = "dbo" },
                        },
                        ServiceFilter = (op, req) =>
                        {
                            if (op.IsCrud())
                            {
                                //op.Request.AddAttributeIfNotExists(new ValidateRequestAttribute("IsAuthenticated"),
                                //    x => x.Validator == "IsAuthenticated");
                                op.Request.AddAttributeIfNotExists(new ValidateHasRoleAttribute("admin-admin"));
                            }
                        },
                        TypeFilter = (type, req) =>
                        {
                            if (type.Name == "TtwMedia") type.Property("UrlKey").AddAttribute(new FormatAttribute(FormatMethods.Icon));
                            if (type.Name == "TtwMedia") type.Property("SmallImageUrl").AddAttribute(new FormatAttribute(FormatMethods.Icon));
                            if (type.Name == "TtwMedia") type.Property("LargeImageUrl").AddAttribute(new FormatAttribute(FormatMethods.Icon));
                        },
                        IncludeService = op => !skipTables.Any(table => op.ReferencesAny(table))
                    }
                });

                appHost.ConfigureTypes(type => {

                    switch (type.Name)
                    {
                        case "TtwMedia":
                            type.Property("ArticleId").Ref = new() { Model = "TtwArticle", RefId = "Id", RefLabel = "Name" };
                            break;
                        ...
                    }

                });
            });
    }

Here is the naming strategy

public class MyPostgreSqlNamingStrategy : PostgreSqlNamingStrategy
    {
        public override string GetTableName(string name)
        {
            return name;
        }

        public override string GetColumnName(string name)
        {
            return name;
        }

        public override string GetSchemaName(string name)
        {
            return name;
        }
    }

Here is the table script

CREATE TABLE IF NOT EXISTS dbo."TtwMedia"
(
    "Id" integer NOT NULL DEFAULT nextval('dbo."TtwMedia_Id_seq"'::regclass),
    "ArticleId" integer NOT NULL,
    "UrlKey" character varying(400) COLLATE pg_catalog."default",
    "Guid" uuid NOT NULL,
    "Name" character varying(400) COLLATE pg_catalog."default",
    "CpxParam" text COLLATE pg_catalog."default",
    "DateCreated" timestamp(3) without time zone,
    "Published" boolean NOT NULL,
    "IsFeatured" boolean NOT NULL,
    "Deleted" boolean NOT NULL,
    "Status" integer NOT NULL,
    "Type" integer NOT NULL,
    "DisplayOrder" integer NOT NULL,
    "SmallImageUrl" character varying(400) COLLATE pg_catalog."default",
    "LargeImageUrl" character varying(400) COLLATE pg_catalog."default",
    "NopId" integer NOT NULL DEFAULT 0,
    "DateNopLastUpdate" timestamp(3) without time zone,
    "AltTag" character varying(400) COLLATE pg_catalog."default",
    CONSTRAINT "PK_TtwMedia" PRIMARY KEY ("Id"),
    CONSTRAINT "FK_TtwMedia_TtwArticle" FOREIGN KEY ("ArticleId")
        REFERENCES dbo."TtwArticle" ("Id") MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION
)

TABLESPACE pg_default;

[Layoric]

This was an issue was related to the non standard naming strategy and OrmLite missing a quoted column for the where statement which has now been resolved in this commit and is available on MyGet.

[tiptopweb]

Yes it is now working. Thank you!