[CalendarServer-dev] [Calendar and Contacts Server] #486: 'sqlparse.sql.Identifier' instances: Field 'value' is 'None'

Calendar and Contacts Server trac at macosforge.org
Tue Aug 28 10:38:03 PDT 2012

#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

 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 </>

More information about the calendarserver-dev mailing list