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

Owner: Nobody in particular
Requestors: mca [...]

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 [...]
From: Matthew Astley <mca [...]>
Download (untitled) / with headers
text/plain 872b
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.

This service is sponsored and maintained by Best Practical Solutions and runs on infrastructure.

Please report any issues with to