douzui0143 2016-07-15 14:55
浏览 91

在Golang应用中处理数据库错误的正确方法

I have simple web app on Go. Logging of errors is important part of app. Errors can be deived on:

a) Database errors - when interact with Database we need log all errors are occured b) Input parameters, logic errors

My typical handler looks like:

func handler(r,w) {
  var client models.Client
  err := json.NewDecoder(r.Body).Decode(&client)
  log.Error(err) // if error was

  err = client.Validate()
  log.Error(err) // if error was

  err = client.Save()
}
...
func (client *Client) Save() error {
   _, err := db.Exec(`insert into client ....`, client.data())
   if err != nil {
     log.Error(err)
     return err
   }
   ...
}

Look at the *Client.Save() method. When DB error occures we log it. My logger takes file:line where error occures.

I think that it's better way that database package processes errors itself. For example, it's good to have some Database type which logs all errors inside methods Exec(), Query, QueryRow with taking file:line where in client code errors occures.

type Database struct {
}
func (d *Database) Exec(...) result, error {
      res, err := d.db.Exec()
      if err != nil {
        log.Error(err, calldepth=3) // calldepth=3 to show place in client code where errors occures
         return nil, err
     }
}

So, we can rewrite out method *Client.Save() mehtod to reduce error processing in client code:

func (client *Client) Save() error {
   _, err := db.Exec(`insert into client ....`, client.data()) // error will processed in Exec
   if err != nil {
     return err
   }
   ...
}

Whats is right way to process errors of Database in model-controller app? How to reduce error processing across code? May be there are database packages with built in features

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 winform的chart曲线生成时有凸起
    • ¥15 msix packaging tool打包问题
    • ¥15 finalshell节点的搭建代码和那个端口代码教程
    • ¥15 用hfss做微带贴片阵列天线的时候分析设置有问题
    • ¥15 Centos / PETSc / PETGEM
    • ¥15 centos7.9 IPv6端口telnet和端口监控问题
    • ¥20 完全没有学习过GAN,看了CSDN的一篇文章,里面有代码但是完全不知道如何操作
    • ¥15 使用ue5插件narrative时如何切换关卡也保存叙事任务记录
    • ¥20 海浪数据 南海地区海况数据,波浪数据
    • ¥20 软件测试决策法疑问求解答