On Thursday, December 19, 2019 at 2:37:29 PM UTC-8, Davidiam wrote:
>
> As part of our release process, we need to insert records in the auth
> tables using specific id's. On sqlite this is no problem, but in mssql we
> get an error saying insert_identity is off.
> The solution is to set insert_identity ON, but I am not sure how to do
> this using the web2py DAL. Can any give me an code example for this?
> We are basically inserting user and group records using ids from a master
> table.
>
> This is the command that I would need to run before doing the inserts :
>
> SET IDENTITY_INSERT dbo.auth_user ON;
>
> Thanks,
> David
>
I can't, because I'm using a different DB, but I remember thinking at the
time of your earlier post about IDs that ... this is wrong. I think your
process should be using *roles*, not *ID*s, and this is what the auth_group
table is for. Perhaps if I understood your process, I would agree that
relying on specific IDs is the right answer, but it is going to take some
effort to convince me.
/dps
--
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/709105be-e47f-487f-a486-5865fe0e37b2%40googlegroups.com.
