• last updated 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
- prefer sql statements between curly braces

- prefer sql statements between curly braces

- write sql statements between curly braces

- prefer braces around sql statements

.xql-file reform of news

    • -8
    • +11
    /openacs-4/packages/news/lib/item.tcl
    • -27
    • +10
    /openacs-4/packages/news/tcl/news-procs.tcl
    • -5
    • +6
    /openacs-4/packages/news/www/preview.tcl
    • -5
    • +0
    /openacs-4/packages/news/www/preview.xql
    • -9
    • +2
    /openacs-4/packages/news/www/admin/revoke.tcl
.xql-file reform of file-storage

  1. … 4 more files in changeset.
.xql-file reform of forums

- remove sql statements from the code, where these are provided via .xql

- prefer empty sql statements over various forms of *SQL*

- remove obsolete queries

- remove obsolete file

.xql-file reform of acs-service-contract

- remove sql statements from the code, where these are provided via .xql

- prefer empty sql statements over various forms of *SQL*

- remove unneeded sql queries

acs_sc::msg_type::delete.delete_by_id

-remove unneeded files

tcl/acs-service-contract-init-oracle.xql

tcl/acs-service-contract-init-postgresql.xql

www/binding-uninstall-postgresql.xql

- prefer empty sql statements over various forms of *SQL*

- remove unneeded queries and files

- remove sql statements from the code, where these are provided via .xql

.xql-file reform of acs-lang

- remove unneeded sql queries

lang::catalog::reset_upgrade_status_message_keys.reset_status"

lang::catalog::import_from_file.reset_upgrade_status_messages

lang::catalog::import_from_file.mark_message_as_deleted

lang::catalog::import_from_file.mark_message_key_as_deleted

lang::message::register.message_exists_p

- remove sql statements from the code, where these are provided via .xql

- remove obsolete file

- add doc(title) to demo page

.xql-file reform of acs-content-repository

- remove sql statements from the code, where these are provided via .xql

- prefer empty sql statements over various forms of *SQL*

- remove unneeded sql queries

cr_check_orphaned_files.fetch_path

content::item::upload_file.get_parent_existing_filenames

content::revision::new.update_lob_attribute

content::init_all.get_template_url

content::init.get_live_revision

content::init_all.get_live_revision

cr::keyword::item_unassign.item_unassign

cr::keyword::get_keyword_id.select_keyword_id

cr::keyword::item_unassign_children.item_unassign_children

cr::keyword::item_get_assigned.get_keywords

cr::keyword::item_get_assigned.get_child_keywords

cr::keyword::get_options_flat.select_keyword_options

publish::write_content.get_revision_id

.xql-file reform of acs-automated-testing

- remove sql statements from the code, where these are provided via .xql

- prefer empty sql statements over various forms of *SQL*

- remove unneeded sql queries (postgres and oracle)

aa_run_testcase.delete_testcase_results_sql

aa_run_testcase.delete_testcase_final_results_sql

- prefer empty sql statements over various forms of *SQL*

.xql-file reform of acs-admin

- remove sql statements from the code, where these are provided via .xql

- prefer empty sql statements over various forms of *SQL*

- remove obsolete Oracle queries

member_approve

member_ban

member_reject

member_deleted

member_unapprove

user_info

- remove obsolete .xql files (containing only unused query names)

www/users/modify-admin-privileges-oracle.xql

www/users/modify-admin-privileges-postgresql.xql

www/users/user-add-2.xql

.xql-file reform of acs-subsite:

- remove queries from .tcl files that can't work

from PostgreSQL (e.g. containing "connect by" or "nvl")

- remove obsolete file www/admin/site-map/parameter-set.tcl

.xql-file reform of acs-subsite:

- remove obsolete queries

email_image::new_item.new_lob_size

email_image::new_item.new_lob_size

group::member_p.group_id_from_name

subsite::default::create_app_group.group_exists

package_mounted_p

- add missing Oracle queries

acs-subsite/tcl/rel-types-procs-oracle.xql

rel_types::additional_rel_types_group_p.group_rel_type_exists

rel_types::additional_rel_types_group_type_p.group_rel_type_exists

www/admin/group-types/new-oracle.xql

select_group_supertypes

- add missing PostgreSQL queries

acs-subsite/tcl/rel-types-procs-postgresql.xql.xql

rel_types::additional_rel_types_group_p.group_rel_type_exists

- remove obsolete files

www/admin/index-oracle.xql

www/admin/index-postgresql.xql

www/admin/index.xql

www/admin/rel-types/roles/new-oracle.xql

www/admin/rel-types/roles/new-postgresql.xql

www/permissions/one.xql

www/pvt/unsubscribe-2-oracle.xql

www/pvt/unsubscribe-2-postgresql.xql

www/pvt/unsubscribe-oracle.xql

www/pvt/unsubscribe-postgresql.xql

www/pvt/unsubscribe.xql

www/register/user-new.xql

www/shared/portrait-bits-oracle.xql

www/shared/portrait-bits-postgresql.xql

www/shared/portrait-bits.xql

  1. … 12 more files in changeset.
.xql-file reform of acs-tcl (part 3)

- remove obsolete queries

ad_acs_admin_id.acs_admin_id_get

ad_db_select_widget.currency_info

ad_maybe_redirect_for_registration.sql_test_1

ad_maybe_redirect_for_registration.sql_test_2

ad_permission_p.n_privs

ad_user_class_query.sql_post_select_for_user_class

apm_file_add.apm_file_add

apm_file_remove.apm_file_remove

apm_package_install.version_exists_p

site_node::get_url_from_object_id.select_url_from_object_id

user_search

- remove obsolete files

tcl/00-database-procs-postgresql-postgresql.xql

tcl/00-database-procs-postgresql.tcl

tcl/defs-procs-oracle.xql

tcl/defs-procs-postgresql.xql

tcl/deprecated-utilities-procs.xql

tcl/request-processor-init.xql

tcl/request-processor-procs-oracle.xql

tcl/request-processor-procs-postgresql.xql

tcl/widgets-procs.xql

    • -10
    • +0
    /openacs-4/packages/acs-tcl/tcl/admin-procs.xql
  1. … 8 more files in changeset.
.xql-file reform of acs-tcl (part 2)

- remove unsused .xql queries

apm_package_list_search_order.get_dependencies

- remove redundant .xql queries

apm_package_version_installed_p.apm_package_version_installed_p

apm_generate_package_spec.callback_info

.xql-file reform of acs-tcl (part 1)

- remove sql statements from the code, where these are provided via .xql

- prefer empty sql statements over various forms of *SQL*

- remove pre xotcl 2.0 code

- use consistently scope_eval instead of per-method handling

- xo::api handles all in thread executions via "do"

- use higher level api

- avoid generation of links with four leading colons