How to create knex request using MySQL syntax?

Question

In MySQL Workbench I have this:

USE my_db;
SELECT 
    transactions.created_at, price
FROM
    transactions
        JOIN
    transactions_items ON transactions.id = transactions_items.transaction_id
        JOIN
    store_items ON store_items.id = transactions_items.store_item_id;

As a result in workbench I get created_at: price. How can I create request to DB using knex syntax to get object {created_at: price}?

I was trying to use knex.raw(), but it does not seem to be working.

BL4DERUNNER · Accepted Answer · 2021-06-27 16:18:53Z

2

const response = await knex('transactions')
        .join('transactions_items', 'transactions.id', '=', 'transactions_items.transaction_id')
        .join('store_items', 'store_items.id', '=', 'transactions_items.store_item_id')
        .select('transactions.created_at', 'price')

answered Jun 27, 2021 at 16:18

BL4DERUNNER

2951 gold badge4 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create knex request using MySQL syntax?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related