modify MySQL adapter interface

move model specific part to SQL::Schema class
remove IO::Adapter::MySQL class

1 files changed, 83 insertions, 23 deletions

diff --git a/fml/lib/IO/Adapter/MySQL.pm b/fml/lib/IO/Adapter/MySQL.pm
index 347412c0..fc34a57b 100644
--- a/fml/lib/IO/Adapter/MySQL.pm
+++ b/fml/lib/IO/Adapter/MySQL.pm
@@ -40,7 +40,28 @@ sub new
     my ($type) = ref($self) || $self;
     my $me     = {};
 
-    $me->{ _ml_name } = $args->{ ml_name };
+    $me->{ _ml_name }          = $args->{ ml_name }    || '';
+    $me->{ _databse }          = $args->{ database }   || 'fml';
+    $me->{ _table }            = $args->{ table }      || 'ml';
+    $me->{ _sql_server }       = $args->{ sql_server } || 'localhost';
+    $me->{ _sql_user }         = $args->{ sql_user }   || 'fml';
+    $me->{ _sql_user_password} = $args->{ sql_user_password } || '';
+
+    # load model dependent module specified by $args->{ schema };
+    if (defined $args->{ schema }) {
+	my $schema = $args->{ schema };
+	my $pkg    = "SQL::Schema::${schema}";
+	my $obj    = '';
+	eval qq{ require $pkg; $pkg->import(); \$obj = $pkg->new(); };
+	unless ($@) {
+	    $me->{ _schema } = $obj;
+	} 
+	else {
+	    print $@;
+	    error_reason($me, $@);
+	    return undef;
+	}
+    }
 
     return bless $me, $type;
 }
@@ -65,16 +86,17 @@ sub open
     use DBD::mysql;
 
     my $driver   = 'mysql';
-    my $database = $args->{ database } || $self->{ _databse } || 'fml';
-    my $table    = $args->{ table }    || $self->{ _table }   || 'ml';
-    my $host     = $args->{ sql_server } || $self->{ _sql_server } || 'localhost';
-    my $dsn      = "DBI:$driver:$database:$host";
-    my $user     = $args->{ sql_user }         || 'fml' || '';
-    my $password = $args->{ sql_user_password} || '';
-
+    my $database = $args->{database}   || $self->{_databse} || 'fml';
+    my $table    = $args->{table}      || $self->{_table}   || 'ml';
+    my $host     = $args->{sql_server} || $self->{_sql_server} || 'localhost';
+    my $user     = $args->{sql_user}   || $self->{ _sql_user } || 'fml';
+    my $password = 
+	$args->{sql_user_password} || $self->{_sql_user_password} || '';
+
+    my $dsn = "DBI:$driver:$database:$host";
     my $dbh = DBI->connect($dsn, $user, $password);
     unless (defined $dbh) { 
-	$args->{'error'} = $DBI::errstr;
+	$self->error_reason( $DBI::errstr );
 	return undef;
     }
 
@@ -99,6 +121,12 @@ sub close
 
 =head2 C<getline()>
 
+return the next address.
+
+=head2 C<get_next_value()>
+
+same as C<getline()> now.
+
 =cut
 
 
@@ -107,34 +135,43 @@ sub _res_configure
     my ($self, $args) = @_;
 
     unless ($self->{ _res }) {
-	my $ml   = $self->{ _ml_name };
-	my $file = $self->{ _file } || 'members';
+	my $ml    = $self->{ _ml_name };
+	my $file  = $self->{ _file } || 'members';
 	my $query = "select address from ml ";
 	$query   .= "where ml='$ml' and file='$file' ";
 	$self->execute({ query => $query });
     }
+    else {
+	$self->error_reason( $DBI::errstr );
+	return undef;
+    }
 }
 
 
 sub getline
 {
     my ($self, $args) = @_;
+
     $self->_res_configure($args) unless $self->{ _res };
-    my @row = $self->{ _res }->fetchrow_array;
-    join(" ", @row);
+    if ($self->{ _res }) {
+	my @row = $self->{ _res }->fetchrow_array;
+	join(" ", @row);
+    }
+    else {
+	$self->error_reason( $DBI::errstr );
+	undef;
+    }
 }
 
 
 sub get_next_value
 {
     my ($self, $args) = @_;
-    $self->_res_configure($args) unless $self->{ _res };
-    my @row = $self->{ _res }->fetchrow_array;
-    $row[0];
+    $self->getline($args);
 }
 
 
-=head2 C<execute($args)
+=head2 C<execute($args)>
 
 execute sql query.
 
@@ -144,6 +181,7 @@ execute sql query.
 
 =cut
 
+
 sub execute
 {
     my ($self, $args) = @_;
@@ -152,21 +190,43 @@ sub execute
 
     if (defined $dbh) {
 	my $res = $dbh->prepare($query);
-	$res->execute;
 
-	unless (defined $res) {
-	    $self->error_reason( $DBI::errstr );
-	    return undef;
-	}
-	else {
+	if (defined $res) {
+	    $res->execute;
 	    $self->{ _res } = $res;
 	    return $res;
 	}
+	else {
+	    $self->error_reason( $DBI::errstr );
+	    return undef;
+	}
     }
     else {
+	$self->error_reason( $DBI::errstr );
 	return undef;
     }
 }
 
 
+
+=head2 C<error_reason($mesg)>
+
+=head2 C<error()>
+
+=cut
+
+sub error_reason
+{
+    my ($self, $mesg) = @_;
+    $self->{ _error } = $mesg;
+}
+
+
+sub error
+{
+    my ($self) = @_;
+    return $self->{ _error };
+}
+
+
 1;