Mengatur Rahasia AccessKey pada objek trajectory untuk mengotentikasi akses ke bucket Object Storage Service (OSS) yang menyimpan data trajectory.
Sintaksis
trajectory ST_SetAkSecret(trajectory traj, text aksecret, bool checkvalid default true);Parameter
| Parameter | Deskripsi |
|---|---|
traj | Objek trajectory. |
aksecret | Rahasia AccessKey yang digunakan untuk mengakses bucket OSS. |
checkvalid | Menentukan apakah Rahasia AccessKey akan divalidasi. Nilai default: true. Jika diatur ke true, sistem menguji apakah Rahasia AccessKey dapat mengakses bucket OSS. Jika pengujian gagal, sistem mengembalikan error. |
Deskripsi
Saat data trajectory disimpan dalam bucket OSS, diperlukan pasangan Kunci Akses untuk membaca data tersebut. Pasangan Kunci Akses terdiri dari ID AccessKey dan Rahasia AccessKey—ID AccessKey mengidentifikasi akun (mirip dengan username), sedangkan Rahasia AccessKey berfungsi sebagai kredensial autentikasi (mirip dengan password). Gunakan ST_SetAkSecret untuk mengatur atau memperbarui Rahasia AccessKey pada objek trajectory yang sudah ada.
Contoh
select ST_SetAkSecret(traj, '<OSS_PWD>') from trajs;
st_setaksecret
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"trajectory":{"version":1,"type":"STPOINT","leafcount":6,"start_time":"Sat Jan 01 03:15:42 2000","end_time":"Sat Jan 01 05:16:43 2000","spatial":"LINESTRING(2 2 0,33.042158099636 36.832684322819 0,47.244002354518 47.230026333034 0,64.978971942887 60.618813472986 0,77.621717839502 78.012496630661 0,80 78 0)","timeline":["Sat Jan 01 03:15:42 2000","Sat Jan 01 03:39:54 2000","Sat Jan 01 04:04:06 2000","Sat Jan 01 04:28:18 2000","Sat Jan 01 04:52:31 2000","Sat Jan 01 05:16:43 2000"]}}
{"trajectory":{"version":1,"type":"STPOINT","leafcount":6,"start_time":"Sat Jan 01 03:15:42 2000","end_time":"Sat Jan 01 05:16:43 2000","spatial":"LINESTRING(2 2 0,33.042158099636 36.832684322819 0,47.244002354518 47.230026333034 0,64.978971942887 60.618813472986 0,77.621717839502 78.012496630661 0,80 78 0)","timeline":["Sat Jan 01 03:15:42 2000","Sat Jan 01 03:39:54 2000","Sat Jan 01 04:04:06 2000","Sat Jan 01 04:28:18 2000","Sat Jan 01 04:52:31 2000","Sat Jan 01 05:16:43 2000"]}}
{"trajectory":{"version":1,"type":"STPOINT","leafcount":6,"start_time":"Sat Jan 01 03:15:42 2000","end_time":"Sat Jan 01 05:16:43 2000","spatial":"LINESTRING(2 2,33.042158099636 36.832684322819,47.244002354518 47.230026333034,64.978971942887 60.618813472986,77.621717839502 78.012496630661,80 78)","timeline":["Sat Jan 01 03:15:42 2000","Sat Jan 01 03:39:54 2000","Sat Jan 01 04:04:06 2000","Sat Jan 01 04:28:18 2000","Sat Jan 01 04:52:31 2000","Sat Jan 01 05:16:43 2000"]}}
TRAJECTORY EMPTY
(4 rows)