DataFrameModel.py 文件源码

def read_sql(sql, con, filePath, index_col=None, coerce_float=True,
             params=None, parse_dates=None, columns=None, chunksize=None):
    """
    Read SQL query or database table into a DataFrameModel.
    Provide a filePath argument in addition to the *args/**kwargs from
    pandas.read_sql and get a DataFrameModel.

    NOTE: The chunksize option is overridden to None always (for now).

    Reference:
    http://pandas.pydata.org/pandas-docs/version/0.18.1/generated/pandas.read_sql.html
    pandas.read_sql(sql, con, index_col=None, coerce_float=True,
                    params=None, parse_dates=None, columns=None, chunksize=None)



    :return: DataFrameModel
    """

    # TODO: Decide if chunksize is worth keeping and how to handle?
    df = pandas.read_sql(sql, con, index_col, coerce_float,
                    params, parse_dates, columns, chunksize=None)
    return DataFrameModel(df, filePath=filePath)