How to access results from a db query in koa?
How to access results from a db query in koa?
1 answer
by
lily ,
6 months ago
@rollin
In Koa, you can access the results from a database query by using the ctx object. Here's an example of how to do it:
- First, import the necessary libraries and create a database connection:
1 2 3 4 5 6 7 8 9 10 11 12 13 |
const Koa = require('koa');
const app = new Koa();
// Assuming you are using a library like Knex.js to connect to the database
const knex = require('knex')({
client: 'mysql',
connection: {
host: '127.0.0.1',
user: 'your_database_user',
password: 'your_password',
database: 'your_database_name'
}
});
|
- Next, define a route handler for your query:
1 2 3 4 5 6 7 8 9 10 |
app.use(async (ctx) => {
try {
const result = await knex('your_table_name').select('*'); // Perform your database query here
ctx.body = result; // Set the query result as the response body
} catch (error) {
console.log(error);
ctx.status = 500;
ctx.body = 'Internal Server Error';
}
});
|
In this example, your_table_name is the name of the table you want to query, and * selects all columns. You can modify the query according to your needs.
- Start the Koa server:
1 2 3 |
app.listen(3000, () => {
console.log('Server listening on port 3000');
});
|
Now, when you access the specified route (e.g., http://localhost:3000/), you will receive the results of your database query in the response body.