penguinolog / sqlalchemy_jsonfield Goto Github PK

Hi,

I was wondering if you would like to integrate continuous fuzzing by way of OSS-Fuzz? In this PR google/oss-fuzz#7846 we do exactly this, namely created the necessary logic from an OSS-Fuzz perspective.

Essentially, OSS-Fuzz is a free service run by Google that performs continuous fuzzing of important open source projects. The only expectation of integrating into OSS-Fuzz is that bugs will be fixed. This is not a "hard" requirement in that no one enforces this and the main point is if bugs are not fixed then it is a waste of resources to run the fuzzers, which we would like to avoid.

If you would like to integrate, the only thing I need is as list of email(s) that will get access to the data produced by OSS-Fuzz, such as bug reports, coverage reports and more stats. Notice the emails affiliated with the project will be public in the OSS-Fuzz repo, as they will be part of a configuration file.

Behavior is the same as the current cache_ok = None, except it emits a SqlAlchemy warning at: https://github.com/sqlalchemy/sqlalchemy/blob/1da3f3455dc97ad095d7abd10add7f12efe6c1c7/lib/sqlalchemy/sql/type_api.py#L1298-L1306

Relevant documentation is also in the same file:

• https://github.com/sqlalchemy/sqlalchemy/blob/1da3f3455dc97ad095d7abd10add7f12efe6c1c7/lib/sqlalchemy/sql/type_api.py#L1549-L1557
• https://github.com/sqlalchemy/sqlalchemy/blob/1da3f3455dc97ad095d7abd10add7f12efe6c1c7/lib/sqlalchemy/sql/type_api.py#L1148

Otherwise if there's a way to make it SqlAlchemy cacheable, could be set to True

I'd like to use this without changing the db.Model, is that possible?

The use case:

• We use MySQL in production which has JSON
• Locally we want to test in sqlite which does not really have it (the extension is a bit annoying to use)
• Can I drop in this project without any changes to the Model purely for local development. So when the database is sqlite and there is no JSON support, override it to store strings?

When i trying to create marshmallow schema i got this:
... marshmallow_sqlalchemy.exceptions.ModelConversionError: Could not find field column of type <class 'sqlalchemy.sql.type_api.TypeEngine'>.