Skip to main content

Changelog for the mysql adaptor

@openfn/language-mysql

4.1.3 - 03 September 2026​

Patch Changes​

  • 931a3fb: Update mysql2 to 3.23.1
  • Updated dependencies [654026d]
  • Updated dependencies [fd1b2be]
    • @openfn/language-common@3.3.5

4.1.2 - 30 June 2026​

Patch Changes​

  • Updated dependencies [c5f8728]
    • @openfn/language-common@3.3.4

4.1.1 - 27 May 2026​

Patch Changes​

  • Updated dependencies [5276a86]
    • @openfn/language-common@3.3.3

4.1.0 - 21 May 2026​

Minor Changes​

  • bf26881: export log function from common

4.0.6 - 20 May 2026​

Patch Changes​

  • Updated dependencies [9d1e1ae]
    • @openfn/language-common@3.3.2

4.0.5 - 07 April 2026​

Patch Changes​

  • Updated dependencies [add9748]
  • Updated dependencies [a9b7597]
    • @openfn/language-common@3.3.1

4.0.4 - 30 March 2026​

Patch Changes​

  • Updated dependencies [295655f]
    • @openfn/language-common@3.3.0

4.0.3 - 24 February 2026​

Patch Changes​

  • Updated dependencies [856f85c]
    • @openfn/language-common@3.2.3

4.0.2 - 09 February 2026​

Patch Changes​

  • Updated dependencies [8ad6b98]
  • Updated dependencies [8ad6b98]
    • @openfn/language-common@3.2.2

4.0.1 - 02 December 2025​

Patch Changes​

  • 6aa9800: Security update

4.0.0 - 02 December 2025​

Major Changes​

  • e6486ad: - Query results write to state.data instead of state.response, for consistency with other adaptors

    • Add support for prepared statements in sql function.

    Migration Guide:

    Transitioning from state.response to state.data

    Accessing Query Results​

    • Old Way: - 
      sql(state => `select id, name from patients limit 10`);
      log($.response.body);
      log($.response.fields);
    • New Way: 
      sql(state => `select id, name from patients limit 10`);
      log($.data.result);
      log($.data.fields);

    Use Prepared Statements​

    Use prepared statements to avoid SQL injection

    Un-Prepared SQL

    // Bad
    sql(state => `select * from users where id =${state.data.userId};`);
    // Potential SQL injection

    Prepared SQL

    // Good
    sql(`select * from users where id = ?;`, {
      values: $.data.userId,
    });
    // Safe from SQL injection

3.0.6 - 28 November 2025​

Patch Changes​

  • Updated dependencies [cfc66df]
    • @openfn/language-common@3.2.1

3.0.5 - 12 November 2025​

Patch Changes​

  • Updated dependencies [4d7a833]
    • @openfn/language-common@3.2.0

3.0.4 - 04 November 2025​

Patch Changes​

  • Updated dependencies
    • @openfn/language-common@3.1.2

3.0.3 - 16 October 2025​

Patch Changes​

  • Updated dependencies [408a3a2]
    • @openfn/language-common@3.1.1

3.0.2 - 18 September 2025​

Patch Changes​

  • Updated dependencies [e2bc436]
    • @openfn/language-common@3.1.0

3.0.1 - 01 September 2025​

Patch Changes​

  • Updated dependencies [1d60531]
    • @openfn/language-common@3.0.3

3.0.0 - 21 July 2025​

Major Changes​

  • 62d0fd3: - Removed query(options) ⇒ Operation function

    • Removed sqlString(queryString) ⇒ Operation function
    • Remove http function from common exports
    • Add sql(query, options) ⇒ Operation function

    Migration Guide​

    If you were using query() or sqlString() functions, you can replace it with sql() function.

    Before:

    query({ sql: 'select * from users;' });
    //or
    sqlString('select * from users;');

    Now:

    sql('select * from users;');

2.2.2 - 14 July 2025​

Patch Changes​

  • Updated dependencies [9b5a4f8]
    • @openfn/language-common@3.0.2

2.2.1 - 10 July 2025​

Patch Changes​

  • Updated dependencies [cf9c09f]
    • @openfn/language-common@3.0.1

2.2.0 - 10 July 2025​

Minor Changes​

  • 19f2d7e: Exported as() function from common.

Patch Changes​

  • Updated dependencies [ea85695]
  • Updated dependencies [3fce58f]
  • Updated dependencies [19f2d7e]
  • Updated dependencies [f26bd2b]
  • Updated dependencies [19f2d7e]
    • @openfn/language-common@3.0.0

2.1.5 - 20 June 2025​

Patch Changes​

  • Updated dependencies [28c2e8b]
    • @openfn/language-common@2.5.0

2.1.4 - 22 April 2025​

Patch Changes​

  • Updated dependencies [99e4b48]
  • Updated dependencies [13bf08f]
    • @openfn/language-common@2.4.0

2.1.3 - 16 April 2025​

Patch Changes​

  • Updated dependencies [b089c56]
    • @openfn/language-common@2.3.3

2.1.2 - 11 April 2025​

Patch Changes​

  • Updated dependencies [d7105c0]
    • @openfn/language-common@2.3.2

2.1.1 - 14 March 2025​

Patch Changes​

  • Updated dependencies [23ccb01]
    • @openfn/language-common@2.3.1

2.1.0 - 10 March 2025​

Minor Changes​

  • e87110f: - add cursor and dateFns from @openfn/language-common
    • cleanup examples wrapped with execute() function
    • Add example caption and add sample payload
    • remove unused import of url

2.0.8 - 16 January 2025​

