OpenAPI is wrong and Input / Output schemas are missing

[tkaraouzene]

OpenAPI is wrong and Input / Output schemas are missing

[cosmicBboy]

This looks like a duplicate of #1395, correct?

[tkaraouzene]

My bad I forgot to specify that I was using pydantic v1 (1.10.2). So no it is not a duplicate

[cosmicBboy]

Gotcha. Feel free to try and debug this and opening a PR for a fix!

The part of the codebase that creates the json schema representation is here

[tkaraouzene]

Thanks, I'll have a look on it

[eharkins]

@tkaraouzene did you have any success getting pandera to work with generating openapi schema accurately using pydantic v1 and fastapi? I am having a similar issue where I am orienting the dataframe as records (list) but openapi is generating a schema where each column is an array like:

                 "year_id": {
                    "type": "array",
                    "items": {
                      "type": "integer"
                    }
                  },

My actual response model is returned as a list of record objects that each have a year_id, etc. , which doesn't match the schema being generated.

[cosmicBboy]

The state of the json_schema support is still the same as before, see this issue: #1395

Would welcome any PRs to actually fix the to_json_schema function here:

pandera/pandera/api/pandas/model.py

Lines 651 to 661 in cf6b5e4

	def _to_json_schema(dataframe_schema):
	"""Serialize schema metadata into json-schema format.
	:param dataframe_schema: schema to write to json-schema format.
	.. note::
	This function is currently does not fully specify a pandera schema,
	and is primarily used internally to render OpenAPI docs via the
	FastAPI integration.
	"""

[eharkins]

Ok, thanks. In the meantime is there a recommended way to override the _to_json_schema function to explicitly specify the schema? Alternatively, would returning a dataframe model with

    class Config:
        to_format = "dict"
        to_format_kwargs = {"orient": "list"}

match the way that the schema is currently generated with columns as arrays?

Edit: using the above kwargs worked for me to make my responses match the way pandera generates the openapi schema