Kasutajaliidesed lectures lab 2 requirements - Redigeerimiste ajalugu

Tammet – 22. mai 2007, kell 09:41

2007-05-22T09:41:16Z

←Vanem redaktsioon		Redaktsioon: 22. mai 2007, kell 11:41
104. rida:		104. rida:

	Open the url when the java server from above works: http://localhost:8080/allparties		Open the url when the java server from above works: http://localhost:8080/allparties

			Example url for submitting values (replace 1,2 etc with string values from your form, replace dates with date values from your form):
			http://dijkstra.cs.ttu.ee:7777/xstone/xfuns/party_insert?1&2&3&4&01.01.2000&02.02.2001&7&8&9&10&11&12

Tammet: /* Great example code */

2007-05-09T16:43:13Z

Great example code

←Vanem redaktsioon		Redaktsioon: 9. mai 2007, kell 18:43
102. rida:		102. rida:
	</xsl:stylesheet>		</xsl:stylesheet>
	</pre>		</pre>

			Open the url when the java server from above works: http://localhost:8080/allparties

Tammet: /* Great example code */

2007-05-09T16:38:11Z

Great example code

←Vanem redaktsioon		Redaktsioon: 9. mai 2007, kell 18:38
80. rida:		80. rida:
	Check this half-baked code from a lecture for a standalone Java server in j2se doing all you need (sort of):		Check this half-baked code from a lecture for a standalone Java server in j2se doing all you need (sort of):
	[[Kasutajaliidesed lab 2 java server example]]		[[Kasutajaliidesed lab 2 java server example]]

			Check this small parties.xsl example:
			<pre>
			<xsl:stylesheet version="1.0"
			xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
			xmlns="http://www.w3.org/TR/xhtml1/strict">
			<xsl:output method="html"/>
			<xsl:template match="/">
			<html>
			<table>
			<xsl:for-each select="/data/rec">
			<tr>
			<td><xsl:value-of select="ID"/></td>
			<td><xsl:value-of select="STUDENT"/></td>
			</tr>
			</xsl:for-each>
			</table>
			this is output
			</html>
			</xsl:template>
			</xsl:stylesheet>
			</pre>

Tammet – 3. aprill 2006, kell 15:44

2006-04-03T15:44:54Z

←Vanem redaktsioon		Redaktsioon: 3. aprill 2006, kell 17:44
75. rida:		75. rida:
	* Date format is MM-DD-YYYY.		* Date format is MM-DD-YYYY.
	* You can check the success of insert/update by the resulting xml		* You can check the success of insert/update by the resulting xml

			== Great example code ==

			Check this half-baked code from a lecture for a standalone Java server in j2se doing all you need (sort of):
			[[Kasutajaliidesed lab 2 java server example]]

Tammet: /* Details about arguments to web services */

2006-04-03T10:40:56Z

Details about arguments to web services

←Vanem redaktsioon		Redaktsioon: 3. aprill 2006, kell 12:40
71. rida:		71. rida:
	** party_insert: the first arg is student code, the following are data fields		** party_insert: the first arg is student code, the following are data fields
	** note_insert: the first arg is the id of the corresponding party, second is student code, rest are data fields		** note_insert: the first arg is the id of the corresponding party, second is student code, rest are data fields
	* update: first arg for party_update and note_update is the id of the row to be updated. The following arguments are exactly as for insert.		* update: first arg for party_update and note_update is the id of the row to be updated. The following arguments are either exactly as (note) or similar to (party) for insert.
	* delete: no delete provided for party or note. Use party.status in your app instead.		* delete: no delete provided for party or note. Use party.status in your app instead.
	* Date format is MM-DD-YYYY.		* Date format is MM-DD-YYYY.
	* You can check the success of insert/update by the resulting xml		* You can check the success of insert/update by the resulting xml

Tammet – 3. aprill 2006, kell 10:39

2006-04-03T10:39:25Z

