def get_today(as_str=False):
now = get_now()
today = datetime.datetime(now.year, now.month, now.day)
if as_str:
return dt.format(today)
return today
def test_format():
actual = format(datetime(2008, 1, 15))
assert actual == '20080115'
"""
from datetime import datetime
import numpy as np
import traceback
from numpy import NaN
from pandas.core.datetools import format, to_datetime
from pandas.core.panel import pivot
from pandas.core.api import (DataFrame, DataMatrix, Series, Index, isnull)
#-------------------------------------------------------------------------------
# Query formatting
_formatters = {
datetime: lambda dt: "'%s'" % 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: "%.8f" % x,
bool: lambda x: "'%s'" % x,
}
def format_query(sql, *args):
"""
"""
from datetime import datetime
import numpy as np
import traceback
from numpy import NaN
from pandas.core.datetools import format, to_datetime
from pandas.core.panel import pivot
from pandas.core.api import (DataFrame, DataMatrix, Series, Index,
isnull)
#-------------------------------------------------------------------------------
# Query formatting
_formatters = {
datetime : lambda dt: "'%s'" % 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: "%.8f" % x,
bool : lambda x: "'%s'" % x,
}
def format_query(sql, *args):
"""
"""
processed_args = []
def test_format():
actual = format(datetime(2008, 1, 15))
assert actual == '20080115'
def format_date(date):
f = dt.format(date)
return '{}-{}-{}'.format(f[:4], f[4:6], f[6:])
def get_now(as_str=False):
now = datetime.datetime.now()
if as_str:
return dt.format(now)
return now
