Home l Features l Demo l Downloads l Documentation l Webcasts l Blog l

S3DB - Simple and Sloppy Semantic Database

API Select
The S3DB API (S3QL) was designed to be as close to regular SQL as possible. In order to make use ofthe S3DB API (S3QL) for performing a query, the following elements are required:

the URL where S3DB is installed (if in a local computer, this would be something like http://localhost/s3db)

a key created through the interface (My Account -> Access keys)

1. Build a query using the XML template:

<?xml version="1.0"?>
<S3QL>
<key>...</key>
  <select> ... </select>
  <from> ... </from>
   <where>
    <project_id>...</project_id>
   </where>
<format>tab/html</format>
</S3QL>

2. Call the query using the URL + S3QL.php
Ex: http://localhost/s3db1.0/S3QL.php?query=<S3QL><key>sCIUdwfWY3ihujX</key></S3QL>
OR
Call the query from a remote location:
http://localhost/s3db1.0/S3QL.php?query=http://myserver/query.xml

3. Possible select queries:

Select	From	Syntax
project_id, project_name, project_description, project_owner, created_on, created_by	projects	<select>*</select> <from>projects</from> <where> <project_id>...</project_id> <project_name>...</project_name> </where>
rule_id, subject, verb, object, notes, created_on, created_by,project_id, permission	rules	<select>*</select> <from>rules</from> <where> <project_id>...</project_id> <subject>...</subject> </where>
resource_id, entity, notes, project_id, created_on,created_by	collections	<select>*</select> <from>collections</from> <where> <project_id>...</project_id> <entity>...</entity> \| <resource_class_id>...</resource_class_id> </where>
resource_id, entity, notes, project_id, resource_class_id, created_on, created_by	items	<select>*</select> <from>items</from> <where> <project_id>...</project_id> <entity>...</entity> \| <class_id>...</class_id> </where>
statement_id, project_id, resource_id, rule_id, value, notes, file_name, created_on, created_by	statements	<select>*</select> <from>statements</from> <where> <project_id>...</project_id> <rule_id>...</rule_id> <value>...</value> </where>
rule_id, action, action_by, action_timestamp, old_subject, old_verb, old_object, old_notes	rulelog	<select>*</select> <from>rulelog</from> <where> <project_id>...</project_id> </where>
account_id, account_uname, account_email, account_phone, created_on, created_by	users	<select>*</select> <from>users</from>
account_id, account_uname, created_on, created_by	groups	<select>*</select> <from>groups</from>
key_id, account_id, expires, notes	keys	<select>*</select> <from>keys</from>

4. Additional features:

Functions	Syntax
distinct	<select>distinct(project_id)</select> <from>projects</from>
max	<select>max(created_on)</select> <from>classes</from>
min	<select>min(created_on)</select> <from>statements</from>
count	<select>count(project_id)</select> <from>rules</from>
count(distinct)	<select>count(distinct(project_id))</select> <from>rules</from>
limit	<select>*</select> <from>rules</from> <limit>3</limit>
offset	<select>*</select> <from>rules</from> <offset>2</offset>
order_by	<select>*</select> <from>rules</from> <order_by>rule_id</order_by>

Previous/Next/Table of Contents

Email: helenadeus@gmail.com, almeida.jonas@gmail.com

Home l Features l Demo l Downloads l Documentation l Webcasts l Blog l

http://www.2serveu.net