into(sql, *) with better datetime support

changes and tests to support into(sql, *) where the source is
a pd.DataFrame, numpy array or dynd array, bcolz.ctable, or csv

If the source has a datetime with a timezone, make use of
sqlalchemy DateTime with timezone support

This also helps with operations of the form into(*, sql) where
the sql table has datetimes with time zone
Appreciated.

On Thu, Sep 11, 2014 at 11:17 AM, T.J. Alumbaugh <notifications@github.com>
wrote:

> In blaze/api/tests/test_into_exhaustive.py:
>
> >
> >      for a in sources:
> >          for b in targets:
> > -            c = Table(a, '{amount: int64, id: int64, name: string[7], timestamp: datetime}')[['amount', 'id', 'name']]
> > +            c = Table(a, "{amount: int64, id: int64, name: string, timestamp: datetime[tz='UTC']}")[['amount', 'id', 'name']]
>
> Actually I agree with you about making sure that typical cases work. I'm
> reminded of the CS adage: "make the common case fast." A corollary might
> be: "make the common case work." I will separate out into cases where
> typical datetime specification will work.
>
> —
> Reply to this email directly or view it on GitHub
> <https://github.com/ContinuumIO/blaze/pull/616/files#r17438136>.
>