go.chromium.org/luci@v0.0.0-20240309015107-7cdc2e660f33/tokenserver/push_bq_schema.sh (about)

     1  #!/bin/bash
     2  
     3  THIS_DIR=$(dirname "$0")
     4  
     5  read -p "Cloud Project name to push BQ schema to: " PROJECT_ID
     6  
     7  bqschemaupdater \
     8    -table "$PROJECT_ID.tokens.delegation_tokens" \
     9    -friendly-name "Issued delegation tokens." \
    10    -message-dir "$THIS_DIR/api/bq" \
    11    -message "tokenserver.bq.DelegationToken" \
    12    -partitioning-expiration "8760h"  # 1y
    13  
    14  bqschemaupdater \
    15    -table "$PROJECT_ID.tokens.machine_tokens" \
    16    -friendly-name "Issued machine tokens." \
    17    -message-dir "$THIS_DIR/api/bq" \
    18    -message "tokenserver.bq.MachineToken" \
    19    -partitioning-expiration "2160h"  # 90d
    20  
    21  bqschemaupdater \
    22    -table "$PROJECT_ID.tokens.project_tokens" \
    23    -friendly-name "Issued project tokens." \
    24    -message-dir "$THIS_DIR/api/bq" \
    25    -message "tokenserver.bq.ProjectToken" \
    26    -partitioning-expiration "8760h"  # 1y
    27  
    28  bqschemaupdater \
    29    -table "$PROJECT_ID.tokens.service_account_tokens" \
    30    -friendly-name "Issued service account tokens." \
    31    -message-dir "$THIS_DIR/api/bq" \
    32    -message "tokenserver.bq.ServiceAccountToken" \
    33    -partitioning-expiration "8760h"  # 1y