D1 数据库

查看 D1 数据库列表。

const TOKEN = '123456';
const ID = '1234';

const url = `https://api.cloudflare.com/client/v4/accounts/${ID}/d1/database`;
const options = {
  method: 'GET',
  headers: { 'Authorization': 'Bearer ' + TOKEN }
};

try {
  const response = await fetch(url, options);
  const data = await response.json();
  console.log(data);
} catch (error) {
  console.error(error);
}

查看 D1 数据库。

const TOKEN = '123456';
const ID = '1234';
const DATABASE_ID = 'ab12';

const url = `https://api.cloudflare.com/client/v4/accounts/${ID}/d1/database/${DATABASE_ID}`;
const options = {
  method: 'GET',
  headers: { 'Authorization': 'Bearer ' + TOKEN }
};

try {
  const response = await fetch(url, options);
  const data = await response.json();
  console.log(data.result);
} catch (error) {
  console.error(error);
}

查询记录。

const TOKEN = '123456';
const ID = '1234';
const DATABASE_ID = 'ab12';
const sql = {sql: "SELECT k, v FROM kv"};

const url = `https://api.cloudflare.com/client/v4/accounts/${ID}/d1/database/${DATABASE_ID}/query`;
const options = {
  method: 'POST',
  headers: { 'Authorization': 'Bearer ' + TOKEN },
  body: JSON.stringify(sql)
};

try {
  const response = await fetch(url, options);
  const data = await response.json();
  console.log(data.result[0].results);
} catch (error) {
  console.error(error);
}