drl37530 2018-07-10 19:47
浏览 16
已采纳

数据库单元测试

I am hoping to get some advice on a unit test I am writing for to test some db entries.

The function I am testing seeds the database if no records are found.

func Seed(db *gorm.DB) {
    var data []Data
    db.Find(&data)

    if len(data) == 0 {
      // do seed default data
    }

}

What I can't quite seem to get going is the test for that if len test. I am using a test db so I can nuke it whenever so it is not an issue if I just need to force an empty DB on the function.

The function itself works and I just want to make sure I get that covered.

Any advice would be great.

Thanks!

  • 写回答

1条回答 默认 最新

  • dongxun1978 2018-07-10 19:55
    关注

    It really depends, there are so many ways of addressing this based on your risk level and the amount of time you want to invest to mitigate those risks.

    • You could write a unit test that asserts your able to detect and act on users logic (ie seeding when empty and ignoring when full) without any database.
    • If you would like to test the logic as well as your programs ability to speak to mysql correctly through the gorm library you could:
      • Have a test where you call Seed with no users in the DB, after calling it your test could select from Users and make sure there are the expected entries created from len(users) == 0 conditional
      • Have a test where the test creates a single entry and calls Seed, after which asserting that underlying tables are empty.

    It can get more complicated. If Seed is selecting a subset of data than your test could insert 2 users, one that qualifies and one that doesnt', and make sure that no new users are Seeded.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 自制电路图为何无法驱动ESP01S?
  • ¥15 前端加access数据库
  • ¥15 ARCGIS 多值提取到点 ERROR 999999
  • ¥15 mysql异常断电, [MY-011971] [InnoDB]
  • ¥15 uni.onBluetoothDeviceFound熄屏不运行
  • ¥35 关于shodan搜索网络摄像头的各种方法详解
  • ¥15 求PHDA糖尿病并发症数据集,有偿
  • ¥15 为什么AVL fire DVI 界面里面的response Editor project 中的Summary result 点不了
  • ¥20 中标麒麟系统V4.0,linux3.10.0的内核,3A4000处理器,如何安装英伟达或AMD的显卡驱动,
  • ¥20 求文心中文心理分析系统(TextMind)