#486: 'sqlparse.sql.Identifier' instances: Field 'value' is 'None' ---------------------------------+------------------------------------------ Reporter: carlos@… | Owner: wsanchez@… Type: Defect | Status: new Priority: 5: Not set | Milestone: CalendarServer-4.x Component: Calendar Server | Severity: Other Keywords: | Radar: ---------------------------------+------------------------------------------ When parsing the following SQL fragment: {{{ create table INVITE ( INVITE_UID varchar(255) not null, NAME varchar(255) not null, RECIPIENT_ADDRESS varchar(255) not null, HOME_RESOURCE_ID integer not null, RESOURCE_ID integer not null -- Need primary key on (INVITE_UID, NAME, RECIPIENT_ADDRESS)? ); }}} {{{sqlparse}}} generates an instance of type {{{sqlparse.sql.Identifier}}} to represent the {{{varchar}}} keyword. With my version of {{{sqlparse}}} (0.1.3), the field {{{value}}} of that instance is {{{None}}}, and CalendarServer dies at {{{twext.enterprise.dal.parseschema._ColumnParser.parseColumn()}}}. The attached patch (diff against branches/release/CalendarServer-4.1.1-dev) attemts to address this. -- Ticket URL: <http://trac.calendarserver.org/ticket/486> Calendar and Contacts Server </> HTTP/WebDAV/CalDAV Server