Description

Fix Geo vis IP address & SQL logic bugs.

As reported in 352, the Geo vis frontend app could not access the database if the database is deployed on a remote server. The root cause is that both the frontend and backend app run in local mode (can only be accessed from the same machine), therefore all external access will be blocked. This PR fixes these bugs.

This PR also fixes some related SQL logic bugs. The original SQL logic fails to get the data under some corner cases.

Linked issue(s)/Pull request(s)

• 352

Type of Change

• Non-breaking bug fix
• Breaking bug fix
• New feature
• Test
• Doc update
• Docker update

Related Component

• Simulation toolkit
• RL toolkit
• Distributed toolkit
• Geo vis

Has Been Tested

• OS:
  • Windows
  • Mac OS
  • Linux
• Python version:
  • 3.6
  • 3.7
• Key information snapshot(s):

Needs Follow Up Actions

• New release package
• New docker image

Checklist

• Add/update the related comments
• Add/update the related tests
• Add/update the related documentations
• Update the dependent downstream modules usage