Dialog database api - Revision history

Niels: /* Getting started */

2010-01-07T13:51:54Z

‎Getting started

Niels: /* Dialog database API */

2010-01-07T13:51:39Z

‎Dialog database API

Niels: /* Download */

2009-07-03T11:32:57Z

‎Download

Niels: /* Dialog database API */

2009-05-13T09:26:25Z

‎Dialog database API

Niels: /* Dialog database API */

2009-05-13T09:23:40Z

‎Dialog database API

Niels at 09:23, 13 May 2009

2009-05-13T09:23:32Z

New page

=== Dialog database API ===

==== Structure ====
Database structuur

<table>
<tr><th>'''''Sentence'''''</th></tr>
<tr><th align="left" >id</th> <td align="left">Int</td> <td align="left">Unique identification number</td></tr>
<tr><th align="left">sentence</th> <td align="left">String</td> <td align="left">Sentence string (text)</td></tr>
<tr><td>-----------</td></tr>
<tr><th>'''''Link'''''</th></tr>
<tr><th align="left">reply_to_sentence</th><td align="left">Int</td><td align="left">Sentence id identifying the sentence replied to</td></tr>
<tr><th align="left">Reply_sentence</th><td align="left">int</td><td align="left">Sentence id identifying the sentence reply</td></tr>
<tr><th align="left">order</th> <td align="left"> int</td> <td align="left">Sentence position in reply list</td></tr>
<tr><td>-----------</td></tr>
<tr><th>'''''Property'''''</th></tr>
<tr><th align="left">id</th> <td align="left"> Int</td> <td align="left"> Unique identification number</td></tr>
<tr><th align="left">name</th> <td align="left"> String</td> <td align="left"> Property name</td></tr>
<tr><th align="left">show</th> <td align="left"> Int</td> <td align="left"> Enable/disable property in database</td></tr>
<tr><td>-----------</td></tr>
<tr><th>'''''Property_list'''''</th></tr>
<tr><th align="left">property_id</th><td align="left">Int</td><td align="left">Property id indentifying the property</td></tr>
<tr><th align="left">sentence_id</th><td align="left">Int</td><td align="left">Sentence id indentifying the sentence</td></tr>
<tr><th align="left">value</th> <td align="left">String</td><td align="left">Value of the property</td></tr>
<tr><td>-----------</td></tr>
<tr><th>'''''Action'''''</th></tr>
<tr><th align="left">id</th> <td align="left"> Int</td> <td align="left"> Unique identification number</td></tr>
<tr><th align="left">action</th> <td align="left"> String</td> <td align="left"> Action string</td></tr>
<tr><td>-----------</td></tr>
<tr><th>'''''Action_list'''''</th></tr>
<tr><th align="left">action_id</th><td align="left">Int</td><td align="left">Action id indentifying the Action</td></tr>
<tr><th align="left">sentence_id</th><td align="left">Int</td><td align="left"> Sentence id indentifying the Sentence</td></tr>
<tr><th align="left">order</th><td align="left">Int</td><td align="left">Action position in action list</td></tr>
<tr><th align="left">kind</th><td align="left">Int</td><td align="left">Identifying if the action is a pre or post action</td></tr>
</table>

Notes:
Default properties already available in the database are:
* audio_url (default = “”)
* avatar_type (default = “”)
* is_root (default=”0”)

Orders of sentences or actions are not forced to be unique so multiple sentences can be placed on the same order number the real order of the data in the list will be unknown then.

Id’s will be automatically generated by the database and can’t be manipulated

Action Kind will be 0 = PreAction and 1 = PostAction

Property show will be 0 = Disabled and 1 = Enabled. When disabled property will not be added to property list of sentences

@@ Line 26: / Line 26: @@
 ==== Getting started ====
-db = MultiThreadAccesDatabase()
+:db = MultiThreadAccesDatabase()
-db.createNewDatabase("C:\\temp.db3")
+:db.createNewDatabase("C:\\temp.db3")
-sentence = Sentence("first sentence")
+:sentence = Sentence("first sentence")
-sentence = db.updateSentence(sentence)
+:sentence = db.updateSentence(sentence)
 ==== Documentation ====

← Older revision		Revision as of 13:51, 7 January 2010
Line 1:		Line 1:
	== Dialog database API ==		== Dialog database API ==
		+
		+	=== Main files ===
		+	*Database.py
		+	*MultiThreadAccesDatabase.py
		+	*ReadOnlyDatabase.py
		+
		+	=== Support files ===
		+	*Action.py
		+	*Link.py
		+	*Property.py
		+	*Sentence.py
		+
		+	==== ReadOnlyDatabase.py ====
		+	Contains functions too read the dialog database file. Can be used if you want to be sure you don't override any data in the database
		+
		+	==== Database.py ====
		+	Extends ReadOnlyDatabase.py with functions to create and add/edit the dialog database file.
		+
		+	==== MultiThreadAccesDatabase.py ====
		+	Interface class that provides a mean to access an database from multiple threads. Python sqlite implementation doesn't allow multiple threads to access the same database.
		+
		+	==== Support files ====
		+	Provides the data from the database in python classes that can be edited and then updated to the database using the correct functions.
		+
		+
		+	==== Getting started ====
		+	db = MultiThreadAccesDatabase()
		+	db.createNewDatabase("C:\\temp.db3")
		+	sentence = Sentence("first sentence")
		+	sentence = db.updateSentence(sentence)
		+
		+	==== Documentation ====
		+	Documentation can be found in the .py files for what every function does.

	=== Structure ===		=== Structure ===

@@ Line 51: / Line 51: @@
 == Download ==
-[http://mmi.tudelft.nl/vret_oud/images/4/48/Dialogue.zip Dialogue 1.0]
+[http://mmi.tudelft.nl/vret_oud/images/d/df/DialogueDatabase.zip Dialogue 1.1]
 === Pre build tools ===

← Older revision		Revision as of 09:26, 13 May 2009
Line 49:		Line 49:

	Property show will be 0 = Disabled and 1 = Enabled. When disabled property will not be added to property list of sentences		Property show will be 0 = Disabled and 1 = Enabled. When disabled property will not be added to property list of sentences
		+
		+	== Download ==
		+	[http://mmi.tudelft.nl/vret_oud/images/4/48/Dialogue.zip Dialogue 1.0]
		+
		+	=== Pre build tools ===

@@ Line 1: / Line 1: @@
-=== Dialog database API ===
+== Dialog database API ==
-==== Structure ====
+=== Structure ===
 Database structuur