Native Data Manipulation

Apr 2, 2018
Native Data Manipulation
  • Manipulating data directly from database is not that hard, as soon as you can correctly edit the data, and know some special string formats. Suppose:
    • [...] means required variable
    • (...) means optional text
    • + means the captured variable or text can be used multiple times
    • {...} means some characters before should be deleted according to the number inside the bracket

    Object Reference

    The format for object referencing is:
    Code (Text):
    object from table [table name] at [index]
    If the row or the table does not exist, exceptions will be thrown.

    List Reference

    The format for list referencing is:
    Code (Text):
    list from table [table name] (range [fromIndex] to [toIndex], )+{2}
    If the rows or the table does not exist, exceptions will be thrown.

    SQLObjectConverter does not support loading lists with bounded type parameters, so only one table should be referenced in a single list.

    Map Reference

    The format for map referencing is:
    Code (Text):
    map keys from table [table name] (range [fromIndex] to [toIndex], )+{2}, values from table [table name] (range [fromIndex] to [toIndex], )+{2}
    If the rows or the tables does not exist, exceptions will be thrown.

    SQLObjectConverter does not support loading maps with bounded type parameters, so only two tables should be referenced in a single map.
  • Loading...
  • Loading...