&lt;!-- language-all: lang-js --&gt;

Well there is the respective documentation to view for both [**`.update()`**][1] and [**`.findAndModify()`**][2] which is the root method of `.findOneAndUpdate()` here.

But in the main differences there are:

 * **update()**: Is meant to perform an atomic update operation against &quot;one or more&quot; documents matched by it&#39;s query condition in a collection. It returns the number of modified documents in it&#39;s response.

 * **findOneAndUpdate()**: Has the purpose of both processing an update statment on a &quot;singular&quot; document, as well as retrieving the content of that &quot;singular&quot; document. The state returned depends on the value of the &quot;new&quot; option as passed to the operation. Where `true` the &quot;modified&quot; document is returned. Where `false` the &quot;original&quot; document is returned before any modification. The latter form is the default option.

In short. One is meant to modify in &quot;bulk&quot; and not worry with the document content in result. And the other is meant to modify a singular document and return the document content in result.

That&#39;s the difference.

  [1]: http://docs.mongodb.org/manual/reference/method/db.collection.update/
  [2]: http://docs.mongodb.org/manual/reference/method/db.collection.findAndModify/

The [`.findOneAndUpdate`][1] method issues a mongodb [`.findAndModify`][2] update command  and returns the found document (if any) to the callback or return the modified document rather than the original if the `new` option is `true` and the [`.update`][3] execute the query as an [`update()`][4] operation.

  [1]: http://mongoosejs.com/docs/api.html#query_Query-findOneAndUpdate
  [2]: http://www.mongodb.org/display/DOCS/findAndModify+Command
  [3]: http://mongoosejs.com/docs/api.html#query_Query-update
  [4]: http://docs.mongodb.org/manual/reference/method/db.collection.update/

Note there is an option `returnNewDocument` in the findOneAndXXX methods and it&#39;s default value is `true`. If you are using the node.js driver, the options is called `returnOriginal`.

I need to use/continue developing a desktop app developed using .NET on my Mac. Is there a .NET framework 4.0 available for Mac? Would this allow running and developing of .NET-based apps on a Mac?

Another option that i am considering is using a windows virtual machine on the Mac.

Can you install and run apps built on the .NET framework on a Mac?

I&#39;m using the Python [requests lib][1] to get a PDF file from the web. This works fine, but I now also want the original filename. If I go to a PDF file in Firefox and click `download` it already has a filename defined to save the pdf. How do I get this filename?

