Class BackofficeMoodAdminDao

java.lang.Object

com.serinity.moodcontrol.dao.backoffice.BackofficeMoodAdminDao

public class BackofficeMoodAdminDao
extends Object

Backend/admin DAO: reads/deletes mood entries across ALL users. Cross-references access-control via profiles (LEFT JOIN). No FK constraints assumed -> deletes join rows manually.

Constructor Summary

Constructors

Constructor	Description
BackofficeMoodAdminDao()

Method Summary

Modifier and Type	Method	Description
boolean	delete(long moodEntryId)	Admin delete: delete join rows first, then mood entry.
List<BackofficeMoodRow>	findAll(String nameLikeOrNull)

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

BackofficeMoodAdminDao

public BackofficeMoodAdminDao()

Method Details

findAll

public List<BackofficeMoodRow> findAll(String nameLikeOrNull)
                                throws SQLException

Parameters:

nameLikeOrNull - null/blank => all users; otherwise filters by username/first/last LIKE

Throws:

SQLException

delete

public boolean delete(long moodEntryId)
               throws SQLException

Admin delete: delete join rows first, then mood entry. Transactional, no FKs assumed.

Throws:

SQLException