←Vanem redaktsioon		Redaktsioon: 3. aprill 2006, kell 12:39
68. rida:		68. rida:
	** nr of rows to get.		** nr of rows to get.
	** from which row to start getting the data (first row is 1)		** from which row to start getting the data (first row is 1)
			* insert:
	* insert: ~~house_insert, description_insert ja visit_insert~~: ~~esimene argument on matriklinumber~~, ~~teised argumendid on juba vastavad infoväljad~~: ~~vaata eelpoolviidatud XML faili.~~ id ~~välja sisu tekitab URL-ga seotud SQL ise~~, ~~seda ei sisestata.~~		** party_insert: the first arg is student code, the following are data fields
	update: ~~house_update: esimene argument on maja~~ id~~, teine tudengi matriklinumber~~. ~~description ja~~ insert ~~tabelite jaoks update teenust pole, nende ridu saab ainult lisada/kustutada~~.		** note_insert: the first arg is the id of the corresponding party, second is student code, rest are data fields
	* delete: ~~house_delete, description_delete ja visit_delete: esimene argument on id, teine matriklinumber~~.		* update: first arg for party_update and note_update is the id of the row to be updated. The following arguments are exactly as for insert.
			* delete: no delete provided for party or note. Use party.status in your app instead.
	* Date format is MM-DD-YYYY.		* Date format is MM-DD-YYYY.
			* You can check the success of insert/update by the resulting xml
	* ~~Kui soovite jätta mõne arvu~~/~~kuupäevavälja tühjaks (eeldusel, et andmebaasi schema seda lubab), peab vastav argument URL-s (ampersandide vahel) olema tekst null.~~
	* Sisetamise/muutmise/kustutamise edukust saab tulemus-XML faili sisu järgi näha.

Tammet – 3. aprill 2006, kell 10:35

2006-04-03T10:35:20Z

←Vanem redaktsioon		Redaktsioon: 3. aprill 2006, kell 12:35
45. rida:		45. rida:
	The XSTONE server contains simple SQL functions for looking and modifying data in the given tables. Every web service corresponds to one SQL sentence.		The XSTONE server contains simple SQL functions for looking and modifying data in the given tables. Every web service corresponds to one SQL sentence.

	~~It is a good idea to~~ read:		You should read the following files specifying the schema and services for the lab:

	* [kasutajaliidesed lab 2 sql schema \| sql schema]].		* [[kasutajaliidesed lab 2 sql schema \| sql schema]].
	* [[kasutajaliidesed lab 2 web service definitions \| web service definitions]].		* [[kasutajaliidesed lab 2 web service definitions \| web service definitions]].
	* [[kasutajaliidesed lab 2 web service examples \| web service examples]]		* [[kasutajaliidesed lab 2 web service examples \| web service examples]]

Tammet – 3. aprill 2006, kell 10:06

2006-04-03T10:06:39Z

←Vanem redaktsioon		Redaktsioon: 3. aprill 2006, kell 12:06
34. rida:		34. rida:
	XSTONE server is called using ordinary url-s, via get. Post is not available. Web service url-s take string parameters without any parameter names: order matters. There is no authentication and you can test the services using an ordinary browswer.		XSTONE server is called using ordinary url-s, via get. Post is not available. Web service url-s take string parameters without any parameter names: order matters. There is no authentication and you can test the services using an ordinary browswer.

	~~Serveris asub andmebaas, kus on realiseeritud kolm tabelit:~~		== Database schema and concrete services ==

	The server contains a database with two tables:		The server contains a database with two tables:
42. rida:		42. rida:

	Observe that actually the schema contains also additional tables for similar application from 2005: tables house, description, visit and the corresponding web services. In case you are interested, see http://cs.ttu.ee/kursused/itv0030/prax2.html. You may use these web services for additional stuff, if you want. However, using them is in no way obligatory.		Observe that actually the schema contains also additional tables for similar application from 2005: tables house, description, visit and the corresponding web services. In case you are interested, see http://cs.ttu.ee/kursused/itv0030/prax2.html. You may use these web services for additional stuff, if you want. However, using them is in no way obligatory.

	~~It is a good idea to read the [[kasutajaliidesed lab 2 sql schema]].~~

	The XSTONE server contains simple SQL functions for looking and modifying data in the given tables. Every web service corresponds to one SQL sentence.		The XSTONE server contains simple SQL functions for looking and modifying data in the given tables. Every web service corresponds to one SQL sentence.

	It is a good idea to read ~~the [[kasutajaliidesed lab 2 web service definitions]].~~		It is a good idea to read:

			* [kasutajaliidesed lab 2 sql schema \| sql schema]].
			* [[kasutajaliidesed lab 2 web service definitions \| web service definitions]].
			* [[kasutajaliidesed lab 2 web service examples \| web service examples]]

			NB! We do not use authentication in this lab. Instead, each table row contains
			a student code for the student creating the application (in case you work as a group,
			please select the code for one of you). Your application must
			insert this code automatically (ie hard-coded into your app), it is NOT asked from
			the end user. The whole idea is to allow all students to use the same tables without
			messing up other students data.

	~~Nimetatud teenuste praktiliseks kasutamiseks vaata ja katseta kõigepealt selles failis toodud näidetega. NB! Nimetatud näiteid tuleb katsetamiseks igaühel veidi ümber teha.~~		== Details about arguments to web services ==

	~~NB! Antud praksi tabelite/veebiteenuste juures ei ole kasutatud mingit autentimist~~. ~~Selle asemel kasutame põhimõtet~~, ~~et igal tabeli real on kindlasti olemas sisestanud tudengi matriklinumber~~. ~~Selle numbri paneb sinna teieloodud rakendus automaatselt~~, ~~koodi sissekirjutatult~~, ~~seda ei küsita kasutajalt! Iga grupp peab seega valima, kumba tudengi matriklinumber koodi sisse kirjutatakse~~.		* all: party_all and note_all do not take arguments and will give the whole table contents. This could be big. Please avoid using in normal situations, just to test stuff, if necessary.
			* select: party_select, note_select take these args:
			** column to sort in the table
			** sorting order (asc or desc)
			** student code of the student writing the app
			** SQL-sentence WHERE-conditions (ie filter/search: in case you want to get all rows, enter 1=1).
			** nr of rows to get.
			** from which row to start getting the data (first row is 1)

	~~Lõpetuseks seletame veidi toodud teenuste põhimõtteid~~/~~argumente~~.		* insert: house_insert, description_insert ja visit_insert: esimene argument on matriklinumber, teised argumendid on juba vastavad infoväljad: vaata eelpoolviidatud XML faili. id välja sisu tekitab URL-ga seotud SQL ise, seda ei sisestata.
			update: house_update: esimene argument on maja id, teine tudengi matriklinumber. description ja insert tabelite jaoks update teenust pole, nende ridu saab ainult lisada/kustutada.
			* delete: house_delete, description_delete ja visit_delete: esimene argument on id, teine matriklinumber.
			* Date format is MM-DD-YYYY.

	* all: house_all, description_all ja visit_all ei võta mingeid argumente ja annavad kogu tabeli sisu, ilma selekteeringuta. Kuna see võib olla väga mahukas, siis palun kasutada väga ettevaatlikult, ainult vajadusel testimiseks (mitte aga rakenduses endas!).		* Kui soovite jätta mõne arvu/kuupäevavälja tühjaks (eeldusel, et andmebaasi schema seda lubab), peab vastav argument URL-s (ampersandide vahel) olema tekst null.
	* select: house_select, description_select ja visit_select võtavad järgmised argumendid:		* Sisetamise/muutmise/kustutamise edukust saab tulemus-XML faili sisu järgi näha.
	~~o sorteeritava tulba nimi vastavas sql tabelis~~
	~~o sorteerimisjärjekord (asc või desc)~~
	~~o tabeli rea sisestanud tudengi matriklinumber.~~
	~~o SQL-lause WHERE-tingimus ehk filter/otsing: kui tahta kõiki ridu saada, pane sinna tautoloogiline tingimus 1=1.~~
	~~o ridade arv: nii palju ridu saadetakse vastuseks (kui tabelis on üldse nii palju sobivaid ridu).~~
	~~o mitmendast reast alustatakse ridade andmist (esimene rida on 1).~~
	* insert: house_insert, description_insert ja visit_insert: esimene argument on matriklinumber, teised argumendid on juba vastavad infoväljad: vaata eelpoolviidatud XML faili. id välja sisu tekitab URL-ga seotud SQL ise, seda ei sisestata.
	* update: house_update: esimene argument on maja id, teine tudengi matriklinumber. description ja insert tabelite jaoks update teenust pole, nende ridu saab ainult lisada/kustutada.
	* delete: house_delete, description_delete ja visit_delete: esimene argument on id, teine matriklinumber.
	* Kuupäevaformaat on MM-DD-YYYY.
	* Kui soovite jätta mõne arvu/kuupäevavälja tühjaks (eeldusel, et andmebaasi schema seda lubab), peab vastav argument URL-s (ampersandide vahel) olema tekst null.
	* Sisetamise/muutmise/kustutamise edukust saab tulemus-XML faili sisu järgi näha.

