Peter Edwards wrote:
On 6 July 2011 15:01, Dave Howorth dhowo...@mrc-lmb.cam.ac.uk wrote:
I have a DBIC class made up using a UNION, something like this
__PACKAGE__-result_source_instance-is_virtual(1);
__PACKAGE__-result_source_instance-view_definition(
SELECT
Ashley Pond V wrote:
On Wed, Jul 6, 2011 at 7:01 AM, Dave Howorth dhowo...@mrc-lmb.cam.ac.uk
wrote:
I have a DBIC class made up using a UNION, something like this
simplified example:
__PACKAGE__-table('nodes');
__PACKAGE__-result_source_instance-is_virtual(1);
I wrote:
That works but results in a series of SELECT followed by DELETE:
SELECT me.sp_id, me.sp_status FROM sp me WHERE ( me.sp_id = ? ): '600011'
DELETE FROM species WHERE ( sp_id = ? ): '600011'
Just to be clear. The same pair of queries results from the following code:
I have a DBIC class made up using a UNION, something like this
simplified example:
__PACKAGE__-table('nodes');
__PACKAGE__-result_source_instance-is_virtual(1);
__PACKAGE__-result_source_instance-view_definition(
SELECT
sp_id AS id,
sp_status COLLATE latin1_general_ci AS
On 6 July 2011 15:01, Dave Howorth dhowo...@mrc-lmb.cam.ac.uk wrote:
I have a DBIC class made up using a UNION, something like this
__PACKAGE__-result_source_instance-is_virtual(1);
__PACKAGE__-result_source_instance-view_definition(
SELECT
sp_id AS id,
...
I've discovered
On Wed, Jul 6, 2011 at 7:01 AM, Dave Howorth dhowo...@mrc-lmb.cam.ac.uk wrote:
I have a DBIC class made up using a UNION, something like this
simplified example:
__PACKAGE__-table('nodes');
__PACKAGE__-result_source_instance-is_virtual(1);