|
package db |
|
|
|
import ( |
|
"testing" |
|
|
|
"github.com/GoAdminGroup/go-admin/modules/config" |
|
_ "github.com/GoAdminGroup/go-admin/modules/db/drivers/mssql" |
|
) |
|
|
|
var driverTestMssqlConn Connection |
|
|
|
func InitMssql() { |
|
driverTestMssqlConn = testConn(DriverMssql, config.Database{ |
|
Host: "127.0.0.1", |
|
Port: "1433", |
|
User: "sa", |
|
Pwd: "Aa123456", |
|
Name: "goadmin", |
|
}) |
|
} |
|
|
|
func TestMssqlSQL_WhereIn(t *testing.T) { testSQLWhereIn(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_Count(t *testing.T) { testSQLCount(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_Select(t *testing.T) { testSQLSelect(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_OrderBy(t *testing.T) { testSQLOrderBy(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_GroupBy(t *testing.T) { testSQLGroupBy(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_Skip(t *testing.T) { testSQLSkip(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_Take(t *testing.T) { testSQLTake(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_Where(t *testing.T) { testSQLWhere(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_WhereNotIn(t *testing.T) { testSQLWhereNotIn(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_Find(t *testing.T) { testSQLFind(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_Sum(t *testing.T) { testSQLSum(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_Max(t *testing.T) { testSQLMax(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_Min(t *testing.T) { testSQLMin(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_Avg(t *testing.T) { testSQLAvg(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_WhereRaw(t *testing.T) { testSQLWhereRaw(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_UpdateRaw(t *testing.T) { testSQLUpdateRaw(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_LeftJoin(t *testing.T) { testSQLLeftJoin(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_WithTransaction(t *testing.T) { testSQLWithTransaction(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_WithTransactionByLevel(t *testing.T) { |
|
testSQLWithTransactionByLevel(t, driverTestMssqlConn) |
|
} |
|
func TestMssqlSQL_First(t *testing.T) { testSQLFirst(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_All(t *testing.T) { testSQLAll(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_ShowColumns(t *testing.T) { testSQLShowColumns(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_ShowTables(t *testing.T) { testSQLShowTables(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_Update(t *testing.T) { testSQLUpdate(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_Delete(t *testing.T) { testSQLDelete(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_Exec(t *testing.T) { testSQLExec(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_Insert(t *testing.T) { testSQLInsert(t, driverTestMssqlConn) } |
|
func TestMssqlSQL_Wrap(t *testing.T) { testSQLWrap(t, driverTestMssqlConn) } |
|
|