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):
"""
"""