v1.5 GA Release

• Websocket latency is now displayed on UI (best kept below 200ms)
• Telegram bot reporting has been improved to display Fund, Profit, Thread Count, System Status, and Master Node
• Telegram now proactively message you when a system fault is detected
• An improved thread locking mechanism
• Improved databased handling (database updated and new stored procedures)
• Logging improvements
• Fixed WebSocket restart issue
• Added various Binance exchange error handlers for stability
• Decommissioned Telegram individual commands for Fund, Profit, Thread Count, System Status, and Master Node
• Multiple code improvements and re-write of multiple functions

This new release requires a database update if you are already running Cryptopump in production. If you are deploying for the first time, simply use cryptopump.sql.

1. Execute the following SQL query against the session table:

ALTER TABLE `cryptopump`.`session` 
ADD COLUMN `Status` TINYINT(1) NOT NULL AFTER `FiatFunds`;

2. Open the UpdateSession Stored Procedure and replace its content with:

CREATE DEFINER=`root`@`%` PROCEDURE `UpdateSession`(in_ThreadID varchar(45), in_ThreadIDSession varchar(45), in_Exchange varchar(45), in_FiatSymbol varchar(45), in_FiatFunds float, in_Status tinyint(1))
BEGIN
SET SQL_SAFE_UPDATES = 0;
	UPDATE `session`
	SET `session`.`FiatFunds` = in_FiatFunds,
		`session`.`Status` = in_Status
	WHERE `session`.`ThreadID` = in_ThreadID;
SET SQL_SAFE_UPDATES = 1;
END

3. Open the SaveSession Stored Procedure and replace its content with:

CREATE DEFINER=`root`@`%` PROCEDURE `SaveSession`(in_ThreadID varchar(45), in_ThreadIDSession varchar(45), in_Exchange varchar(45), in_FiatSymbol varchar(45), in_FiatFunds float, in_Status tinyint(1))
BEGIN
INSERT INTO session (ThreadID, ThreadIDSession, Exchange, FiatSymbol, FiatFunds, Status)
VALUES (in_ThreadID, in_ThreadIDSession, in_Exchange, in_FiatSymbol, in_FiatFunds, in_Status);
END

4. Create a new stored procedure called GetSessionStatus and replace it with the following content:

CREATE DEFINER=`root`@`%` PROCEDURE `GetSessionStatus`()
BEGIN
SELECT `session`.`ThreadID` AS `ThreadID`, `session`.`Status` AS `Status`
FROM cryptopump.session
WHERE `session`.`Status` = 1;
END