Assembly: mindtouch.core
Class: MindTouch.Dream.DatabaseService
(provide a short 2-3 sentence description of what the service does)
| Verb:Suffix | In | Out | Description |
| GET:non-query/ | --- | --- | Execute the predefined non-query. |
| GET:data-set/ | --- | DataSet | Exceute the predefined data-set query. |
<config>
<path>mks-db</path>
<class>MindTouch.Dream.DatabaseService</class>
<database>
<connection>Server=localhost;Port=3306;Database=wikidb;Uid=root;Pwd=xxx;</connection>
<assembly>MySql.Data, Version=1.0.7.30072, Culture=neutral, PublicKeyToken=c5687fc88969c44d</assembly>
<connection-type>MySql.Data.MySqlClient.MySqlConnection</connection-type>
<adapter-type>MySql.Data.MySqlClient.MySqlDataAdapter</adapter-type>
<parameter-type>MySql.Data.MySqlClient.MySqlParameter</parameter-type>
<command-type>MySql.Data.MySqlClient.MySqlCommand</command-type>
<parameter-char>?</parameter-char>
</database>
<sql>SELECT * FROM cur WHERE cur_title=?cur_title AND cur_namespace=?cur_namespace</sql>
<parameter>cur_title</parameter>
<parameter>cur_namespace</parameter>
</config>
<DataSet>
<Table>
<cur_id>5058</cur_id>
<cur_namespace>0</cur_namespace>
<cur_title>Home</cur_title>
<cur_text><p>Congratulations on joining {{SITENAME}}.</p></cur_text>
<cur_comment />
<cur_user>12</cur_user>
<cur_user_text>UrsM</cur_user_text>
<cur_timestamp>20060616204332</cur_timestamp>
<cur_restrictions />
<cur_counter>50</cur_counter>
<cur_is_redirect>0</cur_is_redirect>
<cur_minor_edit>0</cur_minor_edit>
<cur_is_new>0</cur_is_new>
<cur_random>0</cur_random>
<cur_touched>20060616204332</cur_touched>
<inverse_timestamp>79939383795667</inverse_timestamp>
<cur_toc />
<cur_tip />
<cur_usecache>0</cur_usecache>
<cur_parent>0</cur_parent>
</Table>
</DataSet>
Execute the predefined non-query. This is used for DELETE, UPDATE, and INSERT SQL statements.
All parameters are required as specified in the config file.
| Status | Response Body | Description |
| 200 | --- | Successful operation |
Not added yet
Execute the predefined data-set query. This is used for SELECT SQL statements.
All parameters are required as specified in the config file.
| Status | Response Body | Description |
| 200 | DataSet | Successful operation |
Not added yet
to produce above result request http://localhost:8081/mks-db/data-set?cur_title=Home&cur_namespace=0