R
R
Hi All,
I know this is a little bit OT
Suppose I have 2 tables customers and products, customer can buy many
products, product can be bought by many customers - typical n:m
relationship so 3rd table is a must: i.e. purchases
So I need 3 DAO: ProductDAO, CustomerDAO and PurchaseDAO.
How do you deal with i.e. reports - table joins, left joins or
statistics (group by, max, min etc)?
do you create DAOs for that? (especially table joins - probably not)
raports and statistics from i.e. 7 tables can be only read-only, so
insert, update, delete methods
are inadequate.
thanks in advance for shedding some light on this
best regards
R
I know this is a little bit OT
Suppose I have 2 tables customers and products, customer can buy many
products, product can be bought by many customers - typical n:m
relationship so 3rd table is a must: i.e. purchases
So I need 3 DAO: ProductDAO, CustomerDAO and PurchaseDAO.
How do you deal with i.e. reports - table joins, left joins or
statistics (group by, max, min etc)?
do you create DAOs for that? (especially table joins - probably not)
raports and statistics from i.e. 7 tables can be only read-only, so
insert, update, delete methods
are inadequate.
thanks in advance for shedding some light on this
best regards
R