Index: openacs-4/contrib/obsolete-packages/postcard/postcard.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/postcard/postcard.info,v diff -u -r1.1 -r1.2 --- openacs-4/contrib/obsolete-packages/postcard/postcard.info 20 Apr 2001 20:51:22 -0000 1.1 +++ openacs-4/contrib/obsolete-packages/postcard/postcard.info 7 May 2001 19:19:17 -0000 1.2 @@ -1,48 +1,61 @@ - - - - - Postcard - Postcards - f - - - - oracle - postgresql - - Henry Minsky - Send electronics postcards - 2001-01-03 + + + + + Postcard + Postcards + f + + + + oracle + postgresql + + Henry Minsky + Send electronics postcards + 2001-01-03 This lets create and send postcards. It is a simple -demo application which uses ACS 4 templating. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +demo application which uses ACS 4 templating. + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: openacs-4/contrib/obsolete-packages/postcard/sql/postgresql/postcard-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/postcard/sql/postgresql/postcard-create.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/postcard/sql/postgresql/postcard-create.sql 7 May 2001 19:19:06 -0000 1.1 @@ -0,0 +1,23 @@ +-- electronic postcard +create sequence postcard_seq; +create sequence postcard_image_seq; + +create table postcard_images ( + card_image_id integer primary key, + image oid not null, + mime_type varchar(100), + title varchar(1000), + description varchar(4000) +); + +create table postcards ( + card_id integer primary key, + card_picture references postcard_images, + recipient varchar(1000), + sender varchar(1000), + message varchar(4000), + pickup_code varchar(1000), + picked_up date +); + + Index: openacs-4/contrib/obsolete-packages/postcard/sql/postgresql/postcard-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/postcard/sql/postgresql/postcard-drop.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/postcard/sql/postgresql/postcard-drop.sql 7 May 2001 19:19:06 -0000 1.1 @@ -0,0 +1,5 @@ +drop table postcard_images; +drop table postcards; +drop sequence postcard_seq; +drop sequence postcard_image_seq; + Index: openacs-4/contrib/obsolete-packages/postcard/www/add-picture-2-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/postcard/www/add-picture-2-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/postcard/www/add-picture-2-oracle.xql 7 May 2001 19:19:59 -0000 1.1 @@ -0,0 +1,17 @@ + + + + oracle8.1.6 + + + + + insert into postcard_images (card_image_id, image, mime_type, title, description) + values (postcard_image_seq.nextval, empty_blob(), :mime_type, :title, :description) + returning image into :1 + + + + + + Index: openacs-4/contrib/obsolete-packages/postcard/www/add-picture-2-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/postcard/www/add-picture-2-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/postcard/www/add-picture-2-postgresql.xql 7 May 2001 19:19:59 -0000 1.1 @@ -0,0 +1,16 @@ + + + + postgresql7.1 + + + + insert into postcard_images (card_image_id, image, mime_type, title, description) + values (postcard_image_seq.nextval, + [set __lob_id [db_string get_id "select empty_lob()"]], + :mime_type, :title, :description) + + + + + Index: openacs-4/contrib/obsolete-packages/postcard/www/dump-cards.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/postcard/www/dump-cards.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/postcard/www/dump-cards.xql 7 May 2001 19:19:59 -0000 1.1 @@ -0,0 +1,15 @@ + + + + + + + select card_id, card_picture, recipient, sender, message + from postcards + order by card_id + + + + + + Index: openacs-4/contrib/obsolete-packages/postcard/www/postcard-picture-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/postcard/www/postcard-picture-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/postcard/www/postcard-picture-oracle.xql 7 May 2001 19:19:59 -0000 1.1 @@ -0,0 +1,17 @@ + + + + oracle8.1.6 + + + + +select image + from postcard_images + where card_image_id = $image_id + + + + + + Index: openacs-4/contrib/obsolete-packages/postcard/www/postcard-picture-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/postcard/www/postcard-picture-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/postcard/www/postcard-picture-postgresql.xql 7 May 2001 19:19:59 -0000 1.1 @@ -0,0 +1,17 @@ + + + + postgresql7.1 + + + +-- FIX ME LOB + select image + from postcard_images + where card_image_id = $image_id + + + + + + Index: openacs-4/contrib/obsolete-packages/postcard/www/postcard-picture.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/postcard/www/postcard-picture.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/postcard/www/postcard-picture.xql 7 May 2001 19:19:59 -0000 1.1 @@ -0,0 +1,14 @@ + + + + + + + select mime_type + from postcard_images + where card_image_id = :image_id + + + + + Index: openacs-4/contrib/obsolete-packages/postcard/www/send-card.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/postcard/www/send-card.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/postcard/www/send-card.xql 7 May 2001 19:19:59 -0000 1.1 @@ -0,0 +1,23 @@ + + + + + + + insert into postcards (card_id, pickup_code, card_picture, recipient, sender, message) + values (:card_id, :pickup_code, :image_id, :recipient, :sender, :message) + + + + + + + + + select max(card_id) as card_id from postcards + + + + + + Index: openacs-4/contrib/obsolete-packages/postcard/www/show-card-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/postcard/www/show-card-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/postcard/www/show-card-oracle.xql 7 May 2001 19:19:59 -0000 1.1 @@ -0,0 +1,17 @@ + + + + oracle8.1.6 + + + + + update postcards + set picked_up = sysdate + where pickup_code = :pickup_code + + + + + + Index: openacs-4/contrib/obsolete-packages/postcard/www/show-card-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/postcard/www/show-card-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/postcard/www/show-card-postgresql.xql 7 May 2001 19:19:59 -0000 1.1 @@ -0,0 +1,17 @@ + + + + postgresql7.1 + + + + + update postcards + set picked_up = current_time + where pickup_code = :pickup_code + + + + + + Index: openacs-4/contrib/obsolete-packages/postcard/www/show-card.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/postcard/www/show-card.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/obsolete-packages/postcard/www/show-card.xql 7 May 2001 19:19:59 -0000 1.1 @@ -0,0 +1,15 @@ + + + + + + + select card_id, card_picture as image_id, recipient, sender, message, picked_up + from postcards + where pickup_code = :pickup_code + + + + + + Index: openacs-4/packages/postcard/postcard.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/postcard/postcard.info,v diff -u -r1.1 -r1.2 --- openacs-4/packages/postcard/postcard.info 20 Apr 2001 20:51:22 -0000 1.1 +++ openacs-4/packages/postcard/postcard.info 7 May 2001 19:19:17 -0000 1.2 @@ -1,48 +1,61 @@ - - - - - Postcard - Postcards - f - - - - oracle - postgresql - - Henry Minsky - Send electronics postcards - 2001-01-03 + + + + + Postcard + Postcards + f + + + + oracle + postgresql + + Henry Minsky + Send electronics postcards + 2001-01-03 This lets create and send postcards. It is a simple -demo application which uses ACS 4 templating. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +demo application which uses ACS 4 templating. + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: openacs-4/packages/postcard/sql/postgresql/postcard-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/postcard/sql/postgresql/postcard-create.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/postcard/sql/postgresql/postcard-create.sql 7 May 2001 19:19:06 -0000 1.1 @@ -0,0 +1,23 @@ +-- electronic postcard +create sequence postcard_seq; +create sequence postcard_image_seq; + +create table postcard_images ( + card_image_id integer primary key, + image oid not null, + mime_type varchar(100), + title varchar(1000), + description varchar(4000) +); + +create table postcards ( + card_id integer primary key, + card_picture references postcard_images, + recipient varchar(1000), + sender varchar(1000), + message varchar(4000), + pickup_code varchar(1000), + picked_up date +); + + Index: openacs-4/packages/postcard/sql/postgresql/postcard-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/postcard/sql/postgresql/postcard-drop.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/postcard/sql/postgresql/postcard-drop.sql 7 May 2001 19:19:06 -0000 1.1 @@ -0,0 +1,5 @@ +drop table postcard_images; +drop table postcards; +drop sequence postcard_seq; +drop sequence postcard_image_seq; + Index: openacs-4/packages/postcard/www/add-picture-2-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/postcard/www/add-picture-2-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/postcard/www/add-picture-2-oracle.xql 7 May 2001 19:19:59 -0000 1.1 @@ -0,0 +1,17 @@ + + + + oracle8.1.6 + + + + + insert into postcard_images (card_image_id, image, mime_type, title, description) + values (postcard_image_seq.nextval, empty_blob(), :mime_type, :title, :description) + returning image into :1 + + + + + + Index: openacs-4/packages/postcard/www/add-picture-2-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/postcard/www/add-picture-2-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/postcard/www/add-picture-2-postgresql.xql 7 May 2001 19:19:59 -0000 1.1 @@ -0,0 +1,16 @@ + + + + postgresql7.1 + + + + insert into postcard_images (card_image_id, image, mime_type, title, description) + values (postcard_image_seq.nextval, + [set __lob_id [db_string get_id "select empty_lob()"]], + :mime_type, :title, :description) + + + + + Index: openacs-4/packages/postcard/www/dump-cards.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/postcard/www/dump-cards.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/postcard/www/dump-cards.xql 7 May 2001 19:19:59 -0000 1.1 @@ -0,0 +1,15 @@ + + + + + + + select card_id, card_picture, recipient, sender, message + from postcards + order by card_id + + + + + + Index: openacs-4/packages/postcard/www/postcard-picture-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/postcard/www/postcard-picture-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/postcard/www/postcard-picture-oracle.xql 7 May 2001 19:19:59 -0000 1.1 @@ -0,0 +1,17 @@ + + + + oracle8.1.6 + + + + +select image + from postcard_images + where card_image_id = $image_id + + + + + + Index: openacs-4/packages/postcard/www/postcard-picture-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/postcard/www/postcard-picture-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/postcard/www/postcard-picture-postgresql.xql 7 May 2001 19:19:59 -0000 1.1 @@ -0,0 +1,17 @@ + + + + postgresql7.1 + + + +-- FIX ME LOB + select image + from postcard_images + where card_image_id = $image_id + + + + + + Index: openacs-4/packages/postcard/www/postcard-picture.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/postcard/www/postcard-picture.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/postcard/www/postcard-picture.xql 7 May 2001 19:19:59 -0000 1.1 @@ -0,0 +1,14 @@ + + + + + + + select mime_type + from postcard_images + where card_image_id = :image_id + + + + + Index: openacs-4/packages/postcard/www/send-card.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/postcard/www/send-card.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/postcard/www/send-card.xql 7 May 2001 19:19:59 -0000 1.1 @@ -0,0 +1,23 @@ + + + + + + + insert into postcards (card_id, pickup_code, card_picture, recipient, sender, message) + values (:card_id, :pickup_code, :image_id, :recipient, :sender, :message) + + + + + + + + + select max(card_id) as card_id from postcards + + + + + + Index: openacs-4/packages/postcard/www/show-card-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/postcard/www/show-card-oracle.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/postcard/www/show-card-oracle.xql 7 May 2001 19:19:59 -0000 1.1 @@ -0,0 +1,17 @@ + + + + oracle8.1.6 + + + + + update postcards + set picked_up = sysdate + where pickup_code = :pickup_code + + + + + + Index: openacs-4/packages/postcard/www/show-card-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/postcard/www/show-card-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/postcard/www/show-card-postgresql.xql 7 May 2001 19:19:59 -0000 1.1 @@ -0,0 +1,17 @@ + + + + postgresql7.1 + + + + + update postcards + set picked_up = current_time + where pickup_code = :pickup_code + + + + + + Index: openacs-4/packages/postcard/www/show-card.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/postcard/www/show-card.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/postcard/www/show-card.xql 7 May 2001 19:19:59 -0000 1.1 @@ -0,0 +1,15 @@ + + + + + + + select card_id, card_picture as image_id, recipient, sender, message, picked_up + from postcards + where pickup_code = :pickup_code + + + + + +