1st CIE Paper
INSERT :-
No
|
Documents / Queries
|
1
|
db.bus_master.insert({
"_id" : 1,
BusNo : 101,
DriverName : "Ramjibhai",
City : [{From: "Rajkot"},{To : "Ahmedbad"}],
Date : [{Departure : new ISODate("2019-04-11")},
{Arrival : new ISODate("2019-04-12")}],
TotalSeats : 56,
Price : 265,
})
|
2
|
db.bus_master.insertMany([{
"_id" : 2,
BusNo : 102,
DriverName : "Kishanbhai",
City : [{From:"Jamnagar"},{To:"Ahmedbad"}],
Date : [{Departure : new ISODate("2018-12-01")},
{Arrival : new ISODate("2018-12-02")}],
TotalSeats : 36,
Price : 300,
},{
"_id" : 3,
BusNo : 103,
DriverName : "Pareshbhai",
City : [{From:"Gondal"},{To:"Rajkot"}],
Date : [{Departure : new ISODate("2018-12-31")},
{Arrival : new ISODate("2019-01-01")}],
TotalSeats : 56,
Price : 100,
}])
|
3
|
db.bus_master.insertMany([{
"_id" : 4,
BusNo : 106,
DriverName : "Jigarbhai",
City : [{From:"Rajkot"},{To:"Surat"}],
Date : [{Departure : new ISODate("2018-12-01")},
{Arrival : new ISODate("2018-12-03")}],
TotalSeats : 50,
Price : 600,
},{
"_id" : 5,
BusNo : 105,
DriverName : "Rakeshbhai",
City : [{From:"Surat"},{To:"Gondal"}],
Date : [{Departure : new ISODate("2018-11-30")},
{Arrival : new ISODate("2018-12-02")}],
TotalSeats : 56,
Price : 800,
}])
|
Query:-
No.
|
Commands Description
|
Commands
|
1
|
Display all the buses going from Rajkot to Surat.
|
db.bus_master.find(
{"City.From":"Rajkot",
"City.From":"Surat"},
{City:1}
)
|
