[Dbix-class] Creating 'query' objects

[Will Hawes]

Gert Burger wrote:
> Hi
> 
> I'm very new to DBIx::Class and I am very conduffled atm.
> I would like to create a Class based on dbixc that would always give me
> access to a query which is similiar to "select col from table group by
> col" in mysql.
> 
> This may seem odd, but I need to access a database from another program
> which tags row's based on events, but it doesnt not have a table with
> all the events. So I have to discover the events using a group or
> distinct.
> 
> Thanks in advance.
> Gert Burger
> 

Sounds like "Grouping results" at 
http://dev.catalyst.perl.org/trac/bast/browser/branches/DBIx-Class-resultset/lib/DBIx/Class/Manual/Cookbook.pod 
is what you need.

The above example uses the newer (and recommended) schema-based approach 
- if you need an intro to that, please read the following too:

http://dev.catalyst.perl.org/trac/bast/browser/branches/DBIx-Class-resultset/lib/DBIx/Class/Manual/SchemaIntro.pod