Categories > Data structure > rex_taffydb

Introduction

In-memory database for storing data.

Links

• Plugin
• ACE table
• Discussion thread

Dependence

None

Usage

Write

Insert rows by CSV

Sample capx

Action:Insert CSV data

• First row : name of keys
• Other rows : data

Data type

Property Eval mode

• No : string

  • Action:Define type : define a column to be number type (Sample capx)

• Yes : parse value by eval function of javascrpt

  • number: 10
  • string: 'hi'
  • javascript function: Math.random()

  For example,

   
  AخA
  Name,HP,MP
  'aaa',100,20
  'bbb',80,30
  

  will insert 2 rows.

  Error message will display on console when eval failed.

Insert rows by JSON

Sample capx

Action:Insert JSON data

Save row

Sample capx

1. prepare row

   • Save data at a specific row, i.e. pick row then update it

     • Action:Set row ID, or Action:Set row index

     • Action:Set value , to set value of index key (Sample capx)

       • Index keys : a set of keys which the values are unique.

         • Property Index keys, or Action:Set index keys.
         • Multiple keys are separated by ,, for example

          
         xxxxxxxxxx
         UID,VarName
         

   • Other keys

     • Action:Set value

       • options: if greater , if less

     • Action:Set boolean value

     • Action:Set JSON

     • Action:Add to

2. Action:Save

   • Expression:LastSavedRowID

   • Pick row by rowID

     • Update row if found

   • Else

     • Pick row by index keys

       • Update row, if found, or
       • Insert new row

Update rows

Sample capx

Update or append key of queried rows

• Action:Update value
• Action:Update boolean value

Remove

• Action:Remove by row ID
• Action:Remove all

Remove queried rows

• Action:Remove queried rows, sample capx
• Action:Remove by row index

Read

Read all rows

• Expression:AllRowsAsJSON, all rows in JSON string
• Expression:AllRowsCount

Read by index key

Sample capx

Sample capx2-counter

Expression:At, pick row by index key, then get value

• Expression:At( valueOfIndexKey0, valueOfIndexKey1, .... , dataKey )

  1. pick row by (indexKey0 == valueOfIndexKey0) and (indexKey1 == valueOfIndexKey1)

     • Index key is set at property Index keys, or Action:Set index keys.

  2. get value at dataKey

• Expression:At( valueOfIndexKey0, valueOfIndexKey1, valueOfIndexKey2, .... , dataKey, defaultValue ), returns defaultValue if row or dataKey is not found.

For example, property Index keys is Name,

 
xxxxxxxxxx
DB.At("aaa", "HP")

to get row by Name is "aaa", then returns value of key "HP".

Querying

Sample capx

Build filter

1. Create a new filter, or start from current filter (sample capx), if it does not create a new filter.

   • Action:1. New, orCondition:1. New

2. Add conditions

   • Action:2. value compare, or Condition:2. value compare
   • Action:2. boolean value compare, or Condition:2. boolean value compare
   • Action:2. regex matched, or Condition:2. regex matched

3. sort

   • Action:3. order, or Condition:3. order

Read all queried rows

• Expression:QueriedRowsAsJSON, all queried rows in JSON string
• Expression:QueriedRowsCount
• Expression:QueriedSum( key )
• Expression:QueriedMin( key )
• Expression:QueriedMax( key )

Retrieve queried rows

Condition:For each row

• Expression:CurRowContent

  • Expression:CurRowContent, returns key-value pairs of current row in JSON string
  • Expression:CurRowContent( key ), returns the value of a specific key, or 0 if the key does not exist
  • Expression:CurRowContent( key, defaultValue ), returns the value of a specific key, or defaultValue if the key does not exist.

• Expression:CurRowIndex

Get queried row by index from 0 to Expression:QueriedRowsCount-1 (sample capx)

• Expression:Index2QueriedRowContent( index ), returns key-value pairs of the specific row in JSON string

• Expression:Index2QueriedRowContent( index, key ), returns the value of a specific key, or 0 if the key does not exist

  • Expression:Index2QueriedRowID( index ), returns rowID of the specific row

• Expression:Index2QueriedRowContent( index, key, defaultValue ), returns the value of a specific key, or defaultValue if the key does not exist.

Queried result after database updated

Sample capx Queried rows will be changed after database updated.

Database reference

Sample capx

Property Database name

• Empty string "" : private database, destroyed when instance had been destroyed

• Not empty string : a global database indexed by this Database name property

  • Separate writing and reading into different database instance

Save & load

It supports official saving & loading feature, queried result will also be saved.

Debug panel

All rows will be shown at debug panel in JSON format.