dfsql

dfsql copied to clipboard

ImportError: cannot import name 'basestring' from 'pyparsing'

8

Hi guys, I noticed that `dfsql` doesn't work with new versions of `pyparsing` (since 3.0.0). This should probably be fixed.

YarShev

Error if selecting column name is 'status'

2

query: ``` result_df = dfsql.sql_query( 'select name, status from predictors', ds_kwargs={'case_sensitive': False}, reduce_output=False, predictors=predictors_df ) ``` error: ``` Traceback (most recent call last): File "", line 1, in File "/home/maxs/dev/mdb/venv38/sources/dfsql/dfsql/__init__.py",...

StpMax

KeyError if 'ORDER BY' contains table name

2

This query produce `KeyError('COLUMNS.ORDINAL_POSITION')` : ``` dfsql.sql_query( "SELECT * FROM COLUMNS WHERE COLUMNS.TABLE_SCHEMA = 'MINDSDB' AND COLUMNS.TABLE_NAME = 'predictors' ORDER BY COLUMNS.ORDINAL_POSITION", ds_kwargs={'case_sensitive': False}, reduce_output=False, **{table_name: dataframe} ) ``` Dataframe...

StpMax