func (g *gensql) generateQueryPrefix(message *generator.Descriptor, scanner *limbo.ScannerDescriptor) string {
var (
buf bytes.Buffer
model = limbo.GetModel(message)
)
buf.WriteString("SELECT")
for i, column := range scanner.Column {
if i > 0 {
buf.WriteByte(',')
}
buf.WriteByte(' ')
if column.JoinedWith == "" {
buf.WriteString(model.Table)
buf.WriteByte('.')
}
buf.WriteString(column.Name)
}
buf.WriteString(" FROM ")
buf.WriteString(model.Table)
for _, join := range scanner.Join {
buf.WriteString(" LEFT JOIN ")
buf.WriteString(join.Table)
buf.WriteString(" AS ")
buf.WriteString(join.Name)
buf.WriteString(" ON ")
buf.WriteString(join.Name)
buf.WriteByte('.')
buf.WriteString(join.ForeignKey)
buf.WriteString(" = ")
if join.JoinedWith != "" {
buf.WriteString(scanner.LookupJoin(join.JoinedWith).Name)
} else {
buf.WriteString(model.Table)
}
buf.WriteByte('.')
buf.WriteString(join.Key)
}
return buf.String()
}
