DatabasesTools

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

Dec 27, 2023, 22:16

View on Discord

Votes

Replies

Participants

Unknown

Messages

VedsagaOriginal post

Rank 5: Hypervisor

Mar 12, 2023, 11:00

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 ?

Summary

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

Vedsaga

Rank 5: Hypervisor

Mar 12, 2023, 11:00

cc @Steven

Radu

Mar 12, 2023, 15:42

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

bhaskarsingh

Rank 3: Container

Mar 12, 2023, 15:46

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:

createCollection
createStringAttribute
createIndex

Not sure about config permission.

Vedsaga

Rank 5: Hypervisor

Mar 13, 2023, 02:23

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

Vedsaga

Rank 5: Hypervisor

Mar 13, 2023, 02:25

thank you 🙂

Vedsaga

Rank 5: Hypervisor

Mar 13, 2023, 02:41

seems it's script is kinda not possible.

Drake

Mar 13, 2023, 02:43

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

Vedsaga

Rank 5: Hypervisor

Mar 13, 2023, 02:45

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

Drake

Mar 13, 2023, 02:46

Or manually make the JSON file

Vedsaga

Rank 5: Hypervisor

Mar 13, 2023, 02:46

😶‍🌫️

Vedsaga

Rank 5: Hypervisor

Mar 13, 2023, 02:47

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

Drake

Mar 13, 2023, 02:48

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

What do you mean you'll go with UX?

Vedsaga

Rank 5: Hypervisor

Mar 13, 2023, 02:48

I mean UX interface app-write

Drake

Mar 13, 2023, 03:04

The Appwrite Console?

Vedsaga

Rank 5: Hypervisor

Mar 13, 2023, 03:04

yap I mean 😅

Vedsaga

Rank 5: Hypervisor

Mar 13, 2023, 03:05

btw any example for push-notification?

Vedsaga

Rank 5: Hypervisor

Mar 13, 2023, 03:11

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

Vedsaga

Rank 5: Hypervisor

Mar 13, 2023, 03:11

logs also doesn't help much

Drake

Mar 13, 2023, 03:20

Best to create a new #channel post

Vedsaga

Rank 5: Hypervisor

Mar 13, 2023, 03:21

let me 1 min

Join the discussion

Reply to this thread by joining our Discord.

Reply on Discord

Need support?_

Join Discord Get premium support