Changeset 2625

Timestamp:

06/20/08 09:02:09 (20 months ago)

Author:

fumiakiy

Message:

Removed hard-coded SQL statement and pass select list to SQL class. This is mainly for enterprise database drivers to generate SQL statements correctly. BugId:79817

Location:

branches/release-40/lib/MT/ObjectDriver

Files:

• Driver/DBI.pm (modified) (1 diff)
• SQL/SQLite.pm (modified) (1 diff)

branches/release-40/lib/MT/ObjectDriver/Driver/DBI.pm

@@ -257 +257 @@
     }
     $stmt->select([]);
-    my $sql = "SELECT $select\n" . $stmt->as_sql;
+    $stmt->select_map({});
+    $stmt->select_map_reverse({});
+    $stmt->add_select($select => $select);
+    my $sql = $stmt->as_sql;
     $driver->select_one($sql, $stmt->bind);
 }

branches/release-40/lib/MT/ObjectDriver/SQL/SQLite.pm

@@ -30 +30 @@
     my $cd  = delete $stmt->{count_distinct};
     my ($col) = each %$cd;
+    my @select = @{$stmt->select};
     $stmt->select([$col]);
     my $class = ref $stmt;
     my $main_stmt = $class->new;
+    $main_stmt->select(\@select);
     $main_stmt->from_stmt($stmt);
     $main_stmt->as_sql(@_);