Good afternoon, As you know, I'm working on DBIx::Class, and I realized that the DBIx::Class schema (in Koha/Schema/) is not up-to-date with the current database structure (installer/data/mysql/kohastructure.sql) which is really used by the modules. The last update of the DBIx::Class schema was the 2013-10-14, and some changes has been done since this day. Thus, it is problematic to use DBIx::Class if some differences exist. What do you think about updating the DBIx::Class in order to link it with the current database schema and trying to find a way to update automatically the DBIx::Class schema at each change in the database structure. I joined with this email the list of the differences between the DBIx::Class schema and the current database schema. Yohann
I will take care of that DBIx schema upgrade each time I push a patch that changes the schema. Thanks for pointing this out Yohann, Regards To+ On Mon, Jul 7, 2014 at 11:10 AM, Yohann Dufour <yohann.dufour@biblibre.com> wrote:
Good afternoon,
As you know, I'm working on DBIx::Class, and I realized that the DBIx::Class schema (in Koha/Schema/) is not up-to-date with the current database structure (installer/data/mysql/kohastructure.sql) which is really used by the modules. The last update of the DBIx::Class schema was the 2013-10-14, and some changes has been done since this day.
Thus, it is problematic to use DBIx::Class if some differences exist. What do you think about updating the DBIx::Class in order to link it with the current database schema and trying to find a way to update automatically the DBIx::Class schema at each change in the database structure.
I joined with this email the list of the differences between the DBIx::Class schema and the current database schema.
Yohann
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
-- Tomás Cohen Arazi Prosecretaría de Informática Universidad Nacional de Córdoba ✆ +54 351 5353750 ext 13168 GPG: B76C 6E7C 2D80 551A C765 E225 0A27 2EA1 B2F3 C15F
Hi, On Mon, Jul 7, 2014 at 7:10 AM, Yohann Dufour <yohann.dufour@biblibre.com> wrote:
I joined with this email the list of the differences between the DBIx::Class schema and the current database schema.
I believe that the difference in the generated schema classes can be accounted for by the fact that you're using a newer version of DBIx::Class::Schema::Loader. When I was RM for 3.16, I was using DBIC::Schema::Loader version v0.07025. Yesterday Tomas and I did some checking of classes generated using v0.07039. Among other changes, the newer versions now recognize "set null" as a FK action and default to "restrict" rather than "cascade" if the action is not explicitly specified. Those are both good changes, so I recommend that we require at least version v0.07039 of DBIC::Schema::Loader. Since that module is /not/ required for production use -- it's only needed for development -- requiring a hire version should not affect packaging signficantly. Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: gmc@esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org
participants (3)
-
Galen Charlton -
Tomas Cohen Arazi -
Yohann Dufour