ResolvedDatabases

[SOLVED] Is there a way to automate setting up an Appwrite cloud database?

Dec 27, 2023, 20:58

View on Discord

Votes

Replies

Participants

Unknown

Messages

saricdenOriginal post

Rank 2: Process

Jun 1, 2023, 20:42

Is it possible to automate or provide a template to setup a new Appwrite cloud database for a user?

Things I would need to automate or template include:

Creating a DB
Creating collections with specific attributes in that DB

Thanks! 🙂

Summary

Yes, there is a way to automate setting up an Appwrite cloud database. You can use the database Server SDK and create a migration script. Here is an example in JavaScript: 1. Initialize the SDK and client: ```js const sdk = require('node-appwrite'); const client = new sdk.Client(); const databases = new sdk.Databases(client); ``` 2. Set the endpoint, project ID, and API key: ```js client .setEndpoint('https://cloud.appwrite.io/v1') .setProject('5df5acd0d48c2') .setKey('919c

Binyamin

Jun 1, 2023, 20:48

Yes
You'll need to use the database Server SDK, and then create your migration script
Something like this for example:

JavaScript

const sdk = require('node-appwrite');

// Init SDK
const client = new sdk.Client();

const databases = new sdk.Databases(client);

client
    .setEndpoint('https://cloud.appwrite.io/v1')
    .setProject('5df5acd0d48c2')
    .setKey('919c2d18fb5d4...a2ae413da83346ad2');

// Create Database
await databases.create('[DATABASE_ID]', '[NAME]');

// Create collection
await databases.createCollection('[DATABASE_ID]', '[COLLECTION_ID]', '[NAME]');


// Create string attribute
await databases.createStringAttribute('[DATABASE_ID]', '[COLLECTION_ID]', 'username', 1, false);

// Add index
await databases.createIndex('[DATABASE_ID]', '[COLLECTION_ID]', 'user', 'key', ['username']);

Binyamin

Jun 1, 2023, 20:48

Take a look at the Server SDK here
https://appwrite.io/docs/server/databases

saricden

Rank 2: Process

Jun 1, 2023, 20:49

Woohoo!!! Thank you so much @Binyamin this means my idea for the Hackathon is very possible