wandilekhowa/ussd-service
Domain:
digital infrastructureRecord type:
software
Creator:
wan
Host:
Ussd service for sending payments to African countries
# Mama Money Ussd Service
Ussd service for sending payments to African countries
The instructions to run the code:
- `$ mvn clean install`
- In the root directory of the project, run:
`$ docker-compose up --build`
There are initialization scripts which are critical to the running of this service, this file is called `init.sql` and can be found in the root directory of this project. These will give you an idea of how the database is structured.
Ensure that both the mysqldb & spring-boot applications are bot up and running. Run:
`$ docker ps`
```
d2d801c06f91 ussd-service-app "java -jar /app.jar" 23 minutes ago Up 23 minutes 0.0.0.0:8080->8080/tcp, :::8080->8080/tcp ussd-service-app-1
d186622fab7f mysql:5.7 "docker-entrypoint.s…" 23 minutes ago Up 23 minutes 0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp ussd-service-mysqldb-1
```
To connect to the mysqldb container and view the mysql database
```
wkhowa@wkhowa-mac ussd-service % docker exec -it ussd-service-mysqldb-1 bash
bash-4.2# mysql -u root -padmin
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 5.7.43 MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use ussd;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+-----------------------+
| Tables_in_ussd |
+-----------------------+
| country |
| foreign_exchange_rate |
| prompt |
| session |
| transaction |
+-----------------------+
5 rows in set (0.01 sec)
mysql> select * from session;
+----+---------------------+--------------+---------------------------------------------------------------+---------------------+--------------------- …