Sponsored Content
Top Forums UNIX for Dummies Questions & Answers shell/sql to get difference between two database Post 302558475 by Scott on Friday 23rd of September 2011 04:08:51 PM
Old 09-23-2011
Please edit your post to include code tags. I've just spent ten minutes trying to clean up your other thread!

Here is how:



Thanks.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Read SQL database from Unix...

Hi there, I am new here and looking for a bit of help... I don't don't know much about Unix but I've tried to include as much info as possible. We currently operate our system as a bespoke on SCO 5.05 with Informix databases. This includes a financials package called "Multisoft". Both... (0 Replies)
Discussion started by: uptheposh
0 Replies

2. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

Hi- I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment... I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Discussion started by: rajagavini
5 Replies

3. Shell Programming and Scripting

Connecting to MS SQL database from bash (using unixODBC)

I've installed unixODBC and I would like to connect to a MS SQL (2005) database from a bash script. Can you post a code example? Thank you! :D J. (0 Replies)
Discussion started by: ph0enix
0 Replies

4. Programming

SQL for flat file database

I have a B+ tree flat file database which is used by the application we use. I would like to implement a SQL kind of access for that DB. I have implemented my data structures to parse and store the user written query for execution. But i would like to know, do we have any standard data... (2 Replies)
Discussion started by: kumaran_5555
2 Replies

5. UNIX for Advanced & Expert Users

Call parallel sql scripts from shell and return status when both sql are done

Hi Experts: I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing... (3 Replies)
Discussion started by: huasheng8
3 Replies

6. Shell Programming and Scripting

How to run a SQL select query in Oracle database through shell script?

I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this? Is there a way to have a persistent connection to oracle database... (9 Replies)
Discussion started by: vel4ever
9 Replies

7. Shell Programming and Scripting

SQL in LINUX. Variable or Database

Dear Friends :-), Need your help once again. I have following SQL in a shell script to pick values from database select date_stamp, time_stamp from logs where date=31012012 However, at times we need to take these value(s) from a variable. To do this we have following query. select... (2 Replies)
Discussion started by: anushree.a
2 Replies

8. Programming

pls. help with SQL database...

On the Linux systems, we have scripts which monitor disk usage. I want to take that data and feed that into SQL database. Can you give some advise. For example here is one of the file. I have many files like this but the format is same... 2012-09-24 04:36:14 2012-09-24 04:36:16 48414984... (3 Replies)
Discussion started by: samnyc
3 Replies

9. Shell Programming and Scripting

SQL compare database

Hi , I have 2 databases which has same table names and I need to list entries of a particular table in database1 not existing in the same tablename of database2. eg : I have db1 having table name orders ad_d | code | start | end | amountscore | id | amount_class |... (1 Reply)
Discussion started by: siya@
1 Replies

10. AIX

Connect to database server and execute sql

I have a requirement and below is the detail. Create a shell script and needs to run in server "a". Connect to teradata database server "b". execute the .sql file from server "a" Save the output of the query to a file in server "a" Schedule this shell script to run every day for every 4... (1 Reply)
Discussion started by: MadhuSeven
1 Replies
Mojolicious::Routes::Route(3pm) 			User Contributed Perl Documentation			   Mojolicious::Routes::Route(3pm)

