Database

Table of contents
  1. 1. Overview
  2. 2. Data Types
    1. 2.1. Config
    2. 2.2. DataSet
  3. 3. Features
      1. 3.1.1. GET:non-query/
        1. 3.1.1.1. Query Parameters
        2. 3.1.1.2. Response
        3. 3.1.1.3. Version History
      2. 3.1.2. GET:data-set/
        1. 3.1.2.1. Query Parameters
        2. 3.1.2.2. Response
        3. 3.1.2.3. Version History
        4. 3.1.2.4. Examples


Assembly: mindtouch.core

Class: MindTouch.Dream.DatabaseService

Overview

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


Data Types

Config

<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

<DataSet>
<Table>
<cur_id>5058</cur_id>
<cur_namespace>0</cur_namespace>
<cur_title>Home</cur_title>
<cur_text>&lt;p&gt;Congratulations on joining {{SITENAME}}.&lt;/p&gt;</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>

Features

GET:non-query/

Execute the predefined non-query.  This is used for DELETE, UPDATE, and INSERT SQL statements.

Query Parameters

All parameters are required as specified in the config file.

Response
Status Response Body Description
200 --- Successful operation
Version History

Not added yet


GET:data-set/

Execute the predefined data-set query.  This is used for SELECT SQL statements.

Query Parameters

All parameters are required as specified in the config file.

Response
Status Response Body Description
200 DataSet Successful operation
Version History

Not added yet

Tag page
You must login to post a comment.
Powered by MindTouch Deki v.8.08.1a