About PDO JSON support

[fengqi]

I want to provide special support based on the drive name, for example, add json_support switch in the PDO config

different db JSON syntax will be different, sql may also need to write multiple

known and commonly used mysql >=5.7, postgresql >=9.2, sql server >=2016

[glensc]

I added the driver name to PdoRepository:

• Feature: Add driver name to PdoRepository #438

for this merge request:

• Replace sql type text by longtext for profile field in PdoRepository #437

(...but that author disappeared)

anyway, now driver-specific code is now possible.

this must be enabled in config:

"enable_json" => true // (or something similar)

as even if your db server supports json, you may still may have old schema in place

[glensc]

also, depending on how invasive the changes are, maybe need another PdoRepository, like PdoJsonRepository...

[glensc]

Also, when you start working on it, try to make atomic commits:

• https://www.freshconsulting.com/insights/blog/atomic-commits/
• https://en.wikipedia.org/wiki/Atomic_commit#Atomic_commit_convention

makes much easier to rebase, do codereview and apply fixes

(should put this to CONTRIBUTING.md)

[fengqi]

also, depending on how invasive the changes are, maybe need another PdoRepository, like PdoJsonRepository...

Yes, our internal current implementation is for mysql, there is a file PdoMySQLRepository that overrite the buildWhere and initSchema method

[fengqi]

Also, when you start working on it, try to make atomic commits:

• https://www.freshconsulting.com/insights/blog/atomic-commits/
• https://en.wikipedia.org/wiki/Atomic_commit#Atomic_commit_convention

makes much easier to rebase, do codereview and apply fixes

(should put this to CONTRIBUTING.md)

ok

[glensc]

also, depending on how invasive the changes are, maybe need another PdoRepository, like PdoJsonRepository...

Yes, our internal current implementation is for mysql, there is a file PdoMySQLRepository that overrite the buildWhere and initSchema method

I prefer composition over inheritance, but anyway, perhaps you submit your code and then I can then refactor to composition and provide fallback to other drivers.

[fengqi]

also, depending on how invasive the changes are, maybe need another PdoRepository, like PdoJsonRepository...

Yes, our internal current implementation is for mysql, there is a file PdoMySQLRepository that overrite the buildWhere and initSchema method

I prefer composition over inheritance, but anyway, perhaps you submit your code and then I can then refactor to composition and provide fallback to other drivers.

you mean like trait

[glensc]

you mean like trait

no. but don't bother if you don't understand, I'll take the refactoring on me.

[fengqi]

you mean like trait

no. but don't bother if you don't understand, I'll take the refactoring on me.

ok

[glensc]

@fengqi seems you have not pushed your code yet

[fengqi]

@glensc sry, our focus is on migrating to the GoLang project recently, so i haven’t had time yet.
maybe i can temporarily close this issue and open it again later.

[glensc]

@fengqi but i only asked you push your code to some pull request, and can continue from there.

[fengqi]

@fengqi but i only asked you push your code to some pull request, and can continue from there.

ok

[glensc]

@fengqi just push the changes and share the branch.