DBSqlBuilderReplaceMysql Class Reference
[Model]

Implementation of Replace for MySQL. More...

Inheritance diagram for DBSqlBuilderReplaceMysql:

List of all members.

Protected Member Functions
	get_fields_values ($arr_fields, IDBTable $table)
	get_sql_template ()
	get_substitutes ()

---

Detailed Description

Implementation of Replace for MySQL.

Does not use REPLACE but INSERT ... ON DUPLICATED KEY UPDATE, since REPLACE means to DELETE and then INSERT, which is a pain

Author:

Gerd Riesselmann

Definition at line 15 of file dbsqlbuilder.replace.mysql.cls.php.

---

Member Function Documentation

DBSqlBuilderReplaceMysql::get_fields_values	(	$	arr_fields,
		IDBTable $	table
	)			[protected]

Definition at line 30 of file dbsqlbuilder.replace.mysql.cls.php.

                                                                           {
                $fields = array();
                $keyfields = $table->get_table_keys();
                foreach($arr_fields as $column => $value) {
                        if (!array_key_exists($column, $keyfields)) {
                                $fieldname = $this->prefix_column($column, $table);
                                $fields[$fieldname] = DB::format($value, $table, $column);
                        }
                }
                // This is wrong (Duplicated key)
//              foreach($keyfields as $column => $dbfield) { 
//                      if ($dbfield instanceof DBFieldInt && $dbfield->has_policy(DBFieldInt::AUTOINCREMENT)) {
//                              // LAst isnert id fix
//                              $fieldname = $this->prefix_column($column, $table);
//                              $fields[$fieldname] = 'LAST_INSERT_ID(' . DB::format($value, $table, $column) . ')';
//                      }
//              }
                return Arr::implode(', ', $fields, ' = ');
        }

DBSqlBuilderReplaceMysql::get_sql_template

(

)

[protected]

Reimplemented from DBSqlBuilderInsert.

Definition at line 16 of file dbsqlbuilder.replace.mysql.cls.php.

                                              {         
                return 'INSERT INTO %!table (%fields) %!values ON DUPLICATE KEY UPDATE %!fields_values';                
        }       

DBSqlBuilderReplaceMysql::get_substitutes

(

)

[protected]

Reimplemented from DBSqlBuilderInsert.

Definition at line 20 of file dbsqlbuilder.replace.mysql.cls.php.

                                             {
                $ret = array(
                        '%fields' => $this->get_fieldnames($this->fields, $this->query->get_table()),
                        '%!table' => $this->get_table($this->query->get_table()),
                        '%!values' => $this->get_values($this->fields, $this->query->get_table()),
                        '%!fields_values' => $this->get_fields_values($this->fields, $this->query->get_table()),
                );      
                return $ret;
        }

---

The documentation for this class was generated from the following file:

• gyro/core/model/drivers/mysql/sqlbuilder/dbsqlbuilder.replace.mysql.cls.php