blitz-orm icon indicating copy to clipboard operation
blitz-orm copied to clipboard

Add postgres adapter

Open aguspdana opened this issue 11 months ago • 0 comments

[!IMPORTANT] Add PostgreSQL adapter with client support, configuration, schema, data, and tests, including PostgreSQL-specific query handling and limitations.

  • PostgreSQL Adapter:
    • Add PostgreSQL client support in src/index.ts and queryMachine.ts.
    • Implement PostgreSQL-specific query building and execution in pg/build.ts, pg/machine.ts, and pg/run.ts.
  • Configuration:
    • Add PostgreSQL configuration in tests/adapters/postgresDB/mocks/config.ts.
    • Update init.ts to include PostgreSQL test configuration.
  • Schema and Data:
    • Create PostgreSQL schema in schema.sql and data in data.sql.
  • Testing:
    • Add postgres.sh for setting up PostgreSQL test environment.
    • Modify query.ts to include PostgreSQL-specific test cases and handle unsupported features.
    • Update package.json to include PostgreSQL dependencies and test scripts.
  • Miscellaneous:
    • Update schema.ts to include PostgreSQL-specific configurations for roles and fields.

This description was created by Ellipsis for 288fd2ad49876cf572921c22d7d58dc11ac383a5. It will automatically update as commits are pushed.

aguspdana avatar Feb 03 '25 10:02 aguspdana