for example, a table, 2 column
Table
------------------------------------------------------------
|   lang_code |  CHAR(2)    | default: 'en'  |
------------------------------------------------------------
|   time         |  DATETIME |                   |
------------------------------------------------------------

I would like to do in SQL
" INSERT table VALUES (DEFAULT, NOW()); "

I use DBIx::Class and it seems not so easy....
When I do pupulate, I write like this..
$schema->populate(
    'Table',
    [   [ qw/lang_code
               time/
        ],
        (
           [ 
$schema->source('Table')->column_info('lang_code')->{default_value},
             '2006-04-24 12:13:23',
           ],
        )
    ],
)

Question!
is there any simple way I can write like this?
$schema->populate(
    'Table',
...............
     [ DEFAUT,
       NOW(),
     ]
......
)

thanks a lot!

Reply via email to