Re: [Catalyst] Getting DBIC schema from outside Catalyst?
Thank you! This is very simple and enormously helpful. Jen From: Eden Cardim <edencar...@gmail.com> To: The elegant MVC web framework <catalyst@lists.scsys.co.uk> Sent: Thursday, March 9, 2017 7:16 AM Subject: Re: [Catalyst] Getting DBIC schema from outside Catalyst? If you want to reuse the configuration from MyApp: use MyApp; my $schema = MyApp->model('DBICModelName')->schema; You may need to adjust @INC accordingly, etc. ___ List: Catalyst@lists.scsys.co.uk Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/ Dev site: http://dev.catalyst.perl.org/ ___ List: Catalyst@lists.scsys.co.uk Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/ Dev site: http://dev.catalyst.perl.org/
Re: [Catalyst] Getting DBIC schema from outside Catalyst?
On Wed, Mar 8, 2017 at 6:15 PM, Robert Brownwrote: > Hi Jen, > > You can use MyApp::Schema outside of Catalyst: > > my $schema = MyApp::Schema->connect( $ENV{ LIVE } ? 'live' : 'dev' ); > > (I'm additionally using DBIx::Class::Schema::Config to be able to connect > to different servers by using different config files) > > $schema->resultset('Instance')->search_rs(), etc. > > If you want to reuse the configuration from MyApp: use MyApp; my $schema = MyApp->model('DBICModelName')->schema; You may need to adjust @INC accordingly, etc. ___ List: Catalyst@lists.scsys.co.uk Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/ Dev site: http://dev.catalyst.perl.org/
Re: [Catalyst] Getting DBIC schema from outside Catalyst?
Hi Jen, You can use MyApp::Schema outside of Catalyst: my $schema = MyApp::Schema->connect( $ENV{ LIVE } ? 'live' : 'dev' ); (I'm additionally using DBIx::Class::Schema::Config to be able to connect to different servers by using different config files) $schema->resultset('Instance')->search_rs(), etc. Hope this helps, Rob On 08/03/17 21:06, Dr. Jennifer Nussbaum wrote: Hi, I hope Im asking this correctly. I have a full-blown Catalyst application that connects to many DBIC schemas with information stored in the conf file, as per usual C::M::DBIC::Schema practices, and I access them with again the usual practices, $c->model('Foo')->search() etc. I need to get these schemas from outside the Cat application, e.g. to run cron scripts, etc. I was going to write a utility method to parse the config file, connect to the database, etc., but I was wondering that if C::M::DBIC::Schema already does this, is there a way I can access this from _outside_ of my Catalyst app, i.e. something I can call to return this from a script? Thanks. Jen ___ List: Catalyst@lists.scsys.co.uk Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/ Dev site: http://dev.catalyst.perl.org/ ___ List: Catalyst@lists.scsys.co.uk Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/ Dev site: http://dev.catalyst.perl.org/