From 524e72e5ed46ceddc650c33dcbb759125b80ed83 Mon Sep 17 00:00:00 2001 From: "mkanat%kerio.com" <> Date: Fri, 18 Mar 2005 11:18:12 +0000 Subject: Bug 285713: Cross-DB bz_column_info and bz_index_info Patch By Max Kanat-Alexander r=Tomas.Kopal, a=justdave --- Bugzilla/DB/Schema.pm | 51 ++++++++++++++++++++++++++++++++++++++++++++++++--- 1 file changed, 48 insertions(+), 3 deletions(-) (limited to 'Bugzilla/DB') diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index b05f35d77..d246ad542 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -1167,9 +1167,9 @@ sub get_type_ddl { } #eosub--get_type_ddl #-------------------------------------------------------------------------- -sub get_column_info { +sub get_column_ddl { -=item C +=item C Description: Public method to generate a DDL segment of a "create table" SQL statement for a given table and field. @@ -1192,7 +1192,7 @@ sub get_column_info { return() unless ($fields{$column}); return %{ $fields{$column} }; -} #eosub--get_column_info +} #eosub--get_column_ddl #-------------------------------------------------------------------------- sub get_table_list { @@ -1348,7 +1348,52 @@ sub _get_create_index_ddl { } #eosub--_get_create_index_ddl #-------------------------------------------------------------------------- +sub get_column_abstract { +=item C + + Description: A column definition from the abstract internal schema. + cross-database format. + Params: $table - The name of the table + $column - The name of the column that you want + Returns: A hash reference. For the format, see the docs for + C. + Returns undef if the column or table does not exist. + +=cut + + my ($self, $table, $column) = @_; + + # Prevent a possible dereferencing of an undef hash, if the + # table doesn't exist. + if (exists $self->{abstract_schema}->{$table}) { + return $self->{abstract_schema}->{$table}{FIELDS}{$column}; + } + return undef; +} + +sub get_index_abstract { + +=item C docs for details. + Returns undef if the index does not exist. + +=cut + + my ($self, $table, $index) = @_; + + # Prevent a possible dereferencing of an undef hash, if the + # table doesn't exist. + if (exists $self->{abstract_schema}->{$table}) { + return $self->{abstract_schema}->{$table}{INDEXES}{$index}; + } + return undef; +} =head1 SERIALIZATION/DESERIALIZATION -- cgit v1.2.3-24-g4f1b