The Things Network LoRaWAN Stack V3 学习笔记 2.1.1 使用 CockroachDB Shell 操作 Identity Server

前言

由于 OAUTH 命令进行了更新，导致我把一条旧的命令配置进了 Identity Server。所以本节琢磨下如何使用 cockroachdb 修改 Identity Server。

相关 shell 操作参考 https://www.cockroachlabs.com/docs/managed/stable/learn-cockroachdb-sql.html。

小能手这段时间在学习 The Things Network LoRaWAN Stack V3，从使用和代码等角度对该 Stack 进行了分析，详细可点此查看。

1 登录

# cockroach sql --insecure --host=localhost:26257
# Welcome to the cockroach SQL interface.
# All statements must be terminated by a semicolon.
# To exit: CTRL + D.
#
# Server version: CockroachDB CCL v2.1.6 (x86_64-unknown-linux-gnu, built 2019/03/04 23:21:07, go1.10.7) (same version as client)
# Cluster ID: 56c72251-e347-4df5-8016-c0a220807a11
#
# Enter \? for a brief introduction.
#

2 退出

\q

3 查看

root@localhost:26257/defaultdb> SHOW DATABASES;
   database_name   
+-----------------+
  defaultdb        
  postgres         
  system           
  ttn_lorawan_dev  
(4 rows)

Time: 9.753064ms

root@localhost:26257/defaultdb> SHOW TABLES FROM ttn_lorawan_dev;
         table_name         
+--------------------------+
  access_tokens             
  accounts                  
  api_keys                  
  applications              
  attributes                
  authorization_codes       
  client_authorizations     
  clients                   
  contact_info_validations  
  contact_infos             
  end_device_locations      
  end_devices               
  gateway_antennas          
  gateways                  
  invitations               
  memberships               
  organizations             
  pictures                  
  user_sessions             
  users                     
(20 rows)

Time: 1.559261ms

4 删除数据库

root@localhost:26257/defaultdb> DROP DATABASE ttn_lorawan_dev CASCADE;
DROP DATABASE

Time: 586.676844ms

删除非空数据库要增加 CASCADE 参数。

END

---