phpixie / database Goto Github PK

SELECT md5(random()::text || clock_timestamp()::text)::uuid

$result = $query
            ->table('pg_language')
            ->fields(array(
                'md5(random()::text || clock_timestamp()::text)::uuid'
            ))
            ->execute();

// Query: SELECT "md5(random()::text || clock_timestamp()::text)::uuid"
// The field will be handled as a column name and ends up in an error

$result = $query
            ->table('pg_language')
            ->fields(array(
                'lanname", md5(random()::text || clock_timestamp()::text)::uuid AS UUID, "lanowner'
            ))
            ->execute();
// Query: SELECT "lanname", md5(random()::text || clock_timestamp()::text)::uuid AS UUID, "lanowner" FROM "pg_language"

mydatabase
   ⌙-> myschema
          ⌙-> mytable

SELECT * FROM "myschema"."mytable";

$gateways = $query
    ->table('myschema.mytable');

/*
execute():

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "myschema.mytable" does not exist LINE 1: SELECT * FROM "myschema.mytable" ^' in ...

parse():

object(PHPixie\Database\Type\SQL\Expression)#51 (2) { ["sql"]=> string(28) "SELECT * FROM "myschema.mytable"" ["params"]=> array(0) { } }

SQL Query:
SELECT * FROM "myschema.mytable" // invalid
*/

$gateways = $query
    ->table('"myschema"."mytable"');

/*
execute():

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42601]: Syntax error: 7 ERROR: zero-length delimited identifier at or near """" LINE 1: SELECT * FROM ""myschema"."mytable"" ^' in 

parse():

object(PHPixie\Database\Type\SQL\Expression)#51 (2) { ["sql"]=> string(32) "SELECT * FROM ""myschema"."mytable""" ["params"]=> array(0) { } }

SQL Query:
SELECT * FROM ""myschema"."mytable"" // invalid
*/

$query = $connection->selectQuery();
$gateways = $query
    ->table('myschema"."mytable');

parse():

object(PHPixie\Database\Type\SQL\Expression)#51 (2) { ["sql"]=> string(30) "SELECT * FROM "myschema"."mytable"" ["params"]=> array(0) { } }

SQL Query:
SELECT * FROM "myschema"."mytable" // valid

// Inserting
$insertQuery = $connection->insertQuery();
$insertQuery->data(
    'id'    => 1,
    'title' => 'Hello'
)->execute();