velo-external-db-1.0.3

What's Changed

• Dockerfile fix & optimization by @MXPOL in #2
• database operation by @Idokah in #4
• create router file and load async by @Idokah in #5
• secret manager clients packge by @MXPOL in #3
• Async function in startup and test fixes by @MXPOL in #6
• add oid and bool cases to SchemaColumnTranslator postgres by @Idokah in #9
• appjs redesign by @MXPOL in #10
• add app-info pages by @Idokah in #8
• external db config refactor by @MXPOL in #7
• wrap schema api function with try,catch by @Idokah in #12
• replace err.sqlMessage to err.message on postgres by @Idokah in #13
• change validate connection func by @Idokah in #11
• External db config by @MXPOL in #14
• Appinfo page + Error page redesign by @MXPOL in #17
• initial commit of adapter installer packge by @noam-almog in #18
• Travis by @Idokah in #20
• nop by @Idokah in #22
• Travis update by @Idokah in #23
• add main.yml by @Idokah in #24
• github actions by @Idokah in #27
• Azure adapter installer by @Idokah in #19
• fix mssql connection provider by @Idokah in #28
• Firestore implementation by @MXPOL in #26
• add temp fix for spanner float by @Idokah in #31
• mongo data provider implementation by @Idokah in #32
• mongo data provider fixes by @Idokah in #33
• mongo filter transformer by @Idokah in #35
• mongo operations, connection provider by @Idokah in #36
• mongo-urlized by @Idokah in #37
• google sheets implementation by @MXPOL in #34
• Mongo utils tests by @Idokah in #38
• first version airtable data_provider and filter_parser by @Idokah in #43
• Airtable data_provider by @Idokah in #44
• change mongo config reader to uri only by @Idokah in #41
• google-sheets tests by @MXPOL in #42
• MongoDB - add validateTable by @Idokah in #45
• Airtable mock and operations by @Idokah in #47
• allowing to start docker on dev env by @noam-almog in #48
• testing yaml strategy by @noam-almog in #49
• airtable data e2e by @Idokah in #50
• Added matrix testing to mysql 5.7 by @noam-almog in #51
• CI testing versions by @noam-almog in #52
• Docs fix readme by @ebaynash in #54
• syntax by @noam-almog in #55
• adding cache of node modules by @noam-almog in #56
• Airtable schema by @Idokah in #57
• remove updatable fields check on update by @noam-almog in #58
• GCP installer script by @MXPOL in #60
• azure script before refactoring by @Idokah in #62
• Azure script by @Idokah in #63
• add postgres support and fix typo by @Idokah in #64
• add region select for azure by @Idokah in #65
• Airtable by @Idokah in #59
• deps upgrade by @noam-almog in #66
• moved airtable to normal build flow by @noam-almog in #67
• CI fix by @MXPOL in #70
• fixed total count calculation by @noam-almog in #72
• DynamoDB support (WIP) by @Idokah in #71
• removed package lock yet again by @noam-almog in #74
• Dynamo refactor by @Idokah in #73
• default empty sort to remove warning airtable by @Idokah in #76
• add query option for keys (patched for now) by @Idokah in #75
• move queryable logic to filter transformer by @Idokah in #77
• BigQuery support (WIP) by @MXPOL in #69
• docker hub deploy workflow by @Idokah in #83
• Lint refactor by @MXPOL in #80
• V2 new filter, aggregation by @Idokah in #86
• Lint git hooks + lint tests by @MXPOL in #84
• Refactor sql filter parser by @Idokah in #88
• rename from ranomV2Filter to randomFilter by @Idokah in #89
• Spanner schema subtype by @Idokah in #90
• Count aggregation by @MXPOL in #96
• refactor schema adapter layer by @noam-almog in #97
• refactor tests for schema by @noam-almog in #101
• refactor tests for data by @noam-almog in #102
• Api wrapper transform filter by @Idokah in #99
• BigQuery tests by @MXPOL in #85
• added schema headers support by @noam-almog in #103
• added supported operations skeleton for all providers by @noam-almog in #104
• Allowed query operators for each filed type by @MXPOL in #105
• Wrap API - Parse aggregation by @Idokah in #106
• reorged directory structure of core module by @noam-almog in #107
• google sheets - support for the new schema cache feature by @MXPOL in #110
• Split ApiWrapper by @Idokah in #109
• Mysql with new filter, aggregation format by @Idokah in #111
• Google sheets tests by @MXPOL in #112
• Mongo new filter, aggregation format by @Idokah in #113
• Postgres new filter, aggregation format by @Idokah in #114
• Firestore new filter, aggregation format by @Idokah in #115
• spanner support new format by @Idokah in #120
• rename azr to azure by @Idokah in #118
• dynamodb support new format by @Idokah in #121
• Supported schema operations by @MXPOL in #116
• mssql support new format by @Idokah in #122
• bigquery support new format by @Idokah in #124
• google-sheets support new format by @Idokah in #125
• airtable support new format by @Idokah in #123
• All implementations with new filter format by @Idokah in #127
• added timers to refresh cache and remove lazy options by @noam-almog in #132
• refactor data service by @Idokah in #134
• big query cleanup by @noam-almog in #131
• supported schema operations by @MXPOL in #128
• CI: run tests for google-sheets in CI workflow by @MXPOL in #135
• new property to schema list response by @MXPOL in #137
• fix for schema service tests by @MXPOL in #139
• Allowed operation for each collection by @MXPOL in #138
• moved supported operations logic to each schema provider by @MXPOL in #140
• Validate schema operation by @MXPOL in #141
• validate query by @Idokah in #129
• Schema tests matchers by @MXPOL in #142
• Mock query validator by @Idokah in #146
• Schema test minor refactor by @MXPOL in #152
• minor change in data.spec.js by @Idokah in #153
• Bigquery bug fix by @MXPOL in #145
• generate id for collections without _id column by @MXPOL in #151
• config reader for auth configuration by @MXPOL in #155
• fix content manager scroll issue by @Idokah in #149
• Validate dbtype and cloud vendor by @Idokah in #147
• hash id by @Idokah in #156
• add test to check generateIdIfNeeded is consistent by @Idokah in #162
• Schema Aware Data Service by @Idokah in #157
• validate aggregation and refactor tests by @Idokah in #160
• Integration of the auth reader in config reader by @MXPOL in #161
• Cloud authorization for app info by @MXPOL in #154
• Projection - Postgres by @Idokah in #163
• Validate before getById by @Idokah in #164
• Role Authorization Service by @Idokah in #166
• Item patcher class by @Idokah in #165
• deps by @noam-almog in #167
• Move role authorization to module by @Idokah in #168
• Azure auth by @MXPOL in #173
• Add Authorize role api to router by @Idokah in #169
• auth service refactor by @MXPOL in #175
• fix typo azure provision script by @Idokah in #177
• fix date bug by @Idokah in #180
• External-db-authorization package rename by @MXPOL in #186
• Fix MongoDB add / remove column concurrency by @Idokah in #187
• authentication service removal by @MXPOL in #188
• Projection MongoDB by @Idokah in #174
• Projection MySQL by @Idokah in #182
• Projection MSSQL by @Idokah in #183
• Projection Spanner by @Idokah in #184
• Projection BigQuery by @Idokah in #185
• Projection DynamoDB by @Idokah in #190
• airtable projection by @Idokah in #191
• Collection level role config by @Idokah in #178
• pass fields to insert function by @MXPOL in #193
• patch generate _id by @Idokah in #196
• deps by @noam-almog in #199
• authorization config reader validator by @Idokah in #194
• Skip schema tests using supportedOperations method by @MXPOL in #197
• rename const by @noam-almog in #203
• Skip tests when not the operation is not supported by @MXPOL in #205
• error translator for remove column - bigquery by @MXPOL in #206
• New data operations by @MXPOL in #208
• removed each from e2e and storage tests by @michaelir in #202
• schemas-config by @Idokah in #210
• Show role config by @Idokah in #204
• Change role names in collection level config by @Idokah in #200
• Gen js refactor by @MXPOL in #198
• String operators to case-insensitive by @Idokah in #211
• init of firestore projection by @MXPOL in #213
• make find and count parallel by @Idokah in #215
• Change schema information structure by @Idokah in #216
• Generate a number of collections in data script by @MXPOL in #217
• Case insensitive tests by @Idokah in #212
• AWS MongoDB config reader by @Idokah in #225
• Fix dynamo config reader by @Idokah in #223
• terraform script - azure by @Idokah in #220
• Fix mongo without uri by @Idokah in #224
• return items after update/insert asWixData format by @Idokah in #227
• return true or false when the type is boolean instead other values by @Idokah in #228
• Working startWith operator - Firestore by @MXPOL in #218
• Terraform scripts - GCP by @MXPOL in #207
• gcp instruction for terraform script by @MXPOL in #229
• remove hasSome from mongo filter transformer by @Idokah in #230
• Db operations tests - dynamic by implementation by @Idokah in #234
• Change aws config reader by @Idokah in #231
• AWS authorization config by @Idokah in #232
• Skip unsupported tests by @MXPOL in #235
• startWith function to the firestore test driver by @MXPOL in #237
• add next to errorMiddleware function by @Idokah in #241
• New schema operations and test fix by @MXPOL in #238
• Add error messages by @Idokah in #242
• Fix aggregation count by @Idokah in #239
• move test-commons to dev deps by @Idokah in #245
• Fix IS NULL / IS NOT NULL bug by @Idokah in #247
• implement matches operator in mysql by @Idokah in #233
• Docker image for each db type by @MXPOL in #246
• Terraform azure postgres by @Idokah in #250
• and/or operators can get empty filter - mongo by @Idokah in #251
• Fix not operator - MongoDB by @Idokah in #253
• Create greater than test by @Idokah in #249
• split allowedOperators and allowedOperations by @Idokah in #255
• fix authorization level config by @Idokah in #256
• fix authorization config reader by @Idokah in #257
• Add data provider test for not operator by @Idokah in #254
• Implement matches operator by @Idokah in #248
• New data type - Json by @MXPOL in #252
• fix aws authorization config reader by @Idokah in #261
• Aws auth validation fix by @Idokah in #262
• Split the adapter to packages - POC by @Idokah in #259
• update ejs to 3.1.7 by @Idokah in #264
• fix hasSome (include) operator in spanner by @Idokah in #265
• Firestore small test refactor by @MXPOL in #270
• Package-json-update by @MXPOL in #269
• Test hasSome operator by @Idokah in #271
• Authorization config reader by @Idokah in #272
• Renaming authorization config by @Idokah in #274
• data hooks by @Idokah in #273
• fix config validator typo by @Idokah in #277
• Schema hooks by @Idokah in #276
• randomBodyWith to core, fix imports by @Idokah in #278
• replace for loop with promise.reduce by @Idokah in #279
• @wix-velo prefix and version 1.0.2 by @MXPOL in #281
• enable app info without require ejs or perform enableAppInfo by @Idokah in #280
• Nx migration by @MXPOL in #275

New Contributors

• @MXPOL made their first contribution in #2
• @noam-almog made their first contribution in #18
• @ebaynash made their first contribution in #54
• @michaelir made their first contribution in #202

Full Changelog: https://github.com/wix/velo-external-db/commits/1.0.3