ERM db schema and relationship with codes for disable an user

RT Developers
1

I’d like to understand the DB relationship. would we have the ERM or DB
schema in some place on twiki? I took a glace there but with no
successful.

at this point I want to clean up old users from my DB (I have 265
records) in my Users table and I am not sure how can I filter users
disabled as into table there is no
flag field for this, at least I didn’t find this.

and I really would love to understand where is going Disabled value, for
this case below I copied it from rt3/share/html/Admin/Users/Modify.html
so I can’t see this field in Users table.

can my DB schema is no updated?

if ( defined $id && $id eq 'new') {

( $val, $msg ) = $UserObj->Create(
Name => $Name,
EmailAddress => $ARGS{‘EmailAddress’},
Name => $ARGS{‘Name’},
Comments => $ARGS{‘Comments’},
Signature => $ARGS{‘Signature’},
EmailAddress => $ARGS{‘EmailAddress’},
FreeformContactInfo => $ARGS{‘FreeformContactInfo’},
Organization => $ARGS{‘Organization’},
RealName => $ARGS{‘RealName’},
NickName => $ARGS{‘NickName’},
Lang => $ARGS{‘Lang’},
EmailEncoding => $ARGS{‘EmailEncoding’},
WebEncoding => $ARGS{‘WebEncoding’},
ExternalContactInfoId => $ARGS{‘ExternalContactInfoId’},
ContactInfoSystem => $ARGS{‘ContactInfoSystem’},
Gecos => $ARGS{‘Gecos’},
ExternalAuthId => $ARGS{‘ExternalAuthId’},
AuthSystem => $ARGS{‘AuthSystem’},
HomePhone => $ARGS{‘HomePhone’},
WorkPhone => $ARGS{‘WorkPhone’},
MobilePhone => $ARGS{‘MobilePhone’},
PagerPhone => $ARGS{‘PagerPhone’},
Address1 => $ARGS{‘Address1’},
Address2 => $ARGS{‘Address2’},
City => $ARGS{‘City’},
State => $ARGS{‘State’},
Zip => $ARGS{‘Zip’},
Country => $ARGS{‘Country’},
Privileged => $ARGS{‘Privileged’},
Disabled => ($ARGS{‘Enabled’} ? 0 : 1)
);

I really appreciate for your help.

Thanks,
Eduardo

2

Eduardo;

Assuming a user does not belong to a group, there will be 4 entries for
it in the database:
1- A row in the Users table (name,email address, etc etc)
2- A row in the Groups table eg for a user with Users.id = 101
| id | Name | Description | Domain | Type
| Instance |
| 102| User 101 | ACL equiv. for user 101 | ACLEquivalence | UserEquiv
| 101 |
3- 2 rows in the Principals table
| id | PrincipalType | ObjectId | Disabled |
| 101 | User | 101 | 0 |
| id | PrincipalType | ObjectId | Disabled |
| 102 | Group | 102 | 0 |

Disabling a user, will set the Disabled field to 1, for both Principals
rows 101 and 102

Bare in mind tinkering in the database is not recommended , and as far
as I know, later versions of RT include a Shredder which allow you to
clean the database.

Hope that helped;

Regards;
Roy

Eduardo Cerqueira wrote:

3

Yeah as a general rule, use the API. It’s there, it works.On 2010-02-10 10:18:00AM +0000, Raed El-Hames wrote:

Bare in mind tinkering in the database is not recommended , and as far
as I know, later versions of RT include a Shredder which allow you to
clean the database.

Hope that helped;

Regards;
Roy

Eduardo Cerqueira wrote:

I’d like to understand the DB relationship. would we have the ERM or
DB schema in some place on twiki? I took a glace there but with no
successful.

at this point I want to clean up old users from my DB (I have 265
records) in my Users table and I am not sure how can I filter users
disabled as into table there is no
flag field for this, at least I didn’t find this.

and I really would love to understand where is going Disabled value,
for this case below I copied it from
rt3/share/html/Admin/Users/Modify.html so I can’t see this field in
Users table.

/can my DB schema is no updated?/

if ( defined $id && $id eq 'new') {

( $val, $msg ) = $UserObj->Create(
Name => $Name,
EmailAddress => $ARGS{‘EmailAddress’},
Name => $ARGS{‘Name’},
Comments => $ARGS{‘Comments’},
Signature => $ARGS{‘Signature’},
EmailAddress => $ARGS{‘EmailAddress’},
FreeformContactInfo => $ARGS{‘FreeformContactInfo’},
Organization => $ARGS{‘Organization’},
RealName => $ARGS{‘RealName’},
NickName => $ARGS{‘NickName’},
Lang => $ARGS{‘Lang’},
EmailEncoding => $ARGS{‘EmailEncoding’},
WebEncoding => $ARGS{‘WebEncoding’},
ExternalContactInfoId => $ARGS{‘ExternalContactInfoId’},
ContactInfoSystem => $ARGS{‘ContactInfoSystem’},
Gecos => $ARGS{‘Gecos’},
ExternalAuthId => $ARGS{‘ExternalAuthId’},
AuthSystem => $ARGS{‘AuthSystem’},
HomePhone => $ARGS{‘HomePhone’},
WorkPhone => $ARGS{‘WorkPhone’},
MobilePhone => $ARGS{‘MobilePhone’},
PagerPhone => $ARGS{‘PagerPhone’},
Address1 => $ARGS{‘Address1’},
Address2 => $ARGS{‘Address2’},
City => $ARGS{‘City’},
State => $ARGS{‘State’},
Zip => $ARGS{‘Zip’},
Country => $ARGS{‘Country’},
Privileged => $ARGS{‘Privileged’},
Disabled => ($ARGS{‘Enabled’} ? 0 : 1)
);

I really appreciate for your help.

Thanks,
Eduardo

List info: The rt-devel Archives

Peter C. Lai | Bard College at Simon’s Rock
Systems Administrator | 84 Alford Rd.
Information Technology Svcs. | Gt. Barrington, MA 01230 USA
peter AT simons-rock.edu | (413) 528-7428

4

Great!

Thank you very much Roy for clarify this for me.On Wed, 2010-02-10 at 10:18 +0000, Raed El-Hames wrote:

Eduardo;

Assuming a user does not belong to a group, there will be 4 entries for
it in the database:
1- A row in the Users table (name,email address, etc etc)
2- A row in the Groups table eg for a user with Users.id = 101
±----±---------±------------------------±---------------±----------±---------+
| id | Name | Description | Domain | Type
| Instance |
±----±---------±------------------------±---------------±----------±---------+
| 102| User 101 | ACL equiv. for user 101 | ACLEquivalence | UserEquiv
| 101 |
±----±---------±------------------------±---------------±----------±---------+
3- 2 rows in the Principals table
±----±--------------±---------±---------+
| id | PrincipalType | ObjectId | Disabled |
±----±--------------±---------±---------+
| 101 | User | 101 | 0 |
±----±--------------±---------±---------+
±----±--------------±---------±---------+
| id | PrincipalType | ObjectId | Disabled |
±----±--------------±---------±---------+
| 102 | Group | 102 | 0 |
±----±--------------±---------±---------+

Disabling a user, will set the Disabled field to 1, for both Principals
rows 101 and 102

Bare in mind tinkering in the database is not recommended , and as far
as I know, later versions of RT include a Shredder which allow you to
clean the database.

Hope that helped;

Regards;
Roy

Eduardo Cerqueira wrote:

I’d like to understand the DB relationship. would we have the ERM or
DB schema in some place on twiki? I took a glace there but with no
successful.

at this point I want to clean up old users from my DB (I have 265
records) in my Users table and I am not sure how can I filter users
disabled as into table there is no
flag field for this, at least I didn’t find this.

and I really would love to understand where is going Disabled value,
for this case below I copied it from
rt3/share/html/Admin/Users/Modify.html so I can’t see this field in
Users table.

/can my DB schema is no updated?/

if ( defined $id && $id eq 'new') {

( $val, $msg ) = $UserObj->Create(
Name => $Name,
EmailAddress => $ARGS{‘EmailAddress’},
Name => $ARGS{‘Name’},
Comments => $ARGS{‘Comments’},
Signature => $ARGS{‘Signature’},
EmailAddress => $ARGS{‘EmailAddress’},
FreeformContactInfo => $ARGS{‘FreeformContactInfo’},
Organization => $ARGS{‘Organization’},
RealName => $ARGS{‘RealName’},
NickName => $ARGS{‘NickName’},
Lang => $ARGS{‘Lang’},
EmailEncoding => $ARGS{‘EmailEncoding’},
WebEncoding => $ARGS{‘WebEncoding’},
ExternalContactInfoId => $ARGS{‘ExternalContactInfoId’},
ContactInfoSystem => $ARGS{‘ContactInfoSystem’},
Gecos => $ARGS{‘Gecos’},
ExternalAuthId => $ARGS{‘ExternalAuthId’},
AuthSystem => $ARGS{‘AuthSystem’},
HomePhone => $ARGS{‘HomePhone’},
WorkPhone => $ARGS{‘WorkPhone’},
MobilePhone => $ARGS{‘MobilePhone’},
PagerPhone => $ARGS{‘PagerPhone’},
Address1 => $ARGS{‘Address1’},
Address2 => $ARGS{‘Address2’},
City => $ARGS{‘City’},
State => $ARGS{‘State’},
Zip => $ARGS{‘Zip’},
Country => $ARGS{‘Country’},
Privileged => $ARGS{‘Privileged’},
Disabled => ($ARGS{‘Enabled’} ? 0 : 1)
);

I really appreciate for your help.

Thanks,
Eduardo