Sponsored Content
Full Discussion: creating a schema
Top Forums UNIX for Dummies Questions & Answers creating a schema Post 302263528 by reborg on Monday 1st of December 2008 09:01:14 PM
Old 12-01-2008
We do not allow classwork posting here.

However without giving a direct answer you should be able to get an answer by perusing the correct syntax for the if/elif/else control statement in the man page for your shell.
 

7 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script for checking schema satistics in Oracle

I have a script which gives the output of schemas in Oracle DB : #!/bin/ksh ps -ef | grep -v grep | grep ora_pmon_$1 | wc -l | while read CONTROL do if ; then ORACLE_HOME=/u01/app/oracle/product/9.2.0 export ORACLE_HOME PATH=$ORACLE_HOME/bin:$PATH:/bin:/usr/bin:usr/local/bin:. ... (0 Replies)
Discussion started by: run_time_error
0 Replies

2. Shell Programming and Scripting

find a column in a schema

Hi, I need my script to accept a column name and give all the tables and its schema. Any kind of help is appreciated... Thanks in advance... (2 Replies)
Discussion started by: bankimmehta
2 Replies

3. UNIX and Linux Applications

Toad for Oracle 11G - schema browser not working

Need a help Schema browser in Toad not listing the tables when i connected to Oracle 11g schema did any body faced the issue... ? How to resolve the issue (0 Replies)
Discussion started by: girija
0 Replies

4. Emergency UNIX and Linux Support

Toad for Oracle 11G Schema browser

Need a help ..Schema browser in Toad not listing the tables when i connected to Oracle 11g schema did any body faced the issue... ? How to resolve the issue.. I need it asap thats y posted here Thanks (5 Replies)
Discussion started by: girija
5 Replies

5. Cybersecurity

LDAP rfc2307bis.schema or nis.schema?

Hi guys, we are implementing new ldap in our organization exclusively for Linux authentication purposes. As we are new to the subject, I would appreciate help regarding which schema to use to create group of users and accounts / passwords entries? I see both schemas listed in subject above... (0 Replies)
Discussion started by: Lastminute
0 Replies

6. Shell Programming and Scripting

Parallel export of all oracle DB schema.

In my Oracle db there are 4 schemas. All the username & passwords are stored in a text file. I am using a while loop to export all the schemas. It read the first line and doing the export. For all users it export one by one. But I need all the schemas will exported simultaneously. i.e. all the... (1 Reply)
Discussion started by: priya001
1 Replies

7. UNIX for Dummies Questions & Answers

How can I import a particular schema from full dump in Oracle?

Hi All, I have a full oracle dump file that I have exported from a production server. I want to import a specific schema out of the full dump. Is that possible in oracle. What will be the command for that? (6 Replies)
Discussion started by: Palak Sharma
6 Replies
DBICx::TestDatabase(3pm)				User Contributed Perl Documentation				  DBICx::TestDatabase(3pm)

NAME
DBICx::TestDatabase - create a temporary database from a DBIx::Class::Schema SYNOPSIS
Given a DBIx::Class::Schema at "MyApp::Schema", create a test database like this: use DBICx::TestDatabase; my $schema = DBICx::TestDatabase->new('MyApp::Schema'); Then you can use $schema normally: $schema->resultset('Blah')->create({ blah => '123' }); When your program exits, the temporary database will go away. DESCRIPTION
This module creates a temporary SQLite database, deploys your DBIC schema, and then connects to it. This lets you easily test your DBIC schema. Since you have a fresh database for every test, you don't have to worry about cleaning up after your tests, ordering of tests affecting failure, etc. METHODS
new($schema) Loads $schema and returns a connection to it. connect Alias for new. ENVIRONMENT
You can control the behavior of this module at runtime by setting environment variables. DBIC_KEEP_TEST If this variable is true, then the test database will not be deleted at "END" time. Instead, a message containing the paths of the test databases will be printed. This is good if you want to look at the database your test generated, for debugging. (Note that the database will never exist on disk if you don't set this to a true value.) AUTHOR
Jonathan Rockway "<jrockway@cpan.org>" LICENSE
Copyright (c) 2007 Jonathan Rockway. This program is free software. You may use, modify, and redistribute it under the same terms as Perl itself. perl v5.10.1 2010-12-15 DBICx::TestDatabase(3pm)
All times are GMT -4. The time now is 05:19 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy