Sure. From here:
http://search.cpan.org/~rkitover/DBIx-Class-Schema-Loader-0.07000/lib/DBIx/Class/Schema/Loader/Base.pm#constraint
Only load tables matching regex. Best specified as a qr// regex
DBIx::Class::SAchema::Loader is the class Catalyst uses
to create the schema, and you can send parameters to it from the
Catalyst helper script.
So your helper script invocation would something similar to this:
perl
script/testapp_create.pl model
DB
DBIC::Schema DB::Schema create=static 'constraint=qr/^YOUR_TABLE$/'
'dbi:Oracle:SERVICE_NAME=test.abcd.com;host=192.168.100.107;
port=1521'
'user' 'pass'
(quotes around the "constraint" parameter to prevent shell escaping and
such).
There are a few other parameters whic I've found pretty useful, like
"qualify_objects" (prepending the schema name to all table names in the
class files). I recomend to check them all just in case you are
interested.
Regards
J.
 |
Jorge González Villalonga
Director Técnico
DAIKON Integración y
Desarrollo S.L.
Telf: (+34) 91 188 08 28
Fax: (+34) 91 632 65 42
www.daikon.es |
El 11/03/11 11:34, Rohan M escribió:
Dear All,
I believe the oracle server version is 8.1.7 and I don't have
access to that server.
I guess the reason was, I was putting SID= test.abcd.com
which was wrong.
I think Catalyst model provides "SID INSTANCE_NAME SERVER
SERVICE_NAME " as options that can be mentioned as parameters. These
are all name=value pairs that Can (?) be put for model creation.
Today , I tried with
perl
script/testapp_create.pl model
DB
DBIC::Schema DB::Schema create=static 'dbi:Oracle:SERVICE_NAME=test.abcd.com;host=192.168.100.107;
port=1521'
'user' 'pass'
And I
think this connects (?) but since the database has many many tables so
the script kind of stays still.
Can we
just create one table dynamically in order to test everything works
fine? I mean, provide single table name to the above command and test.
Thanks for
the help..
Regards,
ROhan
On Fri, Mar 11, 2011 at 1:29 PM, Jorge
Gonzalez <[email protected]>
wrote:
Have you tried to
troubleshoot the connection at the "other" side, i.e.
the Oracle server? What does the listener log say about the failed
connection, and about the successful ones from the same machine (your
Catalyst host)? How do they differ?
j.
|
_______________________________________________
List: [email protected]
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/
