[plugin] rex_taffydb (local database)

rexrainbow

how to insert json string to some key in nedb?

when i use action:set value, the value become string (not json)

but when i use action:insert json data, it adds new row,although i have set unique index key

agittm

Call "Action:Insert JSON data" to insert rows by JSON string.

I did not add action to set JSON value yet, will add this request to TODO. Now you might set JSON string value.

Update

rex_taffydb, rex_nedb:

• Add "action: Set JSON" to set JSON value into row.

agittm

Here it is.

wow you're amazing! gonna implement it to my ongoing project. Many thanks!

hi rexrainbow

another question, i don't know it's bug or not but when i combine variable with static string in value field, i cannot get what i want.

For example :

i call action:Add to

-key="some.key"

-value=myChar&"_Level"

where myChar is variable, and what i want is the value field contains variable named Foo_Level, but instead of that, the saving progress become fail.

agittm

Please provide a very simple test capx for this case.

rexrainbow

https://drive.google.com/open?id=0B_1kI ... 3VOaUFUeE0

here it is

agittm

Value of MyChar&"_Level" is a string ("Goku_Level" as the result) in first action (the error one). Value of 2nd action is "2", which is a number.

Since "add to" only works with number, the first action will be incorrect.

rexrainbow

I think this example dont work as it shud... it removes all querried rows but 2 shud stay, no?

https://onedrive.live.com/redir?resid=7 ... e%252ccapx

rexrainbow

how do i reset ___id":"T000002R000992 to it's initial state?

rexrainbow

It seems your 'Update query rows' function isn't updating the queried row. The last value, according to your logic, should be 50, but it's still 70. At least, that's on the latest Construct 2 build. Can you please investigate?

I do the following events in my own project, trying to update a key value of one row that is identical to another row in a different DB:

Filter- 1. Create a new row filter

Filter- 2. key "A" value is equal to [DB2 'Index2QueriedRowContent', key "A" value]

Filter- 2. key "B" value is equal to 1

...and actions:

Update value "B" to 0 in all queried rows

...and value B in the DB does not update. In fact, there doesn't seem to be any value that I can update in my first DB, using the identical data from a different DB to filter for it.