Function TestSQLExport

backend/tests/sql_export_test.go:21–272

(t *testing.T)

)

func TestSQLExport(t *testing.T) {
	tests := []struct {
		databaseName     string
		dbType           storepb.Engine
		prepareStatement string
		exportTests      []struct {
			format    v1pb.ExportFormat
			statement string
			password  string
			results   []struct {
				statement string
				content   string
			}
		}
	}{
		{
			databaseName: "Test1",
			dbType:       storepb.Engine_MYSQL,
			prepareStatement: `
			CREATE TABLE tbl(id INT PRIMARY KEY, name VARCHAR(64), gender BIT(1), height BIT(8));
			INSERT INTO Test1.tbl (id, name, gender, height) VALUES(1, 'Alice', B'0', B'01111111');
			`,
			exportTests: []struct {
				format    v1pb.ExportFormat
				statement string
				password  string
				results   []struct {
					statement string
					content   string
				}
			}{
				{
					format:    v1pb.ExportFormat_JSON,
					password:  "123",
					statement: "SELECT * FROM Test1.tbl;",
					results: []struct {
						statement string
						content   string
					}{
						{
							statement: "SELECT * FROM Test1.tbl;",
							content: `[
  {
    "gender": "AA==",
    "height": "fw==",
    "id": 1,
    "name": "Alice"
  }
]`,
						},
					},
				},
				{
					format:    v1pb.ExportFormat_CSV,
					statement: "SELECT * FROM Test1.tbl;",
					results: []struct {
						statement string
						content   string