MCPcopy Index your code
hub / github.com/coder/coder / GetAuthorizedAuditLogsOffset

Method GetAuthorizedAuditLogsOffset

coderd/database/modelqueries.go:477–557  ·  view source on GitHub ↗
(ctx context.Context, arg GetAuditLogsOffsetParams, prepared rbac.PreparedAuthorized)

Source from the content-addressed store, hash-verified

475}
476
477func (q *sqlQuerier) GetAuthorizedAuditLogsOffset(ctx context.Context, arg GetAuditLogsOffsetParams, prepared rbac.PreparedAuthorized) ([]GetAuditLogsOffsetRow, error) {
478 authorizedFilter, err := prepared.CompileToSQL(ctx, regosql.ConvertConfig{
479 VariableConverter: regosql.AuditLogConverter(),
480 })
481 if err != nil {
482 return nil, xerrors.Errorf("compile authorized filter: %w", err)
483 }
484
485 filtered, err := insertAuthorizedFilter(getAuditLogsOffset, fmt.Sprintf(" AND %s", authorizedFilter))
486 if err != nil {
487 return nil, xerrors.Errorf("insert authorized filter: %w", err)
488 }
489
490 query := fmt.Sprintf("-- name: GetAuthorizedAuditLogsOffset :many\n%s", filtered)
491 rows, err := q.db.QueryContext(ctx, query,
492 arg.ResourceType,
493 arg.ResourceID,
494 arg.OrganizationID,
495 arg.ResourceTarget,
496 arg.Action,
497 arg.UserID,
498 arg.Username,
499 arg.Email,
500 arg.DateFrom,
501 arg.DateTo,
502 arg.BuildReason,
503 arg.RequestID,
504 arg.OffsetOpt,
505 arg.LimitOpt,
506 )
507 if err != nil {
508 return nil, err
509 }
510 defer rows.Close()
511 var items []GetAuditLogsOffsetRow
512 for rows.Next() {
513 var i GetAuditLogsOffsetRow
514 if err := rows.Scan(
515 &i.AuditLog.ID,
516 &i.AuditLog.Time,
517 &i.AuditLog.UserID,
518 &i.AuditLog.OrganizationID,
519 &i.AuditLog.Ip,
520 &i.AuditLog.UserAgent,
521 &i.AuditLog.ResourceType,
522 &i.AuditLog.ResourceID,
523 &i.AuditLog.ResourceTarget,
524 &i.AuditLog.Action,
525 &i.AuditLog.Diff,
526 &i.AuditLog.StatusCode,
527 &i.AuditLog.AdditionalFields,
528 &i.AuditLog.RequestID,
529 &i.AuditLog.ResourceIcon,
530 &i.UserUsername,
531 &i.UserName,
532 &i.UserEmail,
533 &i.UserCreatedAt,
534 &i.UserUpdatedAt,

Callers

nothing calls this directly

Calls 9

AuditLogConverterFunction · 0.92
insertAuthorizedFilterFunction · 0.85
QueryContextMethod · 0.80
ErrMethod · 0.80
CompileToSQLMethod · 0.65
CloseMethod · 0.65
NextMethod · 0.65
ErrorfMethod · 0.45
ScanMethod · 0.45

Tested by

no test coverage detected