#从sqlite3模块抄过来的东西，用于datetime,date到字符串之间的相互转换
def adapt_date(val):
    return val.isoformat()

def adapt_datetime(val):
    return val.isoformat(" ")

def convert_date(val):
    return datetime.date(*map(int, val.split("-")))

def convert_timestamp(val):
    datepart, timepart = val.split(" ")
    year, month, day = map(int, datepart.split("-"))
    timepart_full = timepart.split(".")
    hours, minutes, seconds = map(int, timepart_full[0].split(":"))
    if len(timepart_full) == 2:
        microseconds = int(timepart_full[1])
    else:
        microseconds = 0

    val = datetime.datetime(year, month, day, hours, \
            minutes, seconds, microseconds)
    return val