Ostico / PhpOrient

PhpOrient - Official Php driver based on the binary protocol of OrientDB.
Other
68 stars 37 forks source link

How to get all insert id when using multiple insert in a single query #35

Closed rinirinku closed 9 years ago

rinirinku commented 9 years ago

The following query is for multiple insert

insert into con_user_event  (title, description, event_date,is_visible,status,created_date,updated_date) 
values   ('Test a new daily2 ',   'Test a new daily event ', '2015-10-25 11:50:00' ,  true ,
                'true', '2015-07-27 09:39:17',  '2015-07-27 09:39:17' ),
            ('Test a new daily2 ',   'Test a new daily event ', '2015-10-26 11:50:00' ,    true ,
                    'true', '2015-07-27 09:39:30', '2015-07-27 09:39:30'  )

returns only one rid

 PhpOrient\Protocols\Binary\Data\Record Object
(
    [rid:protected] => PhpOrient\Protocols\Binary\Data\ID Object
        (
            [cluster] => 17
            [position] => 2093
        )

    [oClass:protected] => con_user_event
    [version:protected] => 2
    [oData:protected] => Array
        (
            [title] => Test a new daily2 
            [description] => Test a new daily event 
            [event_date] => DateTime Object
                (
                    [date] => 47784-09-30 01:20:00
                    [timezone_type] => 1
                    [timezone] => +00:00
                )

            [is_visible] => 1
            [status] => 1
            [created_date] => 2015-07-27 09:39:17
            [updated_date] => 2015-07-27 09:39:17
        )

)

How to get all the insert id from the above query

Ostico commented 9 years ago

Now multiple inserts returns multiple records.