DBSqlBuilderInsert Class Reference
[Model]

Build an insert query. More...

Inheritance diagram for DBSqlBuilderInsert:

List of all members.

Protected Member Functions
	get_fieldnames ($arr_fields, IDBTable $table)
	get_select ($query)
	get_sql_template ()
	get_substitutes ()
	get_table (IDBTable $table)
	get_values ($arr_fields, IDBTable $table)

---

Detailed Description

Build an insert query.

Author:

Gerd Riesselmann

Definition at line 8 of file dbsqlbuilder.insert.cls.php.

---

Member Function Documentation

DBSqlBuilderInsert::get_fieldnames	(	$	arr_fields,
		IDBTable $	table
	)			[protected]

Definition at line 28 of file dbsqlbuilder.insert.cls.php.

                                                                        {
                $conn = $table->get_table_driver();
                $ret = array();
                foreach($arr_fields as $key => $field) {
                        if (!is_numeric($key)) {
                                // FOrm array('col1' => val1, 'col2' => val2): Used with INSERT VALUES
                                $ret[] = DB::escape_database_entity($key, $conn, IDBDriver::FIELD);
                        }
                        else {
                                // Form array("col1", "col2", ...): Used with INSERT SELECT only
                                $ret[] = DB::escape_database_entity($field, $conn, IDBDriver::FIELD); 
                        }
                }
                return implode(', ', $ret);
        }

DBSqlBuilderInsert::get_select

(

$

query

)

[protected]

Definition at line 53 of file dbsqlbuilder.insert.cls.php.

                                              {
                if ($query) {
                        return $query->get_sql();
                }
                return '';
        }

DBSqlBuilderInsert::get_sql_template

(

)

[protected]

Reimplemented from DBSqlBuilderBase.

Reimplemented in DBSqlBuilderReplaceMysql.

Definition at line 9 of file dbsqlbuilder.insert.cls.php.

                                              {         
                return 'INSERT%delayed%ignore INTO %!table (%fields) %!values_or_select';               
        }

DBSqlBuilderInsert::get_substitutes

(

)

[protected]

Reimplemented from DBSqlBuilderBase.

Reimplemented in DBSqlBuilderReplaceMysql.

Definition at line 13 of file dbsqlbuilder.insert.cls.php.

                                             {
                $value_or_select = $this->get_select(Arr::get_item($this->params, 'select', null));
                if (empty($value_or_select)) {
                        $value_or_select = $this->get_values($this->fields, $this->query->get_table());
                }
                $ret = array(
                        '%fields' => $this->get_fieldnames($this->fields, $this->query->get_table()),
                        '%!table' => $this->get_table($this->query->get_table()),
                        '%!values_or_select' => $value_or_select,
                        '%delayed' => $this->get_feature_sql($this->params, 'delayed', 'DELAYED'),
                        '%ignore' => $this->get_feature_sql($this->params, 'ignore', 'IGNORE'),
                );      
                return $ret;
        }

DBSqlBuilderInsert::get_table

(

IDBTable $

table

)

[protected]

Reimplemented from DBSqlBuilderBase.

Definition at line 60 of file dbsqlbuilder.insert.cls.php.

                                                      {
                return $table->get_table_name_escaped();
        }

DBSqlBuilderInsert::get_values	(	$	arr_fields,
		IDBTable $	table
	)			[protected]

Definition at line 44 of file dbsqlbuilder.insert.cls.php.

                                                                    {
                $values = array();
                foreach($arr_fields as $column => $value) {
                        $values[] = DB::format($value, $table, $column);                        
                }
                $values = 'VALUES (' . implode(', ', $values) . ')';
                return $values;
        }

---

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

• gyro/core/model/base/sqlbuilder/dbsqlbuilder.insert.cls.php