const servicesCatalogQueries = {
  // 🟢 Create a new service
  insertService: `
      INSERT INTO services_catalog (name, price, description)
      VALUES (?, ?, ?)
    `,

  // 🔵 Get all services
  getAllServices: `
      SELECT id, name, price, description, created_at, updated_at
      FROM services_catalog
      ORDER BY name ASC
    `,

  // 🔵 Get a specific service by ID
  getServiceById: `
      SELECT id, name, price, description, created_at, updated_at
      FROM services_catalog
      WHERE id = ?
    `,

  // 🟠 Update a service by ID
  updateService: `
      UPDATE services_catalog
      SET name = ?, price = ?, description = ?, updated_at = CURRENT_TIMESTAMP
      WHERE id = ?
    `,

  // 🔴 Delete a service by ID
  deleteService: `
      DELETE FROM services_catalog
      WHERE id = ?
    `,

  // 🔍 Optional: search by name (e.g., for typeahead search)
  searchServicesByName: `
      SELECT id, name, price, description
      FROM services_catalog
      WHERE name LIKE ?
      ORDER BY name ASC
      LIMIT 10
    `,
};

module.exports = servicesCatalogQueries;
