5. Extract SQL statements to Gateways

[agilare]

Process (from MLAP, p. 84) :

• Search the entire codebase for SQL statements; regex : (SELECT|INSERT|UPDATE|DELETE)
• For each statement not already in a Gateway, move the statement and relevant logic to a related Gateway class method.
• Write a test for the new Gateway method.
• Replace the statement and relevant logic in the original file with a call to the Gateway class method.
• Test, commit, push, and notify QA
• Repeat with the next SQL statement that is outside a Gateway class.

Guidelines :

• organize by domain entities like Domain/Events, Domain/Lieux, etc.
• use everywhere mysqli prepared statements
• write basics test, as a beginning, still needing a db connection
• try to combine identical or similar repetitives queries
• if needed create an abstract gateway class
• some bloated (multiple and/or complex) queries can be preferably split in logical ones