CakeFest 2024: The Official CakePHP Conference

Schema::__construct

(No version information available, might only be in Git)

Schema::__constructSchema constructor

Description

private mysql_xdevapi\Schema::__construct()

The Schema object provides full access to the schema (database).

Parameters

This function has no parameters.

Examples

Example #1 mysql_xdevapi\Schema::__construct() example

<?php
$session
= mysql_xdevapi\getSession("mysqlx://user:password@localhost");

$session->sql("DROP DATABASE IF EXISTS food")->execute();
$session->sql("CREATE DATABASE food")->execute();
$session->sql("CREATE TABLE food.fruit(name text, rating text)")->execute();

$schema = $session->getSchema("food");
$schema->createCollection("trees");

print_r($schema->gettables());
print_r($schema->getcollections());

The above example will output something similar to:

Array
(
    [fruit] => mysql_xdevapi\Table Object
        (
            [name] => fruit
        )
)
Array
(
    [trees] => mysql_xdevapi\Collection Object
        (
            [name] => trees
        )
)
add a note

User Contributed Notes

There are no user contributed notes for this page.
To Top