-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathindex.js
167 lines (148 loc) · 4.9 KB
/
index.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
const express = require("express");
const cors = require("cors");
require("dotenv").config();
const port = process.env.PORT || 5000;
const { MongoClient, ServerApiVersion, ObjectId } = require("mongodb");
// Init Express
const app = express();
// Middleware
app.use(express.json());
app.use(
cors({
origin: ["http://localhost:5173", "https://tourism-2d1ca.web.app"],
})
);
/**
* MongoDB
*/
const uri = `mongodb+srv://${process.env.DB_USER}:${process.env.DB_PASS}@cluster0.apymwsq.mongodb.net/?retryWrites=true&w=majority&appName=Cluster0`;
// Create a MongoClient with a MongoClientOptions object to set the Stable API version
const client = new MongoClient(uri, {
serverApi: {
version: ServerApiVersion.v1,
strict: true,
deprecationErrors: true,
},
});
async function run() {
try {
// DB and Collection
const touristsCollection = client.db("touristsSpotDB").collection("spots");
const touristsCountryCollection = client
.db("touristsSpotDB")
.collection("country");
// Create Spot
app.post("/spot", async (req, res) => {
const spotInfo = req.body;
const existCountry = { countryName: spotInfo.countryName };
const checkCountry = await touristsCountryCollection.findOne(
existCountry
);
// Validate
if (!checkCountry) {
const countryresult = await touristsCountryCollection.insertOne(
spotInfo
);
}
const result = await touristsCollection.insertOne(spotInfo);
res.send(result);
});
// Get All Spot
app.get("/spot", async (req, res) => {
const cursor = touristsCollection.find();
const result = await cursor.toArray();
res.send(result);
});
// Get Countries
app.get("/counties", async (req, res) => {
const cursor = touristsCountryCollection.find();
const result = await cursor.toArray();
res.send(result);
});
// Get Related Countries
app.get("/counties/:country", async (req, res) => {
const { country } = req.params;
const filter = { countryName: country };
const cursor = touristsCollection.find(filter);
const result = await cursor.toArray();
res.send(result);
});
// Get Single Spot
app.get("/spot/:id", async (req, res) => {
const { id } = req.params;
const query = { _id: new ObjectId(id) };
const result = await touristsCollection.findOne(query);
res.send(result);
});
// Get User Added Spot List
app.get("/user-added-spot-list/:username", async (req, res) => {
const { username } = req.params;
const query = { userName: username };
const cursor = touristsCollection.find(query);
const result = await cursor.toArray();
res.send(result);
});
// Get Single User
app.get("/update-my-spot-list/:id", async (req, res) => {
const { id } = req.params;
const query = { _id: new ObjectId(id) };
const result = await touristsCollection.findOne(query);
res.send(result);
});
// Update my Spot List
app.patch("/update-my-spot-list/:id", async (req, res) => {
const { id } = req.params;
const spotInfo = req.body;
const filter = { _id: new ObjectId(id) };
const updateSpot = {
$set: {
touristsSpotName: spotInfo.touristsSpotName,
photoURL: spotInfo.photoURL,
countryName: spotInfo.countryName,
location: spotInfo.location,
averageCost: spotInfo.averageCost,
seasonality: spotInfo.seasonality,
travelTime: spotInfo.travelTime,
totalVisitorsPerYear: spotInfo.totalVisitorsPerYear,
shortDescription: spotInfo.shortDescription,
},
};
// Update Now
const result = await touristsCollection.updateOne(filter, updateSpot);
res.send(result);
});
// Delete Spot
app.delete("/spot-delete/:id", async (req, res) => {
const { id } = req.params;
const query = { _id: new ObjectId(id) };
const result = await touristsCollection.deleteOne(query);
res.send(result);
});
// Sorting Average Cost
app.get("/sorting/:cost", async (req, res) => {
const { cost } = req.params;
let convertCost = parseInt(cost);
// Get Db
const query = { averageCost: { $lt: convertCost } };
const cursor = touristsCollection.find(query);
const result = await cursor.toArray();
res.send(result);
});
// Send a ping to confirm a successful connection
// await client.db("admin").command({ ping: 1 });
console.log(
"Pinged your deployment. You successfully connected to MongoDB!"
);
} finally {
// Ensures that the client will close when you finish/error
// await client.close();
}
}
run().catch(console.dir);
app.get("/sadi", (req, res) => {
res.send("Hello Im From Sadi Route");
});
// Listen Server
app.listen(port, () => {
console.log(`Server is Running On PORT ${port}`);
});