xmysqls_mysql_connection_pool_quickstart_select_insert.ts

1import { xmysqls } from 'xmysqls';
2
3// Configuration for the database connection
4const config = {
5  host: 'localhost',
6  user: 'root',
7  password: 'password',
8  database: 'test_db',
9  port: 3306
10};
11
12async function quickStart() {
13  try {
14    // Initialize the connection
15    const db = await xmysqls(config);
16
17    // Example: Select data from a table named 'users'
18    const users = await db.select('users', {
19      where: { id: 1 },
20      fields: ['id', 'name', 'email']
21    });
22
23    console.log('User data:', users);
24
25    // Example: Insert a new record
26    const insertResult = await db.insert('users', {
27      name: 'John Doe',
28      email: 'john@example.com'
29    });
30
31    console.log('Insert ID:', insertResult.insertId);
32
33  } catch (error) {
34    console.error('Error connecting or querying the database:', error);
35  }
36}
37
38quickStart();