Can anyone please help....
how can I dump just a single file to tape using the ufsrestore command!!! I'm a newbie to unix and It's driving me mad..
Thanks in advance. (2 Replies)
How would i go about dumping my /home/ directory and my /root directory
i currently have.....
dump -f /root/backup.dp /home/ /root/
...but dump only seems to see only my first source directory and not the second (/root in this case)
anyone know a way around this..or if it is even... (1 Reply)
hi,
I wanted to know from anyone out there a way to perform a checksum command on a Microsoft FTP Server for a file and compare this with the checksum of the file that was transferred from a Unix machine.
Thanks,
Erick (0 Replies)
hi,
I wanted to know from anyone out there a way to perform a checksum command on a Microsoft FTP Server for a file and compare this with the checksum of the file that was transferred from a Unix machine.
Thanks,
Erick (1 Reply)
Hi,
My Solaris Workstation has got 4 NICS, out of which one of them(bge3) is unplugged from the rest of the external network & connected to other interface(bge1). The isolated NIC serves as a simulated Ethernet Interface for my application under development.
Now, I'd like to capture RAW... (1 Reply)
Hello ,
When using vim, can ctag and cscope support recording search results and displaying the history results ? Once I jump to one tag, I can use :tnext to jump to next tag, but how can I display the preview search result? (0 Replies)
Hello ppl,
I'm working on a windows program simulating an existing Unix program,
the program is a firmware downloader, it sends a binary firmware file through the serial port (rs232) to a Set-Top Box running under unix system too, as i'm a poor unix user and not a unix programmer i choosed the... (10 Replies)
Hi,
When I use scp to copy a file from other location, I get the output like filename, time taken etc on console. I want to store that into a database table (in oracle).
Could someone give me some pointers on how to achieve this?
Regards,
Sachin Vaidya (1 Reply)
Discussion started by: notthatsachin
1 Replies
LEARN ABOUT OSX
sql::abstract::tree
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 => "
", # 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->unparse($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.16.2 2012-06-14 SQL::Abstract::Tree(3)