Skip to content
This repository was archived by the owner on Nov 10, 2018. It is now read-only.
This repository was archived by the owner on Nov 10, 2018. It is now read-only.

Problem in table creating in dataengine #271

@ah89

Description

@ah89

If we have '-', '/', '.' or other special characters in columns name, because dataframe_to_table method don't put them in comma, we have a problem in creating a table in this method

Error:
ERROR:__main__:Could not execute QueryCREATE TABLE Init_881130941759 ( tid VARCHAR(255), year VARCHAR(255), s-f VARCHAR(255), bt VARCHAR(255), obs VARCHAR(255), date VARCHAR(255), plot VARCHAR(255), tag VARCHAR(255), loc VARCHAR(255), species VARCHAR(255), a-s-1 VARCHAR(255), a-s-2 VARCHAR(255), a-s-3 VARCHAR(255), o-r VARCHAR(255), n VARCHAR(255), tic VARCHAR(255), bot VARCHAR(255), fle VARCHAR(255), wt VARCHAR(255), notes VARCHAR(255), __ind INT, PRIMARY KEY (__ind) ); Traceback (most recent call last): File "/home/a5heidar/Desktop/HoloClean-Private/holoclean/dataengine.py", line 160, in query result = self.db_backend[0].execute(sql_query) ProgrammingError: syntax error at or near "-" LINE 1: ...130941759 ( tid VARCHAR(255), year VARCHAR(255), s-f VARCHAR...

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions