| MIME-Version: | 1.0 |
| X-Spam-Status: | No, score=-3.843 tagged_above=-99.9 required=10 tests=[AWL=0.367, BAYES_00=-1.9, RCVD_IN_DNSWL_MED=-2.3, T_RP_MATCHES_RCVD=-0.01] autolearn=ham |
| Content-Disposition: | inline |
| X-Spam-Flag: | NO |
| content-type: | text/plain; charset="utf-8" |
| Message-ID: | <20150720150454.GB16819 [...] sanger.ac.uk> |
| X-Virus-Scanned: | Debian amavisd-new at bestpractical.com |
| X-Spam-Score: | -3.843 |
| Received: | from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 4B941240516 for <cpan-bug+DBIx-Class [...] hipster.bestpractical.com>; Mon, 20 Jul 2015 11:05:15 -0400 (EDT) |
| Received: | from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id W+Ib-MyNPGfX for <cpan-bug+DBIx-Class [...] hipster.bestpractical.com>; Mon, 20 Jul 2015 11:05:14 -0400 (EDT) |
| Received: | from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id AE1B12403C1 for <bug-DBIx-Class [...] rt.cpan.org>; Mon, 20 Jul 2015 11:05:13 -0400 (EDT) |
| Received: | (qmail 20154 invoked by alias); 20 Jul 2015 15:05:12 -0000 |
| Received: | from smtp.sanger.ac.uk (HELO smtp.sanger.ac.uk) (193.62.202.243) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Mon, 20 Jul 2015 08:05:02 -0700 |
| Received: | from cgp-login.internal.sanger.ac.uk ([172.17.97.155]) by intmail3a.internal.sanger.ac.uk with esmtps (TLSv1:AES256-SHA:256) (Exim 4.80.1) (envelope-from <mca [...] sanger.ac.uk>) id 1ZHCcg-0009v8-Us for bug-DBIx-Class [...] rt.cpan.org; Mon, 20 Jul 2015 16:04:55 +0100 |
| Received: | from mca by cgp-login.internal.sanger.ac.uk with local (Exim 4.69) (envelope-from <mca [...] sanger.ac.uk>) id 1ZHCcg-0002pI-JK for bug-DBIx-Class [...] rt.cpan.org; Mon, 20 Jul 2015 16:04:54 +0100 |
| Delivered-To: | cpan-bug+DBIx-Class [...] hipster.bestpractical.com |
| User-Agent: | Mutt/1.5.18 (2008-05-17) |
| Subject: | Suggest FAQ addition: valid data_types, specifically enum |
| Return-Path: | <mca [...] sanger.ac.uk> |
| X-RT-Mail-Extension: | dbix-class |
| X-Original-To: | cpan-bug+DBIx-Class [...] hipster.bestpractical.com |
| X-Spam-Check-BY: | la.mx.develooper.com |
| Date: | Mon, 20 Jul 2015 16:04:54 +0100 |
| X-Spam-Level: | |
| X-Message-Source: | cgp-login.internal.sanger.ac.uk |
| To: | bug-DBIx-Class [...] rt.cpan.org |
| From: | Matthew Astley <mca [...] sanger.ac.uk> |
| X-RT-Original-Encoding: | ascii |
| X-RT-Interface: | |
| Content-Length: | 872 |
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.