OpenACS / openacs-4 / packages / acs-tcl / tcl

community-core-procs.tcl

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 19
Last Commit: 05 Apr
Commits this week: 0
Total Lines of Code (LoC): 1,270
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 8 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 28 Mar 2023
4:02 pm

antoniop

Commit missing change to the users api

Options
    • -2
    • +1
    ./community-core-procs.tcl
Thursday 29 Dec 2022
1:05 pm

gustafn

added cluster-awareness

NOTE: one should use here the acs-cluster infrastructure instead to

achieve better scalability and easier cache maintenance

Options
    • -11
    • +11
    ./community-core-procs.tcl
Wednesday 07 Sep 2022
3:56 pm

antoniop

When demoting a user, flush the permissions cache as well

Options
    • -1
    • +7
    ./community-core-procs.tcl
Tuesday 15 Feb 2022
6:00 pm

gustafn

fix editing bug

V: ----------------------------------------------------------------------

Options
    • -2
    • +1
    ./community-core-procs.tcl
5:57 pm

gustafn

Fixes for Oracle 19c boolean types in query

This fixes the following bug for Oracle:

: select u.user_id,

: u.authority_id,

: u.username,

: u.screen_name,

: u.priv_name,

: u.priv_email,

: u.email_verified_p,

: u.email_bouncing_p,

: u.no_alerts_until,

: u.last_visit,

: to_char(last_visit, 'YYYY-MM-DD HH24:MI:SS') as last_visit_ansi,

: u.second_to_last_visit,

: to_char(second_to_last_visit, 'YYYY-MM-DD HH24:MI:SS') as second_to_last_visit_ansi,

: u.n_sessions,

: u.password,

: u.salt,

: u.password_question,

: u.password_answer,

: u.password_changed_date,

: extract(day from current_timestamp - password_changed_date) as password_age_days,

: u.auth_token,

: mm.rel_id,

: mr.member_state !>>>!= 'approved' as registered_user_p,

: mr.member_state

: from users u

: left join group_member_map mm on mm.member_id = u.user_id

: and mm.group_id = mm.container_id

: and mm.group_id = :registered_users_group_id

: and mm.rel_type = 'membership_rel'

: left join membership_rels mr on mr.rel_id = mm.rel_id

: where u.user_id = :user_id

Options
    • -1
    • +2
    ./community-core-procs.tcl
Tuesday 25 Jan 2022
6:33 pm

antoniop

Streamline idiom

Options
    • -8
    • +4
    ./community-core-procs.tcl
Sunday 05 Dec 2021
4:37 pm

gustafn

break overlong lines

Options
    • -8
    • +13
    ./community-core-procs.tcl
Friday 02 Jul 2021
7:36 pm

antoniop

Make so that also party::update enforces emails to be lowercase, add/extend automated tests to make sure emails are lowercase everywhere

Options
    • -2
    • +3
    ./community-core-procs.tcl
  2. … 2 more files in changeset.
Sunday 14 Feb 2021
10:47 am

gustafn

reduce verbosity

Options
    • -3
    • +1
    ./community-core-procs.tcl
Saturday 13 Feb 2021
9:24 pm

gustafn

remove race condition from user/person/party cache management

Options
    • -63
    • +81
    ./community-core-procs.tcl
6:31 pm

gustafn