Patch Changes​

  • Updated dependencies [b3d7f59]
  • Updated dependencies [2d709ff]
  • Updated dependencies [41e8cc3]
    • @openfn/language-common@2.3.0

2.0.7 - 16 January 2025​

Patch Changes​

  • Updated dependencies [6dffdbd]
    • @openfn/language-common@2.2.1

2.0.6 - 09 January 2025​

Patch Changes​

  • Updated dependencies [a47d8d5]
  • Updated dependencies [9240428]
    • @openfn/language-common@2.2.0

2.0.5 - 28 October 2024​

Patch Changes​

  • Updated docs for each()
  • Updated dependencies
    • @openfn/language-common@2.1.1

2.0.4 - 18 October 2024​

Patch Changes​

  • Updated dependencies [03a1a74]
    • @openfn/language-common@2.1.0

2.0.3 - 15 October 2024​

Patch Changes​

  • Fixed security vulnerability in jsonpath-plus [33973a2]
    • @openfn/language-common@2.0.3

2.0.2 - 24 September 2024​

Patch Changes​

  • Updated dependencies [77a690f]
    • @openfn/language-common@2.0.2

2.0.1 - 16 August 2024​

Patch Changes​

  • 8146c23: Fix typings in package.json
  • Updated dependencies [8146c23]
    • @openfn/language-common@2.0.1

2.0.0 - 01 August 2024​

Major Changes​

  • Export new common http helpers (http namespace)

1.5.3​

Patch Changes​

  • Updated dependencies [4fe527c]
    • @openfn/language-common@2.0.0

1.5.2 - 25 July 2024​

Patch Changes​

  • 73d0a02: Make documentation public
  • Updated dependencies [4c08444]
  • Updated dependencies [73d0a02]
    • @openfn/language-common@1.15.1

1.5.1 - 19 June 2024​

Patch Changes​

  • Updated dependencies [5fb82f07]
    • @openfn/language-common@1.15.0

1.5.0 - 13 June 2024​

Minor Changes​

  • 73433c20: Add fnIf operation

Patch Changes​

  • Updated dependencies [106ecf6d]
    • @openfn/language-common@1.14.0

1.4.15 - 11 June 2024​

Patch Changes​

  • Updated dependencies
    • @openfn/language-common@1.13.5

1.4.14 - 21 May 2024​

Patch Changes​

  • Updated dependencies [12f02ed5]
    • @openfn/language-common@1.13.4

1.4.13 - 08 May 2024​

Patch Changes​

  • Updated dependencies [88f99a8f]
    • @openfn/language-common@1.13.3

1.4.12 - 08 May 2024​

Patch Changes​

  • Updated dependencies
    • @openfn/language-common@1.13.2

1.4.11 - 24 April 2024​

Patch Changes​

  • e9d0dac9: - Change host format from uri to string in configuration-schema.json
    • Update required list to include user and password

1.4.10 - 12 April 2024​

Patch Changes​

  • Updated dependencies
    • @openfn/language-common@1.13.1

1.4.9 - 12 April 2024​

Patch Changes​

  • Updated dependencies [1ad86651]
    • @openfn/language-common@1.13.0

1.4.8 - 20 September 2023​

Patch Changes​

  • Updated dependencies [c19efbe]
    • @openfn/language-common@1.11.1

1.4.7 - 08 September 2023​

Patch Changes​

  • Updated dependencies [85c35b8]
    • @openfn/language-common@1.11.0

1.4.6 - 14 August 2023​

Patch Changes​

  • Updated dependencies [df09270]
    • @openfn/language-common@1.10.3

1.4.5 - 14 July 2023​

Patch Changes​

  • Updated dependencies [26a303e]
    • @openfn/language-common@1.10.2

1.4.4 - 14 July 2023​

Patch Changes​

  • Updated dependencies [8c32eb3]
    • @openfn/language-common@1.10.1

1.4.3 - 30 June 2023​

Patch Changes​

  • Updated dependencies [aad9549]
    • @openfn/language-common@1.10.0

1.4.2 - 23 June 2023​

Patch Changes​

  • Updated dependencies [111807f]
    • @openfn/language-common@1.9.0

1.4.1 - 19 June 2023​

Patch Changes​

  • Update lock files
  • Updated dependencies
    • @openfn/language-common@1.8.1

1.4.0​

Minor Changes​

  • 2c1d603: Remove parameter reassignment to ensure proper functioning inside an each block; add eslint

    The packages receiving a major bump here exposed functions that didn't work as expected inside each blocks. Users were previously wrapping these functions inside their own custom fn blocks, and this change will ensure that they can be used inside a standard each.

    See https://github.com/OpenFn/adaptors/issues/275 for more details.

Patch Changes​

  • Updated dependencies [2c1d603]
    • @openfn/language-common@1.8.0

1.3.5 - 31 March 2023​

Patch Changes​

  • Updated dependencies [929bca6]
    • @openfn/language-common@1.7.7

1.3.4 - 30 March 2023​

Patch Changes​

  • ef828e7: update old urls in readme
  • 14f481e: mark execute as private
  • Updated dependencies [2b4c61a]
    • @openfn/language-common@1.7.6

1.3.3 - 15 February 2023​

Patch Changes​

  • f7ebd3c: remove sample configuration

1.3.2 - 15 February 2023​

Patch Changes​

  • f2aed32: add examples

1.3.1 - 13 January 2023​

Patch Changes​

  • 6d8de03: change @constructor to @function and remove /*_ @module Adaptor _/

1.3.0 - 25 November 2022​

Minor Changes​

  • 9d674c5: Migrate MySQL