Tammet – 3. aprill 2006, kell 10:33

2006-04-03T10:33:55Z

@@ 1. rida: / 1. rida: @@
 <pre>
 <?xml version="1.0" encoding="iso-8859-1"?>
 <functions>
     <function>
@@ 80. rida: / 81. rida: @@
      <auth>N</auth>
    </function>
@@ 299. rida: / 377. rida: @@
 </functions>
 </pre>

Tammet – 3. aprill 2006, kell 09:56

2006-04-03T09:56:18Z

Uus lehekülg

<pre>

<?xml version="1.0" encoding="iso-8859-1"?>
<functions>

<function>
<name>/party_all</name>
<doc>
</doc>
<sql>
select * from party
</sql>
<nsqlparams>0</nsqlparams>
<nrparams>0</nrparams>
<fparams>0</fparams>
<fname>psql_select</fname>
<output>xml</output>
<auth>N</auth>
</function>

<function>
<name>/party_select</name>
<doc>
</doc>
<sql>
select *
from party
where student=':3' and :4
order by :1 :2
</sql>
<nsqlparams>0</nsqlparams>
<nrparams>4</nrparams>
<fparams>2</fparams>
<fname>psql_select</fname>
<output>xml</output>
<auth>N</auth>
</function>

<function>
<name>/party_insert</name>
<sql>
insert into party
(id,student,autent,name,organizer,date,time,duration,location,
xcoordinate,ycoordinate,type,poster,postingdatetime,status)
values
(nextval('house_sequence'),':1',':2',':3',':4',':5',':6',':7',':8',
':9',':10',':11',':12',now(),'A');
</sql>
<nsqlparams>0</nsqlparams>
<nrparams>12</nrparams>
<fparams>0</fparams>
<fname>psql_select</fname>
<auth>N</auth>
</function>

<function>
<name>/party_update</name>
<sql>
update party set
name=':4',
organizer=':5',
date=':6',
time=':7',
duration=':8',
location=':9',
xcoordinate=':10',
ycoordinate=':11',
type=':12',
poster=':13',
status=':14'
where id=':1' and student=':2' and autent=':3'
</sql>
<nsqlparams>0</nsqlparams>
<nrparams>14</nrparams>
<fparams>0</fparams>
<fname>psql_select</fname>
<auth>N</auth>
</function>



<function>
<name>/house_all</name>
<doc>
</doc>
<sql>
select * from house
</sql>
<nsqlparams>0</nsqlparams>
<nrparams>0</nrparams>
<fparams>0</fparams>
<fname>psql_select</fname>
<output>xml</output>
<auth>N</auth>
</function>

<function>
<name>/house_select</name>
<doc>
</doc>
<sql>
select *
from house
where student=':3' and :4
order by :1 :2
</sql>
<nsqlparams>0</nsqlparams>
<nrparams>4</nrparams>
<fparams>2</fparams>
<fname>psql_select</fname>
<output>xml</output>
<auth>N</auth>
</function>

<function>
<name>/house_insert</name>
<sql>
insert into house
(id,student,category,city,address,price,owner,stories)
values
(nextval('house_sequence'),':1',':2',':3',':4',:5,':6',:7);
</sql>
<nsqlparams>0</nsqlparams>
<nrparams>7</nrparams>
<fparams>0</fparams>
<fname>psql_select</fname>
<auth>N</auth>
</function>

<function>
<name>/house_update</name>
<sql>
update house set
category=':3',
city=':4',
address=':5',
price=:6,
owner=':7',
stories=:8
where id=':1' and student=':2'
</sql>
<nsqlparams>0</nsqlparams>
<nrparams>8</nrparams>
<fparams>0</fparams>
<fname>psql_select</fname>
<auth>N</auth>
</function>

<function>
<name>/house_delete</name>
<sql>
delete from house where id=':1' and student=':2'
</sql>
<nsqlparams>0</nsqlparams>
<nrparams>2</nrparams>
<fparams>0</fparams>
<fname>psql_select</fname>
<auth>N</auth>
</function>



<function>
<name>/decription_all</name>
<doc>
</doc>
<sql>
select * from description
</sql>
<nsqlparams>0</nsqlparams>
<nrparams>0</nrparams>
<fparams>0</fparams>
<fname>psql_select</fname>
<output>xml</output>
<auth>N</auth>
</function>

<function>
<name>/description_select</name>
<doc>
</doc>
<sql>
select *
from description
where student=':3' and :4
order by :1 :2
</sql>
<nsqlparams>0</nsqlparams>
<nrparams>4</nrparams>
<fparams>2</fparams>
<fname>psql_select</fname>
<output>xml</output>
<auth>N</auth>
</function>

<function>
<name>/description_insert</name>
<sql>
insert into description
(id,student,houseid,enterdate,description,points)
values
(nextval('house_sequence'),':1',':2',current_date,':3',:4);
</sql>
<nsqlparams>0</nsqlparams>
<nrparams>4</nrparams>
<fparams>0</fparams>
<fname>psql_select</fname>
<auth>N</auth>
</function>

<function>
<name>/description_delete</name>
<sql>
delete from description where id=':1' and student=':2'
</sql>
<nsqlparams>0</nsqlparams>
<nrparams>2</nrparams>
<fparams>0</fparams>
<fname>psql_select</fname>
<auth>N</auth>
</function>



<function>
<name>/visit_all</name>
<doc>
</doc>
<sql>
select * from visit
</sql>
<nsqlparams>0</nsqlparams>
<nrparams>0</nrparams>
<fparams>0</fparams>
<fname>psql_select</fname>
<output>xml</output>
<auth>N</auth>
</function>

<function>
<name>/visit_select</name>
<doc>
</doc>
<sql>
select *
from visit
where student=':3' and :4
order by :1 :2
</sql>
<nsqlparams>0</nsqlparams>
<nrparams>4</nrparams>
<fparams>2</fparams>
<fname>psql_select</fname>
<output>xml</output>
<auth>N</auth>
</function>

<function>
<name>/visit_insert</name>
<sql>
insert into visit
(id,student,houseid,category,visitdate,description,points)
values
(nextval('house_sequence'),':1',':2',':3',':4',':5',:6);
</sql>
<nsqlparams>0</nsqlparams>
<nrparams>6</nrparams>
<fparams>0</fparams>
<fname>psql_select</fname>
<auth>N</auth>
</function>

<function>
<name>/visit_delete</name>
<sql>
delete from visit where id=':1' and student=':2'
</sql>
<nsqlparams>0</nsqlparams>
<nrparams>2</nrparams>
<fparams>0</fparams>
<fname>psql_select</fname>
<auth>N</auth>
</function>

</functions>

</pre>

Kasutajaliidesed lab 2 web service definitions - Redigeerimiste ajalugu

Tammet – 3. aprill 2006, kell 10:33

Tammet – 3. aprill 2006, kell 09:56