For example:

    import requests
    r = requests.get(&#39;http://www.researchgate.net/profile/M_Gotic/publication/260197848_Mater_Sci_Eng_B47_%281997%29_33/links/0c9605301e48beda0f000000.pdf&#39;)
    print r.headers[&#39;content-type&#39;]  # prints &#39;application/pdf&#39;

I checked the `r.headers` for anything interesting, but there&#39;s no filename in there. I was actually hoping for something like `r.filename`..

Does anybody know how I can get the filename of a downloaded PDF file with requests library?


  [1]: http://docs.python-requests.org/en/latest/

How to get pdf filename with Python requests?

What is the difference between findOneAndUpdate and update?

Both accept criteria to query and doc to update.

mongoose difference of findOneAndUpdate and update

<p>What is the difference between findOneAndUpdate and update?</p>
<p>Both accept criteria to query and doc to update.</p>


I want to combine multiple databases in my system. Most of the time the database is MySQL; but it may differ in future i.e. Admin can generate such a reports  which is **use source of heterogeneous** database system.

So my question is **does Laravel provide any Facade** to deal with such situations? Or any other framework have more suitable capabilities for problem is?

How to use multiple databases in Laravel

How can I connect to my RDS instance using pg_dump?

This is the instance&#39;s endpoint:

    &lt;long public dns thing&gt;:5432

So I&#39;m running this command:

    pg_dump -h &lt;long public dns thing&gt; -p 5432 -f dump.sql

And getting this:

    pg_dump: [archiver (db)] connection to database &quot;brendan&quot; failed:
    could not connect to server: Connection refused
    Is the server running on host &quot;&lt;long public dns thing&gt;&quot;
    (&lt;IP address&gt;) and accepting TCP/IP connections on port 5432?

This is Amazon&#39;s troubleshooting advice:

***Cannot Connect to Amazon RDS PostgreSQL DB Instance***

*The most common problem when attempting to connect to a PostgreSQL DB instance is that the security group assigned to the DB instance has incorrect access rules. By default, DB instances do not allow access; access is granted through a security group. To grant access, you must create your own security group with specific ingress and egress rules for your situation. For more information about creating a security group for your DB instance, see Create a Security Group.*

*The most common error is could not connect to server: Connection timed out. If you receive this error, check that the host name is the DB instance endpoint and that the port number is correct. Check that the security group assigned to the DB instance has the necessary rules to allow access through your local firewall.*

Is there a way to specify my security group from pg_dump?  If so, do I have to get a local copy of that the way that I need an ssh key when ssh&#39;ing?

Is it a mistake to even try to use pg_dump remotely?  Should I be trying to just ssh onto the instance instead, or doing something else entirely?

How to pg_dump an RDS Postgres database?

I am learning MySQL and tried using a `LOAD DATA` clause. When I used it as below:

    LOAD DATA INFILE &quot;text.txt&quot; INTO table mytable;

I got the following error:

&gt; The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

How do I tackle this error?

I have checked [another question on the same error message][1], but still can’t find a solution.

I am using MySQL 5.6

  [1]: https://stackoverflow.com/questions/31951468/error-code-1290-the-mysql-server-is-running-with-the-secure-file-priv-option

How should I resolve --secure-file-priv in MySQL?

What is the difference between wait-die and wound-wait algorithms?

It seems that both of these deadlock prevention techniques are doing the same thing: A Rollback of older process.

What is the difference between the two? 

Please provide a suitable example to contrast the two algorithms.

What is the difference between &quot;wait-die&quot; and &quot;wound-wait&quot; deadlock prevention algorithms?

So I have this tiny query to run on my DB and it works fine in MySQL Workbench.
Basically, a SELECT with LEFT JOIN and UNION with LEFT JOIN again.

    SELECT
    	cards.id_card,
    	cards.hash_card,
        cards.`table`,
        users.name,
        0 as total,
        cards.card_status,
        cards.created_at
    FROM cards
    LEFT JOIN users
    ON users.id_user = cards.id_user
    WHERE hash_card NOT IN ( SELECT orders.hash_card FROM orders )
    UNION
    SELECT
    	cards.id_card,
    	orders.hash_card,
    	cards.`table`,
        users.name,
        sum(orders.quantity*orders.product_price) as total, 
        cards.card_status, 
        max(orders.created_at) 
    FROM menu.orders
    LEFT JOIN cards
    ON cards.hash_card = orders.hash_card
    LEFT JOIN users
    ON users.id_user = cards.id_user
    GROUP BY hash_card
    ORDER BY id_card ASC

In tried to translate it to Laravel, with no success.

    $cards = Card::selectRaw(&#39;cards.id_card, cards.hash_card ,cards.table, users.name, 0 as total, cards.card_status, cards.created_at as last_update&#39;)
    				-&gt;leftJoin(&#39;users&#39;,&#39;users.id_user&#39;,&#39;=&#39;,&#39;cards.id_user&#39;)
    				-&gt;whereNotIn( &#39;hash_card&#39;, Order::select(&#39;orders.hash_card&#39;)-&gt;get() )
    				-&gt;union(
    						Order::selectRaw(&#39;cards.id_card, orders.hash_card, cards.table, users.name, sum(orders.quantity*orders.product_price) as total, cards.card_status, max(orders.created_at) as last_update&#39;)
    						-&gt;leftJoin(&#39;cards&#39;,&#39;cards.hash_card&#39;,&#39;=&#39;,&#39;orders.hash_card&#39;)
    						-&gt;leftJoin(&#39;users&#39;,&#39;users.id_user&#39;,&#39;=&#39;,&#39;cards.id_user&#39;)
    				)
    				-&gt;groupBy(&#39;hash_card&#39;)
    				-&gt;orderBy(&#39;cards.id_card&#39;,&#39;asc&#39;)
    				-&gt;get();

I&#39;m getting the error 

&gt; ErrorException in Builder.php line 1249: Undefined property:
&gt; Illuminate\Database\Eloquent\Builder::$bindings

How could I execute a completely raw query in Laravel or write the query in the right manner in Laravel?

How to execute raw queries with Laravel 5.1?

When I create backup of all databases in MongoDB (version 3):

    mongodump --username bacUser --password 12345

It&#39;s OK. But when I try to create backup of a selected db:

    mongodump --username bacUser --password 12345 --db test

It gives me this error:

&gt; Failed: error connecting to db server: server returned error on SASL authentication step: Authentication failed.

Can&#39;t create backup mongodump with --db. Authentication failed

I have a mongodb collection like:

    db.kids.find()
    //results
    [
        {name:&#39;tom&#39;, age:10},
        {name:&#39;alice&#39;, age:12},
        ....
    ]

I need a query to get MAX &#39;age&#39; from this collection
like in SQL: `SELECT MAX(age) FROM kids WHERE 1`


mongodb how to get max value from collections

I installed mongodb in Ubuntu14.04 server

I was not able to connect to mongodb via &quot;mongoimport&quot;, &quot;mongodump&quot;, &quot;mongostat&quot;, etc. It always show &quot;no reachable server&quot;

    mongoimport --db test --collection restaurants --drop --file dataset.json
    2015-08-25T13:08:29.802+0800	[........................] test.restaurants	0.0 B/11.3 MB (0.0%)
    2015-08-25T13:08:30.306+0800	Failed: error connecting to db server: no reachable servers
    2015-08-25T13:08:30.306+0800	imported 0 documents

Somehow, I was able to connect with mongo shell

    mongo --port 27017
    MongoDB shell version: 3.0.6
    connecting to: 127.0.0.1:27017/test

At first, I doubt if it cause by my iptables, so I flush all iptables rules and create rules for ALL accept, but it still same

     sudo iptables -S
        -P INPUT ACCEPT
        -P FORWARD ACCEPT
        -P OUTPUT ACCEPT
        -A INPUT -j ACCEPT
        -A INPUT -i lo -j ACCEPT
        -A FORWARD -j ACCEPT
        -A OUTPUT -j ACCEPT
        -A OUTPUT -o lo -j ACCEPT

I search the stackOverflow and google and someone told marked off 
bind_ip or set bind_ip to 0.0.0.0, I tried all but still failed.


Below are my mangodb config, would any one can help me to check?
Thanks for your help

    james@localhost:~$ cat /etc/mongod.conf 
    # mongod.conf
    
    # Where to store the data.
    
    # Note: if you run mongodb as a non-root user (recommended) you may
    # need to create and set permissions for this directory manually,
    # e.g., if the parent directory isn&#39;t mutable by the mongodb user.
    dbpath=/var/lib/mongodb
    
    #where to log
    logpath=/var/log/mongodb/mongod.log
    
    logappend=true
    
    port = 27017
    
    # Listen to local interface only. Comment out to listen on all interfaces. 
    #bind_ip = 127.0.0.1
    # Disables write-ahead journaling
    # nojournal = true
    
    # Enables periodic logging of CPU utilization and I/O wait
    #cpu = true
    
    # Turn on/off security.  Off is currently the default
    #noauth = true
    #auth = true
    
    # Verbose logging output.
    verbose = true
    
    # Inspect all client data for validity on receipt (useful for
    # developing drivers)
    #objcheck = true
    
    # Enable db quota management
    #quota = true
    
    # Set oplogging level where n is
    #   0=off (default)
    #   1=W
    #   2=R
    #   3=both
    #   7=W+some reads
    #diaglog = 0
    
    # Ignore query hints
    #nohints = true
    
    # Enable the HTTP interface (Defaults to port 28017).
    #httpinterface = true
    
    # Turns off server-side scripting.  This will result in greatly limited
    # functionality
    #noscripting = true
    
    # Turns off table scans.  Any query that would do a table scan fails.
    #notablescan = true
    
    # Disable data file preallocation.
    #noprealloc = true
    
    # Specify .ns file size for new databases.
    # nssize = &lt;size&gt;
    
    # Replication Options
    
    # in replicated mongo databases, specify the replica set name here
    #replSet=setname
    # maximum size in megabytes for replication operation log
    #oplogSize=1024
    # path to a key file storing authentication info for connections
    # between replica set members
    #keyFile=/path/to/keyfile




mongodb Failed: error connecting to db server: no reachable servers

I have an array of ids and I want to get  all document of them at once. For that I am writing but it return 0 records.

How can I search using multiple Ids ?

    db.getCollection(&#39;feed&#39;).find({&quot;_id&quot; : { &quot;$in&quot; : [  
    &quot;55880c251df42d0466919268&quot;,&quot;55bf528e69b70ae79be35006&quot; ]}})

I am able to get records by passing single id like               

    db.getCollection(&#39;feed&#39;).find({&quot;_id&quot;:ObjectId(&quot;55880c251df42d0466919268&quot;)})


How to get multiple document using array of MongoDb id?

Below is my code
    
    var mongoose = require(&#39;mongoose&#39;);
    mongoose.connect(&#39;mongodb://localhost/test&#39;);

    var Cat = mongoose.model(&#39;Cat&#39;, {
        name: String,
        age: {type: Number, default: 20},
        create: {type: Date, default: Date.now} 
    });

    Cat.findOneAndUpdate({age: 17}, {$set:{name:&quot;Naomi&quot;}},function(err, doc){
        if(err){
            console.log(&quot;Something wrong when updating data!&quot;);
        }

        console.log(doc);
    });

I already have some record in my mongo database and I would like to run this code to update name for which age is 17 and then print result out in the end of code.

However, why I still get same result from console(not the modified name) but when I go to mongo db command line and type &quot;`db.cats.find();`&quot;. The result came with modified name.

Then I go back to run this code again and the result is modified.

My question is:  If the data was modified, then why I still got original data at first time when console.log it.

 

Mongoose: findOneAndUpdate doesn&#39;t return updated document

Basically I have a mongodb collection called &#39;people&#39;
whose schema is as follows: 

    people: {
             name: String, 
             friends: [{firstName: String, lastName: String}]
            }

Now, I have a very basic express application that connects to the database and successfully creates &#39;people&#39; with an empty friends array.

In a secondary place in the application, a form is in place to add friends. The form takes in firstName and lastName and then POSTs with the name field also for reference to the proper people object. 

What I&#39;m having a hard time doing is creating a new friend object and then &quot;pushing&quot; it into the friends array.

I know that when I do this via the mongo console I use the update function with `$push` as my second argument after the lookup criteria, but I can&#39;t seem to find the appropriate way to get mongoose to do this.

    db.people.update({name: &quot;John&quot;}, {$push: {friends: {firstName: &quot;Harry&quot;, lastName: &quot;Potter&quot;}}});

Push items into mongo array via mongoose

I&#39;m looking for a way to refactor part of my code to be shorter and simpler, but I don&#39;t know Mongoose very well and I&#39;m not sure how to proceed.

I am trying to check a collection for the existence of a document and, if it doesn&#39;t exist, create it. If it does exist, I need to update it. In either case I need to access the document&#39;s contents afterward.

What I&#39;ve managed to do so far is query the collection for a specific document and, if it&#39;s not found, create a new document. If it is found, I update it (currently using dates as dummy data for this). From there I can access either the found document from my initial `find` operation or the newly saved document and this works, but there must be a better way to accomplish what I&#39;m after.

Here&#39;s my working code, sans distracting extras.

    var query = Model.find({
        /* query */
    }).lean().limit(1);
    
    // Find the document
    query.exec(function(error, result) {
        if (error) { throw error; }
        // If the document doesn&#39;t exist
        if (!result.length) {
            // Create a new one
            var model = new Model(); //use the defaults in the schema
            model.save(function(error) {
                if (error) { throw error; }
                // do something with the document here
            });
        }
        // If the document does exist
        else {
            // Update it
            var query = { /* query */ },
                update = {},
                options = {};
    
            Model.update(query, update, options, function(error) {
                if (error) { throw error; }
                // do the same something with the document here
                // in this case, using result[0] from the topmost query
            });
        }
    });

I&#39;ve looked into `findOneAndUpdate` and other related methods but I&#39;m not sure if they fit my use case or if I understand how to use them correctly. Can anyone point me in the right direction?

(Probably) Related questions:

 - [How to check if that data already exist in the database during update (Mongoose And Express)][1]
 - [Mongoose.js: how to implement create or update?][2]
 - [NodeJS + Mongo: Insert if not exists, otherwise - update][3]
 - [Return updated collection with Mongoose][4]


----------

Edit
----

I didn&#39;t come across the question pointed out to me in my searching, but after reviewing the answers there I&#39;ve come up with this. It&#39;s certainly prettier, in my opinion, and it works, so unless I&#39;m doing something horribly wrong I think my question can probably be closed.

I would appreciate any additional input on my solution.

    // Setup stuff
    var query = { /* query */ },
        update = { expire: new Date() },
        options = { upsert: true };
    
    // Find the document
    Model.findOneAndUpdate(query, update, options, function(error, result) {
        if (!error) {
            // If the document doesn&#39;t exist
            if (!result) {
                // Create it
                result = new Model();
            }
            // Save the document
            result.save(function(error) {
                if (!error) {
                    // Do something with the document
                } else {
                    throw error;
                }
            });
        }
    });

  [1]: https://stackoverflow.com/q/16882938
  [2]: https://stackoverflow.com/q/13337685
  [3]: https://stackoverflow.com/q/13010290
  [4]: https://stackoverflow.com/q/20667739

Mongoose - Create document if not exists, otherwise, update- return document in either case

I am trying to get data from my mongoDB database by using mongoose filters. The scenario is that each user object in the database has certain fields like **&quot;Region&quot;** or **&quot;Sector&quot;**.

Currently I am getting all the users that contain the keyword **&quot;region&quot;** in there object like so:

     // Filter all healthcare bios by region
     app.get(&#39;/user&#39;,function(req, res) {

	 // use mongoose to get all users in the database
	 User.find({region: &quot;NA&quot;}, function(err, user) 
	 {
		// if there is an error retrieving, send the error. nothing after res.send(err) will execute
		if (err)
		{
			res.send(err);
		}
		// return all todos in JSON format
		console.log(user);
		res.json(user);
		
	});
    });

**How can put some conditions in mongoose that it return users that contain both &quot;region&quot; &amp;&amp; &quot;Sector&quot; in their objects.** Currently its only returning the user which have the region keyword in them. 

I have tried using $and operator but I couldn&#39;t get it to work.

mongoose &quot;Find&quot; with multiple conditions

Trying to implement a Mongoose model in Typescript.  Scouring the Google has revealed only a hybrid approach (combining JS and TS).  How would one go about implementing the User class, on my rather naive approach, without the JS?

Want to be able to IUserModel without the baggage.

    import {IUser} from &#39;./user.ts&#39;;
    import {Document, Schema, Model} from &#39;mongoose&#39;;

    // mixing in a couple of interfaces
    interface IUserDocument extends IUser,  Document {}

    // mongoose, why oh why &#39;[String]&#39; 
    // TODO: investigate out why mongoose needs its own data types
    let userSchema: Schema = new Schema({
      userName  : String,
      password  : String,
      firstName : String,
      lastName  : String,
      email     : String,
      activated : Boolean,
      roles     : [String]
    });

    // interface we want to code to?
    export interface IUserModel extends Model&lt;IUserDocument&gt; {/* any custom methods here */}

    // stumped here
    export class User {
      constructor() {}
    }

Mongoose the Typescript way...?

How to update mysql data in bulk ?
How to define something like this :

    UPDATE `table` 
    WHERE `column1` = somevalues
    SET  `column2` = othervalues

with somevalues like :

    VALUES
    	(&#39;160009&#39;),
    	(&#39;160010&#39;),
    	(&#39;160011&#39;);
and othervalues :

    VALUES
    	(&#39;val1&#39;),
    	(&#39;val2&#39;),
    	(&#39;val3&#39;);

maybe it&#39;s impossible with mysql ?
a php script ?

Bulk update mysql with where statement

I am using android room persistence library for my new project.
I want to update some field of table. 
I have tried like in my `Dao` -

    // Method 1:

    @Dao
    public interface TourDao {
        @Update
        int updateTour(Tour tour);
    }

But when I try to update using this method then it updates every field of the entity where it matches primary key value of tour object.
I have used `@Query`

    // Method 2:

    @Query(&quot;UPDATE Tour SET endAddress = :end_address WHERE id = :tid&quot;)
    int updateTour(long tid, String end_address);

 It is working but there will be many queries in my case because I have many fields in my entity. I want to know how can I update some field (not all) like `Method 1` where id = 1; (id is the auto generate primary key).

    // Entity:

    @Entity
    public class Tour {
        @PrimaryKey(autoGenerate = true)
        public long id;
        private String startAddress;
        private String endAddress;
        //constructor, getter and setter
    }



Update some specific field of an entity in android Room

I would like to update my column with other column in other table. Before doing so, I would like to nullify my column(integer) first. However, below code did not work. (column_a: bigint; column_b: text) 

&lt;!-- language: lang-sql --&gt;

    UPDATE table1
    SET column_a IS NULL
    WHERE column_b = &#39;XXX&#39;;

ERROR: syntax error at or near &quot;ISNULL&quot;


Content Type	Original Author	Original Content on Stackoverflow
Question	SooCheng Koh	View Question on Stackoverflow
Solution 1 - Database	Blakes Seven	View Answer on Stackoverflow
Solution 2 - Database	styvane	View Answer on Stackoverflow
Solution 3 - Database	clarkttfu	View Answer on Stackoverflow

mongoose difference of findOneAndUpdate and update

Database Problem Overview

Database Solutions

Solution 1 - Database

Solution 2 - Database

Solution 3 - Database

How to get pdf filename with Python requests?

Can you install and run apps built on the .NET framework on a Mac?

Attributions