Module structure - Database > Array > Tpl - How to?

[xgarb]

Working on my first module to show the category path for all categories a product can be found in.

I've read the docs and looked at the customer reviews module for inspiration.

I'm a bit stuck on the structure for this.

I guess as I'm targeting a hook on an existing page I don't use a controller?

I should use a separate file in the module root for my database query and refer to this in the main module file?

I need to create an array and pass this to the template which will loop through the values?

I just need some pointers on what code would end up where. I've used similar MVC with Smarty before but I'm not sure where things should be in Prestashop.

Thanks,
xgarb

Edited October 31, 2021 by xgarb (see edit history)