Create Deta Base DB on app start (FastApi)

[Master-Y0da]

I'm trying to create a users DB in Deta base when app is starting, but can't make it work.

I try using event startup:

  @app.on_event("startup")
    def startup_event():
   users = deta.Base("users")
   user = users.put({
    "name": "name",
    "age": "age",
    "hometown": "hometown"
  })

And also tryed with main :

     if __name__ == '__main__':
      users = deta.Base("users")
      user = users.put({
    "name": "name",
    "age": "age",
    "hometown": "hometown"
   })

Any help would be so much appreciated!.

[abdelhai]

what is the error you are getting? how are you making sure it doesn't work?

[Master-Y0da]

There is no error...just nothing happens when I take a look into my app url...
Expected behaviour would be that I enter into my Deta panel, and in base section should display an item called users

When I deploy code to deta, behind scenes is restarting/re launching the app ?

[abdelhai]

i recommend following this tutorial exactly: https://docs.deta.sh/docs/base/py_tutorial

events like on_startup don't work on deta micros

[Master-Y0da]

Ok !...but what about if I need to populate and create some tables previously to users use my app ? ....Do I need to create a specific route like /populate and call this every time ?... I'm just looking for some ideas to solve my problem, thanks for your help and time!

[abdelhai]

what is the event that triggers the population? like when should it happen?

[harshitsinghai77]

Just call the function in main.py, I think you would be good. Assuming you need to call this every time the app starts.

[jnsougata]

I guess you don't have to make the table at the startup. you can use put whenever you want. it will create the table for the user but there's a chance of overwrting the existing data so I will suggest you to use update with set inside try except block and check for exception... if the key doesn't exist go with put

for example key is my target... I use the following to create or update

    async def add_field(self, key: str, field: Field, force: bool = False) -> Dict[str, Any]:
        """
        adds a field to an existing key.
        if field already exists, old value will be overwritten.
        """
        if not force:
            return await self.update(key=key, updates=[Update.set([field])])
        try:
            return await self.update(key=key, updates=[Update.set([field])])
        except NotFound:
            return await self.put(key=key, field=field)

[Master-Y0da]

Sorry about late response...but yes ! you are wright!...I just use put when my app calls a router and that's it. Thank you!