search

kayak / pypika

PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.
http://pypika.readthedocs.io/en/latest/
Apache License 2.0
2.43k stars 292 forks source link

When select a list of fields and sql with [ ] #799

Closed yqz945 closed 2 months ago

yqz945 commented 2 months ago

sqldef = { "table": "table_a", "id_fld": "id", "fields": ["resource_id", "resource_name", "subject_name", "period_name", "view_url", "download_url", "score", "view_count_td", "like_count_td", "download_count_td", "spread_count"] }

Query.from_(table).select(conf.fields).get_sql()

return SQL is : SELECT ['resource_id','resource_name','subject_name','period_name','view_url','download_url','score','view_count_td','like_count_td','download_count_td','spread_count'] FROM "table_a"

How to remove the [ ] ?

Thanks!

yqz945 commented 2 months ago

I solved it by adding a sql = str(Query.from_(table).select([Field(f) for f in conf.fields]).get_sql()) SELECT "resource_id","resource_name","subject_name","period_name","view_url","download_url","score","view_count_td","like_count_td","download_count_td","spread_count" FROM "table_a" Thanks!