github.com/RevenueMonster/sqlike@v1.0.6/sql/dialect/mysql/database.go (about)

     1  package mysql
     2  
     3  import (
     4  	sqlstmt "github.com/RevenueMonster/sqlike/sql/stmt"
     5  )
     6  
     7  // UseDatabase :
     8  func (ms MySQL) UseDatabase(stmt sqlstmt.Stmt, db string) {
     9  	stmt.WriteString("USE " + ms.Quote(db) + ";")
    10  }
    11  
    12  // CreateDatabase :
    13  func (ms MySQL) CreateDatabase(stmt sqlstmt.Stmt, db string, checkExists bool) {
    14  	stmt.WriteString("CREATE DATABASE")
    15  	if checkExists {
    16  		stmt.WriteString(" IF NOT EXISTS")
    17  	}
    18  	stmt.WriteByte(' ')
    19  	stmt.WriteString(ms.Quote(db) + ";")
    20  }
    21  
    22  // DropDatabase :
    23  func (ms MySQL) DropDatabase(stmt sqlstmt.Stmt, db string, checkExists bool) {
    24  	stmt.WriteString("DROP SCHEMA")
    25  	if checkExists {
    26  		stmt.WriteString(" IF EXISTS")
    27  	}
    28  	stmt.WriteByte(' ')
    29  	stmt.WriteString(ms.Quote(db) + ";")
    30  }
    31  
    32  // GetDatabases :
    33  func (ms MySQL) GetDatabases(stmt sqlstmt.Stmt) {
    34  	stmt.WriteString("SHOW DATABASES;")
    35  }