Naturally you can still use auth to identify the user. The auth groups is really just to identify the type of user, e.g. teachers, students, admins. This is useful for allowing access to certain functionality. You must still design your DB and create links between your tables using relational keys/ids. This can get rather complex. For example, a teacher might work at more than one school. Start off by drawing a diagram to connect all your tables.
On Wednesday, 26 February 2020 08:36:22 UTC, AGRogers wrote: > > Thanks for the extra info. In my scenario I have schools, teachers, > subjects, classes and students. At the Classes level there will be hundreds > eventually (new ones each term). Your school limits what subjects you can > see. The teacher limits what classes she can see etc. > > If I understood you correctly you are suggesting to use the auth > functionality built into web2py. Do you think that is still appropriate > when there are potentially hundreds of groups? > > And second, I think I read that py4web uses a different approach with > tags(?) Is that correct? > > Thanks > > On Wed, 26 Feb 2020, 15:43 'Annet' via web2py-users, < > web...@googlegroups.com <javascript:>> wrote: > >> I don't understand the use of field 'groups' and function 'get_groups() >> >> I think you should use web2py's built in auth_ functionality: drop field >> 'groups' in both tables, link users and groups (each hotel its own group) >> in the auth_membership table, and use this table to create a list of >> options >> for the drop-down. >> >> I hope this points you in the right direction to solve your problem >> >> >> Kind regards, >> >> Annet >> >> -- >> Resources: >> - http://web2py.com >> - http://web2py.com/book (Documentation) >> - http://github.com/web2py/web2py (Source code) >> - https://code.google.com/p/web2py/issues/list (Report Issues) >> --- >> You received this message because you are subscribed to the Google Groups >> "web2py-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to web...@googlegroups.com <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/web2py/bd2e0505-00f8-4403-9e3d-f89372e2f027%40googlegroups.com >> >> <https://groups.google.com/d/msgid/web2py/bd2e0505-00f8-4403-9e3d-f89372e2f027%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/8710dad0-fd36-4d21-8d44-2039aab256a6%40googlegroups.com.
