github.com/1aal/kubeblocks@v0.0.0-20231107070852-e1c03e598921/pkg/lorry/engines/mysql/query.go (about)

     1  /*
     2  Copyright (C) 2022-2023 ApeCloud Co., Ltd
     3  
     4  This file is part of KubeBlocks project
     5  
     6  This program is free software: you can redistribute it and/or modify
     7  it under the terms of the GNU Affero General Public License as published by
     8  the Free Software Foundation, either version 3 of the License, or
     9  (at your option) any later version.
    10  
    11  This program is distributed in the hope that it will be useful
    12  but WITHOUT ANY WARRANTY; without even the implied warranty of
    13  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    14  GNU Affero General Public License for more details.
    15  
    16  You should have received a copy of the GNU Affero General Public License
    17  along with this program.  If not, see <http://www.gnu.org/licenses/>.
    18  */
    19  
    20  package mysql
    21  
    22  import (
    23  	"context"
    24  	"fmt"
    25  
    26  	"github.com/pkg/errors"
    27  )
    28  
    29  func (mgr *Manager) Query(ctx context.Context, sql string) ([]byte, error) {
    30  	mgr.Logger.Info(fmt.Sprintf("query: %s", sql))
    31  	rows, err := mgr.DB.QueryContext(ctx, sql)
    32  	if err != nil {
    33  		return nil, errors.Wrapf(err, "error executing %s", sql)
    34  	}
    35  	defer func() {
    36  		_ = rows.Close()
    37  		_ = rows.Err()
    38  	}()
    39  	result, err := jsonify(rows)
    40  	if err != nil {
    41  		return nil, errors.Wrapf(err, "error marshalling query result for %s", sql)
    42  	}
    43  	return result, nil
    44  }
    45  
    46  func (mgr *Manager) Exec(ctx context.Context, sql string) (int64, error) {
    47  	mgr.Logger.Info(fmt.Sprintf("exec: %s", sql))
    48  	res, err := mgr.DB.ExecContext(ctx, sql)
    49  	if err != nil {
    50  		return 0, errors.Wrapf(err, "error executing %s", sql)
    51  	}
    52  	return res.RowsAffected()
    53  }