Welcome to the Ultimate Guide to `db-filters` APIs

The `db-filters` library is a powerful tool for refining and optimizing your database queries in Python. In this guide, we will introduce numerous APIs available within the library, along with code snippets to help you get started.

Basic Usage

  
  from db_filters import Filter
  from some_database_module import Database

  db = Database.connect('database_uri')

  # Basic filter by field
  filter = Filter(field='name', operator='==', value='John Doe')
  results = db.query(filter)
  

Complex Filters

  
  from db_filters import AndFilter, OrFilter

  # Combining filters using AND
  filter = AndFilter(
      Filter(field='age', operator='>', value=30),
      Filter(field='city', operator='==', value='New York')
  )
  results = db.query(filter)

  # Combining filters using OR
  filter = OrFilter(
      Filter(field='status', operator='==', value='active'),
      Filter(field='signup_date', operator='<', value='2022-01-01')
  )
  results = db.query(filter)
  

Advanced Operators

  
  # Using LIKE operator
  filter = Filter(field='email', operator='like', value='%@example.com')
  results = db.query(filter)

  # Using IN operator
  filter = Filter(field='role', operator='in', value=['admin', 'user'])
  results = db.query(filter)
  

App Example

Below is a simple app example showcasing the use of `db-filters` APIs for effective data retrieval.

  
  from flask import Flask, jsonify
  from db_filters import Filter, AndFilter
  from some_database_module import Database

  app = Flask(__name__)
  db = Database.connect('database_uri')

  @app.route('/users')
  def get_users():
      filters = AndFilter(
          Filter(field='status', operator='==', value='active'),
          Filter(field='subscribe', operator='==', value=True)
      )
      users = db.query(filters)
      return jsonify(users)
  
  if __name__ == "__main__":
      app.run(debug=True)
  

By leveraging the power of `db-filters`, you can write cleaner, more efficient database queries that improve the performance of your applications.

Hash: e0577ddcbf1100e9d55bd0e75afd48ffc7a4fe450d9011369de1cefdd032c64d