Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Calling stored JavaScript function in MongoDB from PHP

I have this function stored in db.system.js

function SomeFunc(o) {
    x = db.Collection;
    while( 1 ) {
        var c = x.find({},{_id:1}).sort({_id:-1}).limit(1);
        var i = c.hasNext() ? c.next()._id + 1 : 1;
        o._id = i;
        x.insert(o);
        var err = db.getLastErrorObj();
        if( err && err.code ) {
            if( err.code == 11000 /* dup key */ )
                continue;
            else
                print("unexpected error inserting data: " + tojson(err));
        }
        break;
    }
}

In PHP

print_r(
    $db->execute("SumeFunc(o)", array("name" => "test"))
);

Error

Array
(
    [errno] => -3
    [errmsg] => invoke failed: JS Error: ReferenceError: o is not defined nofile_a:0
    [ok] => 0
)
like image 732
amirka Avatar asked Feb 26 '23 01:02

amirka


1 Answers

$db->execute(
    new MongoCode('SomeFunc(o)', array(
        'o' => array('name' => 'test') 
    ))
);
like image 61
amirka Avatar answered Feb 28 '23 17:02

amirka