Hi, Could you share with me an effective method for initializing the MySQL database from your code? about flat-server HOT 9 CLOSED

See #796.

from flat-server.

Are there alternative solutions aside from the utilization of Docker?

from flat-server.

If I use Docker, is there any change at this position in https://github.com/netless-io/flat-server/blob/main/scripts/prepare-test-env.sh?

from flat-server.

Because my knowledge in this area is quite limited, could you please clarify for me?
Sorry for any inconvenience I may have caused and thank you very much for your support.

from flat-server.

Is the command to run like this?
wget -O - https://github.com/netless-io/flat-server/raw/main/scripts/prepare-test-env.sh | sh
docker run --name mysql-db -e MYSQL_ROOT_PASSWORD=your_password -d mysql:latest
docker run --name redis-db -d redis:latest
yarn run test:sync:orm

from flat-server.

It doesn't need to be docker of course. The code of flat-server has to connect to a mysql service and a redis service. It will read config/development.local.yaml or config/production.local.yaml (depending on the env NODE_ENV) at runtime and connect to these services, see

So you just have to make sure the services are there, and that's enough. The test:sync:orm script will create database tables for you.

Once you have prepared the databases, you can start running the server with:

# watch build the server, will generate dist/index.js
$ yarn run start

# start server in another terminal
$ node dist/index.js

from flat-server.

Thanks for your support. I will try it.

from flat-server.

Could you please tell me why when I use 'yarn run start' and 'node ./dist/index.js' with port 8080, even though it displays as running successfully but the link doesn't work?

from flat-server.

0.0.0.0 is not a valid address to connect to (ERR_ADDRESS_INVALID). It means that the server listens to all possible addresses that could reach the server. For example localhost 127.0.0.1 192.168.x.y {your internet ip}. You can just use 127.0.0.1.

from flat-server.