Reload/Refresh the GraphQL content from MySQL data.

[AjayDhimanELS]

I'm using Node/Express to successfully push some data into a MySQL db. Now the issue is that GraphQL is not refreshing/loading the new/recently added data. I tried following these:

• Force a refresh of GraphQL data without restarting gatsby develop #14395

• gatsby with graphql won't load new data #2847

But couldn't get any help. Have we found any simpler solutions to this?

[herecydev]

So have you tried using ENABLE_GATSBY_REFRESH_ENDPOINT? If so, is there something that's not working correctly?

[vladar]

Can you elaborate a bit more on what did you try? And what didn't work?

Did you try sending a POST request to __reresh endpoint? If so, did you set ENABLE_GATSBY_REFRESH_ENDPOINT env variable as @herecydev correctly pointed out above?

[AjayDhimanELS]

@vladar @herecydev
Yes, I tried adding ENABLE_GATSBY_REFRESH_ENDPOINT= true in my .env file.
Also, added the following in my node file.

app.post('/__refresh', (req, res) => {

const enableRefresh = process.env.ENABLE_GATSBY_REFRESH_ENDPOINT

const refreshToken = process.env.GATSBY_REFRESH_TOKEN

const authorizedRefresh =

!refreshToken || req.headers.authorization === refreshToken 

if (enableRefresh && authorizedRefresh) {

console.log(`Refreshing source data`) 

sourceNodes() 

}
res.end()
})

app.listen(8001, function() {
console.log('App listening on port 8001!');
});

Still, this doesn't seem to refresh the graphQL query's data.

[capndave]

Not sure if this will help, but I think you need to remove a space from the variable definition in your .env file. Try changing ENABLE_GATSBY_REFRESH_ENDPOINT= true to ENABLE_GATSBY_REFRESH_ENDPOINT=true.

[vladar]

@AjayDhimanELS You don't need to add anything to your gatsby-node file to enable this feature. Did you try removing the space from ENABLE_GATSBY_REFRESH_ENDPOINT= true as suggested above?

[openscript]

Unfortunately I also have troubles with this. I've created a .env.development file with the following content:

ENABLE_GATSBY_REFRESH_ENDPOINT=true

When I start Gatsby with gatsby develop from the console it doesn't pick up this variable, hence the refresh button in the GraphiQL editor is not shown. What am I doing wrong?

  System:
    OS: Linux 5.9 alpine VSCode devcontainer
    CPU: (8) x64 Intel(R) Core(TM) i7-7700HQ CPU @ 2.80GHz
    Shell: 5.0.3 - /bin/bash
  Binaries:
    Node: 14.14.0 - /tmp/yarn--1608064598022-0.6500972906168905/node
    Yarn: 1.22.5 - /tmp/yarn--1608064598022-0.6500972906168905/yarn
    npm: 6.14.8 - /usr/local/bin/npm
  Languages:
    Python: 2.7.16 - /usr/bin/python
  npmPackages:
    gatsby: ^2.28.2 => 2.28.2 
    gatsby-image: ^2.7.0 => 2.7.0 
    gatsby-plugin-emotion: ^5.0.0 => 5.0.0 
    gatsby-plugin-manifest: ^2.8.0 => 2.8.0 
    gatsby-plugin-react-helmet: ^3.6.0 => 3.6.0 
    gatsby-plugin-robots-txt: ^1.5.3 => 1.5.3 
    gatsby-plugin-sharp: ^2.10.1 => 2.10.1 
    gatsby-plugin-sitemap: ^2.8.0 => 2.8.0 
    gatsby-plugin-svgr: ^2.0.2 => 2.0.2 
    gatsby-plugin-ts-config: ^1.1.5 => 1.1.5 
    gatsby-remark-copy-linked-files: ^2.6.0 => 2.6.0 
    gatsby-remark-images: ^3.7.1 => 3.7.1 
    gatsby-source-filesystem: ^2.7.0 => 2.7.0 
    gatsby-transformer-remark: ^2.12.0 => 2.12.0 
    gatsby-transformer-sharp: ^2.8.0 => 2.8.0