Tammet – 3. aprill 2006, kell 09:55

2006-04-03T09:55:41Z

←Vanem redaktsioon		Redaktsioon: 3. aprill 2006, kell 11:55
38. rida:		38. rida:
	The server contains a database with two tables:		The server contains a database with two tables:

	* main table party: contains all main data about a party.		* main table party: contains all main data about a party.
	* additional table notes: contains additional notes for parties.		* additional table notes: contains additional notes for parties.

	Observe that actually the schema contains also additional tables for similar application from 2005: tables house, description, visit and the corresponding web services. In case you are interested, see http://cs.ttu.ee/kursused/itv0030/prax2.html. You may use these web services for additional stuff, if you want. However, using them is in no way obligatory.		Observe that actually the schema contains also additional tables for similar application from 2005: tables house, description, visit and the corresponding web services. In case you are interested, see http://cs.ttu.ee/kursused/itv0030/prax2.html. You may use these web services for additional stuff, if you want. However, using them is in no way obligatory.
45. rida:		45. rida:
	It is a good idea to read the [[kasutajaliidesed lab 2 sql schema]].		It is a good idea to read the [[kasutajaliidesed lab 2 sql schema]].

	XSTONE ~~serveris on realiseeritud lihtsad~~ SQL ~~funktsioonid nimetatud tabelite sisu vaatamiseks, otsimiseks, muutmiseks ja kustutamiseks~~. ~~Igale veebiteenusele vastab üks~~ SQL ~~lause~~.		The XSTONE server contains simple SQL functions for looking and modifying data in the given tables. Every web service corresponds to one SQL sentence.

			It is a good idea to read the [[kasutajaliidesed lab 2 web service definitions]].


	~~Veebiteenuste loetelu ja nendega seotud konkreetseid SQL lauseid saad lugeda sellest XML failist.~~

	Nimetatud teenuste praktiliseks kasutamiseks vaata ja katseta kõigepealt selles failis toodud näidetega. NB! Nimetatud näiteid tuleb katsetamiseks igaühel veidi ümber teha.		Nimetatud teenuste praktiliseks kasutamiseks vaata ja katseta kõigepealt selles failis toodud näidetega. NB! Nimetatud näiteid tuleb katsetamiseks igaühel veidi ümber teha.

Tammet – 3. aprill 2006, kell 09:49

2006-04-03T09:49:58Z

