Kasutajaliidesed lab 2 web service definitions

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

<!-- party -->

   <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>


<!-- note -->


   <function>
    <name>/note_all</name>     
    <doc>    
    </doc>	
    <sql>
      select * from note 
    </sql>
    <nsqlparams>0</nsqlparams>
    <nrparams>0</nrparams>
    <fparams>0</fparams>
    <fname>psql_select</fname>
    <output>xml</output>
    <auth>N</auth>
  </function>
  
  
  <function>
    <name>/note_select</name>     
    <doc>    
    </doc>	
    <sql>
      select *
      from note 
      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>/note_insert</name>
    <sql>
      insert into note 
       (id,partyid,student      
        ,notetext,notecategory,poster,postingdatetime,picturefile)          	    
      values
       (nextval('house_sequence'),':1',':2',
       ':3',':4',':5',now(),':6')       
    </sql>
    <nsqlparams>0</nsqlparams>
    <nrparams>6</nrparams>
    <fparams>0</fparams>
    <fname>psql_select</fname>
    <auth>N</auth>  
  </function>


   <function>           
    <name>/note_update</name>
    <sql>
     update note set 
       partyid=':3',
       notetext=':4',
       notecategory=':5',
       poster=':6',
       postingdatetime=now(),
       picturefile=':7'     
     where id=':1' and student=':2'
    </sql>
    <nsqlparams>0</nsqlparams>
    <nrparams>7</nrparams>
    <fparams>0</fparams>
    <fname>psql_select</fname>
    <auth>N</auth>  
  </function>



<!-- house functions -->

   <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>


<!-- description functions -->


   <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>



<!-- visit functions -->


   <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>