how to override col_spec

[fredzannarbor]

Hi,

I need to add some more columns to my USERS table and be able to query them. Is there a way that I can override col_spec without modifying your code?

auth-simple-for-streamlit/authlib/repo/provider/sqlite/implementation.py

Line 35 in 86472f3

col_spec='id INTEGER PRIMARY KEY, username UNIQUE ON CONFLICT REPLACE, password, su INTEGER',

[asehmi]

I haven't implemented that. This code is supposed to be taken as-is and modified to suit your needs. For easier extensibility, I'd suggest you use the AIRTABLE provider. Having said that, the table creation code is really all you need to touch in the SQLITE provider, perhaps adding a [roles] column. If your needs are getting beyond this, then you need an identity solution, not a login auth solution, which is what this is. You can also make a few little changes so the success login token is returned with the roles data. HTH.