import express from "express"
import bodyParser from "body-parser"
import {
    listDatabases,
    listCollections,
    listfields,
    query,
} from "../services/db-services"

export const queryRouter = express.Router()
queryRouter.use(bodyParser.urlencoded({ extended: false }))
queryRouter.use(bodyParser.json())

queryRouter.get("/dbs", async (req, res) => {
    const client = (req.app as any).client
    const allDBs = await listDatabases(client)

    res.send(allDBs)
})

queryRouter.post("/dbcollections", async (req, res) => {
    const client = (req.app as any).client
    const allCollections = await listCollections(client, req.body.dbname)
    res.send(allCollections)
})

queryRouter.post("/collectionfields", async (req, res) => {
    const client = (req.app as any).client
    const allFields = await listfields(
        client,
        req.body.dbname,
        req.body.collectionname
    )
    res.send(allFields)
})

queryRouter.post("/query", async (req, res) => {
    const client = (req.app as any).client

    const queryResults = await query(
        client,
        req.body.dbname,
        req.body.collectionname,
        req.body.listoffields,
        req.body.substitution
    )
    res.send(queryResults)
})