Subject: | Suggest FAQ addition: valid data_types, specifically enum |
Date: | Mon, 20 Jul 2015 16:04:54 +0100 |
To: | bug-DBIx-Class [...] rt.cpan.org |
From: | Matthew Astley <mca [...] sanger.ac.uk> |
Hi maintainers of marvellous tool,
Could the FAQ include some pointers to finding out the valid
$source->add_columns(foo => { data_types => ??? })
please?
I realise it is a complex one because it depends on the Storage, but
it would save time if there were answers for the common backends,
plus how to find out for the others.
Specifically I was looking for how to set up an enum field. I found
this works (for Oracle and PostgreSQL anyway),
stype => { data_type => 'enum', extra => { list => [ @STYPE ] }, ... }
Hoping this helps the next person / me in a few years when I forget
again,
--
Matthew
--
The Wellcome Trust Sanger Institute is operated by Genome Research
Limited, a charity registered in England with number 1021457 and a
company registered in England with number 2742969, whose registered
office is 215 Euston Road, London, NW1 2BE.