openapi integers range.

[Naramsim]

Hi, @FallenDeity , could you help me here if you have some spare time? I wanted to regenerate the openapi schema on my PC but I get a different result than the current version on master, when building many properties get this modification:

         growth_time:
           type: integer
-          maximum: 2147483647
-          minimum: -2147483648
+          maximum: 9223372036854775807
+          minimum: -9223372036854775808
+          format: int64

Can we add a rule for these ranges?

[FallenDeity]

I have run into this before iirc this happens when you try to generate the openapi schema in local using the sqlite db instead of the postgres db

the int in sqlite goes upto 8 bytes https://www.sqlite.org/datatype3.html postgres is standard 4 bytes

i usually just generate it using docker container with the postgres config

[jemarq04]

Ah, I was wondering how that was happening. Is there a way to lower the size limit with sqlite to 4 bytes like postgres? I'm not familiar with these tools but it would be nice for that to work whenever I need to regenerate the openapi schema file.

[FallenDeity]

I dont think there is any config var that sqlite defines for that but perhaps we can allow people to use their local postgres db as a setting config option too instead of sqlite when running locally or not inside the docker container