new_contents: import sqlalchemy
  
  from .base import Directory, User
  
  class DjangoDirectory(Directory):
      query = """
      SELECT
          auth_user.id,
          auth_user.date_joined,
          auth_user.is_superuser
      FROM
          auth_user
      """
  
      def __init__(self, url):
          self.engine = sqlalchemy.create_engine(url)
  
      def describe_user(self, row):
          tags = []
  
          if row.is_superuser:
              tags.append('superuser')
  
          return User(
              id=row.id,
              join_date=row.date_joined,
              tags=tuple(tags),
          )
  
      def lookup_user(self, user_id):
          query = self.query + " WHERE id = ?"
  
          result = self.engine.execute(query, int(user_id))
  
          return describe_user(next(iter(result)))
  
      def all_users(self):
          result = self.engine.execute(self.query)
  
          for row in result:
              yield self.describe_user(row)
  
subject: Add base Django user directory