Skip Menu |

This queue is for tickets about the DBIx-Class CPAN distribution.

Report information
The Basics
Id: 105979
Status: new
Priority: 0/
Queue: DBIx-Class

People
Owner: Nobody in particular
Requestors: mca [...] sanger.ac.uk
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



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.