Outputting id Only with .find()

CodeManFantastic · March 14, 2018, 6:30pm

@m_hutley it seems like its populating now

app.get('/console', (req, res, next) => {
    School.find({"Boarders": {'$regex': 'No B'}, "Gender": {'$regex': 'Mixed'}, "Town": {'$regex': 'London'}}, {"_id": 0, "Boarders": 1, "Gender": 1, "Town": 1})
        .exec(function (err, items) {
            if (err) { return next(err); }
            var myData = new School(req.body)
            console.log('schools', items);
            res.send('Check console.log for list of items');
        });
});

very very strange it seems to of worked? before I read your reply…

Express is running on port 3000
Mongoose connection open on mongodb://localhost:27017/test
Mongoose connection open on mongodb://localhost:27017/CSV
schools [ { _id: 5aa95da24b3656465499239d,
    Town: 'London',
    Gender: 'Mixed',
    Boarders: 'No B' },
  { _id: 5aa95dce1031443430b4880f,
    Town: '/London/',
    Gender: '/Mixed/',
    Boarders: '/No B/' },
  { _id: 5aa95e05d8d4b3378c3da510,
    Town: '/London/',
    Gender: '/Mixed/',
    Boarders: '/No B/' },
  { _id: 5aa95f1315e6592c9485fa5a,
    Town: '/London/',
    Gender: '/Mixed/',
    Boarders: '/No B/' },
  { _id: 5aa95f8cc79d8f4300aa87c4,
    Town: '/London/',
    Gender: '/Mixed/',
    Boarders: '/No B/' },
  { _id: 5aa95fc959b2c937c47fc085,
    Town: '/London/',
    Gender: '/Mixed/',
    Boarders: '/No B/' },
  { _id: 5aa95fed686bbe39284a2fef,
    Town: '/London/',
    Gender: '/Mixed/',
    Boarders: '/No B/' },
  { _id: 5aa960885a2dbe33889fdd90,
    Town: '/London/',
    Gender: '/Mixed/',
    Boarders: '/No B/' },
  { _id: 5aa9618aba68d13ed4d57303,
    Town: '/London/',
    Gender: '/Mixed/',
    Boarders: '/No B/' },
  { _id: 5aa9639b72e6e92c945b0bde,
    Town: '/London/',
    Gender: '/Mixed/',
    Boarders: '/No B/' },
  { _id: 5aa963d5b8940f2b6c276fa8,
    Town: '/London/',
    Gender: '/Mixed/',
    Boarders: '/No B/' },
  { _id: 5aa964808e012d2edca009b6,
    Town: '/London/',
    Gender: '/Mixed/',
    Boarders: '/No B/' } ]

m_hutley · March 14, 2018, 6:33pm

That looks like the remnants of repeated testing to me… (Because your actual table contains “No Boarders” in the Boarders column…)

I dont see any of your -actual- data, which means you’re still poking around in a different collection than you think you are…

CodeManFantastic · March 14, 2018, 6:38pm

maybe you are right but has this query pulled out the id now?

and it contrains the regex which is a like in mongodb… soon as i click the button in the html it shows all this data

so where would this be finding the ID from?

m_hutley · March 14, 2018, 6:46pm

You ran the script. It inserted a record into the collection. That generates an id automatically.
You changed the entry line to use /'s. You ran the script again. It inserted another record into the collection. That generated another id.
You did it again 6 more times. 6 more records. 6 more ID’s.

Back in Studio3T, what happens if you give it the command db.getCollectionInfos() ?

CodeManFantastic · March 14, 2018, 6:54pm

funny you say that there is no ID that matches what is in the console;

[
	{
		"name" : "Schools",
		"type" : "collection",
		"options" : {
			
		},
		"info" : {
			"readOnly" : false
		},
		"idIndex" : {
			"v" : 2,
			"key" : {
				"_id" : 1
			},
			"name" : "_id_",
			"ns" : "CSV.Schools"
		}

I run what you asked and got tthe following

m_hutley · March 14, 2018, 6:57pm

Try

db.adminCommand( { listDatabases: 1 } )

CodeManFantastic · March 14, 2018, 6:58pm

"databases" : [
	{
		"name" : "CSV",
		"sizeOnDisk" : 8241152,
		"empty" : false
	},

m_hutley · March 14, 2018, 7:00pm

I feel like that was an incomplete response. At the very least, there’s also a test database in there…

m_hutley · March 14, 2018, 7:02pm

Run the page script again (so that it puts another record into the collection), and then list the databases again. Look to see which one has gotten bigger. That’s the one the script is connected into.

CodeManFantastic · March 14, 2018, 7:29pm

I believe after refreshing the database list it shows the data in a new folder callec schools under the test database

so I need to somehow point this to the CSV database and Schools folder

m_hutley · March 14, 2018, 7:45pm

So let’s try this.

Remove the connection to /test entirely.
Remove the two lines (var entry… and entry.save()) from the app code.

Change your model line to read mongoose.model(‘School’, schoolsSchema,‘Schools’);

See if that works.

CodeManFantastic · March 14, 2018, 7:51pm

The only problem I currently face is I need the test database as it has inserts in the app.js connected to it for my other pages

so I basically need to make a new page and link the page to the new connection instead of using the app would that work do you think??

m_hutley · March 14, 2018, 7:55pm

Instead of calling .connect, The Docs say you should use createConnection, and then set the .db of your model to the one you create to the CSV database.

CodeManFantastic · March 14, 2018, 8:37pm

I had a quick fix pop into my brain,

I copied the table from CSV database to test and ran the script and it worked

School [ { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },
  { Town: 'London', Boarders: 'No Boarders', Gender: 'Mixed' },

system · June 14, 2018, 3:37am

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.