Handle all query in a more secure way #2

New issue

Open

opened 2025-02-24 14:20:50 +01:00 by kazhnuz · 2 comments

kazhnuz commented

2025-02-24 14:20:50 +01:00

Owner

No description provided.

kazhnuz added the

Kind/Security

Priority

Critical

labels 2025-02-28 11:17:29 +01:00

kazhnuz added this to the Code modernisation project 2025-02-28 11:17:33 +01:00

kazhnuz added this to the v0.1.0 milestone 2025-02-28 11:17:36 +01:00

kazhnuz commented

2025-04-04 15:46:50 +02:00

Author

Owner

-> Use PDO for all query, in a Database class, and that'll count queries
-> Keep the table system where we parse a "{{table}}", it's usefull for what'll do. But for all the rest, use PDO native parameter system
-> Add a repository system with a Repository parent class and specific class for all repositories, that'll live in a /repositories or a /core/repositories folder.

-> Use PDO for all query, in a Database class, and that'll count queries -> Keep the table system where we parse a "{{table}}", it's usefull for what'll do. But for all the rest, use PDO native parameter system -> Add a repository system with a Repository parent class and specific class for all repositories, that'll live in a /repositories or a /core/repositories folder.

kazhnuz referenced this issue from a pull request that will close it,

2025-07-18 11:19:25 +02:00

Port entirely to a MVC-like pattern #37

kazhnuz commented

2025-07-18 16:15:40 +02:00

Author

Owner

-> Add a $dbField array that contains data for array and stuff (as something like 'id'=>['type'='smallint(5) unsigned', 'nullable'=>false, 'defaultValue'=>'0', autoIncrement=>true])
-> Add some query construction to update/create using those fields
-> Add a create table function for tables.
-> Handle default datas as JSON files ?

-> Add a $dbField array that contains data for array and stuff (as something like `'id'=>['type'='smallint(5) unsigned', 'nullable'=>false, 'defaultValue'=>'0', autoIncrement=>true]`) -> Add some query construction to update/create using those fields -> Add a create table function for tables. -> Handle default datas as JSON files ?