←Vanem redaktsioon		Redaktsioon: 3. aprill 2006, kell 11:49
20. rida:		20. rida:
	** searching		** searching
	into the app. Apps without these capabilities will get lower points than apps with these capabilities.		into the app. Apps without these capabilities will get lower points than apps with these capabilities.
			* Please treat the web services and the dijkstra machine sparingly: do not make huge, repeated calls just for fun. Also, please try to avoid disturbing other students. For example, avoid using the student codes of other people.

			== Web service to use ==

			You will have to use publicly available web services using the XSTONE server (you can find detailed information about XSTONE from http://www.ttu.ee/it/xstone. However, you will not really need this detailed information in the lab).

			The XSTONE server runs in the dijkstra.cs.ttu.ee machine, port 7777. You may want to
			try out a service giving all parties currently in the database:
			http://dijkstra.cs.ttu.ee:7777/xstone/xfuns/party_all

			Observe that you cannot change the underlying sql schema or xstone web services themselves: you can only use them as they are.

			XSTONE server is called using ordinary url-s, via get. Post is not available. Web service url-s take string parameters without any parameter names: order matters. There is no authentication and you can test the services using an ordinary browswer.

			Serveris asub andmebaas, kus on realiseeritud kolm tabelit:

			The server contains a database with two tables:

			* main table party: contains all main data about a party.
			* additional table notes: contains additional notes for parties.

			Observe that actually the schema contains also additional tables for similar application from 2005: tables house, description, visit and the corresponding web services. In case you are interested, see http://cs.ttu.ee/kursused/itv0030/prax2.html. You may use these web services for additional stuff, if you want. However, using them is in no way obligatory.

			It is a good idea to read the [[kasutajaliidesed lab 2 sql schema]].

			XSTONE serveris on realiseeritud lihtsad SQL funktsioonid nimetatud tabelite sisu vaatamiseks, otsimiseks, muutmiseks ja kustutamiseks. Igale veebiteenusele vastab üks SQL lause.

			Veebiteenuste loetelu ja nendega seotud konkreetseid SQL lauseid saad lugeda sellest XML failist.

			Nimetatud teenuste praktiliseks kasutamiseks vaata ja katseta kõigepealt selles failis toodud näidetega. NB! Nimetatud näiteid tuleb katsetamiseks igaühel veidi ümber teha.

			NB! Antud praksi tabelite/veebiteenuste juures ei ole kasutatud mingit autentimist. Selle asemel kasutame põhimõtet, et igal tabeli real on kindlasti olemas sisestanud tudengi matriklinumber. Selle numbri paneb sinna teieloodud rakendus automaatselt, koodi sissekirjutatult, seda ei küsita kasutajalt! Iga grupp peab seega valima, kumba tudengi matriklinumber koodi sisse kirjutatakse.

			Lõpetuseks seletame veidi toodud teenuste põhimõtteid/argumente.

			* all: house_all, description_all ja visit_all ei võta mingeid argumente ja annavad kogu tabeli sisu, ilma selekteeringuta. Kuna see võib olla väga mahukas, siis palun kasutada väga ettevaatlikult, ainult vajadusel testimiseks (mitte aga rakenduses endas!).
			* select: house_select, description_select ja visit_select võtavad järgmised argumendid:
			o sorteeritava tulba nimi vastavas sql tabelis
			o sorteerimisjärjekord (asc või desc)
			o tabeli rea sisestanud tudengi matriklinumber.
			o SQL-lause WHERE-tingimus ehk filter/otsing: kui tahta kõiki ridu saada, pane sinna tautoloogiline tingimus 1=1.
			o ridade arv: nii palju ridu saadetakse vastuseks (kui tabelis on üldse nii palju sobivaid ridu).
			o mitmendast reast alustatakse ridade andmist (esimene rida on 1).
			* insert: house_insert, description_insert ja visit_insert: esimene argument on matriklinumber, teised argumendid on juba vastavad infoväljad: vaata eelpoolviidatud XML faili. id välja sisu tekitab URL-ga seotud SQL ise, seda ei sisestata.
			* update: house_update: esimene argument on maja id, teine tudengi matriklinumber. description ja insert tabelite jaoks update teenust pole, nende ridu saab ainult lisada/kustutada.
			* delete: house_delete, description_delete ja visit_delete: esimene argument on id, teine matriklinumber.
			* Kuupäevaformaat on MM-DD-YYYY.
			* Kui soovite jätta mõne arvu/kuupäevavälja tühjaks (eeldusel, et andmebaasi schema seda lubab), peab vastav argument URL-s (ampersandide vahel) olema tekst null.
			* Sisetamise/muutmise/kustutamise edukust saab tulemus-XML faili sisu järgi näha.