Mirror of forum.nim-lang.org

9741 :: Proposed method of writing filters in Nexus v2

• jasonfi (orginal) [2022-12-20T08:14:57+01:00] view original

  Here's the example filter code

  include filter_types
  
  
  proc getAdminUsersWithReportsAccess(context: Context): AccountUsers =
    
    var filter: AccountUserFilter
    
    filter.whereEq.isAdmin = true
    filter.whereIn.names = @[ "User 1", "User 2" ]
    filter.includes.accountUserRole.whereEq.role = "Admin reports"
    filter.orderBy.name = asc
    filter.orderBy.created = desc
    
    return filterAccountUser(
             context.db,
             filter)
  
  
  # Main
  var context: Context
  
  discard getAdminUsersWithReportsAccess(context)
  Run

  The filter_types.nim file (which would be auto-generated):

  import times
  
  
  const
    asc = 1
    desc = 2
  
  
  type
    DbContext* = object
      dbConn: string  # stub
    
    
    Context* = object
      db: DbContext
    
    
    AccountUserRole* = object
      accountUserId*: string
      role*: string
    
    
    AccountUserRoles* = seq[AccountUserRole]
    
    
    AccountUser* = object
      name*: string
      isAdmin*: bool
    
    
    AccountUsers* = seq[AccountUser]
    
    
    AccountUserIncludeRoleModels* = object
      accountUsers*: seq[AccountUser]
    
    
    AccountUserRoleWhereEq* = object
      accountUserId*: string
      role*: string
    
    
    AccountUserRoleWhereIn* = object
      accountUserIds*: seq[string]
      roles*: seq[string]
    
    
    AccountUserRoleOrderBy* = object
      name*: int
      isAdmin*: int
    
    
    AccountUserRoleFilter* = object
      whereEq*: AccountUserRoleWhereEq
      whereIn*: AccountUserRoleWhereIn
      # includes*: AccountUserRoleIncludeModels
      orderBy*: AccountUserRoleOrderBy
    
    
    AccountUserWhereEq* = object
      name*: string
      isAdmin*: bool
      created*: DateTime
    
    
    AccountUserWhereIn* = object
      names*: seq[string]
      isAdmins*: seq[bool]
    
    
    AccountUserIncludeModels* = object
      accountUserRole*: AccountUserRoleFilter
    
    
    AccountUserOrderBy* = object
      name*: int
      isAdmin*: int
      created*: int
    
    
    AccountUserFilter* = object
      whereEq*: AccountUserWhereEq
      whereIn*: AccountUserWhereIn
      includes*: AccountUserIncludeModels
      orderBy*: AccountUserOrderBy
  
  
  proc filterAccountUser*(
         dbContext: DbContext,
         filter: AccountUserFilter): AccountUsers =
    
    echo $filter
  Run

---