v0.3.4

BotArcAPI

• Improve best30 endpoint, add overflow option for v4/user/best30.
• Append jacketOverride and version in the result of v4/song/info.
• Add a new endpoint v4/song/id. For alias to songid light weight converting use.
• Improve arcfetch, append BOTARCAPI_FRONTPROXY_CHANGE_NODE config to change the node while remote node error happened.

arcsong.db

• append jacket_override and version fields in the song table.

Upgrade

This update will break the database compatibility(in arcbest30.db and arcsong.db).
We don't offer the database automatic upgrade procedures.
If you want to keep your data, please append a new field on your old database using the following SQL command:
Before running this command, please make sure to BACKUP your database.

For arcbest30.db only.

ALTER TABLE `cache` RENAME TO `_cache_old`;

CREATE TABLE `cache` (
  `uid`  INTEGER NOT NULL,
  `last_played` INTEGER NOT NULL DEFAULT 0,
  `best30_avg` INTEGER NOT NULL DEFAULT 0,
  `recent10_avg` INTEGER NOT NULL DEFAULT 0,
  `best30_list` TEXT DEFAULT "",
  `best30_overflow` TEXT DEFAULT "",
PRIMARY KEY (`uid` ASC));

INSERT INTO `cache` (
  `uid`, `last_played`, 
  `best30_avg`, `recent10_avg`, 
  `best30_list`, `best30_overflow`) 
SELECT
  `uid`, `last_played`, 
  `best30_avg`, `recent10_avg`, 
  `best30_list`, "W10="
FROM `_cache_old`;

This might be spending some time, follows your database size.
If no errors happened, that means you have finished the upgrade.
Finally, you can remove the old table.

DROP TABLE `_cache_old`;