mlaanderson / database-js-ini Goto Github PK

Publish a release in order to have a stable version to install (e.g. 1.0.0).

AFAIK, database-js-ini does not support UPDATE commands yet. One problem is probably the syntax.

Thus, I would like to suggest a syntax for that:

Update the ROOT

UPDATE ROOT SET foo = "bar"
UPDATE ROOT SET max = 1

would produce

foo=bar
max=1

only if the corresponding keys ("foo" and "max") exist.

Update a section

UPDATE `my section` SET foo = "bar"
UPDATE `my section` SET max = 1

would produce

[my section]
foo=bar
max=1

only if the section ("my section") and its corresponding keys ("foo" and "max") exist.

Update with restriction

UPDATE `my section` SET foo = "bar" WHERE foo = "zoo"
UPDATE `my section` SET max = 100, `new key` = "new value" WHERE max < 100

Note: Keys can be produced during UPDATE, like the "new key" above.

Removing a key

A key should be removed by setting its value to NULL.

UPDATE ROOT SET foo = null WHERE foo = "zoo"
UPDATE `my section` SET max = null WHERE max < 100
UPDATE `my section` SET foo = null, `other key` = null WHERE max < 100

AFAIK, database-js-ini does not support INSERT commands yet. One problem is probably the syntax.

Thus, I would like to suggest a syntax for that:

Insert into the ROOT

INSERT INTO ROOT VALUES ( "foo", "bar" )
INSERT INTO ROOT VALUES ( "max", 1 )

would produce

foo=bar
max=1

Insert into a section

INSERT INTO `my section` VALUES ( "foo", "bar" )
INSERT INTO `my section` VALUES ( "max", 1 )

would produce

[my section]
foo=bar
max=1

Notes:

• Section is created if not exists.
• Values are overwritten if exist.

AFAIK, database-js-ini does not support DELETE commands yet. One problem is probably the syntax.

Thus, I would like to suggest a syntax for that:

Delete from the ROOT

DELETE FROM ROOT

would remove all the sections and keys from the file.

Delete a section

DELETE FROM `my section`

would remove the section "my section".

DELETE FROM `my section` WHERE max < 100

would only remove the section "my section" if "max" is less than 100.

Notes

• Keys can be removed with the UPDATE method, setting their value to NULL.
  For example:

  UPDATE `my section` SET max = null WHERE max < 100

  would remove the key "max" if its current value is less than 100.

This needs a readme

Section "About" is referring to MySQL