For an application I'm working on, I have two classes which represent a 'user' one controls all the db functionality, and the other provides access to the 'current user' attributes, or is a blank slate to create a new user. Simply the classic mapper pattern.
Now...I have an interface which needs to provide a select menu of all the 'users', based on their user 'rank'. This is a simple select query to gather a list of users, but my problem is that I have no idea where to put the method.
It doesn't really fit into either of the classes, because they represent one user, but the select statement deals with the same db tables, and it seems a little crazy to create another class for this method.
Now...I have an interface which needs to provide a select menu of all the 'users', based on their user 'rank'. This is a simple select query to gather a list of users, but my problem is that I have no idea where to put the method.
It doesn't really fit into either of the classes, because they represent one user, but the select statement deals with the same db tables, and it seems a little crazy to create another class for this method.