dongrao9436 2016-08-31 14:37
浏览 7
已采纳

Rethinkdb,继续:确保一个ReQL语句中的表和索引

I need to ensure existence of table(s) upon application startup.

I also want to create secondary index on the table if table does not exist and needs to be created.

It is easily done in Go but I would like to do it in ReQL in one statement. So I came up with this:

func ensureTableIndex(ses *r.Session, name string, index string) (err error) {
    err = r.TableList().Contains(name).Do(r.Branch(r.Row, r.Expr(nil), r.Do(func() r.Term {
        return r.TableCreate(name).Do(func() r.Term {
            return r.Table(name).IndexCreate(index)
        })
    }))).Exec(ses)
    return
}

Seems to pass the test.

My question is whether this is a correct/efficient way to do table and index creation in one go? Is using ReQL Do() function the correct way to sequence multiple write commands?

Thanks

  • 写回答

1条回答 默认 最新

  • dragon4587 2016-09-01 07:16
    关注

    Yeah, do is the normal way you sequence operations in ReQL. The r.Do as the third argument to branch is superfluous, though; you can just put the tableCreate call there directly.

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

报告相同问题?

悬赏问题

  • ¥15 VS2022创建MVC framework提示:预安装的程序包具有对缺少的注册表值的引用
  • ¥15 weditor无法连接模拟器Local server not started, start with?
  • ¥20 6-3 String类定义
  • ¥15 嵌入式--定时器使用
  • ¥20 51单片机学习中的问题
  • ¥30 Windows Server 2016利用兩張網卡處理兩個不同網絡
  • ¥15 Python中knn问题
  • ¥15 使用C#,asp.net读取Excel文件并保存到Oracle数据库
  • ¥15 C# datagridview 单元格显示进度及值
  • ¥15 thinkphp6配合social login单点登录问题