Skip test for those applets associated with a package_id of 0 (happens when no community with this applet is on the system, verified that for 'real' applets this is fine)
Set package_id explicitly as the main subsite package, as ad_conn package_id could not be properly initialized for tests when a system was freshly restarted
Simplify idioms, handle also the case where multiple results might come from the query, as the datamodel doesn't state it clearly and we also had a suspicious orderby
Fix News automated tests: - rename tests using underscore instead of '-' or links in UI would not work - remove duplicated SQL - fix awkward hardcoded dates that were supposed to be in the future for test to work
Make sure namespaced variable ::acs::db_pools is created before accessing itThis is needed when upgrading from openacs versions that didn't use this variable before
it seems, we can reactivate per-request caching for sitenodes, otherwise we see up to 37 locks per requests on get_node_id on openacs.org (regression test works fine)