PHP lithium\data\source Database::schema Examples

schema() public method

Builds an array of keyed on the fully-namespaced Model with array of fields as values for the given Query

public schema ( Query $query, Result | null $resource = null, object | null $context = null ) : array
$query	lithium\data\model\Query	A Query instance.
$resource	Result | null	An optional a result resource.
$context	object | null
return	array

Example #1

File: MockDatabase.php Project: nilamdoc/KYCGlobal

 public function schema($query, $resource = null, $context = null)
 {
     if (isset($this->return['schema'])) {
         return $this->return['schema'];
     }
     return parent::schema($query, $resource = null, $context = null);
 }

Example #2

File: Sqlite3.php Project: niel/lithium

	/**
	 * In cases where the query is a raw string (as opposed to a `Query` object), to database must
	 * determine the correct column names from the result resource.
	 *
	 * @param mixed $query
	 * @param resource $resource
	 * @param object $context
	 * @return array
	 */
	public function schema($query, $resource = null, $context = null) {
		if (is_object($query)) {
			return parent::schema($query, $resource, $context);
		}

		$result = array();
		$count = $resource->numColumns();

		for ($i = 0; $i < $count; $i++) {
			$result[] = $resource->columnName($i);
		}
		return $result;
	}

Example #3

File: MySql.php Project: WarToaster/HangOn

 /**
  * In cases where the query is a raw string (as opposed to a `Query` object), to database must
  * determine the correct column names from the result resource.
  *
  * @param mixed $query
  * @param resource $resource
  * @param object $context
  * @return array
  */
 public function schema($query, $resource = null, $context = null)
 {
     if (is_object($query)) {
         return parent::schema($query, $resource, $context);
     }
     $result = array();
     $count = mysql_num_fields($resource->resource());
     for ($i = 0; $i < $count; $i++) {
         $result[] = mysql_field_name($resource->resource(), $i);
     }
     return $result;
 }

Example #4

File: MySql.php Project: rmarscher/lithium

 /**
  * In cases where the query is a raw string (as opposed to a `Query` object), to database must
  * determine the correct column names from the result resource.
  *
  * @param mixed $query
  * @param resource $resource
  * @param object $context
  * @return array
  */
 public function schema($query, $resource = null, $context = null)
 {
     if (is_object($query)) {
         return parent::schema($query, $resource, $context);
     }
     $result = array();
     $count = $resource->resource()->columnCount();
     for ($i = 0; $i < $count; $i++) {
         $meta = $resource->resource()->getColumnMeta($i);
         $result[] = $meta['name'];
     }
     return $result;
 }