Page 3 of 4

Re: [plugin] rex_taffydb (local database)

PostPosted: Thu Aug 04, 2016 2:19 pm
by rexrainbow
@andykenobi

Shuffle could be implemented by events
1. add a column in each row named "index" with a random value
2. sort rows by this "index" column

Re: [plugin] rex_taffydb (local database)

PostPosted: Sat Aug 06, 2016 6:54 am
by rexrainbow
Update

- Add "Action:Add to" to add a value to the key
- Add options 'if greater', 'if less' in "Action:set value", to set value by condition.

Sample capx

Re: [plugin] rex_taffydb (local database)

PostPosted: Sun Aug 07, 2016 11:46 am
by rexrainbow
Here is another database plugin - nedb, asynchronous database. Reference


@Joannesalfa
Here it is.

Re: [plugin] rex_taffydb (local database)

PostPosted: Mon Aug 08, 2016 4:00 am
by rexrainbow
@Kyatric

Please move this thread to "Completed Addons" section.

Re: [plugin] rex_taffydb (local database)

PostPosted: Mon Aug 08, 2016 6:31 am
by actuallybrown
@rexrainbow How do I do the following:
- I have a listview of several items
- When selecting each item, change the corresponding TaffyDB param for that item (i.e., "selected" = 1)
- Then I want to grab the selected items only, and group them into a new item by pressing a button (I already have a function for creating this item with text fields and stuff to name and classify the new item)

thanks

Re: [plugin] rex_taffydb (local database)

PostPosted: Mon Aug 08, 2016 6:49 am
by rexrainbow
@actuallybrown

Assume that the content of each items in your listview come from the result of querying of taffydb.
1. Then you could get value of a key by "Expression:Index2QueriedRowContent( index , key )" , index is the "selected" in your case.
2. To save the modified item, uses "Action:Set row index" to set the row id by index. See the section "Insert a row" in my document for more detail.

Re: [plugin] rex_taffydb (local database)

PostPosted: Mon Aug 08, 2016 9:18 am
by Kyatric
Moved to completed addons as per request.

Re: [plugin] rex_taffydb (local database)

PostPosted: Sat Aug 13, 2016 5:49 am
by Joannesalfa
@rexrainbow awesome! I thought it would never happen until now, so I can test with my huge rpg database

Re: [plugin] rex_taffydb (local database)

PostPosted: Mon Aug 22, 2016 12:11 pm
by norman74
@rexrainbow

If i use Nedb.QueiredRowsAsJSON, then it returns something like "key":"value". But how to get just value by key?

Re: [plugin] rex_taffydb (local database)

PostPosted: Mon Aug 22, 2016 2:28 pm
by rexrainbow
@norman74

sample capx

Code: Select all
+ Condition:For each row
- Expression:CurRowContent( key )


Or
Code: Select all
Expression:Index2QueriedRowContent( index, key )