require "./vendor/autoload.php";

use PhpOrient\PhpOrient;
use PhpOrient\Protocols\Binary\Data\Record;

$database_name = 'datetime';
$table_name = 'DateTime';

$client           = new PhpOrient( '192.168.1.1', 2424 );
$client->username = 'root';
$client->password = 'root';
$client->connect();

prepareDB( $client, $database_name, $table_name );

$clusterId = $client->dbOpen( $database_name, 'admin', 'admin' );
$client->command( "drop property DateTime.defaultDate" );
$client->command( "create property DateTime.defaultDate Date" );
$client->command( "INSERT INTO DateTime ( defaultDate ) VALUES ( '1600-02-28 01:01:55' )" );


$client->command( "insert into DateTime ( data ) VALUES ( Date( '1334-11-27 03:17:58' ) )" );


$result = $client->query( "Select * from DateTime" );
var_export($result);


$odata = [
        "fromPHPDateTime" => new Datetime( '1377-12-28 14:17:06' ) ,
];

$rec = ( new Record() )->setOClass("DateTime")->setOData( $odata );

$client->recordCreate( $rec );


$result = $client->query( "Select * from DateTime" );
var_export($result);


function prepareDB( PhpOrient $client, $database_name, $table_name ){

    if( !$client->dbExists( $database_name ) ){

        $clusterId = $client->dbCreate( $database_name, PhpOrient::STORAGE_TYPE_MEMORY );
        $client->dbOpen( $database_name, 'admin', 'admin' );
        $client->command( "create class $table_name extends V" );

    }

    $client->dbOpen( 'datetime', 'admin', 'admin' );
    $client->command( "DELETE FROM DateTime UNSAFE" );

}