view release on metacpan or  search on metacpan

lib/Rapi/Demo/Chinook/Model/DB.pm  view on Meta::CPAN

package Rapi::Demo::Chinook::Model::DB;

use strict;
use warnings;

use Moo;
extends 'Catalyst::Model::DBIC::Schema';

__PACKAGE__->config(
    schema_class => 'Rapi::Demo::Chinook::DB',
    
    connect_info => {
        dsn => 'dbi:SQLite:chinook.db', #<-- Note: this gets changed in Rapi::Demo::Chinook
        user => '',
        password => '',
        sqlite_unicode => q{1},
        on_connect_call => q{use_foreign_keys},
        quote_names => q{1},
    },
    
    # Configs copied from the RA::ChinookDemo (http://www.rapidapp.info/demos/chinook)
    RapidDbic => {
      hide_fk_columns => 1,
      grid_params => {
         '*defaults' => { # Defaults for all Sources
            updatable_colspec => ['*'],
            creatable_colspec => ['*'],
            destroyable_relspec => ['*']
         }, # ('*defaults')
         Album => {
            include_colspec => ['*','artistid.name'] 
         },
         Genre => {
            # Leave persist_immediately on without the add form
            # (inserts blank/default rows immediately):
            use_add_form => 0,
            # No delete confirmations:
            confirm_on_destroy => 0
         },
         Invoice => {
            # Delete invoice_lines with invoice (cascade):
            destroyable_relspec => ['*','invoice_lines']
         },
         InvoiceLine => {
            # join all columns of all relationships (first-level):
            include_colspec => ['*','*.*'],
            updatable_colspec => [
               'invoiceid','unitprice',
               'invoiceid.billing*'
            ],
         },
         MediaType => {
            # Use the grid itself to set new row values:
            use_add_form => 0, #<-- also disables autoload_added_record
            persist_immediately => {
               create  => 0,
               update  => 1,
               destroy => 1
            },
            # No delete confirmations:
            confirm_on_destroy => 0
         },
         Track => {
            include_colspec => ['*','albumid.artistid.*'],
            # Don't persist anything immediately:
            persist_immediately => {
               # 'create => 0' changes these defaults:
               #   use_add_form => '0' (normally 'tab')
               #   autoload_added_record => 0 (normally '1')
               create  => 0,
               update  => 0,
               destroy => 0
            },
            # Use the add form in a window:
            use_add_form => 'window'
         },
      }, # (grid_params)
      TableSpecs => {
         Album => {
            display_column => 'title'
         },
         Artist => {
            display_column => 'name'
         },
         Employee => {
            # Use virtual column 'full_name' as the display column:
            display_column => 'full_name'
         },
         Genre => {
            display_column => 'name',
            auto_editor_type => 'combo'
         },
         MediaType => {
            display_column => 'name',
            auto_editor_type => 'combo'
         },
         Track => {
            columns => {
               bytes => {
                  renderer => 'Ext.util.Format.fileSize'
               },