Introducing db-logger: A Powerful Tool for Database Logging

The db-logger is an advanced, feature-rich database logging utility designed to streamline and enhance your database interactions. Whether you are dealing with simple queries or complex transactions, db-logger offers extensive APIs to ensure your logging process is efficient and insightful.

Getting Started

Setting up db-logger is straightforward. Below is an example of a basic initialization and setup:

  from db_logger import DBLogger

  # Initialize the logger
  logger = DBLogger(database="my_database", user="username", password="password")

  # Setting log level
  logger.set_log_level("INFO")

  # Start logging
  logger.start_logging()

API Examples

Log a Simple Query

  query = "SELECT * FROM users WHERE id = 1"
  logger.log_query(query)

Log an Insert Operation

  query = "INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com')"
  logger.log_insert(query)

Log an Update Operation

  query = "UPDATE users SET email = 'john.doe@example.com' WHERE id = 1"
  logger.log_update(query)

Log a Delete Operation

  query = "DELETE FROM users WHERE id = 1"
  logger.log_delete(query)

Custom Log Messages

  message = "Custom log message: Query execution took longer than expected."
  logger.log_message("WARNING", message)

Advanced API Usage

Bulk Insert Logging

  queries = [
      "INSERT INTO users (name, email) VALUES ('Alice', 'alice@example.com')",
      "INSERT INTO users (name, email) VALUES ('Bob', 'bob@example.com')"
  ]
  logger.log_bulk_insert(queries)

Transaction Logging

  transaction = [
      "BEGIN",
      "UPDATE accounts SET balance = balance - 100 WHERE user_id = 1",
      "UPDATE accounts SET balance = balance + 100 WHERE user_id = 2",
      "COMMIT"
  ]
  logger.log_transaction(transaction)

Error Logging

  try:
      query = "SELECT * FROM non_existent_table"
      logger.log_query(query)
  except Exception as e:
      logger.log_error(e)

Example Application

Here is an example of how to integrate db-logger into an application:

  from db_logger import DBLogger

  class MyApp:
      def __init__(self, db_params):
          self.logger = DBLogger(**db_params)
          self.logger.set_log_level("INFO")
          self.logger.start_logging()
          
      def get_user(self, user_id):
          try:
              query = f"SELECT * FROM users WHERE id = {user_id}"
              self.logger.log_query(query)
              # Execute query and fetch result
          except Exception as e:
              self.logger.log_error(e)
      
      def add_user(self, name, email):
          try:
              query = f"INSERT INTO users (name, email) VALUES ('{name}', '{email}')"
              self.logger.log_insert(query)
              # Execute query to insert user
          except Exception as e:
              self.logger.log_error(e)
  
  # Usage
  db_params = {"database": "my_database", "user": "username", "password": "password"}
  app = MyApp(db_params)
  app.get_user(1)
  app.add_user("Jane Doe", "jane@example.com")

With db-logger, your database logging becomes more manageable, insightful, and robust, ensuring that your application can benefit from comprehensive logging capabilities.

Hash: 416caa0cddd185fe07799e0b495acec92554de696c1c21e798a7bcd7c10cc22d