Hi, When generating models your create.pl script uses internally DBIx::Class::Schema::Loader and you can pass to it most of the options that you can pass to DBIx::Class::Schema::Loader's dbicdump utility. You will probably need to use 'db_schema', which lets you specify the schema for which to generate table classes. You may also look into 'qualify_objects', which prepends the value of 'db_schema' to table names and relationships (this may be useful if you are working with multiple schemas simultaneously). All of the above options are documented in the docs for DBIx::Class::Schema::Loader::Base.
Regards, ----- Original Message ---- > From: Hetényi Csaba <[email protected]> > To: The elegant MVC web framework <[email protected]> > Sent: Wed, 20 October, 2010 17:22:15 > Subject: [Catalyst] Postgresql database with non default -public- schema > > Dear All > > Please forgive me, may i must ask this question on DBIX maillist. > > I'd like to use "script/???_create.pl" helper script to create > model from a PostgreSql database. > But my tables are not in the default Postgre tablespace (public). > > Is this helper script capable to automatically create model for > the non-default tablespace? > > If i run the script the standard way: > > script/pcm_create.pl model DB DBIC::Schema Pcm::Schema create=static >components=TimeStamp,EncodedColumn 'dbi:Pg:dbname=pcmv2;host=xxx.xx' >'pcmuser' >'xxx' '{ AutoCommit => 1 }' > > the script dumps schema without errors: > > ... > Dumping manual schema for Pcm::Schema to directory >/home/csabi/Dev/Pcm/script/../lib ... > Schema dump completed. > created "/home/csabi/Dev/Pcm/script/../lib/Pcm/Model/DB.pm" > created "/home/csabi/Dev/Pcm/script/../t/model_DB.t" > > But when starting the application it says: > > ******************************* WARNING >*************************************** > * No sources found (did you forget to define your tables?) > >* > * > >* > * To turn off this warning, set the CMDS_NO_SOURCES environment variable. > >* > ******************************************************************************* > > which is correct, because there is no tables in the default "public" pg >schema. > My tables are in the manually created "pcmbiz" schema. > > Thank You in advance! > > -- Hetényi Csaba > > > > _______________________________________________ > 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/ > _______________________________________________ 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/
