初始化数据库连接
()
| 18 | |
| 19 | // 初始化数据库连接 |
| 20 | func InitDB() *sql.DB { |
| 21 | db, err = sql.Open("sqlite", "file:data.db?cache=shared&mode=rwc") |
| 22 | if err != nil { |
| 23 | logger.Error.Printf("sqlerr:", err) |
| 24 | } |
| 25 | |
| 26 | // 创建表的语句 |
| 27 | _, err = db.Exec(`CREATE TABLE IF NOT EXISTS key_info ( |
| 28 | id INTEGER PRIMARY KEY AUTOINCREMENT, |
| 29 | RuleName VARCHAR(255), |
| 30 | Host VARCHAR(255), |
| 31 | Req_Path VARCHAR(255), |
| 32 | Req_Body TEXT, |
| 33 | Res_Body TEXT, |
| 34 | Key_text TEXT, |
| 35 | Content_Type VARCHAR(255) |
| 36 | )`) |
| 37 | if err != nil { |
| 38 | log.Printf("sqlerr:", err) |
| 39 | } |
| 40 | return db |
| 41 | |
| 42 | } |
| 43 | func WriteDataToDatabase(data *consts.Keyinfo) error { |
| 44 | logger.Info.Println("检测到敏感信息:", data.Key_text) |
| 45 | if InsertData(db, data) { |