testsql alternatives and similar packages
Based on the "Testing Frameworks" category.
Alternatively, view testsql alternatives based on common mentions on social networks and blogs.
-
-
-
-
dockertest
Write better integration tests! Dockertest helps you boot up ephermal docker images for your Go tests with minimal work. -
-
-
-
-
-
-
gnomock
Test your code without writing mocks with ephemeral Docker containers 📦 Setup popular services with just a couple lines of code ⏱️ No bash, no yaml, only code 💻 -
-
-
-
-
-
embedded-postgres
Run a real Postgres database locally on Linux, OSX or Windows as part of another Go application or test -
-
-
-
gotest.tools
A collection of packages to augment the go testing package and support common patterns. -
-
go-testdeep
Extremely flexible golang deep comparison, extends the go testing package, tests HTTP APIs and provides tests suite -
testza
Full-featured test framework for Go! Assertions, fuzzing, input testing, output capturing, and much more! 🍕 -
-
-
-
-
-
-
-
jsonassert
A Go test assertion library for verifying that two representations of JSON are semantically equal -
GoSpec
Testing framework for Go. Allows writing self-documenting tests/specifications, and executes them concurrently and safely isolated. [UNMAINTAINED] -
-
-
-
assert
:exclamation:Basic Assertion Library used along side native go testing, with building blocks for custom assertions -
-
-
-
-
-
fluentassert
DISCONTINUED. Extensible, type-safe, fluent assertion Go library. Do NOT use it (sic!). -
-
CodeRabbit: AI Code Reviews for Developers
Do you think we are missing an alternative of testsql or a related project?
README
TestSQL
[TestSQL](./docs/img/testsql.png)
Generate test data from SQL files before testing and clear it after finished.
Contents
Installation
go get github.com/zhulongcheng/testsql
Usage
Create a folder for the table-schema file and sql files:
testsql
├── fixtures
│ └── users.sql
└── schema.sql
The table-schema file include all tables schema, it would be like this:
CREATE TABLE `users` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(32) CHARACTER SET utf8mb4 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
The sql file would be like this:
INSERT INTO `users` (`id`, `name`)
VALUES
(1, 'foo');
Your tests would be like this:
var TS *testsql.TestSQL
func newTS() *testsql.TestSQL {
dsn := "user:password@tcp(host:port)/test_db_name"
tableSchemaPath := "testsql/schema.sql"
dirPath := "testsql/fixtures"
ts := testsql.New(dsn, tableSchemaPath, dirPath)
return ts
}
func initTestDB() {
TS = newTS()
// set sql-driver/orm to read/write data from TS's DSN
// Driver = sql.Open(TS.Config.DSN)
// ORM = ORM.New(TS.Config.DSN)
}
func TestMain(m *testing.M) {
initTestDB()
r := m.Run()
TS.DropTestDB()
os.Exit(r)
}
func TestUser(t *testing.T) {
TS.Use("users.sql")
defer TS.Clear()
// user := GetUserByID(1)
// if user.name != "foo" {
// t.Errorf("not equal, expected: %s, actual: %s", "foo", user.name)
// }
}
API Reference
TestSQL.Exec generates test data from sql string.
TestSQL.Use generates test data from sql files.
TestSQL.Clear deletes data of all tables
TestSQL.DropTestDB drops the database created by TestSQL.
FQA
Set sql-driver/orm to read/write data from TestSQL's DSN
db := yourSQLDriver.Open(TS.Config.DSN)
// or db := yourORM.Open(TS.Config.DSN)
yourModel.SetDB(db) // reset db