Re: [Dbix-class] WG: using DBIx::Class::Migration with Journal
On Sun, Apr 7, 2013 at 3:21 PM, Mario Minati mario.min...@minati.de wrote: Further investigations let my understand that DBIx::Class::Journal keeps a special journaling schema for all journaled records. ** ** I’ll try to extend DBIx::Class::Migration to handle this. I was going to suggest a separate set of schemas to handle the journal tables (say, through DBICSL), but just making DBIC:M work with :J would be the right thing to do in the long run. I'm sure jnap would appreciate the patch. -- Brendan Byrd p...@resonatorsoft.org Brendan Byrd bb...@cpan.org ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
AW: [Dbix-class] WG: using DBIx::Class::Migration with Journal
Further investigations let my understand that DBIx::Class::Journal keeps a special journaling schema for all journaled records. I'll try to extend DBIx::Class::Migration to handle this. Best greets, Mario Von: Mario Minati [mailto:mario.min...@minati.de] Gesendet: Samstag, 6. April 2013 12:46 An: DBIx::Class user and developer list Betreff: AW: [Dbix-class] WG: using DBIx::Class::Migration with Journal Hi Brendan, we have a Catalyst App with about 100 dbix result classes defined in schema. We use dbix::journal for logging and want to use some tool for managing db migrations before rolling out that app. We expected dbix::Class::migration to work out of the box with dbix::class::journal, but non of the journal classes shows off in the generated files, e.g. the 001-auto.sql So I guess this is a generic problem due to the way dbix::class::journal changes the schema when be instantiated. As Dbix::Class::Auditlog borrows code from that module I guess it might have the same problems. I guess that someone of the users here on the ML might also have such complex apps and I'd like to learn from their experiences and solutions :) Best greets, Mario Von: Brendan Byrd [mailto:p...@resonatorsoft.org] Gesendet: Samstag, 6. April 2013 04:23 An: DBIx::Class user and developer list Betreff: Re: [Dbix-class] WG: using DBIx::Class::Migration with Journal On Fri, Apr 5, 2013 at 3:58 PM, Mario Minati mario.min...@minati.demailto:mario.min...@minati.de wrote: Hello, can anyone help? Von: Mario Minati [mailto:mario.min...@minati.demailto:mario.min...@minati.de] Gesendet: Mittwoch, 3. April 2013 00:04 An: dbix-class@lists.scsys.co.ukmailto:dbix-class@lists.scsys.co.uk Betreff: [Dbix-class] using DBIx::Class::Migration with Journal Hello, I'd like to combine the usage of DBIx::Class::Migration with DBIx::Class::Journal but setting up a test environment doesn't show the tables created from Journal. Is this a general problem that both modules do not work together or can this be healed by any extra params / settings? If DBIx::Class::Journal doesn't work is there maybe any other Journaling module that can be used with DBIx::Class::Migration? There isn't a lot of information here. What commands did you try? What is your environment? Where there any error messages? If I were to take a complete SWAG, it might partially to do with Journal's subclassing with DBIx::Class, but Migration doesn't seem to do the same thing, and I'm not familiar enough with the latter. I have used DBIx::Class::AuditLog in the past, so that might be an option to try out. -- Brendan Byrd p...@resonatorsoft.orgmailto:p...@resonatorsoft.org Brendan Byrd bb...@cpan.orgmailto:bb...@cpan.org ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
AW: [Dbix-class] WG: using DBIx::Class::Migration with Journal
Hi Brendan, we have a Catalyst App with about 100 dbix result classes defined in schema. We use dbix::journal for logging and want to use some tool for managing db migrations before rolling out that app. We expected dbix::Class::migration to work out of the box with dbix::class::journal, but non of the journal classes shows off in the generated files, e.g. the 001-auto.sql So I guess this is a generic problem due to the way dbix::class::journal changes the schema when be instantiated. As Dbix::Class::Auditlog borrows code from that module I guess it might have the same problems. I guess that someone of the users here on the ML might also have such complex apps and I'd like to learn from their experiences and solutions :) Best greets, Mario Von: Brendan Byrd [mailto:p...@resonatorsoft.org] Gesendet: Samstag, 6. April 2013 04:23 An: DBIx::Class user and developer list Betreff: Re: [Dbix-class] WG: using DBIx::Class::Migration with Journal On Fri, Apr 5, 2013 at 3:58 PM, Mario Minati mario.min...@minati.demailto:mario.min...@minati.de wrote: Hello, can anyone help? Von: Mario Minati [mailto:mario.min...@minati.demailto:mario.min...@minati.de] Gesendet: Mittwoch, 3. April 2013 00:04 An: dbix-class@lists.scsys.co.ukmailto:dbix-class@lists.scsys.co.uk Betreff: [Dbix-class] using DBIx::Class::Migration with Journal Hello, I'd like to combine the usage of DBIx::Class::Migration with DBIx::Class::Journal but setting up a test environment doesn't show the tables created from Journal. Is this a general problem that both modules do not work together or can this be healed by any extra params / settings? If DBIx::Class::Journal doesn't work is there maybe any other Journaling module that can be used with DBIx::Class::Migration? There isn't a lot of information here. What commands did you try? What is your environment? Where there any error messages? If I were to take a complete SWAG, it might partially to do with Journal's subclassing with DBIx::Class, but Migration doesn't seem to do the same thing, and I'm not familiar enough with the latter. I have used DBIx::Class::AuditLog in the past, so that might be an option to try out. -- Brendan Byrd p...@resonatorsoft.orgmailto:p...@resonatorsoft.org Brendan Byrd bb...@cpan.orgmailto:bb...@cpan.org ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
[Dbix-class] WG: using DBIx::Class::Migration with Journal
Hello, can anyone help? Best greets, Mario Von: Mario Minati [mailto:mario.min...@minati.de] Gesendet: Mittwoch, 3. April 2013 00:04 An: dbix-class@lists.scsys.co.uk Betreff: [Dbix-class] using DBIx::Class::Migration with Journal Hello, I'd like to combine the usage of DBIx::Class::Migration with DBIx::Class::Journal but setting up a test environment doesn't show the tables created from Journal. Is this a general problem that both modules do not work together or can this be healed by any extra params / settings? If DBIx::Class::Journal doesn't work is there maybe any other Journaling module that can be used with DBIx::Class::Migration? Best greets, Mario Minati -- Geschäftsführer MINATI Planungsbüro für Haustechnik Dörenwaldstraße 6a D-32760 Detmold Germany Tel: +49 / 5231 / 4580-100 Fax: +49 / 5231 / 4580-118 E-Mail: mario.min...@minati.demailto:mario.min...@minati.de WWW: www.minati.dehttp://www.minati.de Ablage: WV: ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
Re: [Dbix-class] WG: using DBIx::Class::Migration with Journal
On Fri, Apr 5, 2013 at 3:58 PM, Mario Minati mario.min...@minati.de wrote: Hello, ** ** can anyone help? *Von:* Mario Minati [mailto:mario.min...@minati.de] *Gesendet:* Mittwoch, 3. April 2013 00:04 *An:* dbix-class@lists.scsys.co.uk *Betreff:* [Dbix-class] using DBIx::Class::Migration with Journal ** ** Hello, ** ** I’d like to combine the usage of DBIx::Class::Migration with DBIx::Class::Journal but setting up a test environment doesn’t show the tables created from Journal. ** ** Is this a general problem that both modules do not work together or can this be healed by any extra params / settings? ** ** If DBIx::Class::Journal doesn’t work is there maybe any other Journaling module that can be used with DBIx::Class::Migration? ** There isn't a lot of information here. What commands did you try? What is your environment? Where there any error messages? If I were to take a complete SWAG, it might partially to do with Journal's subclassing with DBIx::Class, but Migration doesn't seem to do the same thing, and I'm not familiar enough with the latter. I have used DBIx::Class::AuditLog in the past, so that might be an option to try out. -- Brendan Byrd p...@resonatorsoft.org Brendan Byrd bb...@cpan.org ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk