WriteSelect writes a select statement to select key columns without any condition
()
| 111 | |
| 112 | // WriteSelect writes a select statement to select key columns without any condition |
| 113 | func (b *SQLBuilder) WriteSelect() error { |
| 114 | if b.state != writeBegin { |
| 115 | return errors.Errorf("invalid state: %v", b.state) |
| 116 | } |
| 117 | b.restoreCtx.WritePlain("SELECT LOW_PRIORITY SQL_NO_CACHE ") |
| 118 | b.writeColNames(b.tbl.KeyColumns, false) |
| 119 | b.restoreCtx.WritePlain(" FROM ") |
| 120 | if err := b.writeTblName(); err != nil { |
| 121 | return err |
| 122 | } |
| 123 | if par := b.tbl.PartitionDef; par != nil { |
| 124 | b.restoreCtx.WritePlain(" PARTITION(") |
| 125 | b.restoreCtx.WriteName(par.Name.O) |
| 126 | b.restoreCtx.WritePlain(")") |
| 127 | } |
| 128 | b.state = writeSelOrDel |
| 129 | b.isReadOnly = true |
| 130 | return nil |
| 131 | } |
| 132 | |
| 133 | // WriteDelete writes a delete statement without any condition |
| 134 | func (b *SQLBuilder) WriteDelete() error { |