Code Monkey home page Code Monkey logo

db2rest-web's Introduction

Website

This website is built using Docusaurus, a modern static website generator.

Installation

$ yarn

Local Development

$ yarn start

This command starts a local development server and opens up a browser window. Most changes are reflected live without having to restart the server.

Build

$ yarn build

This command generates static content into the build directory and can be served using any static contents hosting service.

Deployment

Using SSH:

$ USE_SSH=true yarn deploy

Not using SSH:

$ GIT_USER=<Your GitHub username> yarn deploy

If you are using GitHub pages for hosting, this command is a convenient way to build the website and push to the gh-pages branch.

db2rest-web's People

Contributors

grabdoc avatar thadguidry avatar kdhrubo avatar

Stargazers

 avatar  avatar  avatar Nguyễn Tấn Anh avatar  avatar

Watchers

 avatar  avatar  avatar

Forkers

thadguidry

db2rest-web's Issues

Possible bug in default join `type` condition logic when `type` or `table` is omitted?

@dhrubo Looks like if we omit type attribute from the /_expand data then also omit table attribute, then it's a self join? But your Self Join example and also the key attributes table listing Description showing the Default value: "INNER" seems to conflict with the actual default value of type if its omitted?

Seems we need to fix the documentation, but first, we need to know:

  1. What is the join type assumed (default) if table and type are omitted and only fields and on are used with /film/_expand ?
  2. What is the join type assumed (default) if table is present and only fields and on are used with /film/_expand ?
  3. Or do we throw an error on logic in scenario 1. or 2. because it's not allowed and we need to fix documentation for Joining?

Call Stored Procedure error with Posgres Database - "To call a procedure, use CALL."

We seem to get below error with Postgres Stored procedure during integration test or while we test /procedure/{procName} endpoint using Postman:

Caused by: org.postgresql.util.PSQLException: ERROR: getmovierentalrateproc(character varying) is a procedure
  Hint: To call a procedure, use CALL.
  Position: 15
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2713)

Root cause of the error:

After PostgreSQL 11, PostgreSQL JDBC driver team has introduced a ENUM name EscapeSyntaxCallMode in PostgreSQL driver version 42.2.16...
https://stackoverflow.com/questions/65696904/postgresql-11-stored-procedure-call-error-to-call-a-procedure-use-call-java

Fix:

When we test using Postman, please make sure DB_URL is configured as:
DB_URL=jdbc:postgresql://localhost:5432/sakila?escapeSyntaxCallMode=callIfNoReturn

When running integration test we can add below config to the datasource:
dataSourceBuilder.url(testPostgres.getJdbcUrl() + "&escapeSyntaxCallMode=callIfNoReturn");

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.