GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  SQL::TRANSLATOR::FILTER::NAMES (3)

.ds Aq ’

NAME

SQL::Translator::Filter::Names - Tweak the names of schema objects.

CONTENTS

SYNOPSIS



  #! /usr/bin/perl -w
  use SQL::Translator;

  # Lowercase all table names and upper case the first letter of all field
  # names. (MySql style!)
  #
  my $sqlt = SQL::Translator->new(
      filename => \@ARGV,
      from     => MySQL,
      to       => MySQL,
      filters => [
        Names => {
            tables => lc,
            fields => ucfirst,
        },
      ],
  ) || die "SQLFairy error : ".SQL::Translator->error;
  print($sqlt->translate) || die "SQLFairy error : ".$sqlt->error;



DESCRIPTION

SEE ALSO

perl(1), SQL::Translator

BUGS

TODO

Name Groups Define a bunch of useful groups to run the name filters over. e.g. all, fkeys, pkeys etc.
More Functions e.g. camelcase, titlecase, single word etc. Also a way to pass in a regexp.

May also want a way to pass in arguments for the func e.g. prefix.

Multiple Filters on the same name (filter order)? Do we actually need this, you could just run lots of filters. Would make adding func args to the interface easier.



    filters => [
        [ Names, { all => lc } ],
        [ Names, {
            tables => lc,
            fields => ucfirst,
        } ],
    ],



Mind you if you could give the filter a list this wouldn’t be a problem!



    filters => [
        [ Names,
            all    => lc
            fields => ucfirst,
        ],
    ],



Which is nice. Might have to change the calling conventions for filters. Would also provide an order to run the filters in rather than having to hard code it into the filter it’s self.

AUTHOR

Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 SQL::TRANSLATOR::FILTER::NAMES (3) 2013-06-28

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.