mvhub-dev team mailing list archive

[noreply@xxxxxxxxxxxxx]

Merge authors:
  Priya Ravindran (priya)
Related merge proposals:
  https://code.launchpad.net/~priya/mvhub/move_sql_lib_headings/+merge/25348
  proposed by: Priya Ravindran (priya)
  review: Approve - Dan MacNeil (omacneil)
------------------------------------------------------------
revno: 385 [merge]
committer: Priya Ravindran <pthirumal@xxxxxxxxxx>
branch nick: trunk
timestamp: Tue 2010-05-18 10:50:08 -0400
message:
  MOved query from Headings.pm to sql_select.lib and merged the branch
modified:
  app-mvhub/conf/sql_select.lib
  lib-mvhub/lib/MVHub/Headings.pm


--
lp:mvhub
https://code.launchpad.net/~mvhub-commit/mvhub/trunk

Your team MVHub Developers is subscribed to branch lp:mvhub.
To unsubscribe from this branch go to https://code.launchpad.net/~mvhub-commit/mvhub/trunk/+edit-subscription

=== modified file 'app-mvhub/conf/sql_select.lib'
--- app-mvhub/conf/sql_select.lib	2010-05-03 21:01:56 +0000
+++ app-mvhub/conf/sql_select.lib	2010-05-14 17:33:15 +0000
@@ -152,7 +152,17 @@
   cats_with_visible_programs_view c 
 USING (category_id) 
 WHERE 
-  stems_name ~* ?  
+  stems_name ~* ? 
+
+[CATEGORY_HEADING_CATEGORY_X_FETCH_HEADING_CATEGORY]
+SELECT
+   h.heading_name, c.category_id, c.category_name 
+FROM 
+  category c, heading_category h 
+WHERE 
+  h.category_id = c.category_id 
+ORDER BY 
+  h.heading_name, c.category_name
 
 [CATEGORY_PROGRAM_VIEW_HEADING_CATEGORY_X_ID_NAME_COUNT]
 SELECT

=== modified file 'lib-mvhub/lib/MVHub/Headings.pm'
--- lib-mvhub/lib/MVHub/Headings.pm	2009-12-07 20:00:37 +0000
+++ lib-mvhub/lib/MVHub/Headings.pm	2010-05-14 17:31:43 +0000
@@ -77,14 +77,10 @@
 sub _fetch_heading_categories {
 
     my $dbh = MVHub::Utils::DB::get_dbh();
-
-    my $stmt
-        = "SELECT h.heading_name, c.category_id, c.category_name "
-        . "FROM category c, heading_category h "
-        . "WHERE h.category_id = c.category_id "
-        . "ORDER BY h.heading_name, c.category_name ";
-
-    my $rows_aref = $dbh->selectall_arrayref( $stmt, { Slice => {} } );
+    my $sql = MVHub::Utils::DB::get_sql_select_statement(
+        "CATEGORY_HEADING_CATEGORY_X_FETCH_HEADING_CATEGORY");
+
+    my $rows_aref = $dbh->selectall_arrayref( $sql, { Slice => {} } );
 
     my %heading_categories;
     foreach my $row_href (@$rows_aref) {