Webware for Python

On Friday 21 December 2001 08:35 am, Ng Pheng Siong wrote:
> I know of the following problems:
>
> 1. Application.py's line 731, "assert isinstance(factory,
> ServletFactory)", fails for PSPExamples (but not those that came
> before):

That usually indicates the infamous "duplicate module problem" whereby 
Python has managed to load the same module twice through different 
paths. It's a subtle bug that WebKit once suffered from. I'm still 
under the impression that Python should fix this by tracking the 
absolute paths of modules, but I don't know the internals well enough 
for a patch and my suggestion was not well received on c.l.p.

>     $ python HttpAppServer.py
>     [...]
>     Loading plug-in: MiscUtils at

What directory is your HttpAppServer.py located in when you launch it? 
If in WebKit/ you might consult Launch.py for the solution.

> 2. PushServlet's output is buffered.
>
> 3. Shutdown works with IE (on Windows) but not with Netscape (Windows
> or FreeBSD). I don't have another browser to test.

If you have FreeBSD you can probably get lynx, Galeon, opera, etc. 
Strange that it doesn't work.


-Chuck

On Thu, Dec 27, 2001 at 05:42:49PM -0800, Chuck Esterbrook wrote:
> > 1. Application.py's line 731, "assert isinstance(factory,
> > ServletFactory)", fails for PSPExamples (but not those that came
> > before):
> >
> What directory is your HttpAppServer.py located in when you launch it? 
> If in WebKit/ you might consult Launch.py for the solution.

I've modified HttpAppServer to be compatible with Launch.py, and this
problem went away. 


> > 2. PushServlet's output is buffered.

I now have a version that allows PushServlet to work, but it doesn't smell
nice. ;-) Since I don't need the server-push functionality, I probably
won't release this other version.


> > 3. Shutdown works with IE (on Windows) but not with Netscape (Windows
> > or FreeBSD). I don't have another browser to test.
> 
> If you have FreeBSD you can probably get lynx, Galeon, opera, etc. 
> Strange that it doesn't work.

To elaborate: the app server part shut down nicely, but HTTPServer's
serve_forever() loop went around one more time. ;-\ I've added a simple
bandaid. 

(I'm ready to give up on Netscape entirely anyways and will probably go for
Mozilla on my Unix boxen.)

Cheers.
-- 
Ng Pheng Siong <ngps@...> * http://www.netmemetic.com

I am trying to get a Postgres notification event heard in webware and having problems with what should be simple PG code.

I'm trying to link a notify to a trigger, but I cannot seem to get notify working in a function.  I only have C or SQL as a lang in
the server, I do not have PL/pgSQL installed on this server.

Should something as simple as
create function wc_send_notify()
return int4
AS '
notify wc_configuration_changed;
select 1;
'
language 'SQL';


Thanks,
-Aaron Held

On Fri, Jan 04, 2002 at 01:54:51PM -0500, Aaron Held wrote:
> I am trying to get a Postgres notification event heard in webware and
> having problems with what should be simple PG code.
> 
> I'm trying to link a notify to a trigger, but I cannot seem to get notify
> working in a function.  I only have C or SQL as a lang in the server, I
> do not have PL/pgSQL installed on this server.
> 
> Should something as simple as 
> create function wc_send_notify() 
> return int4 
> AS ' 
> notify wc_configuration_changed; 
> select 1; 
> ' language 'SQL';

Should be "returns", not "return". Otherwise, the function works for me:

    pgnotify_test=> create function test_notify()
    pgnotify_test-> returns int4
    pgnotify_test-> as 'notify wc_config; select 1'
    pgnotify_test-> language 'sql';
    CREATE

    pgnotify_test=> listen wc_config;
    LISTEN

    pgnotify_test=> select test_notify();
     test_notify 
    -------------
               1
    (1 row)
    
    Asynchronous NOTIFY 'wc_config' from backend with pid '571' received.


However, you can't use the function in a trigger because trigger functions
must return "opaque", and you can't create functions that return opaque in
language 'sql':

    pgnotify_test=> create table test (id int primary key);
    NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'test_pkey' for table 'test'
    CREATE

    pgnotify_test=> create trigger boom                                   
    pgnotify_test-> after insert
    pgnotify_test-> on test
    pgnotify_test-> for each row
    pgnotify_test-> execute procedure test_notify();
    ERROR:  CreateTrigger: function test_notify() must return OPAQUE
    
    pgnotify_test=> drop function test_notify();
    DROP

    pgnotify_test=> create function test_notify()
    pgnotify_test-> returns opaque
    pgnotify_test-> as 'notify wc_config; select 1'
    pgnotify_test-> language 'sql';
    ERROR:  ProcedureCreate: sql functions cannot return type "opaque"



-- 
Ng Pheng Siong <ngps@...> * http://www.netmemetic.com