/** * @param array $params * @param string $username * @param string $password * @param array $driverOptions * * @throws SocketException */ public function __construct(array $params, $username = null, $password = null, array $driverOptions = array()) { if (!class_exists('PhpOrient\\PhpOrient')) { $message = sprintf('OrientDB Socket Connection: the socket connection requires a package "%s" but was not installed.', static::PACKAGE); throw new SocketException($message); } if (empty($params['host']) or empty($params['port']) or empty($params['dbname']) or empty($params['user']) or empty($params['password'])) { throw new SocketException('OrientDB Socket Connection: Host, port, dbname, user and password must be configured.'); } $this->connection = new BaseConnection($params['host'], $params['port']); $this->connection->dbOpen($params['dbname'], $params['user'], $params['password']); }
public function setUp() { $this->client = $this->createClient('connect'); $this->client->connect(); try { $this->client->dbDrop($this->db_name, Constants::STORAGE_TYPE_MEMORY); } catch (\Exception $e) { // echo $e->getMessage(); $this->client->getTransport()->debug($e->getMessage()); } $this->client->dbCreate($this->db_name, Constants::STORAGE_TYPE_MEMORY, Constants::DATABASE_TYPE_GRAPH); $this->cluster_struct = $this->client->dbOpen($this->db_name, 'admin', 'admin'); $this->thisTest = microtime(true); }
protected function createDBConnection() { $client = new PhpOrient(); $client->configure(['username' => 'root', 'password' => '369', 'hostname' => 'localhost', 'port' => 2424]); $client->connect(); $client->dbOpen('logistics'); return $client; }
public function createConnection() { $client = new PhpOrient(); $client->configure(['username' => $this->getUsername(), 'password' => $this->getPassword(), 'hostname' => $this->getHostname(), 'port' => $this->getPort()]); $client->connect(); $client->dbOpen($this->getDatabase(), $this->getUsername(), $this->getPassword()); return $client; }
public function testRestrictedProperties() { // $this->markTestSkipped('PupĆ¹'); $client = new PhpOrient('localhost', 2424); $client->dbOpen("GratefulDeadConcerts", 'admin', 'admin'); $result = $client->query('SELECT @rid, @class, @version FROM #11:0'); // $result = $client->query('select from followed_by limit 1'); usleep(1000); }
public function testLoadWithCache() { $client = new PhpOrient('localhost', 2424); $client->dbOpen('GratefulDeadConcerts', 'admin', 'admin'); $myFunction = function (Record $record) { $this->assertInstanceOf('\\PhpOrient\\Protocols\\Binary\\Data\\Record', $record); }; $records = $client->recordLoad(new ID("9", "1"), ['fetch_plan' => '*:3', '_callback' => $myFunction]); $this->assertNotEmpty($records); }
protected function getClient() { $client = new PhpOrient(); $client->hostname = '127.0.0.1'; $client->port = 2424; $client->username = '******'; $client->password = '******'; $client->connect(); $client->dbOpen('Smile', 'root', 'root'); return $client; }
public function testDoubleDeserialization() { $db_name = 'test_date'; $client = new PhpOrient('localhost', 2424); $client->connect('root', 'root'); try { $client->dbDrop($db_name, Constants::STORAGE_TYPE_MEMORY); } catch (\Exception $e) { // echo $e->getMessage(); $client->getTransport()->debug($e->getMessage()); } $client->dbCreate($db_name, Constants::STORAGE_TYPE_MEMORY, Constants::DATABASE_TYPE_GRAPH); $client->dbOpen($db_name, 'admin', 'admin'); $client->command("create class Test extends V"); $client->command("create property Test.myDate date"); $client->command("insert into Test set myDate='2015-01-01'"); $start = microtime(true); $result = $client->query("SELECT FROM Test WHERE myDate <= '2015-10-17'"); $end = microtime(true); $this->assertTrue($end - $start < 1); $this->assertNotEmpty($result); }
public function testWrongTokenWithNoInitialization() { // print_r( new \DateTime() ); $client = new PhpOrient('localhost', 2424); $client->setSessionToken(true); // set true to enable the token based authentication $clusterID = $client->dbOpen("GratefulDeadConcerts", 'admin', 'admin'); $sessionToken = $client->getSessionToken(); // store this token somewhere file_put_contents("token.bin", $sessionToken); unset($client); $sessionToken = file_get_contents("token.bin"); unlink("token.bin"); // start a new connection $client = new PhpOrient('localhost', 2424); // set the previous received token to re-attach to the old session $client->setSessionToken($sessionToken . "WRONG_TOKEN"); // $client->setSessionToken( $sessionToken ); $this->setExpectedException('\\PhpOrient\\Exceptions\\SocketException'); //now the dbOpen is not needed to perform database operations $client->query('select * from V limit 10'); }
public function __construct(BindingParameters $parameters) { $this->client = $client = new PhpOrient($parameters->getHost(), $parameters->getPort()); $this->clusterMap = $client->dbOpen($parameters->getDatabase(), $parameters->getUsername(), $parameters->getPassword()); }
/** * */ public function testLinkSetCreation() { $config = static::getConfig('connect'); $client = new PhpOrient('localhost', 2424); $client->configure(array('username' => $config['username'], 'password' => $config['password'])); $client->connect(); try { $client->dbDrop('temp', Constants::STORAGE_TYPE_MEMORY); } catch (\Exception $e) { // echo $e->getMessage(); $client->getTransport()->debug($e->getMessage()); } $client->dbCreate('temp', Constants::STORAGE_TYPE_MEMORY, Constants::DATABASE_TYPE_DOCUMENT); $client->dbOpen('temp'); $client->sqlBatch(' create class Test1; create property Test1.aString string; insert into Test1 (aString) VALUES ("b"),("c"),("d"); create class Test2; create property Test2.aString string; create property Test2.anEmbeddedSetOfString embeddedset string; create property Test2.aLinkedSetOfTest1 linkset Test1;'); $clusterTest1 = $client->query("select classes[name='Test1'].defaultClusterId from 0:1", -1)[0]['classes']; $clusterTest2 = $client->query("select classes[name='Test2'].defaultClusterId from 0:1", -1)[0]['classes']; $this->assertEquals('9', $clusterTest1); $this->assertEquals('10', $clusterTest2); $newRecord = ['oClass' => 'Test2', 'oData' => ['aString' => 'Test record', 'anEmbeddedSetOfString' => ['something 1', 'something 2', 'more other'], 'aLinkedSetOfTest1' => [new ID($clusterTest1, 1), new ID($clusterTest1, 2)]]]; $newRecordObject = Record::fromConfig($newRecord); $newRecordObject->setRid(new ID($clusterTest2)); $tmp = $client->recordCreate($newRecordObject); $this->assertInstanceOf('\\PhpOrient\\Protocols\\Binary\\Data\\Record', $tmp); /** * @var \PhpOrient\Protocols\Binary\Data\Record $record */ $record = $client->recordLoad($tmp->getRid())[0]; $this->assertEquals('Test record', $record->aString); $this->assertArrayHasKey(0, $record->anEmbeddedSetOfString); $this->assertArrayHasKey(1, $record->anEmbeddedSetOfString); $this->assertArrayHasKey(2, $record->anEmbeddedSetOfString); $this->assertEquals('something 1', $record->anEmbeddedSetOfString[0]); $this->assertEquals('something 2', $record->anEmbeddedSetOfString[1]); $this->assertEquals('more other', $record->anEmbeddedSetOfString[2]); $this->assertArrayHasKey(0, $record->aLinkedSetOfTest1); $this->assertArrayHasKey(1, $record->aLinkedSetOfTest1); $this->assertInstanceOf('\\PhpOrient\\Protocols\\Binary\\Data\\ID', $record->aLinkedSetOfTest1[0]); $this->assertInstanceOf('\\PhpOrient\\Protocols\\Binary\\Data\\ID', $record->aLinkedSetOfTest1[1]); $aLinkedSetOfTest1 = $record->aLinkedSetOfTest1; /** * @var \PhpOrient\Protocols\Binary\Data\ID[] $aLinkedSetOfTest1 */ $this->assertEquals('#9:1', $aLinkedSetOfTest1[0]->jsonSerialize()); $this->assertEquals('#9:2', $aLinkedSetOfTest1[1]->__toString()); }
public function testWrongClusterID() { $client = new PhpOrient('localhost', 2424); $client->dbOpen('GratefulDeadConcerts', 'admin', 'admin'); $records = $client->query('select song_type, name from V '); /** * @var Record[] $records */ foreach ($records as $k => $rec) { if ($client->getTransport()->getProtocolVersion() < 26) { $this->assertEquals($k + 1, $rec->getRid()->position); } else { $this->assertEquals($k, $rec->getRid()->position); } $this->assertEquals(-2, $rec->getRid()->cluster); } }
/** * Creates the client connection instance. * This method is called by [[open]] to establish a DB connection. * The default implementation will create a PhpOrient instance. * You may override this method if the default client needs to be adapted for certain DBMS. * @return client the pdo instance */ public function createClientInstance() { $client = new PhpOrient(); $client->configure(['username' => $this->username, 'password' => $this->password, 'hostname' => $this->hostname, 'port' => $this->port]); $client->connect(); $client->dbOpen($this->dbname); return $client; }
public function testRecordData() { $db_name = 'test_record_data'; $client = new PhpOrient('localhost', 2424); $client->connect('root', 'root'); $this->skipTestByOrientDBVersion(['2.0.13', '1.7.10']); try { $client->dbDrop($db_name, Constants::STORAGE_TYPE_MEMORY); } catch (\Exception $e) { // echo $e->getMessage(); $client->getTransport()->debug($e->getMessage()); } $client->dbCreate($db_name, Constants::STORAGE_TYPE_MEMORY, Constants::DATABASE_TYPE_GRAPH); $client->dbOpen($db_name, 'admin', 'admin'); $client->command("create class Test extends V"); $client->command("create property Test.id string"); $client->command("alter property Test.id DEFAULT uuid()"); $rec = (new Record())->setOData([])->setRid(new ID(11)); $record = $client->recordCreate($rec); $this->assertArrayHasKey('id', $record); $this->assertNotEmpty($record['id']); }
<?php use PhpOrient\PhpOrient; use PhpOrient\Protocols\Binary\Data\ID; use PhpOrient\Protocols\Binary\Data\Record; require 'vendor/autoload.php'; $client = new PhpOrient('orientdb3', 2424); $client->connect('root', 'rootpwd'); if ($client->dbExists('demo')) { $client->dbDrop('demo'); } $client->dbCreate('demo'); $client->dbOpen('demo'); // Create a new collection $clusterId = $client->command('create class Elements extends V'); // Add new documents $document1 = new Record(); $document1->setOData(['now' => date('Y-m-d H:i:s')]); $document1->setRid(new ID($clusterId)); $document2 = new Record(); $document2->setOData(["created" => ['during' => ['VilniusPHP', 'event']]]); $document2->setRid(new ID($clusterId)); $record1 = $client->recordCreate($document1); $record2 = $client->recordCreate($document2); // Read them all $documents = $client->query('select from Elements'); foreach ($documents as $document) { /** @var $document Record */ echo '<h2>' . $document->getRid() . '</h2>'; echo "<div><b>Class:</b> {$document->getOClass()}</b>"; echo "<div><b>Revision:</b> {$document->getVersion()}</b>";
public function testWrongProtocol_2() { $client = new PhpOrient('localhost', 2424); $this->setExpectedException('\\PhpOrient\\Exceptions\\PhpOrientWrongProtocolVersionException'); $client->dbOpen('GratefulDeadConcerts', 'admin', 'admin', ['serializationType' => PhpOrient::SERIALIZATION_SERIAL_BIN]); }