Telegram Bot

Appearance

数据库设计 ​

本章节介绍如何使用 tio-boot+大模型+telegram 开发一个翻译机器人,本节仅仅仅仅介绍数据库部分

openai ​

前往 openai 申请 key 过程略

telegram ​

创建 telegram 机器人 过程略

数据库 ​

sql
create database ai_translator;

数据表设计 ​

max_kb_sentence_tanslate_cache ​

sql
CREATE TABLE "max_kb_sentence_tanslate_cache" (
  "id" "varchar" primary key,
  "from" varchar,
  "user_id" varchar,
  "md5" varchar,
  "src_lang" varchar,
  "dst_lang" varchar,
  "src_text" varchar,
  "dst_text" varchar,
  "model" varchar,
  "system_fingerprint" VARCHAR,
  "completion_tokens" INT,
  "prompt_tokens" INT,
  "total_tokens" INT,
  "elapsed" bigint
);

CREATE INDEX "max_kb_sentence_tanslate_cache_md5" ON "public"."max_kb_sentence_tanslate_cache" ("md5");

CREATE INDEX "max_kb_sentence_tanslate_cache_md5_model" ON "public"."max_kb_sentence_tanslate_cache" USING btree (
  "md5" TEXT_OPS ASC NULLS LAST,
  "model" TEXT_OPS ASC NULLS LAST
);