keystr = '' if keys is not None: if isinstance(keys, basestring): keys = (keys,) keystr = ', PRIMARY KEY (%s)' % ','.join(keys) return template % {'name' : name, 'columns' : columns, 'keystr' : keystr} #------------------------------------------------------------------------------- # Query formatting _formatters = { datetime : lambda dt: "'%s'" % date_format(dt), str : lambda x: "'%s'" % x, np.str_ : lambda x: "'%s'" % x, unicode : lambda x: "'%s'" % x, float : lambda x: "%.8f" % x, int : lambda x: "%s" % x, type(None) : lambda x: "NULL", np.float64 : lambda x: "%.10f" % x, bool : lambda x: "'%s'" % x, } def format_query(sql, *args): """ """ processed_args = []
import nose import numpy as np from pandas.core.datetools import format as date_format from pandas.core.api import DataFrame, isnull from pandas.compat import StringIO, range, lrange import pandas.compat as compat import pandas.io.sql as sql import pandas.util.testing as tm from pandas import Series, Index, DataFrame from datetime import datetime _formatters = { datetime: lambda dt: "'%s'" % date_format(dt), str: lambda x: "'%s'" % x, np.str_: lambda x: "'%s'" % x, compat.text_type: lambda x: "'%s'" % x, compat.binary_type: lambda x: "'%s'" % x, float: lambda x: "%.8f" % x, int: lambda x: "%s" % x, type(None): lambda x: "NULL", np.float64: lambda x: "%.10f" % x, bool: lambda x: "'%s'" % x, } def format_query(sql, *args): """ """