Users and tables

[per]

Hi there,
I have some experience from python and db but I’m far from being an expert.

I’m trying to make a function that makes different logged in users do their input to different tables in db.
Logged in user A add rows into Table 1
Logged in user B add rows into Table 2
Logged in user C add rows into Table 1 and so on…

I’m really trying to find the best approach to make this happen.

anvil.tables expects a specific table and I can’t find a way to put a variable there. However that would be smooth.
Is link tables a route or should I try with psycopg2 or do I have to take the route through local server and use another way?

Kind regards
Per Billengren

[p.colbert]

It’s not documented (that I recall), but this trick still works:

@stefano.menci

You use the built-in getattr() function when you know the name of the attribute at runtime. These two are equivalent:

db_name = 'customers'
table = getattr(app_tables, db_name)

table = app_tables.customers

Hope this helps!

[stefano.menci]

This can be useful: Database Table Management

[per]

Big thanks!
Totally forgot about that function, I now recall using it ones a couple of years ago.
That would work!

I really love this app.
Kind regards
Per Billengren

[ianb]

Since you said you are new and already know something about python and databases, I’m going to plug this app I dropped last Sunday.

CSV to Anvil Data Tables For Beginners with Full Example App

https://anvil.works/build#clone:Z4O2BXJEL6TVJ4QK=2LL4HNW3TZQAG7FICS57W6JN [csvexample] I see many new anvil users struggling to load data sets into the data tables for the first time without having an example of how to avoid abusing the free resources while still loading your use case sample data under the 30 second limit provided by the server modules. So I created this full example app. Feel free to clone it and use it for testing, reference, ideas, or anything else. It is not fast. That’…

Its a clone link for a full working app that includes all the working code.