Moving from Appwrite

export FORTLY_TOKEN=fly_...

curl -X POST https://api.fortly.com/projects \
  -H "Authorization: Bearer $FORTLY_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"name": "my-app"}'

mkdir appwrite-export && cd appwrite-export
npm init -y && npm install node-appwrite

export APPWRITE_ENDPOINT=https://fra.cloud.appwrite.io/v1
export APPWRITE_PROJECT=your-project-id
export APPWRITE_KEY=standard_...

import { Client, TablesDB, Users, Query } from "node-appwrite";

const client = new Client()
  .setEndpoint(process.env.APPWRITE_ENDPOINT)
  .setProject(process.env.APPWRITE_PROJECT)
  .setKey(process.env.APPWRITE_KEY);
const tablesDB = new TablesDB(client);
const users = new Users(client);

// Every item of a paged list, 100 at a time.
async function* all(list, key) {
  let cursor;
  for (;;) {
    const queries = [Query.limit(100)];
    if (cursor) queries.push(Query.cursorAfter(cursor));
    const items = (await list(queries))[key];
    if (items.length === 0) return;
    yield* items;
    cursor = items[items.length - 1].$id;
  }
}

const q = (v) => (v == null || v === "" ? "null" : "'" + String(v).replaceAll("'", "''") + "'");
const json = (v) => q(JSON.stringify(v ?? null));
const tableFor = (id) => "aw_" + id.toLowerCase().replace(/[^a-z0-9]+/g, "_");
const print = (line) => process.stdout.write(line + "\n");

for await (const db of all((queries) => tablesDB.list({ queries }), "databases")) {
  for await (const t of all((queries) => tablesDB.listTables({ databaseId: db.$id, queries }), "tables")) {
    const table = tableFor(t.$id);
    print(`create table ${table} (id text primary key, created_at timestamptz, updated_at timestamptz, permissions jsonb, data jsonb not null);`);
    const rows = (queries) => tablesDB.listRows({ databaseId: db.$id, tableId: t.$id, queries });
    for await (const row of all(rows, "rows")) {
      const data = Object.fromEntries(Object.entries(row).filter(([k]) => !k.startsWith("$")));
      print(`insert into ${table} values (${q(row.$id)}, ${q(row.$createdAt)}, ${q(row.$updatedAt)}, ${json(row.$permissions)}, ${json(data)});`);
    }
  }
}

print(`create table app_users (
  id text primary key, email text, phone text, name text,
  email_verified boolean not null default false, enabled boolean not null default true,
  labels jsonb, prefs jsonb,
  password_hash text, hash_algorithm text, hash_options jsonb,
  created_at timestamptz
);`);
for await (const u of all((queries) => users.list({ queries }), "users")) {
  print(
    `insert into app_users values (${q(u.$id)}, ${q(u.email)}, ${q(u.phone)}, ${q(u.name)}, ` +
      `${u.emailVerification ? "true" : "false"}, ${u.status ? "true" : "false"}, ${json(u.labels)}, ${json(u.prefs)}, ` +
      `${q(u.password)}, ${q(u.hash)}, ${json(u.hashOptions)}, ${q(u.registration)});`,
  );
}

node export-appwrite.mjs > appwrite.sql

curl -X POST https://api.fortly.com/projects/my-app-ada/import \
  -H "Authorization: Bearer $FORTLY_TOKEN" \
  --data-binary @appwrite.sql

{ "imported": "statements", "ran": 5530, "skipped": 0, "tables": 5 }

create table posts (
  id         text primary key,
  author_id  text references app_users(id),
  title      text not null,
  body       text,
  published  boolean not null default false,
  cover      text,
  created_at timestamptz not null
);

insert into posts (id, author_id, title, body, published, cover, created_at)
select id,
       data->>'authorId',
       data->>'title',
       data->>'body',
       coalesce((data->>'published')::boolean, false),
       data->>'coverFileId',
       created_at
from aw_posts;

drop table aw_posts;

curl -X POST https://api.fortly.com/projects/my-app-ada/import \
  -H "Authorization: Bearer $FORTLY_TOKEN" \
  --data-binary @reshape.sql

import { Client, Storage, Query } from "node-appwrite";
import { extname } from "node:path";

const client = new Client()
  .setEndpoint(process.env.APPWRITE_ENDPOINT)
  .setProject(process.env.APPWRITE_PROJECT)
  .setKey(process.env.APPWRITE_KEY);
const storage = new Storage(client);
const project = process.env.FORTLY_PROJECT;

async function* all(list, key) {
  let cursor;
  for (;;) {
    const queries = [Query.limit(100)];
    if (cursor) queries.push(Query.cursorAfter(cursor));
    const items = (await list(queries))[key];
    if (items.length === 0) return;
    yield* items;
    cursor = items[items.length - 1].$id;
  }
}

const q = (v) => "'" + String(v).replaceAll("'", "''") + "'";
console.log("create table aw_files (bucket_id text, file_id text, name text, path text primary key, bytes bigint);");

for await (const bucket of all((queries) => storage.listBuckets({ queries }), "buckets")) {
  for await (const file of all((queries) => storage.listFiles({ bucketId: bucket.$id, queries }), "files")) {
    const bytes = await storage.getFileDownload({ bucketId: bucket.$id, fileId: file.$id });
    const path = `${bucket.$id}/${file.$id}${extname(file.name).toLowerCase()}`;
    const res = await fetch(`https://api.fortly.com/projects/${project}/files/${path}`, {
      method: "POST",
      headers: { Authorization: `Bearer ${process.env.FORTLY_TOKEN}` },
      body: Buffer.from(bytes),
    });
    if (!res.ok) throw new Error(`${path}: ${res.status} ${await res.text()}`);
    console.log(`insert into aw_files values (${q(bucket.$id)}, ${q(file.$id)}, ${q(file.name)}, ${q(path)}, ${file.sizeOriginal});`);
  }
}

FORTLY_PROJECT=my-app-ada node copy-files.mjs > files.sql

curl -X POST https://api.fortly.com/projects/my-app-ada/import \
  -H "Authorization: Bearer $FORTLY_TOKEN" \
  --data-binary @files.sql

curl -X POST https://api.fortly.com/projects/my-app-ada/secrets \
  -H "Authorization: Bearer $FORTLY_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"name": "STRIPE_SECRET_KEY", "value": "sk_live_..."}'

tar --exclude=node_modules --exclude=.git -czf release.tgz .

curl -X POST https://api.fortly.com/projects/my-app-ada/deploys \
  -H "Authorization: Bearer $FORTLY_TOKEN" \
  --data-binary @release.tgz

curl -X POST https://api.fortly.com/projects/my-app-ada/domains \
  -H "Authorization: Bearer $FORTLY_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"host": "www.example.com"}'

curl -X POST https://api.fortly.com/projects/my-app-ada/domains/www.example.com/verify \
  -H "Authorization: Bearer $FORTLY_TOKEN"