Acceptance Criteria
- The command can trigger the following database transactions:
- write banner impression data
- get date of the last successful processing
- determine if the banner keyword for a given banner name has already been fetched
Implementation Notes
- The date of the last successful processing can be retrieved by MAX( date ).
- Date needs to be converted to the right time zone.
- The legacy tables will stay for now, prefix the table names with a sensible prefix that will be removed later
- Create a migration for creating the new tables
- It's up to you if you want to create a full Doctrine ORM mapping or use SQL and the database connection directly