github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/engine/pkg/meta/util.go (about)

     1  // Copyright 2022 PingCAP, Inc.
     2  //
     3  // Licensed under the Apache License, Version 2.0 (the "License");
     4  // you may not use this file except in compliance with the License.
     5  // You may obtain a copy of the License at
     6  //
     7  //     http://www.apache.org/licenses/LICENSE-2.0
     8  //
     9  // Unless required by applicable law or agreed to in writing, software
    10  // distributed under the License is distributed on an "AS IS" BASIS,
    11  // See the License for the specific language governing permissions and
    12  // limitations under the License.
    13  
    14  package meta
    15  
    16  import (
    17  	"context"
    18  	"fmt"
    19  
    20  	"github.com/pingcap/tiflow/engine/pkg/dbutil"
    21  	"github.com/pingcap/tiflow/engine/pkg/meta/model"
    22  	"github.com/pingcap/tiflow/pkg/errors"
    23  )
    24  
    25  // CreateSchemaIfNotExists creates a db schema if not exists
    26  func CreateSchemaIfNotExists(ctx context.Context, storeConf model.StoreConfig) error {
    27  	schema := storeConf.Schema
    28  	// clear the schema to open a connection without any schema
    29  	storeConf.Schema = ""
    30  	dsn, err := model.GenerateDSNByParams(&storeConf, nil)
    31  	if err != nil {
    32  		return err
    33  	}
    34  	db, err := dbutil.NewSQLDB("mysql", dsn, nil /*DBConfig*/)
    35  	if err != nil {
    36  		return nil
    37  	}
    38  	defer db.Close()
    39  
    40  	query := fmt.Sprintf("CREATE DATABASE if not exists %s", schema)
    41  	_, err = db.ExecContext(ctx, query)
    42  	if err != nil {
    43  		return errors.ErrMetaOpFail.Wrap(err)
    44  	}
    45  
    46  	return nil
    47  }