NAME
Mojolicious::Routes::Route - Route container SYNOPSIS
use Mojolicious::Routes::Route; my $r = Mojolicious::Routes::Route->new; DESCRIPTION
Mojolicious::Routes::Route is the route container used by Mojolicious::Routes. ATTRIBUTES
Mojolicious::Routes::Route implements the following attributes. "children" my $children = $r->children; $r = $r->children([Mojolicious::Routes::Route->new]); The children of this route, used for nesting routes. "inline" my $inline = $r->inline; $r = $r->inline(1); Allow "bridge" semantics for this route. "parent" my $parent = $r->parent; $r = $r->parent(Mojolicious::Routes::Route->new); The parent of this route, used for nesting routes. "partial" my $partial = $r->partial; $r = $r->partial(1); Route has no specific end, remaining characters will be captured in "path". "pattern" my $pattern = $r->pattern; $r = $r->pattern(Mojolicious::Routes::Pattern->new); Pattern for this route, defaults to a Mojolicious::Routes::Pattern object. METHODS
Mojolicious::Routes::Route inherits all methods from Mojo::Base and implements the following ones. "new" my $r = Mojolicious::Routes::Route->new; my $r = Mojolicious::Routes::Route->new('/:controller/:action'); Construct a new Mojolicious::Routes::Route object. "add_child" $r = $r->add_child(Mojolicious::Route->new); Add a new child to this route, it will be automatically removed from its current parent if necessary. # Reattach route $r->add_child($r->find('foo')); "any" my $route = $r->any('/:foo' => sub {...}); my $route = $r->any([qw(GET POST)] => '/:foo' => sub {...}); Generate route matching any of the listed HTTP request methods or all. See also the Mojolicious::Lite tutorial for more argument variations. $r->any('/user')->to('user#whatever'); "bridge" my $bridge = $r->bridge; my $bridge = $r->bridge('/:action'); my $bridge = $r->bridge('/:action', action => qr/w+/); my $bridge = $r->bridge(format => 0); Generate bridge. my $auth = $r->bridge('/user')->to('user#auth'); $auth->get('/show')->to('#show'); $auth->post('/create')->to('#create'); "delete" my $route = $r->delete('/:foo' => sub {...}); Generate route matching only "DELETE" requests. See also the Mojolicious::Lite tutorial for more argument variations. $r->delete('/user')->to('user#remove'); "detour" $r = $r->detour(action => 'foo'); $r = $r->detour({action => 'foo'}); $r = $r->detour('controller#action'); $r = $r->detour('controller#action', foo => 'bar'); $r = $r->detour('controller#action', {foo => 'bar'}); $r = $r->detour($app); $r = $r->detour($app, foo => 'bar'); $r = $r->detour($app, {foo => 'bar'}); $r = $r->detour('MyApp'); $r = $r->detour('MyApp', foo => 'bar'); $r = $r->detour('MyApp', {foo => 'bar'}); Set default parameters for this route and allow partial matching to simplify application embedding. "find" my $route = $r->find('foo'); Find child route by name, custom names have precedence over automatically generated ones. $r->find('show_user')->to(foo => 'bar'); "get" my $route = $r->get('/:foo' => sub {...}); Generate route matching only "GET" requests. See also the Mojolicious::Lite tutorial for more argument variations. $r->get('/user')->to('user#show'); "has_conditions" my $success = $r->has_conditions; Check if this route has active conditions. "has_custom_name" my $success = $r->has_custom_name; Check if this route has a custom name. "has_websocket" my $success = $r->has_websocket; Check if this route has a WebSocket ancestor. "is_endpoint" my $success = $r->is_endpoint; Check if this route qualifies as an endpoint. "is_websocket" my $success = $r->is_websocket; Check if this route is a WebSocket. "name" my $name = $r->name; $r = $r->name('foo'); The name of this route, defaults to an automatically generated name based on the route pattern. Note that the name "current" is reserved for refering to the current route. $r->get('/user')->to('user#show')->name('show_user'); "options" my $route = $r->options('/:foo' => sub {...}); Generate route matching only "OPTIONS" requests. See also the Mojolicious::Lite tutorial for more argument variations. $r->options('/user')->to('user#overview'); "over" my $over = $r->over; $r = $r->over(foo => qr/w+/); Activate conditions for this route. Note that this automatically disables the routing cache, since conditions are too complex for caching. $r->get('/foo')->over(host => qr/mojolicio.us/)->to('foo#bar'); "parse" $r = $r->parse('/:action'); $r = $r->parse('/:action', action => qr/w+/); $r = $r->parse(format => 0); Parse a pattern. "patch" my $route = $r->patch('/:foo' => sub {...}); Generate route matching only "PATCH" requests. See also the Mojolicious::Lite tutorial for more argument variations. $r->patch('/user')->to('user#update'); "post" my $route = $r->post('/:foo' => sub {...}); Generate route matching only "POST" requests. See also the Mojolicious::Lite tutorial for more argument variations. $r->post('/user')->to('user#create'); "put" my $route = $r->put('/:foo' => sub {...}); Generate route matching only "PUT" requests. See also the Mojolicious::Lite tutorial for more argument variations. $r->put('/user')->to('user#replace'); "remove" $r = $r->remove; Remove route from parent. # Remove route completely $r->find('foo')->remove; # Reattach route to new parent $r->route('/foo')->add_child($r->find('bar')->remove); "render" my $path = $r->render($suffix); my $path = $r->render($suffix, {foo => 'bar'}); Render route with parameters into a path. "root" my $root = $r->root; The Mojolicious::Routes object this route is an ancestor of. $r->root->cache(0); "route" my $route = $r->route; my $route = $r->route('/:action'); my $route = $r->route('/:action', action => qr/w+/); my $route = $r->route(format => 0); Generate route matching all HTTP request methods. "to" $r = $r->to(action => 'foo'); $r = $r->to({action => 'foo'}); $r = $r->to('controller#action'); $r = $r->to('controller#action', foo => 'bar'); $r = $r->to('controller#action', {foo => 'bar'}); $r = $r->to($app); $r = $r->to($app, foo => 'bar'); $r = $r->to($app, {foo => 'bar'}); $r = $r->to('MyApp'); $r = $r->to('MyApp', foo => 'bar'); $r = $r->to('MyApp', {foo => 'bar'}); Set default parameters for this route. "to_string" my $string = $r->to_string; Stringify the whole route. "under" my $route = $r->under(sub {...}); my $route = $r->under('/:foo'); Generate bridge. See also the Mojolicious::Lite tutorial for more argument variations. my $auth = $r->under('/user')->to('user#auth'); $auth->get('/show')->to('#show'); $auth->post('/create')->to('#create'); "via" my $methods = $r->via; $r = $r->via('GET'); $r = $r->via(qw(GET POST)); $r = $r->via([qw(GET POST)]); Restrict HTTP methods this route is allowed to handle, defaults to no restrictions. $r->route('/foo')->via(qw(GET POST))->to('foo#bar'); "websocket" my $websocket = $r->websocket('/:foo' => sub {...}); Generate route matching only "WebSocket" handshakes. See also the Mojolicious::Lite tutorial for more argument variations. $r->websocket('/echo')->to('example#echo'); SHORTCUTS
In addition to the attributes and methods above you can also call shortcuts on Mojolicious::Routes::Route objects. $r->root->add_shortcut(firefox => sub { my ($r, $path) = @_; $r->get($path, agent => qr/Firefox/); }); $r->firefox('/welcome')->to('firefox#welcome'); $r->firefox('/bye')->to('firefox#bye); SEE ALSO
Mojolicious, Mojolicious::Guides, <http://mojolicio.us>. perl v5.14.2 2012-09-05 Mojolicious::Routes::Route(3pm)
All times are GMT -4. The time now is 01:05 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy