Fr3nch13/CakePHP Utilities

NumberTreesFixture extends TestFixture
in package

NumberTreeFixture

Generates a tree of data for use testing the tree behavior

Table of Contents

Properties

$connection  : string
Fixture Datasource
$fields  : array<string|int, mixed>
fields property
$import  : array<string|int, mixed>|null
Configuration for importing fixture schema
$records  : array<string|int, mixed>
Records
$table  : string
Full Table Name
$_constraints  : array<string, mixed>
Fixture constraints to be created.
$_schema  : TableSchemaInterface|SqlGeneratorInterface
The schema for this fixture.
$_tableLocator  : LocatorInterface|null
Table locator instance
$defaultTable  : string|null
This object's default table alias.

Methods

__construct()  : mixed
Instantiate the fixture.
connection()  : string
Get the connection name this fixture should be inserted into.
create()  : bool
Create the fixture schema/mapping/definition
createConstraints()  : bool
Build and execute SQL queries necessary to create the constraints for the fixture
drop()  : bool
Run after all tests executed, should remove the table/collection from the connection.
dropConstraints()  : bool
Build and execute SQL queries necessary to drop the constraints for the fixture
fetchTable()  : Table
Convenience method to get a table instance.
getTableLocator()  : LocatorInterface
Gets the table locator.
getTableSchema()  : TableSchemaInterface|SqlGeneratorInterface
Get and set the schema for this fixture.
init()  : void
Initialize the fixture.
insert()  : StatementInterface|bool
Run before each test is executed.
setTableLocator()  : $this
Sets the table locator.
setTableSchema()  : $this
Get and set the schema for this fixture.
sourceName()  : string
Get the table/collection name for this fixture.
truncate()  : bool
Truncates the current fixture.
_getRecords()  : array<string|int, mixed>
Converts the internal records into data used to generate a query.
_schemaFromFields()  : void
Build the fixtures table schema from the fields property.
_schemaFromImport()  : void
Build fixture schema from a table in another datasource.
_schemaFromReflection()  : void
Build fixture schema directly from the datasource
_tableFromClass()  : string
Returns the table name using the fixture class

Properties

$connection

Fixture Datasource

public string $connection = 'test'

$fields

fields property

public array<string|int, mixed> $fields = ['id' => ['type' => 'integer'], 'name' => ['type' => 'string', 'null' => false], 'parent_id' => 'integer', 'lft' => ['type' => 'integer'], 'rght' => ['type' => 'integer'], 'depth' => ['type' => 'integer'], '_constraints' => ['primary' => ['type' => 'primary', 'columns' => ['id']]]]

$import

Configuration for importing fixture schema

public array<string|int, mixed>|null $import

Accepts a connection and model or table key, to define which table and which connection contain the schema to be imported.

$records

Records

public array<string|int, mixed> $records = [['name' => 'electronics', 'parent_id' => null, 'lft' => '1', 'rght' => '20', 'depth' => 0], ['name' => 'televisions', 'parent_id' => '1', 'lft' => '2', 'rght' => '9', 'depth' => 1], ['name' => 'tube', 'parent_id' => '2', 'lft' => '3', 'rght' => '4', 'depth' => 2], ['name' => 'lcd', 'parent_id' => '2', 'lft' => '5', 'rght' => '6', 'depth' => 2], ['name' => 'plasma', 'parent_id' => '2', 'lft' => '7', 'rght' => '8', 'depth' => 2], ['name' => 'portable', 'parent_id' => '1', 'lft' => '10', 'rght' => '19', 'depth' => 1], ['name' => 'mp3', 'parent_id' => '6', 'lft' => '11', 'rght' => '14', 'depth' => 2], ['name' => 'flash', 'parent_id' => '7', 'lft' => '12', 'rght' => '13', 'depth' => 3], ['name' => 'cd', 'parent_id' => '6', 'lft' => '15', 'rght' => '16', 'depth' => 2], ['name' => 'radios', 'parent_id' => '6', 'lft' => '17', 'rght' => '18', 'depth' => 2], ['name' => 'alien hardware', 'parent_id' => null, 'lft' => '21', 'rght' => '22', 'depth' => 0]]
  • electronics:1
    • televisions:2
      • tube:3
      • lcd:4
      • plasma:5
    • portable:6
      • mp3:7
        • flash:8
      • cd:9
      • radios:10
  • alien ware: 11

$table

Full Table Name

public string $table
Tags
psalm-suppress

PropertyNotSetInConstructor

$_constraints

Fixture constraints to be created.

protected array<string, mixed> $_constraints = []

$defaultTable

This object's default table alias.

protected string|null $defaultTable = null

Methods

__construct()

Instantiate the fixture.

public __construct() : mixed
Tags
throws
CakeException

on invalid datasource usage.

connection()

Get the connection name this fixture should be inserted into.

public connection() : string
Tags
inheritDoc
Return values
string

create()

Create the fixture schema/mapping/definition

public create(ConnectionInterface $connection) : bool
Parameters
$connection : ConnectionInterface

An instance of the connection the fixture should be created on.

Tags
inheritDoc
Return values
bool —

True on success, false on failure.

createConstraints()

Build and execute SQL queries necessary to create the constraints for the fixture

public createConstraints(ConnectionInterface $connection) : bool
Parameters
$connection : ConnectionInterface

An instance of the database into which the constraints will be created.

Tags
inheritDoc
Return values
bool —

on success or if there are no constraints to create, or false on failure

drop()

Run after all tests executed, should remove the table/collection from the connection.

public drop(ConnectionInterface $connection) : bool
Parameters
$connection : ConnectionInterface

An instance of the connection the fixture should be removed from.

Tags
inheritDoc
Return values
bool —

True on success, false on failure.

dropConstraints()

Build and execute SQL queries necessary to drop the constraints for the fixture

public dropConstraints(ConnectionInterface $connection) : bool
Parameters
$connection : ConnectionInterface

An instance of the database into which the constraints will be dropped.

Tags
inheritDoc
Return values
bool —

on success or if there are no constraints to drop, or false on failure

fetchTable()

Convenience method to get a table instance.

public fetchTable([string|null $alias = null ][, array<string, mixed> $options = [] ]) : Table
Parameters
$alias : string|null = null

The alias name you want to get. Should be in CamelCase format. If null then the value of $defaultTable property is used.

$options : array<string, mixed> = []

The options you want to build the table with. If a table has already been loaded the registry options will be ignored.

Tags
throws
CakeException

If $alias argument and $defaultTable property both are null.

see
TableLocator::get()
since
4.3.0
Return values
Table

setTableSchema()

Get and set the schema for this fixture.

public setTableSchema(mixed $schema) : $this
Parameters
$schema : mixed

The table to set.

Tags
inheritDoc
Return values
$this

sourceName()

Get the table/collection name for this fixture.

public sourceName() : string
Tags
inheritDoc
Return values
string

_getRecords()

Converts the internal records into data used to generate a query.

protected _getRecords() : array<string|int, mixed>
Return values
array<string|int, mixed>

_schemaFromFields()

Build the fixtures table schema from the fields property.

protected _schemaFromFields() : void

_schemaFromImport()

Build fixture schema from a table in another datasource.

protected _schemaFromImport() : void
Tags
throws
CakeException

when trying to import from an empty table.

_schemaFromReflection()

Build fixture schema directly from the datasource

protected _schemaFromReflection() : void
Tags
throws
CakeException

when trying to reflect a table that does not exist

_tableFromClass()

Returns the table name using the fixture class

protected _tableFromClass() : string
Return values
string 

        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results