Posted by gerhard killesreiter on July 19, 2007 at 9:52pm
Hi there,
I need some help to update the event_views module to the rewritten version of the event module aka "event 5.2". I am not too familiar with views.
The main change is the change of storage format for dates. All previous versions of event used "seconds since 1970" as storage mode, 5.2 uses actual SQL dates.
Please let met know if you are interested in helping out, I'd hate to release event 5.2 without views support.
Cheers,
Gerhard
Comments
I spent a little time to see
I spent a little time to see if I could help out with this, but I think this may be a bit difficult to do. Your new method has some pretty complex sql and it requires that someone understand how the new queries work and be able to rewrite that sql in a way that it can be used in Views in both MYSQL and PG, after being adapted on the fly to match whatever fields or arguments or filters have been requested in Views.
The best idea I could come up with was to add some new functions in event_database_mysql.inc and event_database_postgres.inc that look like your current functions but return just the sql code instead of actually executing the query. Once the sql is available, the names of the tables and fields in the sql have to be adapted to match the aliases that views has given them, and I'm not sure how to best do that. Then the right sql has to be inserted into views in field and filter and argument handlers.
I don't have time to do any more work on this in the near future, so I'm just posting this much as a FYI in case anyone else has time to help killes with this.
Hi Karen, thanks for looking
Hi Karen, thanks for looking into this.
There are already event_select, event_join, and event_where functions that only wait to be used by omebody who wants to integrate event 5.2 with another module. I am using them myself for the signup integration, so they do get actually tested.
I'd appreciate if somebody would look into this.
Cheers,
Gerhard