incubator-zeta-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dominique 'NetAndroid' Schramm <li...@schramm.es>
Subject [zeta-dev] sqlabstraction update -> multiple tables @ once
Date Sat, 09 Jul 2011 15:57:58 GMT
Hi,

i put my head into the core of the sqlabstraction to find out how an
update performs for multiple tables. for an example:

$q = $pdb->createUpdateQuery();
$q->update('`domains`,`emailaddresses`')
	->set('`domains.change`', '0')
	->set('`emailaddresses.change`', '0');
$stmt = $q->prepare();
$stmt->execute();

@ the sqlabstraction i found the following code:

line:104
public function update( $table )
{
	$table = $this->getIdentifier( $table );
        $this->table = $table;
        return $this;
}

this code means for me that only one table at once is possible. but why?
i think it will be quite simple to extend this section for multiple
tables update like the sql query. i am not perhaps i can create the code
and give it back to you?

-- 
Dominique 'NetAndroid' Schramm
- Twitter: @NetAndroid_BY
- Identi.ca: @netandroid
- Blog: http://netandroid.nl/


Mime
View raw message