也谈自建统计

其实在使用各种第三方的统计之前，一直用的都是jetpack自带的统计系统，虽然简陋但是也基本够用了。主要是也没有什么太多需要分析的数据，后来有一段时间用的cnzz的免费版，但是在某一天之后忽然收费了不能用了。改换到百度，51la，不过这俩统计也是各种被屏蔽。

前几天看到小乔同学那个统计感觉很有意思就自建了一个：

是不是很可爱哒，就喜欢这种可可爱爱的风格。这个用的是Moe-Counter多种风格可选的萌萌计数器.

https://github.com/journey-ad/Moe-Counter

安装神马的也非常简单，使用sqlite数据库，可以直接通过数据库修改基数。

今天想着把百度的统计要给换了，于是尝试用Umami统计：

Umami is a simple, fast, privacy-focused alternative to Google Analytics.

https://github.com/umami-software/umami

不过在安装的时候出现了下面的错误：

Error: P3018

A migration failed to apply. New migrations cannot be applied before the error is recovered from. Read more about how to resolve migration issues in a production database: https://pris.ly/d/migrate-resolve

Migration name: 02_report_schema_session_data

Database error code: 1064

Database error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLUMN `event_data_type` TO `data_type`;
ALTER TABLE `event_data` RENAME COLUMN ' at line 2

Please check the query number 1 from the migration file.


✗ Command failed: prisma migrate deploy
Error: P3018

A migration failed to apply. New migrations cannot be applied before the error is recovered from. Read more about how to resolve migration issues in a production database: https://pris.ly/d/migrate-resolve

Migration name: 02_report_schema_session_data

Database error code: 1064

Database error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLUMN `event_data_type` TO `data_type`;
ALTER TABLE `event_data` RENAME COLUMN ' at line 2

Please check the query number 1 from the migration file.



error Command failed with exit code 1.
info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command.
ERROR: "check-db" exited with 1.
error Command failed with exit code 1.

这个就很蛋疼了，搜索了一下，发现说是语法问题，参考这个链接：https://roy.wang/umami-build-error-p3009/

修改sql文件：

vim db/mysql/migrations/02_report_schema_session_data/migration.sql 

将下面的代码：

-- AlterTable
ALTER TABLE "event_data" RENAME COLUMN "event_data_type" TO "data_type";
ALTER TABLE "event_data" RENAME COLUMN "event_date_value" TO "date_value";
ALTER TABLE "event_data" RENAME COLUMN "event_id" TO "event_data_id";
ALTER TABLE "event_data" RENAME COLUMN "event_numeric_value" TO "number_value";
ALTER TABLE "event_data" RENAME COLUMN "event_string_value" TO "string_value";

修改为：

-- RenameColumns
ALTER TABLE `event_data` ADD COLUMN data_type INTEGER UNSIGNED AFTER event_data_type;
ALTER TABLE `event_data` ADD COLUMN date_value TIMESTAMP(0) AFTER event_date_value;
ALTER TABLE `event_data` ADD COLUMN event_data_id VARCHAR(36) AFTER event_id;
ALTER TABLE `event_data` ADD COLUMN number_value DECIMAL(19, 4) AFTER event_numeric_value;
ALTER TABLE `event_data` ADD COLUMN string_value VARCHAR(500) AFTER event_string_value;

UPDATE event_data
SET data_type = event_data_type,
    date_value = event_date_value,
    event_data_id = event_id,
    number_value = event_numeric_value,
    string_value = event_string_value;

ALTER TABLE `event_data` MODIFY data_type INTEGER UNSIGNED NOT NULL;
ALTER TABLE `event_data` MODIFY event_data_id VARCHAR(36) NOT NULL;

ALTER TABLE `event_data` DROP COLUMN event_data_type;
ALTER TABLE `event_data` DROP COLUMN event_date_value;
ALTER TABLE `event_data` DROP COLUMN event_id;
ALTER TABLE `event_data` DROP COLUMN event_numeric_value;
ALTER TABLE `event_data` DROP COLUMN event_string_value;

ALTER TABLE `event_data` ADD PRIMARY KEY(event_data_id);

之行下面的命令重新build：

npx prisma migrate resolve --rolled-back "02_report_schema_session_data"
yarn build

基本就ok了。

如果要使用其他的端口启动服务，使用下面的命令：

npx next start -p 4000

实际效果：