changed mysql TIMESTAMP->DATETIME

fixed up date unit test
RowProxy __iter__ properly routes columns through type processing

3 files changed, 6 insertions, 2 deletions

diff --git a/lib/sqlalchemy/databases/mysql.py b/lib/sqlalchemy/databases/mysql.py
index 4e43f3673..21dbc2c17 100644
--- a/lib/sqlalchemy/databases/mysql.py
+++ b/lib/sqlalchemy/databases/mysql.py
@@ -30,7 +30,7 @@ class MSInteger(sqltypes.Integer):
         return "INTEGER"
 class MSDateTime(sqltypes.DateTime):
     def get_col_spec(self):
-        return "TIMESTAMP"
+        return "DATETIME"
 class MSText(sqltypes.TEXT):
     def get_col_spec(self):
         return "TEXT"
diff --git a/lib/sqlalchemy/databases/sqlite.py b/lib/sqlalchemy/databases/sqlite.py
index 5a143a201..5708247e2 100644
--- a/lib/sqlalchemy/databases/sqlite.py
+++ b/lib/sqlalchemy/databases/sqlite.py
@@ -30,8 +30,11 @@ class SLDateTime(sqltypes.DateTime):
     def get_col_spec(self):
         return "TIMESTAMP"
     def convert_result_value(self, value):
+        print "RESULT", value
         if value is None:
+            print "RETNONE"
             return None
+        print "HI"
         parts = value.split('.')
         try:
             (value, microsecond) = value.split('.')
diff --git a/lib/sqlalchemy/engine.py b/lib/sqlalchemy/engine.py
index 07574a260..580d85450 100644
--- a/lib/sqlalchemy/engine.py
+++ b/lib/sqlalchemy/engine.py
@@ -670,7 +670,8 @@ class RowProxy:
         self.parent = parent
         self.row = row
     def __iter__(self):
-        return iter(self.row)
+        for i in range(0, len(self.row)):
+            yield self.parent._get_col(self.row, i)
     def __eq__(self, other):
         return (other is self) or (other == tuple([self.parent._get_col(self.row, key) for key in range(0, len(self.row))]))
     def __repr__(self):