Simple JavaScript database

[eluser]Cyclops[/eluser]

Code:

//------------------------------------------------------------------------
    //------------------------------------------------------------------------
    // let's try an UPDATE on _everything_
    //
        update = {
            'records' : '*',
            'change' : [
                {'name':'new_field', 'value':'new_value'}
            ]
        }
        //alert( 'UPDATING: ' + print_r(update) );
        updated = newdb._update(update);
        //alert( 'UPDATED: '  + print_r(updated) );
        //alert( 'SELECT *: ' + print_r(newdb._select({'records':'*'})));
    //
    //------------------------------------------------------------------------
    //------------------------------------------------------------------------




    //------------------------------------------------------------------------
    //------------------------------------------------------------------------
    // an UPDATE with various criteria
    //
        update = {
            //'records' : '*',
            'records' : [
                //{'name':'name', 'value':'Mike'},
                //{'name':'children' , 'value':'2'}

                //{'name':'occupation' , 'value':'doctor'}
            ],
            'records_gt' : [
                //{'name':'children', 'value':2}

                //{'name':'name', 'value':'Mike'}
            ],
            'records_lt' : [
                //{'name':'children', 'value':4}
            ],
            'records_ne' : [
                //{'name':'children', 'value':2}
            ],
            'change' : [
                //{'name':'desired_children', 'value':'12'}//,
                //{'name':'name', 'value':'I am Cool'}
            ]
        }

        //update.limit       = 3;      // with a limit
        //update.limit_start = 2;      // with a limit_start
        //update.order_by    = 'name'; // with an ORDER BY
        //update.order_dir   = 'asc';  // with an order by direction
        //alert( 'UPDATING: ' + print_r(update) );
        updated = newdb._update(update);
        //alert( 'UPDATED: '  + print_r(updated) );
        //alert( 'SELECT *: ' + print_r(newdb._select({'records':'*'})));
    //
    //------------------------------------------------------------------------
    //------------------------------------------------------------------------