43 lines
1.6 KiB
JavaScript
43 lines
1.6 KiB
JavaScript
const db = require('../surreal');
|
|
const router = require('express').Router();
|
|
|
|
router.post('/:search', async (req, res) => {
|
|
try{
|
|
const {type, category} = req.body;
|
|
const search = req.params.search;
|
|
|
|
if (type === 'user') {
|
|
const users = await db.query(`SELECT username, array::len(posts) AS posts_len, search::score(1) AS score FROM users WHERE username @1@ '${search}' ORDER BY score DESC;`);
|
|
res.status(200).json(users);
|
|
}
|
|
|
|
else if (type === 'post') {
|
|
let query = `SELECT category, title, content, author, date, array::len(likes) AS likes_len, array::len(comments) AS comments_len, array::len(saves) AS saves_len, search::score(1) AS score FROM posts WHERE title @1@ '${search}')`;
|
|
if (category) {
|
|
//check if category is json array
|
|
if(category instanceof Array) {
|
|
query += ' AND (';
|
|
for(let i = 0; i < category.length; i++) {
|
|
if(i != 0) query += ' OR ';
|
|
query += `category = '${category[i]}'`;
|
|
}
|
|
query += ')';
|
|
}
|
|
else query += ` AND category = '${category}'`;
|
|
}
|
|
console.log(query)
|
|
query += ' ORDER BY score DESC;';
|
|
const posts = await db.query(query);
|
|
res.status(200).json(posts);
|
|
}
|
|
|
|
else {
|
|
res.status(400).json({error: 'Invalid type'});
|
|
}
|
|
}
|
|
catch(err){
|
|
res.status(500).json({error: err});
|
|
}
|
|
});
|
|
|
|
module.exports = router; |