github.com/lmorg/murex@v0.0.0-20240217211045-e081c89cd4ef/builtins/optional/select/select_test.go (about)

     1  package sqlselect_test
     2  
     3  import (
     4  	"fmt"
     5  	"testing"
     6  
     7  	_ "github.com/lmorg/murex/builtins"
     8  	"github.com/lmorg/murex/test"
     9  )
    10  
    11  var table = `
    12  ["FID","Parent","Scope","State","RunMode","BG","OutPipe","ErrPipe","Command","Parameters"]
    13  [2723,0,0,"Executing","Default",false,"out","err","exec","dog"]
    14  [2724,0,0,"Executing","Default",false,"out","err","exec","cat"]
    15  [2724,0,0,"Executing","Default",true,"out","err","foo",""]
    16  [2724,0,0,"Executing","Default",false,"out","err","bar",""]
    17  `
    18  
    19  func TestSelectStdin(t *testing.T) {
    20  	tests := []test.MurexTest{
    21  		{
    22  			Block: fmt.Sprintf(
    23  				"tout jsonl (%s) -> select * WHERE command = `exec` ORDER BY `Command` DESC",
    24  				table),
    25  			Stdout: string(
    26  				`["FID","Parent","Scope","State","RunMode","BG","OutPipe","ErrPipe","Command","Parameters"]
    27  ["2723","0","0","Executing","Default","false","out","err","exec","dog"]
    28  ["2724","0","0","Executing","Default","false","out","err","exec","cat"]
    29  `,
    30  			),
    31  		},
    32  	}
    33  
    34  	test.RunMurexTests(tests, t)
    35  }