OpenACS / openacs-4 / packages / news-aggregator / tcl

source-procs-postgresql.xql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 4
Last Commit: 18:36
Commits this week: 0
Total Lines of Code (LoC): 61
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 3 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 05 Oct 2021
12:36 pm

antoniop

Use portable SQL idioms

Options
    • -6
    • +0
    ./source-procs-postgresql.xql
  2. … 1 more file in changeset.
Wednesday 18 Jul 2018
11:08 am

antoniop

Package rework and maintenance

- deprecate undocumented news_aggregator::source::get_identifier as no mention was found in upstream code (fixes automated tests)

- put all portable sql inline

- rework all sql idioms that could be made portable

- remove leftover sql statements

- simplify idioms

Options
    • -34
    • +1
    ./source-procs-postgresql.xql
  2. … 2 more files in changeset.
Tuesday 17 Jul 2018
5:48 pm

antoniop

Rework of news_aggregator::source::update

- replace deprecated calls

- replace array idioms with dict idioms

- bring portable sql inline

This was tested against RSS feeds used downstream on a vanilla instance

Options
    • -26
    • +1
    ./source-procs-postgresql.xql
  2. … 2 more files in changeset.
3:28 pm

antoniop

Almost complete rewrite of news_aggregator::source::new

- replace deprecated calls

- remove code duplication

- don't loop through response items, as nothing is done with that information

- replace array idioms with dict idioms

- let stored procedure figure out the object_id

Works on WU RSS URLs on a vanilla instance

Options
    • -7
    • +6
    ./source-procs-postgresql.xql
  2. … 2 more files in changeset.
Sunday 15 Jan 2006
12:27 am

michaels

lots of little tweaks for data cleanup on uninstantiate, some more UI work, bug fixes, etc.; added daveb's sweeper proc; not tagging v0.9.8 just yet though

Options
    • -3
    • +2
    ./source-procs-postgresql.xql
  2. … 25 more files in changeset.
Monday 02 Jan 2006
9:49 pm

michaels

fixing something minor i broke in proc args and changing now() to current_timestamp

Options
    • -4
    • +15
    ./source-procs-postgresql.xql
  2. … 1 more file in changeset.
Sunday 27 Feb 2005
6:07 pm

jeffd

fix missing rdbms things and a few oracle or postgresisms that snuck in the wrong files

Options
    • -0
    • +2
    ./source-procs-postgresql.xql
  2. … 57 more files in changeset.
Tuesday 01 Jun 2004
2:18 pm

gyang

Support for item-level author and pubDate elements (news-aggregator)

Options
    • -1
    • +15
    ./source-procs-postgresql.xql
  2. … 4 more files in changeset.
Sunday 30 May 2004
2:29 pm

gyang

Changes to source procs in news-aggregator:

- Formatting (tabs)

- Implement source::update_all -all_sources correctly, so that the -all_sources flag actually updates all sources regardless of when they were last updated

- Now using the RSS parser in feed-parser

Options
    • -1
    • +7
    ./source-procs-postgresql.xql
  2. … 1 more file in changeset.
Saturday 20 Mar 2004
3:06 pm

gyang

Reshuffled some queries into DB-spsecific .xql files

Options
    • -19
    • +0
    ./source-procs-postgresql.xql
  2. … 3 more files in changeset.
2:21 pm

gyang

Fixed various bugs so that it works in HEAD now. This version is labelled 0.6d and will carry the tag news-aggregator-0-6d

Options
    • -1
    • +7
    ./source-procs-postgresql.xql
  2. … 3 more files in changeset.
12:04 pm

gyang

Import of news-aggregator version 0.4d (from Guan's and Simon's CVS) by Guan Yang <guan@unicast.org>

Options
    • -0
    • +0
    ./source-procs-postgresql.xql
  2. … 80 more files in changeset.
12:04 pm

gyang

Initial revision

Options
    • -0
    • +117
    ./source-procs-postgresql.xql
  2. … 66 more files in changeset.