How to use the table function from knex

index.js

GitHub: GromovoiStanislav/KnexJS_ORM

800
801
802
803
804
805
806
807
808
809
// //select * from "users" inner join "accounts" on "accounts"."type" = "admin"

//const data = await knex.from('users').innerJoin('accounts','users.id','accounts.user_id');
//select * from "users" inner join "accounts" on "users"."id" = "accounts"."user_id"

// const data = await knex.table('users').innerJoin('accounts', 'users.id', '=', 'accounts.user_id');
// //select * from "users" inner join "accounts" on "users"."id" = "accounts"."user_id"

// const data = await knex('users').innerJoin('accounts',  (qb) => {
//   qb.on('accounts.id', '=', 'users.account_id')

0

0

1

+ 2 other calls in file

insert.js

GitHub: axe-api/bookstore

59
60
61
62
63
64
65
66
67
68
69
  console.log("Categories done!");
};


const createTags = async () => {
  for (let index = 0; index < 10000; index++) {
    await knex.table("tags").insert({
      name: capitalize(faker.random.word()),
      created_at: new Date(),
      updated_at: new Date(),
    });

0

0

0

+ 11 other calls in file

index.js

GitHub: kelishrestha/node-sample-app

8
9
10
11
12
13
14
15
16
17
18
19
app.listen(port, () => console.log(`listening on port: ${port}`));




// Base route
app.get('/', async (request, response) => {
  const getModel = () => database.table('users');
  const totalCount = await getModel().count();
  const usersCount = totalCount[0]['count'];
  var message = 'Server running at port 9000 with ' + usersCount + ' users'
  response.send(message);

0

0

0