github.com/kaydxh/golang@v0.0.131/pkg/binlog/datastore/dbstore/db.store.go (about)

     1  /*
     2   *Copyright (c) 2023, kaydxh
     3   *
     4   *Permission is hereby granted, free of charge, to any person obtaining a copy
     5   *of this software and associated documentation files (the "Software"), to deal
     6   *in the Software without restriction, including without limitation the rights
     7   *to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
     8   *copies of the Software, and to permit persons to whom the Software is
     9   *furnished to do so, subject to the following conditions:
    10   *
    11   *The above copyright notice and this permission notice shall be included in all
    12   *copies or substantial portions of the Software.
    13   *
    14   *THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
    15   *IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
    16   *FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
    17   *AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
    18   *LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
    19   *OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
    20   *SOFTWARE.
    21   */
    22  package dbstore
    23  
    24  import (
    25  	"context"
    26  	"fmt"
    27  
    28  	"github.com/jmoiron/sqlx"
    29  	ds_ "github.com/kaydxh/golang/pkg/binlog/datastore"
    30  	mysql_ "github.com/kaydxh/golang/pkg/database/mysql"
    31  )
    32  
    33  var _ ds_.DataStore = (*DBDataStore)(nil)
    34  
    35  type DBDataStore struct {
    36  	*sqlx.DB
    37  	insertSql string
    38  	updateSql string
    39  }
    40  
    41  func NewDBDataStore(db *sqlx.DB) (*DBDataStore, error) {
    42  	if db == nil {
    43  		return nil, fmt.Errorf("db is nil")
    44  	}
    45  
    46  	s := &DBDataStore{}
    47  	s.DB = db
    48  	return s, nil
    49  }
    50  
    51  func (s *DBDataStore) WriteData(ctx context.Context, arg interface{}, key ds_.MessageKey) (n int64, err error) {
    52  	columnsValues := mysql_.BuildNamedColumnsValuesBatch(arg)
    53  	sql := mysql_.BuildNamedInsertSql(key.Path, key.Fields, len(columnsValues))
    54  	n, err = mysql_.ExecContext(ctx, sql, mysql_.BuildNamedColumnsValuesBatch(arg), nil, s.DB)
    55  	return n, err
    56  }