Skip to content

Releases: trevordevore/sql-yoga

2.0.1

22 Dec 21:41
Compare
Choose a tag to compare
  • Changed dbconn_retrieveQueryAsData, sqlquery_retrieveAsData, and sqlquery_currentRowToArray from commands to functions. They can't aggregate data into an existing array so they should be functions.
  • sqlquery_currentRowToArray(pQueryA, pFields) now accepts an optional second parameter that filters the fields that are returned.

2.0.0

01 Dec 21:28
Compare
Choose a tag to compare

SQL Yoga has been been converted to script only stacks and is now distributed as a Levure Helper. While it can still be used outside of the Levure framework you will find it much easier to use within Levure. When using Levure you can create database connections, tables objects, relationship objects, scope objects, and SQL query template object using YAML. You can also perform create database tables and insert records using migration files (YAML or LiveCode scripts). These YAML files are easier to write and update and will work nicely in a version control system.

Check out the wiki for the latest docs. Error handling has been standardized and the new behavior is described in the wiki. There is also a stack that runs in the LiveCode IDE which provides some helper functions for running migrations and keeping the schema YAML file up to date.