mvhub-dev team mailing list archive

[noreply@xxxxxxxxxxxxx]

Merge authors:
  Dan MacNeil (omacneil)
Related merge proposals:
  https://code.launchpad.net/~omacneil/mvhub/fix_passwd_test/+merge/29233
  proposed by: Dan MacNeil (omacneil)
  review: Approve - Dan MacNeil (omacneil)
------------------------------------------------------------
revno: 446 [merge]
committer: Dan MacNeil <dan@xxxxxxxxxxxx>
branch nick: trunk
timestamp: Fri 2010-07-09 18:10:18 -0400
message:
   merged lp:~omacneil/mvhub/fix_passwd_test
modified:
  app-mvhub/conf/sql_select.lib
  app-mvhub/t/mech/user/login_with_good_password.t
  app-mvhub/t/sql_lib_sanity.t


--
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-07-09 18:49:34 +0000
+++ app-mvhub/conf/sql_select.lib	2010-07-09 22:10:18 +0000
@@ -372,6 +372,11 @@
 FROM agency 
 WHERE agency_id = ?
 
+[AGENCY_X_PASSWORD]
+SELECT password
+FROM agency
+WHERE agency_id= ?
+
 [AGENCY_X_PROGRAM_NAME_AGENCY_NAME_DATE_CREATED]
 SELECT p.program_name, a.agency_name, p.date_created
 FROM agency a, program p 

=== modified file 'app-mvhub/t/mech/user/login_with_good_password.t'
--- app-mvhub/t/mech/user/login_with_good_password.t	2010-07-04 18:04:25 +0000
+++ app-mvhub/t/mech/user/login_with_good_password.t	2010-07-09 22:10:18 +0000
@@ -4,11 +4,15 @@
 use strict;
 use warnings;
 
+use Params::Validate;
+
 use Test::More;
 use Test::WWW::Mechanize;
 
 use TestHelper;
 
+use MVHub::Utils::DB;
+
 {    #main
     TestHelper::run_submit_forms_ok(
         get_forms_sub => \&get_forms,
@@ -28,7 +32,7 @@
             'skip_reason'      => '',
             'tests_to_skip'    => '',
             'fields'           => {
-                'agency_password' => '@lunch4all',
+                'agency_password' => _get_password(103586),
                 'rm'              => 'do_login',
                 'agency_id'       => '103586'
             },
@@ -37,3 +41,18 @@
     );    # @forms
     return @forms;
 }
+
+sub _get_password{
+  Params::Validate::validate_pos(@_,1);
+  my $agency_id=shift;
+  my $dbh=MVHub::Utils::DB::get_dbh($ENV{MV_CONFIG_FILE});
+
+  my $sql=MVHub::Utils::DB::get_sql_select_statement('AGENCY_X_PASSWORD');
+  my @bind_values=($agency_id);
+  my $aref = $dbh->selectall_arrayref( $sql, {Slice=>{}}, @bind_values);
+  my $password= $aref->[0]{password};
+  
+  return $password;
+  
+  
+}

=== modified file 'app-mvhub/t/sql_lib_sanity.t'
--- app-mvhub/t/sql_lib_sanity.t	2010-06-29 19:21:04 +0000
+++ app-mvhub/t/sql_lib_sanity.t	2010-07-05 18:42:14 +0000
@@ -60,6 +60,7 @@
             '[[:<:]](ymca|counsel|immi|shelter)[[:>:]]'
         ],
         'AGENCY_X_WEBSITE'                          => [103553],
+        'AGENCY_X_PASSWORD'                         =>[103586],
         'AGENCY_PROGRAM_X_AGENCY_NAME_AGENCY_ALIAS' => [510296],
         'AGENCY_X_LAST_UPDATED'                     => [103553],
         'ALIAS_X_ALIAS_NAME'                        => [1],