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.