Ticket #433 (fixed enhancement)
Allow for queries from/to non-prefixed tables
- Created: 2011-05-14 14:49:09
- Reported by: Franz
- Assigned to: Franz
- Milestone: 2.0-alpha1
- Component: database
- Priority: high
Currently, the database table prefix is automatically prepended to all table names in all types of queries.
There needs to be some option to circumvent this and simply use the table name that is provided with the query.
Franz 2011-09-13 03:11:55
Pretty much done with this now, committed in 8344f44.
That is, except for the join clause where code like the following is the reason that I do not have access to the $query object to determine whether to use the prefix or not:
if (!empty($query->joins)) $sql .= $this->join($query->joins); if (!empty($query->where)) $sql .= $this->where($query->where);
I'd be tempted to simply pass the query object to these functions. You never know when you might need it (plus these helper functions would all have the same, consistent interface).
Franz 2011-09-13 03:13:05
Oh, one more thing:
Should I add this to queries like "CREATE TABLE", too?