assertEquals([':id' => 'key'], Parameters::id('key'), 'ID parameter not constructed correctly'); } #[TestDox('ID succeeds with non string')] public function testIdSucceedsWithNonString(): void { $this->assertEquals([':id' => '7'], Parameters::id(7), 'ID parameter not constructed correctly'); } public function testJsonSucceedsForArray(): void { $this->assertEquals([':it' => '{"id":18,"url":"https://www.unittest.com"}'], Parameters::json(':it', ['id' => 18, 'url' => 'https://www.unittest.com']), 'JSON parameter not constructed correctly'); } #[TestDox('json succeeds for stdClass')] public function testJsonSucceedsForStdClass(): void { $obj = new stdClass(); $obj->id = 19; $obj->url = 'https://testhere.info'; $this->assertEquals([':it' => '{"id":19,"url":"https://testhere.info"}'], Parameters::json(':it', $obj), 'JSON parameter not constructed correctly'); } public function testJsonSucceedsForPjsonClass(): void { $this->assertEquals([':it' => '{"id":"999","name":"a test","num_value":98}'], Parameters::json(':it', new PjsonDocument(new PjsonId('999'), 'a test', 98, 'nothing')), 'JSON parameter not constructed correctly'); } public function testJsonSucceedsForArrayOfPjsonClass(): void { $this->assertEquals([':it' => '{"pjson":[{"id":"997","name":"another test","num_value":94}]}'], Parameters::json(':it', ['pjson' => [new PjsonDocument(new PjsonId('997'), 'another test', 94, 'nothing')]]), 'JSON parameter not constructed correctly'); } public function testNameFieldsSucceeds(): void { $named = Parameters::nameFields([Field::EQ('it', 17), Field::EQ('also', 22, ':also'), Field::EQ('other', 24)]); $this->assertCount(3, $named, 'There should be 3 parameters in the array'); $this->assertEquals(':field0', $named[0]->paramName, 'Parameter 1 not named correctly'); $this->assertEquals(':also', $named[1]->paramName, 'Parameter 2 not named correctly'); $this->assertEquals(':field2', $named[2]->paramName, 'Parameter 3 not named correctly'); } public function testAddFieldsSucceeds(): void { $this->assertEquals([':a' => 1, ':b' => 'two', ':z' => 18], Parameters::addFields([Field::EQ('b', 'two', ':b'), Field::EQ('z', 18, ':z')], [':a' => 1]), 'Field parameters not added correctly'); } #[TestDox('Field names succeeds for PostgreSQL')] public function testFieldNamesSucceedsForPostgreSQL(): void { try { Configuration::$mode = Mode::PgSQL; $this->assertEquals([':names' => "{one,two,seven}"], Parameters::fieldNames(':names', ['one', 'two', 'seven']), 'Field name parameters not correct'); } finally { Configuration::$mode = null; } } #[TestDox('Field names succeeds for SQLite')] public function testFieldNamesSucceedsForSQLite(): void { try { Configuration::$mode = Mode::SQLite; $this->assertEquals([':it0' => '$.test', ':it1' => '$.unit', ':it2' => '$.wow'], Parameters::fieldNames(':it', ['test', 'unit', 'wow']), 'Field name parameters not correct'); } finally { Configuration::$mode = null; } } public function testFieldNamesFailsWhenModeNotSet(): void { $this->expectException(DocumentException::class); Configuration::$mode = null; Parameters::fieldNames('', []); } }