Commit Graph

  • c42fa11c1a fix(reflection): update GetForeignKeyColumn to return multiple columns * Change return type to []string for composite keys * Adjust related logic in injectForeignKeys method * Update tests to validate new behavior for composite foreign keys v1.0.98 Hein 2026-05-18 12:39:06 +02:00
  • 85bb0f7874 fix(funcspec): update meta variable replacement in SQL query v1.0.97 Hein 2026-05-18 12:13:06 +02:00
  • cd65946191 fix(database): add Scan method to insert query interfaces * Implement Scan method for BunInsertQuery, GormInsertQuery, and PgSQLInsertQuery * Update mock implementations to support Scan method * Introduce GetForeignKeyColumn utility for foreign key resolution * Add tests for GetForeignKeyColumn functionality Hein 2026-05-18 12:04:50 +02:00
  • cb416d49c4 fix(headers): handle decoding errors in header values * return original value if decoding fails * decode base64 strings when appropriate v1.0.96 Hein 2026-05-15 16:59:06 +02:00
  • cb921f2c5e fix(websocketspec): add transaction access to HookContext v1.0.95 Hein 2026-05-15 14:59:34 +02:00
  • 1ebe0d7ac3 fix(funcspec): refine filter application logic for SQL queries * update filter checks to only consider SELECT list * add test for function parameters not matching filters v1.0.94 Hein 2026-05-15 14:28:12 +02:00
  • ae9e06c98b fix(sql_helpers): strip empty RHS conditions from SQL strings * Add regex patterns to identify and remove empty comparisons * Implement tests for stripping empty RHS conditions fix(handler): prevent duplicate JOIN aliases from preload * Skip custom SQL JOINs if alias already provided by preload * Split multiple JOIN clauses for individual alias handling v1.0.93 Hein 2026-05-15 13:35:24 +02:00
  • 2ae4d07544 fix(funcspec): remove AllowQueryParamFilters and related logic * Simplify SqlQueryOptions by removing AllowQueryParamFilters * Update mergeQueryParams to avoid applying filters for JSON arguments * Add tests for sqlStripStringLiterals and query param handling v1.0.92 Hein 2026-05-15 09:25:55 +02:00
  • 49639b6c19 fix(funcspec): add support for query param filters * Introduced AllowQueryParamFilters option in SqlQueryOptions * Implemented applyQueryParamFilters method to handle field filters v1.0.91 Hein 2026-05-15 09:07:21 +02:00
  • 8733176cba fix(funcspec): enhance quote detection for parameters v1.0.90 Hein 2026-05-15 08:26:59 +02:00
  • bce27f7ed2 fix: 🐛 Fixed array to slice array resolution on reflection GetRelationType v1.0.89 Hein 2026-05-11 14:24:25 +02:00
  • 987a2a7faf fix(db): convert slices to PostgreSQL array literals in queries v1.0.88 Hein 2026-05-07 14:33:35 +02:00
  • 157788b73b fix(todo): document issue with GormResult.LastInsertId() not returning correct ID warkanum 2026-05-05 09:52:31 +02:00
  • fb051b5577 fix(spectypes): correct quoting logic in formatPostgresStringArray v1.0.87 Hein 2026-04-30 15:38:21 +02:00
  • cc9c4337fd feat(spectypes): add PostgreSQL array types and parsing functions Hein 2026-04-30 15:37:33 +02:00
  • 0aaeff63a2 fix(db): guard against non-existent relations in preload Hein 2026-04-20 17:15:33 +02:00
  • 325769be4e feat(reflection): add support for nested struct mapping v1.0.86 Hein 2026-04-16 13:45:46 +02:00
  • f79a400772 feat(security): add self-service password reset functionality * Implement password reset request and completion procedures * Update database schema for password reset tokens * Add new request and response types for password reset v1.0.85 warkanum 2026-04-15 21:46:33 +02:00
  • aef1f96c10 fix(db): cast columns to text for LIKE/ILIKE queries v1.0.84 Hein 2026-04-13 14:05:17 +02:00
  • 354ed2a8dc feat(db): add fallback metric entity handling for unknown targets * implement fallbackMetricEntityFromQuery for query sanitization * add tests for fallback metric entity and sanitization logic v1.0.83 Hein 2026-04-10 16:00:22 +02:00
  • dfb63c3328 refactor(db): remove metrics enabling methods from adapters v1.0.82 Hein 2026-04-10 14:13:15 +02:00
  • e8d0ab28c3 feat(db): add query metrics tracking for database operations Hein 2026-04-10 13:51:46 +02:00
  • 4fc25c60ae fix(db): correct connection pool assignment in GORM adapter v1.0.81 Hein 2026-04-10 11:20:44 +02:00
  • 16a960d973 feat(db): add reconnect logic for database adapters * Implement reconnect functionality in GormAdapter and other database adapters. * Introduce a DBFactory to handle reconnections. * Update health check logic to skip reconnects for transient failures. * Add tests for reconnect behavior in DatabaseAuthenticator. Hein 2026-04-10 11:18:39 +02:00
  • 2afee9d238 fix(db): handle database reconnection in transactions v1.0.80 v1.0.79 Hein 2026-04-10 08:42:41 +02:00
  • 1e89124c97 Merge pull request #18 from bitechdev/feature-auth-mcp v1.0.78 Hein Puth (Warkanum) 2026-04-09 16:18:18 +02:00
  • ca0545e144 fix(security): address validation review comments - mutex safety and issuer normalization copilot-swe-agent[bot]andwarkanum 2026-04-09 14:07:45 +00:00
  • 850ad2b2ab fix(security): address all OAuth2 PR review issues copilot-swe-agent[bot]andwarkanum 2026-04-09 14:04:53 +00:00
  • 2a2e33da0c Merge branch 'main' of https://github.com/bitechdev/ResolveSpec into feature-auth-mcp Hein 2026-04-09 15:52:26 +02:00
  • 17808a8121 Merge pull request #19 from bitechdev/feature-keystore Hein Puth (Warkanum) 2026-04-09 15:50:36 +02:00
  • 134ff85c59 Merge branch 'main' of https://github.com/bitechdev/ResolveSpec into feature-keystore Hein 2026-04-09 15:47:54 +02:00
  • bacddc58a6 style(recursive_crud): remove unnecessary blank line Hein 2026-04-09 15:37:13 +02:00
  • f1ad83d966 feat(reflection): add JSON to DB column name mapping functions * Implement BuildJSONToDBColumnMap for translating JSON keys to DB column names * Enhance GetColumnName to extract column names with priority * Update filterValidFields to utilize new mapping for improved data handling * Fix TestToSnakeCase expected values for consistency Hein 2026-04-09 15:36:52 +02:00
  • 79a3912f93 fix(db): improve database connection handling and reconnection logic Hein 2026-04-09 09:19:28 +02:00
  • 6502b55797 feat(security): implement OAuth2 authorization server with database support warkanum 2026-04-07 22:56:05 +02:00
  • aa095d6bfd fix(tests): replace panic with log.Fatal for better error handling v1.0.77 warkanum 2026-04-07 20:38:22 +02:00
  • ea5bb38ee4 feat(handler): update to use static base path for SSE server v1.0.76 warkanum 2026-04-07 20:03:43 +02:00
  • c2e2c9b873 feat(transport): add streamable HTTP transport for MCP v1.0.75 warkanum 2026-04-07 19:52:38 +02:00
  • 4adf94fe37 feat(go.mod): add mcp-go dependency for enhanced functionality v1.0.74 warkanum 2026-04-07 19:09:51 +02:00
  • a9bf08f58b feat(security): implement keystore for user authentication keys * Add ConfigKeyStore for in-memory key management * Introduce DatabaseKeyStore for PostgreSQL-backed key storage * Create KeyStoreAuthenticator for API key validation * Define SQL procedures for key management in PostgreSQL * Document keystore functionality and usage in KEYSTORE.md Hein 2026-04-07 17:09:17 +02:00
  • 405a04a192 feat(security): integrate security hooks for access control * Add security hooks for per-entity operation rules and row/column-level security. * Implement annotation tool for storing and retrieving freeform annotations. * Enhance handler to support model registration with access rules. Hein 2026-04-07 15:53:12 +02:00
  • c1b16d363a feat(db): add DB method to sqlConnection and mongoConnection Hein 2026-04-01 15:34:09 +02:00
  • 568df8c6d6 feat(security): add configurable SQL procedure names v1.0.73 Hein 2026-03-31 14:25:59 +02:00
  • aa362c77da fix(cursor): trim parentheses from sort column names v1.0.72 v1.0.71 Hein 2026-03-27 15:07:10 +02:00
  • 1641eaf278 feat(resolvemcp): enhance handler with configuration support * Introduce Config struct for BaseURL and BasePath settings * Update handler creation functions to accept configuration * Modify SSEServer to use dynamic base URL detection * Adjust route setup functions to utilize BasePath from config v1.0.70 Hein 2026-03-27 13:56:03 +02:00
  • 200a03c225 feat(resolvemcp): add SSE server and bunrouter setup functions * Introduce SSEServer method for creating an SSE server bound to the handler. * Add SetupBunRouterRoutes function to mount MCP HTTP/SSE endpoints on bunrouter. * Update README with usage examples for new features. v1.0.69 Hein 2026-03-27 13:28:03 +02:00
  • 7ef9cf39d3 style(tools): simplify string formatting in descriptions v1.0.68 Hein 2026-03-27 13:10:50 +02:00
  • 7f6410f665 feat(resolvemcp): add support for join-column sorting in cursor pagination * Enhance getCursorFilter to accept join clauses for sorting * Update resolveColumn to handle joined columns * Modify tests to validate new join functionality Hein 2026-03-27 13:10:42 +02:00
  • 835bbb0727 style(hooks): reorder fields in HookContext for consistency Hein 2026-03-27 12:57:30 +02:00
  • 047a1cc187 feat(resolvemcp): add hook system for model operations * Implement hooks for CRUD operations: before/after handle, read, create, update, delete. * Introduce HookContext and HookRegistry for managing hooks. * Allow registration and execution of multiple hooks per operation. Hein 2026-03-27 12:57:08 +02:00
  • 7a498edab7 fix(headers): enhance relation name resolution logic * Allow resolution for both regular headers and X-Files. * Introduce join-key-aware resolution for disambiguation. * Add new function to handle multiple fields pointing to the same type. v1.0.67 Hein 2026-03-25 12:09:03 +02:00
  • f10bb0827e fix(sql_helpers): ensure case-insensitive matching for allowed prefixes v1.0.66 v1.0.65 Hein 2026-03-25 10:57:42 +02:00
  • 22a4ab345a feat(security): add session cookie management functions * Introduce SessionCookieOptions for configurable session cookies * Implement SetSessionCookie, GetSessionCookie, and ClearSessionCookie functions * Enhance cookie handling in DatabaseAuthenticator v1.0.64 Hein 2026-03-24 17:11:53 +02:00
  • e289c2ed8f fix(handler): restore JoinAliases for proper WHERE sanitization v1.0.63 Hein 2026-03-24 12:00:02 +02:00
  • 0d50bcfee6 fix(provider): enhance file opening logic with alternate path. Handling broken cases to be compatible with Bitech clients * Implemented alternate path handling for file retrieval * Improved error messaging for file not found scenarios v1.0.62 Hein 2026-03-24 09:02:17 +02:00
  • 4df626ea71 chore(license): update project notice and clarify licensing terms warkanum 2026-03-23 20:32:09 +02:00
  • 7dd630dec2 fix(handler): set default sort to primary key if none provided v1.0.61 Hein 2026-03-11 14:37:04 +02:00
  • 613bf22cbd fix(cursor): use full schema-qualified table name in filters v1.0.60 Hein 2026-03-11 14:25:44 +02:00
  • d1ae4fe64e refactor(handler): unify filter operator handling for consistency v1.0.59 warkanum 2026-03-01 13:21:38 +02:00
  • 254102bfac refactor(auth): simplify handler type assertions for middleware v1.0.58 warkanum 2026-03-01 12:08:36 +02:00
  • 6c27419dbc refactor(auth): enhance request handling with middleware-enriched context warkanum 2026-03-01 12:06:43 +02:00
  • 377336caf4 feat(sql): implement IN condition handling with parameterized queries v1.0.57 warkanum 2026-03-01 09:52:32 +02:00
  • 79720d5421 feat(security): add BeforeHandle hook for auth checks after model resolution v1.0.56 warkanum 2026-03-01 09:15:30 +02:00
  • e7ab0a20d6 Merge branch 'main' of github.com:bitechdev/ResolveSpec v1.0.55 warkanum 2026-02-28 22:53:26 +02:00
  • e4087104a9 feat(security): add model rules enforcement for update and delete operations warkanum 2026-02-28 22:53:21 +02:00
  • 17e580a9d3 fix(pgsql): optimize SQL string building for LIMIT and OFFSET v1.0.54 Hein 2026-02-25 09:38:37 +02:00
  • 337a007d57 feat(openapi): add OpenAPI handling for OPTIONS requests Hein 2026-02-25 09:36:50 +02:00
  • e923b0a2a3 feat(routes): add authentication middleware support for routes v1.0.53 Hein 2026-02-16 10:38:06 +02:00
  • ea4a4371ba feat(changesets): add README and config files for changeset management warkanum 2026-02-15 19:51:57 +02:00
  • b3694e50fe refactor(websocket): rename classes and functions for clarity warkanum 2026-02-15 19:51:05 +02:00
  • b76dae5991 refactor(headerspec): improve code formatting and consistency warkanum 2026-02-15 19:49:29 +02:00
  • dc85008d7f feat(api): add ResolveSpec and WebSocket client implementations warkanum 2026-02-15 15:17:39 +02:00
  • fd77385dd6 feat(handler): enhance FetchRowNumber support in handlers * Implement FetchRowNumber handling in multiple handlers * Improve error logging for missing rows with filters * Set row numbers correctly based on FetchRowNumber v1.0.52 Hein 2026-02-10 17:42:27 +02:00
  • b322ef76a2 Merge branch 'main' of https://github.com/bitechdev/ResolveSpec v1.0.51 Hein 2026-02-10 16:55:58 +02:00
  • a6c7edb0e4 feat(resolvespec): add OR logic support in filters * Introduce logic_operator field to combine filters with OR logic. * Implement grouping for consecutive OR filters to ensure proper SQL precedence. * Add support for custom SQL operators in filter conditions. * Enhance fetch_row_number functionality to return specific record with its position. * Update tests to cover new filter logic and grouping behavior. Hein 2026-02-10 16:55:55 +02:00
  • 71eeb8315e chore: 📝 Refactored documentation and added better sqlite support. v1.0.50 warkanum 2026-02-07 10:58:34 +02:00
  • 4bf3d0224e feat(database): ✨ normalize driver names across adapters v1.0.49 Hein 2026-02-05 13:28:53 +02:00
  • 50d0caabc2 refactor(database): ♻️ simplify relation type handling * Consolidate related type determination logic * Improve clarity in slice creation for results * Enhance foreign key field name handling v1.0.48 Hein 2026-02-03 08:40:11 +02:00
  • 5269ae4de2 style(database): 🎨 format comments for clarity Hein 2026-02-02 18:40:37 +02:00
  • 646620ed83 feat(database): ✨ add custom preload handling for relations Hein 2026-02-02 18:39:48 +02:00
  • 7600a6d1fb fix(security): 🐛 handle errors in OAuth2 examples and passkey methods warkanum 2026-01-31 22:58:52 +02:00
  • 2e7b3e7abd feat(security): ✨ add database-backed passkey provider warkanum 2026-01-31 22:53:33 +02:00
  • fdf9e118c5 feat(security): ✨ Add two-factor authentication support warkanum 2026-01-31 22:45:28 +02:00
  • e11e6a8bf7 feat(security): ✨ Add OAuth2 authentication examples and methods warkanum 2026-01-31 22:35:40 +02:00
  • 261f98eb29 Merge branch 'main' of github.com:bitechdev/ResolveSpec warkanum 2026-01-31 21:50:37 +02:00
  • 0b8d11361c feat(auth): ✨ add user registration functionality warkanum 2026-01-31 21:50:32 +02:00
  • e70bab92d7 feat(tests): 🎉 More test for preload fixes. v1.0.47 Hein 2026-01-30 10:09:59 +02:00
  • fc8f44e3e8 feat(preload): ✨ Enhance recursive preload functionality v1.0.46 Hein 2026-01-29 15:31:50 +02:00
  • 584bb9813d .. v1.0.45 Hein 2026-01-29 09:37:22 +02:00
  • 17239d1611 feat(preload): ✨ Add support for custom SQL joins Hein 2026-01-29 09:37:09 +02:00
  • defe27549b feat(sql): ✨ Improve base64 handling in SqlNull type v1.0.44 Hein 2026-01-27 17:35:13 +02:00
  • f7725340a6 feat(sql): ✨ Add base64 encoding/decoding for SqlByteArray Hein 2026-01-27 17:33:50 +02:00
  • 07016d1b73 feat(config): ✨ Update timeout settings for connections v1.0.43 Hein 2026-01-26 11:06:16 +02:00
  • 09f2256899 feat(sql): ✨ Enhance SQL clause handling with parentheses v1.0.42 Hein 2026-01-26 09:14:17 +02:00
  • c12c045db1 feat(validation): ✨ Clear JoinAliases in FilterRequestOptions Hein 2026-01-15 14:43:11 +02:00
  • 24a7ef7284 feat(restheadspec): ✨ Add support for join aliases in filters and sorts v1.0.41 Hein 2026-01-15 14:18:25 +02:00
  • b87841a51c feat(restheadspec): ✨ Add custom SQL JOIN support v1.0.40 Hein 2026-01-15 14:07:45 +02:00
  • 289cd74485 feat(database): ✨ Enhance Preload and Join functionality v1.0.39 Hein 2026-01-14 17:02:26 +02:00
  • c75842ebb0 feat(dbmanager): ✨ update health check interval and add tests Hein 2026-01-14 15:04:27 +02:00
  • 7879272dda fix(recursive_crud): 🐛 prevent overwriting primary key in recursive relationships v1.0.38 Hein 2026-01-14 10:19:04 +02:00