github.com/kotovmak/go-admin@v1.1.1/modules/db/statement_mssql_test.go (about)

     1  package db
     2  
     3  import (
     4  	"testing"
     5  
     6  	"github.com/kotovmak/go-admin/modules/config"
     7  	_ "github.com/kotovmak/go-admin/modules/db/drivers/mssql"
     8  )
     9  
    10  var driverTestMssqlConn Connection
    11  
    12  func InitMssql() {
    13  	driverTestMssqlConn = testConn(DriverMssql, config.Database{
    14  		Host: "127.0.0.1",
    15  		Port: "1433",
    16  		User: "sa",
    17  		Pwd:  "Aa123456",
    18  		Name: "goadmin",
    19  	})
    20  }
    21  
    22  func TestMssqlSQL_WhereIn(t *testing.T)         { testSQLWhereIn(t, driverTestMssqlConn) }
    23  func TestMssqlSQL_Count(t *testing.T)           { testSQLCount(t, driverTestMssqlConn) }
    24  func TestMssqlSQL_Select(t *testing.T)          { testSQLSelect(t, driverTestMssqlConn) }
    25  func TestMssqlSQL_OrderBy(t *testing.T)         { testSQLOrderBy(t, driverTestMssqlConn) }
    26  func TestMssqlSQL_GroupBy(t *testing.T)         { testSQLGroupBy(t, driverTestMssqlConn) }
    27  func TestMssqlSQL_Skip(t *testing.T)            { testSQLSkip(t, driverTestMssqlConn) }
    28  func TestMssqlSQL_Take(t *testing.T)            { testSQLTake(t, driverTestMssqlConn) }
    29  func TestMssqlSQL_Where(t *testing.T)           { testSQLWhere(t, driverTestMssqlConn) }
    30  func TestMssqlSQL_WhereNotIn(t *testing.T)      { testSQLWhereNotIn(t, driverTestMssqlConn) }
    31  func TestMssqlSQL_Find(t *testing.T)            { testSQLFind(t, driverTestMssqlConn) }
    32  func TestMssqlSQL_Sum(t *testing.T)             { testSQLSum(t, driverTestMssqlConn) }
    33  func TestMssqlSQL_Max(t *testing.T)             { testSQLMax(t, driverTestMssqlConn) }
    34  func TestMssqlSQL_Min(t *testing.T)             { testSQLMin(t, driverTestMssqlConn) }
    35  func TestMssqlSQL_Avg(t *testing.T)             { testSQLAvg(t, driverTestMssqlConn) }
    36  func TestMssqlSQL_WhereRaw(t *testing.T)        { testSQLWhereRaw(t, driverTestMssqlConn) }
    37  func TestMssqlSQL_UpdateRaw(t *testing.T)       { testSQLUpdateRaw(t, driverTestMssqlConn) }
    38  func TestMssqlSQL_LeftJoin(t *testing.T)        { testSQLLeftJoin(t, driverTestMssqlConn) }
    39  func TestMssqlSQL_WithTransaction(t *testing.T) { testSQLWithTransaction(t, driverTestMssqlConn) }
    40  func TestMssqlSQL_WithTransactionByLevel(t *testing.T) {
    41  	testSQLWithTransactionByLevel(t, driverTestMssqlConn)
    42  }
    43  func TestMssqlSQL_First(t *testing.T)       { testSQLFirst(t, driverTestMssqlConn) }
    44  func TestMssqlSQL_All(t *testing.T)         { testSQLAll(t, driverTestMssqlConn) }
    45  func TestMssqlSQL_ShowColumns(t *testing.T) { testSQLShowColumns(t, driverTestMssqlConn) }
    46  func TestMssqlSQL_ShowTables(t *testing.T)  { testSQLShowTables(t, driverTestMssqlConn) }
    47  func TestMssqlSQL_Update(t *testing.T)      { testSQLUpdate(t, driverTestMssqlConn) }
    48  func TestMssqlSQL_Delete(t *testing.T)      { testSQLDelete(t, driverTestMssqlConn) }
    49  func TestMssqlSQL_Exec(t *testing.T)        { testSQLExec(t, driverTestMssqlConn) }
    50  func TestMssqlSQL_Insert(t *testing.T)      { testSQLInsert(t, driverTestMssqlConn) }
    51  func TestMssqlSQL_Wrap(t *testing.T)        { testSQLWrap(t, driverTestMssqlConn) }