'SelectFrom' object has no attribute 'Columns'
ifuchs opened this issue · 1 comments
Tried the following:
sqlitis 'SELECT DISTINCT last_name, first_name,addressee_display, street_address, city, a.name, postal_code, f.name as country FROM civicrm_contact c, civicrm_entity_tag d , civicrm_address e, civicrm_state_province a, civicrm_country f WHERE c.id = d.entity_id and tag_id = 6 and c.id = e.contact_id AND state_province_id = a.id and e.country_id = f.id and display_name not in ( SELECT display_name FROM civicrm_contribution, civicrm_contact c, civicrm_entity_tag d WHERE contact_id = c.id and c.id = entity_id and tag_id = 6'
Got: 'SelectFrom' object has no attribute 'Columns'
First thing is it looks like sqlitis doesn't support commas for joining tables (e.g. FROM a JOIN b JOIN c
works but FROM a, b, c
does not). That should be an easy fix.
The harder thing is that sqlitis doesn't support table aliases yet. There's a lot to that, so created a separate issue for it (#23)