Страницы справочника OS X

Эта страница руководства для  версии 10.9 Mac OS X

Читать страницы руководства

SQL::Abstract::Tree(3)               User Contributed Perl Documentation              SQL::Abstract::Tree(3)



NAME
       SQL::Abstract::Tree - Represent SQL as an AST

SYNOPSIS
        my $sqla_tree = SQL::Abstract::Tree->new({ profile => 'console' });

        print $sqla_tree->format('SELECT * FROM foo WHERE foo.a > 2');

        # SELECT *
        #   FROM foo
        #   WHERE foo.a > 2

METHODS
   new
        my $sqla_tree = SQL::Abstract::Tree->new({ profile => 'console' });

        $args = {
          profile => 'console',      # predefined profile to use (default: 'none')
          fill_in_placeholders => 1, # true for placeholder population
          placeholder_surround =>    # The strings that will be wrapped around
                     [GREEN, RESET], # populated placeholders if the above is set
          indent_string => ' ',      # the string used when indenting
          indent_amount => 2,        # how many of above string to use for a single
                                     # indent level
          newline       => "\n",     # string for newline
          colormap      => {
            select => [RED, RESET], # a pair of strings defining what to surround
                                    # the keyword with for colorization
            # ...
          },
          indentmap     => {
            select        => 0,     # A zero means that the keyword will start on
                                    # a new line
            from          => 1,     # Any other positive integer means that after
            on            => 2,     # said newline it will get that many indents
            # ...
          },
        }

       Returns a new SQL::Abstract::Tree object.  All arguments are optional.

       profiles

       There are four predefined profiles, "none", "console", "console_monochrome", and "html".  Typically a
       user will probably just use "console" or "console_monochrome", but if something about a profile
       bothers you, merely use the profile and override the parts that you don't like.

   format
        $sqlat->format('SELECT * FROM bar WHERE x = ?', [1])

       Takes $sql and "\@bindargs".

       Returns a formatting string based on the string passed in

   parse
        $sqlat->parse('SELECT * FROM bar WHERE x = ?')

       Returns a "tree" representing passed in SQL.  Please do not depend on the structure of the returned
       tree.  It may be stable at some point, but not yet.

   unparse
        $sqlat->parse($tree_structure, \@bindargs)

       Transform "tree" into SQL, applying various transforms on the way.

   format_keyword
        $sqlat->format_keyword('SELECT')

       Currently this just takes a keyword and puts the "colormap" stuff around it.  Later on it may do more
       and allow for coderef based transforms.

   pad_keyword
        my ($before, $after) = @{$sqlat->pad_keyword('SELECT')};

       Returns whitespace to be inserted around a keyword.

   fill_in_placeholder
        my $value = $sqlat->fill_in_placeholder(\@bindargs)

       Removes last arg from passed arrayref and returns it, surrounded with the values in
       placeholder_surround, and then surrounded with single quotes.

   indent
       Returns as many indent strings as indent amounts times the first argument.

ACCESSORS
   colormap
       See "new"

   fill_in_placeholders
       See "new"

   indent_amount
       See "new"

   indent_string
       See "new"

   indentmap
       See "new"

   newline
       See "new"

   placeholder_surround
       See "new"



perl v5.12.5                                     2010-12-21                           SQL::Abstract::Tree(3)