Re: Database MySQL Perl

[shmem]

1. What value is stored in @intervals

Since @intervals denotes an array, most likely it holds a list of values - only one would just be a special case. The array holds what is returned from the search method of the object provided by resultset.

If in doubt, have a look:

{
    my $c;
    for my $thingy (@intervals) {
        printf "%2d. '%s'\n",++$c, $thingy;
    }
}

2. How is it possible to have 'Aggregation' in code and 'aggregation' table in database

It's possible with some piece of software which does the connection between 'Aggregation' and 'aggregation', probably by upper-/lowercasing the identifier.

3. What does 'undef' signify here.

It means just what undef means anywhere else: a placeholder for nothing, which is just about the same as the NULL value in a database cell.

Have a look at the documentation of DBIx::Class and DBIx::Class::ResultSet.

[akagrawal3]

Thank you very much :)