Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options

Re^3: MongoDB replacing an array

by Mr. Muskrat (Canon)
on Aug 26, 2012 at 18:07 UTC ( #989859=note: print w/replies, xml ) Need Help??

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

And you're sure that @new is not empty at the point of the insert? Have you tried printing out its contents to be sure?

Replies are listed 'Best First'.
Re^4: MongoDB replacing an array
by neilwatson (Priest) on Aug 26, 2012 at 18:10 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

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://989859]
[stevieb]: james28909: what's the problem/question?
[james28909]: it is not an absolute date like "27" or "31". sometimes it is like wednesday or friday
[james28909]: and i need to format those special instances into an absolute date instead of "yesterday"
[stevieb]: ask a question on SoPW, and include at least a half-dozen examples of the input, and at least one example of expected output
[davido]: Exactly: SoPW. This isn't going to be solved easily in the CB.
[james28909]: in need "yesterday" and so on, to be absolute like "1" or "31"
[stevieb]: ...and throw some of your existing code into the equation as well, just so readers know you've given a try at it ;)
[james28909]: ok
[stevieb]: davido thanks for the link ;) I was being the typical lazy
[davido]: date parsing is hard. The more examples you can provide of the input (within reason) and expected output, the better.

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (4)
As of 2017-04-29 02:36 GMT
Find Nodes?
    Voting Booth?
    I'm a fool:

    Results (531 votes). Check out past polls.