Is it possible to created collection, attributes, indexes & config permission using script?

I have been Designing SQL DB schema, keeping in mind Relationship between each table. So, I ended-up with 30+ Tables (500+ lines) of SQL command to created each-table and indexes. I wonder, if is it possible to write a script which can be executed to created relevant collection if I feed attribute and it's data-type and indexes ?

TL;DR

The user is asking if it's possible to create collections, attributes, indexes, and config permissions using a script. They mention that the logs don't help much and they encountered errors while trying to trigger a function. They also ask for an example of push notification. Another user suggests using the Appwrite Console or the UX interface to create the collections, but the original user finds it time-consuming. There is a discussion about creating a JSON file manually or using the CLI command. Finally, another user suggests checking the `appwrite databases` CLI command for possible commands, including creating collections, string attributes, and indexes. There is uncertainty about config

cc @Steven

You mean something like this? https://appwrite.io/docs/server/databases?sdk=nodejs-default#databasesCreateCollection

You can check appwrite databases using this CLI command it will show all the possible commands You will get the some option like these and many more:

TypeScript

createCollection
createStringAttribute
createIndex

Not sure about config permission.

thank you, seems it will solve. Just that not sure about adding indexes & attributes... so far in the doc nothing seems be mentioned.

thank you 🙂

seems it's script is kinda not possible.

Or CLI: https://appwrite.io/docs/command-line-deployment#appwriteJSON

umm, so like we have create script to write json and then feed json cli?

Or manually make the JSON file

😶‍🌫️

that's alot time taking... I guess I will go with UX

It'd be copying and pasting each attribute but sure you can script whatever.

What do you mean you'll go with UX?

I mean UX interface app-write

The Appwrite Console?

yap I mean 😅

btw any example for push-notification?

@Steven getting erros while trying to trigger the function..

logs also doesn't help much

Best to create a new <#1072905050399191082> post

let me 1 min

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more

Recommended threads

Need support?

Join our Discord

Get premium support