github.com/unionj-cloud/go-doudou/v2@v2.3.5/toolkit/dbvendor/mysql/template.go (about)

     1  package mysql
     2  
     3  var (
     4  	createTable = `CREATE TABLE ` + "`" + `{{.Name}}` + "`" + ` (
     5  {{- range $co := .Columns }}
     6  ` + "`" + `{{$co.Name}}` + "`" + ` {{$co.Type}} {{if $co.Nullable}}NULL{{else}}NOT NULL{{end}}{{if $co.Autoincrement}} AUTO_INCREMENT{{end}}{{if $co.Default}} DEFAULT {{$co.Default}}{{end}}{{if $co.Extra}} {{$co.Extra}}{{end}},
     7  {{- end }}
     8  PRIMARY KEY (` + "`" + `{{.Pk}}` + "`" + `))`
     9  
    10  	dropTable = `DROP TABLE ` + "`" + `{{.Name}}` + "`;"
    11  
    12  	alterTable = `{{define "change"}}
    13  ALTER TABLE ` + "`" + `{{.Table}}` + "`" + `
    14  CHANGE COLUMN ` + "`" + `{{if .OldName}}{{.OldName}}{{else}}{{.Name}}{{end}}` + "`" + ` ` + "`" + `{{.Name}}` + "`" + ` {{.Type}} {{if .Nullable}}NULL{{else}}NOT NULL{{end}}{{if .Autoincrement}} AUTO_INCREMENT{{end}}{{if .Default}} DEFAULT {{.Default}}{{end}}{{if .Extra}} {{.Extra}}{{end}};
    15  {{end}}
    16  
    17  {{define "add"}}
    18  ALTER TABLE ` + "`" + `{{.Table}}` + "`" + `
    19  ADD COLUMN ` + "`" + `{{.Name}}` + "`" + ` {{.Type}} {{if .Nullable}}NULL{{else}}NOT NULL{{end}}{{if .Autoincrement}} AUTO_INCREMENT{{end}}{{if .Default}} DEFAULT {{.Default}}{{end}}{{if .Extra}} {{.Extra}}{{end}};
    20  {{end}}
    21  
    22  {{define "drop"}}
    23  ALTER TABLE ` + "`" + `{{.Table}}` + "`" + `
    24  DROP COLUMN ` + "`" + `{{.Name}}` + "`" + `;
    25  {{end}}
    26  `
    27  
    28  	insertInto = `INSERT INTO ` + "`" + `{{.Schema}}` + "`" + `.` + "`" + `{{.TableName}}` + "`" + `
    29  ({{- range $i, $co := .InsertColumns}}
    30  {{- if $i}},{{end}}
    31  ` + "`" + `{{$co.Name}}` + "`" + `
    32  {{- end }})
    33  VALUES ({{- range $i, $co := .InsertColumns}}
    34  	   {{- if $i}},{{end}}
    35  	   ?
    36  	   {{- end }});
    37  `
    38  
    39  	updateTable = `UPDATE ` + "`" + `{{.Schema}}` + "`" + `.` + "`" + `{{.TableName}}` + "`" + `
    40  SET
    41  	{{- range $i, $co := .UpdateColumns}}
    42  	{{- if $i}},{{end}}
    43  	` + "`" + `{{$co.Name}}` + "`" + `=?
    44  	{{- end }}
    45  WHERE
    46      ` + "`" + `{{.Pk.Name}}` + "`" + ` =?;
    47  `
    48  
    49  	deleteFrom = `DELETE FROM ` + "`" + `{{.Schema}}` + "`" + `.` + "`" + `{{.TableName}}` + "`" + `
    50  WHERE
    51      ` + "`" + `{{.Pk.Name}}` + "`" + ` =?;
    52  `
    53  
    54  	selectFromById = `SELECT * FROM ` + "`" + `{{.Schema}}` + "`" + `.` + "`" + `{{.TableName}}` + "`" + `
    55  WHERE
    56      ` + "`" + `{{.Pk.Name}}` + "`" + ` =?;
    57  `
    58  )