1 package SL::DB::Helper::Mappings;
7 our @ISA = qw(Exporter);
8 our @EXPORT_OK = qw(get_table_for_package get_package_for_table get_package_names);
10 # these will not be managed as Rose::DB models, because they are not normalized,
11 # significant changes are needed to get them done, or they were done by CRM.
12 my @lxoffice_blacklist_permanent = qw(
16 # these are not managed _yet_, but will hopefully at some point.
17 # if you are confident that one of these works, remove it here.
18 my @lxoffice_blacklist_temp = qw(
21 my @lxoffice_blacklist = (@lxoffice_blacklist_permanent, @lxoffice_blacklist_temp);
23 # map table names to their models.
24 # unlike rails we have no singular<->plural magic.
25 # remeber: tables should be named as the plural of the model name.
26 my %lxoffice_package_names = (
27 acc_trans => 'acc_transaction',
28 audittrail => 'audit_trail',
30 ap => 'purchase_invoice',
31 background_jobs => 'background_job',
32 background_job_histories => 'background_job_history',
33 ap => 'purchase_invoice',
34 bank_accounts => 'bank_account',
35 buchungsgruppen => 'buchungsgruppe',
36 contacts => 'contact',
37 custom_variable_configs => 'custom_variable_config',
38 custom_variables => 'custom_variable',
39 custom_variables_validity => 'custom_variable_validity',
40 customertax => 'customer_tax',
42 defaults => 'default',
43 delivery_orders => 'delivery_order',
44 delivery_order_items => 'delivery_order_item',
45 department => 'department',
46 dpt_trans => 'dpt_trans',
49 dunning_config => 'dunning_config',
50 employee => 'employee',
51 exchangerate => 'exchangerate',
52 finanzamt => 'finanzamt',
53 follow_up_access => 'follow_up_access',
54 follow_up_links => 'follow_up_link',
55 follow_ups => 'follow_up',
56 generic_translations => 'generic_translation',
58 gl => 'GLTransaction',
59 history_erp => 'history',
60 inventory => 'inventory',
61 invoice => 'invoice_item',
62 language => 'language',
64 licenseinvoice => 'license_invoice',
65 makemodel => 'make_model',
67 orderitems => 'order_item',
70 partsgroup => 'parts_group',
71 partstax => 'parts_tax',
72 payment_terms => 'payment_term',
73 periodic_invoices => 'periodic_invoice',
74 periodic_invoices_configs => 'periodic_invoices_config',
76 price_factors => 'price_factor',
77 pricegroup => 'pricegroup',
78 printers => 'Printer',
79 record_links => 'record_link',
81 rmaitems => 'RMA_item',
82 sepa_export => 'sepa_export',
83 sepa_export_items => 'sepa_export_item',
84 schema_info => 'schema_info',
88 tax_zones => 'tax_zone',
89 todo_user_config => 'todo_user_config',
90 translation => 'translation',
91 translation_payment_terms => 'translation_payment_term',
93 units_language => 'units_language',
94 vendortax => 'vendor_tax',
97 my (%lxoffice_tables_to_packages, %lxoffice_tables_to_manager_packages, %lxoffice_packages_to_tables);
100 return LXOFFICE => \@lxoffice_blacklist;
103 sub get_package_names {
104 return LXOFFICE => \%lxoffice_package_names;
107 sub get_package_for_table {
108 %lxoffice_tables_to_packages = map { ($_ => "SL::DB::" . camelify($lxoffice_package_names{$_})) } keys %lxoffice_package_names
109 unless %lxoffice_tables_to_packages;
111 return $lxoffice_tables_to_packages{ $_[0] };
114 sub get_manager_package_for_table {
115 %lxoffice_tables_to_manager_packages = map { ($_ => "SL::DB::Manager::" . camelify($lxoffice_package_names{$_})) } keys %lxoffice_package_names
116 unless %lxoffice_tables_to_manager_packages;
118 return $lxoffice_tables_to_manager_packages{ $_[0] };
121 sub get_table_for_package {
122 get_package_for_table('dummy') if !%lxoffice_tables_to_packages;
123 %lxoffice_packages_to_tables = reverse %lxoffice_tables_to_packages unless %lxoffice_packages_to_tables;
125 my $package = $_[0] =~ m/^SL::DB::/ ? $_[0] : "SL::DB::" . $_[0];
126 return $lxoffice_packages_to_tables{ $package };
131 my $lookup = $lxoffice_package_names{$_[0]} ||
132 plurify($lxoffice_package_names{singlify($_[0])});
134 for my $thing ($string, $lookup) {
136 # best guess? its already the name. like part. camelize it first
137 my $class = "SL::DB::" . camelify($thing);
138 return $class if defined *{ $class. '::' };
140 # next, someone wants a manager and pluralized.
141 my $manager = "SL::DB::Manager::" . singlify(camelify($thing));
142 return $manager if defined *{ $manager . '::' };
145 die "Can't resolve '$string' as a database model, sorry. Did you perhaps forgot to load it?";
150 $str =~ s/_+(.)/uc($1)/ge;
156 $str =~ s/(?<!^)\u(.)/'_' . lc($1)/ge;
180 SL::DB::Helper::Mappings - Rose Table <-> Model mapping information
184 use SL::DB::Helper::Mappings qw(@blacklist %table2model);
188 This modul stores table <-> model mappings used by the
189 L<scripts/rose_auto_create_model.pl> script. If you add a new table that has
190 custom mappings, add it here.
198 A special function provided here is C<db>. Without it you'd have to write:
200 my $part = SL::DB::Part->new(id => 1234);
201 my @all_parts = SL::DB::Manager::Part->get_all;
203 with them it becomes:
205 my $part = db('part')->new(id => 123);
206 my @all_parts = db('parts')->get_all;
208 You don't have to care about add that SL::DB:: incantation anymore. Also, a
209 simple s at the end will get you the associated Manager class.
211 db is written to try to make sense of what you give it, but if all fails, it
212 will die with an error.
214 =item C<get_package_for_table $table_name>
216 Returns the package name for a table name:
218 SL::DB::Helpers::Mappings::get_package_for_table('oe')
221 =item C<get_manager_package_for_table $table_name>
223 Returns the manager package name for a table name:
225 SL::DB::Helpers::Mappings::get_manager_package_for_table('oe')
226 # SL::DB::Manager::Order
228 =item C<get_table_for_package $package_name>
230 Returns the table name for a package name:
232 SL::DB::Helpers::Mappings::get_table_for_package('SL::DB::Order')
234 SL::DB::Helpers::Mappings::get_table_for_package('Order')
245 L<scripts/rose_auto_create_model.pl>
249 Sven Schöling E<lt>s.schoeling@linet-services.deE<gt>,
250 Moritz Bunkus E<lt>m.bunkus@linet-services.deE<gt>