Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re^4: MongoDB replacing an array

by neilwatson (Curate)
on Aug 26, 2012 at 18:10 UTC ( #989861=note: print w/ replies, xml ) Need Help??


in reply to Re^3: MongoDB replacing an array
in thread MongoDB replacing an array

@new is definitely not empty. Have printed it.

Neil Watson
watson-wilson.ca


Comment on Re^4: MongoDB replacing an array
Re^5: MongoDB replacing an array
by Mr. Muskrat (Abbot) on Aug 26, 2012 at 18:39 UTC

    Okay, let's look at what you have.

    The MongoDB::Collection docs show that update takes three hash references (\%criteria, \%object and \%options).

    $col->update( { "host" => $host }, { '$set' => { "timestamp" => [ @new ] } }, { 'multiple' => 1, 'safe' => 1 } ) || die "$!";

    Your criteria is simply host = $host. Your object should set timestamp to the contents of @new. Your options include multiple which tells it to update all matching records and safe which causes it to croak on errors (so the || die you have is superfluous).

    Are you getting any errors or do the records just end up empty?

    Based on the docs, it looks right. So what's missing? We don't know. Without seeing more of the code, I don't think anyone will be able to help you.

      There is not much more to show. Most is boring data manipulation that leads to the final array. The array holds only numbers. Nothing embedded.

      my $conn = MongoDB::Connection->new; my $db = $conn->mydb || die "$!"; my ($col, $cols, @cols, $q, $doc, @b, @c, @new, $x, $date, $l, $host); + @cols = $db->collection_names; foreach $cols (@cols) {

      Above a loop through some collections and for each make the new array. Then I try to replace the array.

      if ( @new > 1 ){ foreach my $xxx (@new){ print '@new = '.strftime('%Y-%m-%d', l +ocaltime($xxx))."\n"; } $col->update( { "host" => $host }, { '$set' => { "timestamp" => @new } }, { 'multiple' => 1, 'safe' => 1 } ) || die "$!";

      The foreach loop above is just to show there is data in @new. That works :). The update fails. The documentation for MongoDB is a bit sparse. I assume my syntax is wrong. Alas, I cannot figure how.

      Neil Watson
      watson-wilson.ca

        I'm hoping that I can learn a bit about MongoDB from trying to help you. Is the update happening within the @cols foreach loop? How are you getting $col? $col = $db->$cols;?

        Based on your @new foreach print, it looks like you are storing multiple timestamps in each record. Is that what you intended? If so, it seems odd to me to store timestamps in a column named timestamp. :)

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://989861]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (4)
As of 2014-09-20 19:52 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (160 votes), past polls