2 new API functions acs_user::promote_person_to_user and acs_user::demote_user (see issue #3461)

acs_user::promote_person_to_user

Promotes a person/party to an ACS user.

@param person_id the person_id in the acs system that should be promoted to a user.

@param username the username to be used for this user.

Defaults to the person's email

@param password the password to be used for this user.

Defaults to a randomly generated password.

@param authority_id the authority that will be used for the user.

@param locale locale to be used in user preferences.

Defaults to the site wide locale is taken.

@return The user_id of the person promoted to user

@error An error is thrown

if the username is already in use,

or the person_id has no email address,

or if person_id is not in the persons table.

acs_user::demote_user

Demotes an ACS user to a person/party.

This will fail if other tables have content referencing the users

table. It is probably best for tables created in other packages

to reference persons, parties, or acs_objects instead. This proc

could be extended with an option to find all referenced tables and

remove rows referencing this user.

See the following FK relationship in basic OpenACS installations:

TABLE "acs_objects" CONSTRAINT "acs_objects_creation_user_fk" FOREIGN KEY (creation_user) REFERENCES users(user_id)

TABLE "acs_objects" CONSTRAINT "acs_objects_modifying_user_fk" FOREIGN KEY (modifying_user) REFERENCES users(user_id)

TABLE "ad_locale_user_prefs" CONSTRAINT "ad_locale_user_prefs_users_fk" FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE

TABLE "auth_batch_job_entries" CONSTRAINT "auth_batch_job_entries_user_fk" FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE SET NULL

TABLE "auth_batch_jobs" CONSTRAINT "auth_batch_jobs_user_fk" FOREIGN KEY (creation_user) REFERENCES users(user_id) ON DELETE SET NULL

TABLE "cr_news" CONSTRAINT "cr_news_approval_user_fk" FOREIGN KEY (approval_user) REFERENCES users(user_id)

TABLE "email_images" CONSTRAINT "email_images_user_id_fk" FOREIGN KEY (user_id) REFERENCES users(user_id)

TABLE "forums_messages" CONSTRAINT "forums_mess_last_poster_fk" FOREIGN KEY (last_poster) REFERENCES users(user_id)

TABLE "forums_messages" CONSTRAINT "forums_mess_user_id_fk" FOREIGN KEY (user_id) REFERENCES users(user_id)

TABLE "forums_reading_info" CONSTRAINT "forums_read_user_id_fk" FOREIGN KEY (user_id) REFERENCES users(user_id)

TABLE "lang_messages_audit" CONSTRAINT "lang_messages_audit_ou_fk" FOREIGN KEY (overwrite_user) REFERENCES users(user_id)

TABLE "lang_messages" CONSTRAINT "lang_messages_creation_user_fk" FOREIGN KEY (creation_user) REFERENCES users(user_id)

TABLE "lang_user_timezone" CONSTRAINT "lang_user_timezone_user_id_fk" FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE

TABLE "notification_replies" CONSTRAINT "notif_repl_from_fk" FOREIGN KEY (from_user) REFERENCES users(user_id)

TABLE "notification_user_map" CONSTRAINT "notif_user_map_user_id_fk" FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE

TABLE "notifications" CONSTRAINT "notifications_notif_user_fk" FOREIGN KEY (notif_user) REFERENCES users(user_id)

TABLE "notification_requests" CONSTRAINT "notifications_request_user_id_fk" FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE

TABLE "proctoring_examination_statement_acceptance" CONSTRAINT "proctoring_examination_statement_acceptance_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE

TABLE "user_portraits" CONSTRAINT "user_portraits_user_id_fk" FOREIGN KEY (user_id) REFERENCES users(user_id)

TABLE "user_preferences" CONSTRAINT "user_preferences_user_id_fk" FOREIGN KEY (user_id) REFERENCES users(user_id)

TABLE "xowiki_tags" CONSTRAINT "xowiki_tags_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(user_id)

Options
    • -9
    • +252
    ./community-core-procs.tcl
Tuesday 08 Oct 2019
6:30 pm

gustafn

Make comma setting more consistent

see: https://onlinewritingtraining.com.au/however-therefore-furthermore/

Options
    • -2
    • +2
    ./community-core-procs.tcl
  2. … 6 more files in changeset.
Thursday 05 Sep 2019
3:47 pm

antoniop

Reimplement portrait retrieval around the user_portrait relationship, as procs such as merge::MergeUserInfo do not assume a certain name format on the cr_item

Options
    • -5
    • +8
    ./community-core-procs.tcl
Monday 19 Aug 2019
12:44 pm

gustafn

improve spelling

Options
    • -4
    • +4
    ./community-core-procs.tcl
  2. … 1 more file in changeset.
Friday 26 Apr 2019
9:14 am

michaela

Remove duplicate column

Options
    • -2
    • +2
    ./community-core-procs.tcl
Wednesday 10 Apr 2019
10:50 pm

gustafn

get proper default authority

Options
    • -10
    • +12
    ./community-core-procs.tcl
Sunday 10 Mar 2019
10:34 pm

gustafn

improve spelling

Options
    • -2
    • +2
    ./community-core-procs.tcl
  2. … 14 more files in changeset.
Friday 20 Jul 2018
2:57 pm

antoniop

Cache the portrait in the right cache (Thanks to Felix Mödritscher)

Options
    • -2
    • +2
    ./community-core-procs.tcl
Wednesday 11 Jul 2018
11:57 pm

hectorr

Fix typos

Options
    • -2
    • +2
    ./community-core-procs.tcl
  2. … 11 more files in changeset.
Saturday 07 Jul 2018
9:48 am

gustafn

Don't be so quick on deprecating a common interface

Options
    • -3
    • +4
    ./community-core-procs.tcl
Thursday 28 Jun 2018
3:25 pm

hectorr

Deprecate 'person::update_bio' in favor of 'person::update'

Options
    • -4
    • +3
    ./community-core-procs.tcl
2:37 pm

hectorr

Deprecate 'person::name_flush', unnecessary and used nowhere...

Options
    • -4
    • +3
    ./community-core-procs.tcl
2:17 pm

hectorr

Deprecate 'acs_user::get_element' in favor of 'acs_user::get'

Options
    • -4
    • +3
    ./community-core-procs.tcl
12:45 pm

antoniop

Put get_by_username in the proper cache, handle cases when we delete a user that was not in the cache (in this case we could not retrieve authority and username after deletion)

Options
    • -6
    • +8
    ./community-core-procs.tcl
11:42 am

antoniop

Fix typo

Options
    • -2
    • +2
    ./community-core-procs.tcl
11:41 am

antoniop

Unify person update api, exploit cache better and remove unneded queries

Options
    • -9
    • +35
    ./community-core-procs.tcl
  2. … 1 more file in changeset.
11:20 am

antoniop

No need to check as now person::name won't fail

Options
    • -15
    • +11
    ./community-core-procs.tcl
11:13 am

antoniop

Fix expression

Options
    • -2
    • +2
    ./community-core-procs.tcl
11:10 am

antoniop

Parties api had procs defined in both acs-subsite and acs-tcl and sometimes duplicated

- move all party:: api into acs-tcl/tcl/community-core-procs

- remove duplicated definitions

- move leftover deprecated proc to deprecated-procs.tcl

Options
    • -1
    • +214
    ./community-core-procs.tcl
  2. … 4 more files in changeset.
Wednesday 27 Jun 2018
5:54 pm

antoniop

Second revision of the party/person/user api

- split api into 3 caches for party/person/user

- new *_info procs for the specific object type: stresses only specific cache and is therefore faster when only specific info is needed

Options
    • -138
    • +313
    ./community-core-procs.tcl
  2. … 1 more file in changeset.