Home

Plugin : Taffydb

Author:Rex.Rainbow

Download

Properties

Database name

  • Database reference. Sets "" to be a private database.

Index keys

  • Index keys, separated by ","

Actions

Database

Action:Link to database

  • Link to database.
    • Name ( string ) : Database reference. Sets "" to be a private database.

Filter - 1. new

Action:1. New

  • Create a new row filter.

Filter - 2. key

Action:2. value compare

  • Add a value compared for this key.
    • Key ( string ) : The name of the key.
    • Conditions ( Combo ) : Condition type.
      • Options : ["equal to","not equal to","greater than","less than","greater than or equal to","less than or equal to"]
    • Value ( number or string ) : The value to comparsion, could be number or string.

Action:2. boolean value compare

  • Add a boolean value compared for this key.
    • Key ( string ) : The name of the key.
    • Compared value ( Combo ) : Compared value.
      • Options : ["false","true"]

Action:2. value include

  • Add a value including of this key.
    • Key ( string ) : The name of the key.
    • Value ( number or string ) : The value to set, could be number or string.

Action:2. regex matched

  • Add a regex matched for this key.
    • Key ( string ) : The name of the key.
    • Regex ( string ) : Test string with regular expression.
    • Flags ( string ) : Test flags with regular expression.

Filter - 3. order

Action:3. order

  • Order items.
    • Key ( string ) : The name of the key.
    • Order ( Combo ) : Order of items.
      • Options : ["descending","ascending","logical descending","logical ascending"]

Index keys

Action:Set index keys

  • Set index keys.
    • Keys ( string ) : Index keys, separated by ","

Insert - CSV

Action:Insert CSV data

  • Insert data from CSV string.
    • CSV string ( string ) : The CSV string for inserting.
    • Eval ( Combo ) : Eval the string.
      • Options : ["No","Yes"]
    • Delimiter ( string ) : Delimiter for splitting items.

Action:Define type

  • Define value type of a key.
    • Key ( string ) : The name of the key.
    • Type ( Combo ) : Type.
      • Options : ["string","number","any (eval)"]

Insert - JSON

Action:Insert JSON data

  • Insert data from JSON string.
    • JSON string ( string ) : The JSON string for inserting.

Remove

Action:Remove all

  • Remove all rows.

Remove - queried rows

Action:Remove queried rows

  • Remove queried rows.

Remove - row ID

Action:Remove by row ID

  • Remove row by row ID.
    • Row ID ( string ) : Row ID

Action:Remove by row index

  • Remove row by row index.
    • Index ( number ) : Index of queried rows.

Save

Action:Save

  • Save prepared item into server.

Save - prepare item

Action:Set value

  • Set value into current item.
    • Key ( string ) : The name of the key.
    • Value ( number or string ) : The value to set, could be number or string.
    • Condition ( Combo ) : Set value if new value is greater or less then old value.
      • Options : ["","if greater","if less"]

Action:Set boolean value

  • Set boolean value into current item.
    • Key ( string ) : The name of the key.
    • Boolean ( Combo ) : Boolean value.
      • Options : ["False","True"]

Action:Add to

  • Add value to key.
    • Key ( string ) : The name of the key.
    • Value ( number or string ) : The value to set, could be number or string.

Action:Set JSON

  • Set JSON value into current item.
    • Key ( string ) : The name of the key.
    • JSON ( string ) : The JSON value to set.

Save - row ID

Action:Set row ID

  • Set row ID.
    • Row ID ( string ) : Row ID

Action:Set row index

  • Convert index of queried rows to row ID for saving. Append row if row ID had not found.
    • Index ( number ) : Index of queried rows.

Update queried rows

Action:Update value

  • Update queried rows.
    • Key ( string ) : The name of the key.
    • Value ( number or string ) : The value to set, could be number or string.

Action:Update boolean value

  • Update queried rows.
    • Key ( string ) : The name of the key.
    • Boolean ( Combo ) : Boolean value.
      • Options : ["False","True"]

Expressions

All data

Expression:AllRowsAsJSON

  • Get JSON string of all rows.

Expression:AllRowsCount

  • Get count of all rows.

Database

Expression:DatabaseName

  • Get current linked database name.

Key name

Expression:KeyRowID

  • Get key name of row ID.

Queried rows

Expression:QueriedRowsCount

  • Get current queried rows count.

Expression:QueriedSum

  • Get sum in current queried rows of a key.
    • Key ( string ) : The name of the key.

Expression:QueriedMin

  • Get min in current queried rows of a key.
    • Key ( string ) : The name of the key.

Expression:QueriedMax

  • Get max in current queried rows of a key.
    • Key ( string ) : The name of the key.

Expression:QueriedRowsAsJSON

  • Get JSON string of queried rows.

Queried rows - For each row

Expression:CurRowContent

  • Get current row content in JSON string in a For Each loop. Add 1st parameter to get value at the specific key. Add 2nd parameter for default value if this key is not existed.

Expression:CurRowIndex

  • Get index oif current row in a For Each loop.

Expression:CurRowID

  • Get current rowID in a For Each loop.

Queried rows - Index

Expression:Index2QueriedRowContent

  • Get queried rows content by index in JSON format. Add 2nd parameter to get value at the specific key. Add 3rd parameter for default value if this key is not existed.
    • Index ( number ) : Index of queried rows.

Expression:Index2QueriedRowID

  • Get rowID by Index of queried rows. Return "" if the specific row had not existed.
    • Index ( number ) : Index of queried rows.

Row ID

Expression:ID2RowContent

  • Get rows content by row ID in JSON format. Add 2nd parameter to get value at the specific key. Add 3rd parameter for default value if this key is not existed.
    • Row ID ( string ) : Row ID.

Save

Expression:LastSavedRowID

  • Get last saved row ID.

Table

Expression:At

  • Get value from current database. Add index keys then add 1 data key. Add an optional default value at the last.

Conditions

Filter - 1. new

Condition:1. New

  • Create a new row filter.

Filter - 2. key

Condition:2. value compare

  • Add a value compared for this key.
    • Key ( string ) : The name of the key.
    • Conditions ( Combo ) : Condition type.
      • Options : ["equal to","not equal to","greater than","less than","greater than or equal to","less than or equal to"]
    • Value ( number or string ) : The value to comparsion, could be number or string.

Condition:2. boolean value compare

  • Add a boolean value compared for this key.
    • Key ( string ) : The name of the key.
    • Compared value ( Combo ) : Compared value.
      • Options : ["false","true"]

Condition:2. value include

  • Add a value including of this key.
    • Key ( string ) : The name of the key.
    • Value ( number or string ) : The value to set, could be number or string.

Condition:2. regex matched

  • Add a regex matched for this key.
    • Key ( string ) : The name of the key.
    • Regex ( string ) : Test string with regular expression.
    • Flags ( string ) : Test flags with regular expression.

Filter - 3. order

Condition:3. order

  • Order items.
    • Key ( string ) : The name of the key.
    • Order ( Combo ) : Order of items.
      • Options : ["descending","ascending","logical descending","logical ascending"]

For each row

Condition:For each row

  • Repeat the event for each queried row.