skript-db

Rewrite for Minecraft 1.21 to 26.x with Skript 2.14 and newer.

Added

- transaction on {sql}: section: all statements inside run in one transaction, committed at the end, rolled back on the first error. - with batch arguments {_rows::*}: runs a statement once per sub list in a single round trip. - with arguments ... now also works with literal values, store the generated keys in {_id} returns the first generated key. - List expressions inside a statement expand to one parameter per value, for IN (...). - Folia-safe scheduling and folia-supported: true for Folia based Skript forks.

Changed

- Result values are converted for Skript: timestamps become dates, decimals become numbers, UUIDs and binary data become text, SQL arrays become lists. - last sql error is tracked per trigger, so concurrent queries no longer see each other's errors. - Result lists are emptied before a new result is stored. - Effects that cannot run after a delay (such as cancel event) are reported at parse time when they follow an execute. - Runtime errors such as an unset data source are reported with script and line. - New config keys pool-size, connection-timeout, query-timeout and transaction-timeout; old config files keep working.

Fixed

- max-connection-lifetime was written into a comment and never read. - Connection pools were never closed on reload or shutdown. - Data sources loaded from saved variables created a second, unconfigured pool. - Generated keys were never returned for inserts. - Placeholder counting for with arguments counted question marks inside strings and comments. - Wrong warning about expressions surrounded by quotes.

Removed

- The complete of sql query event and sql query expression.