File:  [parser3project] / parser3 / tests / results / 388-sql.processed
Revision 1.3: download - view: text, annotated - select for diffs - revision graph
Fri Dec 8 00:55:21 2017 UTC (8 years, 8 months ago) by moko
Branches: MAIN
CVS tags: HEAD
more code coverage tests

Content-Type: text/html
Content-Length: 2923

1. 2 + 2 = 4
2. void
2.1 2.2 2.3 Type: parser.runtime,
Source: sqlite://****,
Comment: must return nothing
2.4 Type: parser.runtime,
Source: sql,
Comment: called with invalid option
2.5 Type: sql.execute,
Source: query,
Comment: bind variables not supported yet
3. int/double
3.1 2 int
3.2 Type: parser.runtime,
Source: sql,
Comment: produced no result, but no default option specified
3.3 1
3.4 -2 double
3.5 Type: parser.runtime,
Source: sql,
Comment: produced no result, but no default option specified
3.6 1
4. hash
4.1 {
	"cat":{
		"food":"milk",
		"aggressive":"'very'",
		"weigth":"5"
	},
	"dog":{
		"food":"bone",
		"aggressive":"\"never\"",
		"weigth":"10"
	},
	"parrot":{
		"food":"grain",
		"aggressive":"alwayws",
		"weigth":"1"
	}
}
4.2 {
	"cat":[
		{"pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
	],
	"dog":[
		{"pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
	],
	"parrot":[
		{"pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
	]
}
4.3 {
	"cat":"milk",
	"dog":"bone",
	"parrot":"grain"
}
4.4 Type: parser.runtime,
Source: sqlite://****,
Comment: only 2 columns allowed for $.type[string].
4.5. {
	"dog":[
		{"pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
	]
}
5. table
5.1 [
	{"pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
	{"pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
	{"pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
]
5.2. [
	{"pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
]
5.3 Type: sql.execute,
Source: select * from pets,
Comment: bind variables not supported yet
5.4 Type: parser.runtime,
Source: sql,
Comment: called with invalid option
6. file
6.1 {
	"class":"file",
	"name":"test.txt",
	"size":6,
	"mode":"binary",
	"content-type":"text\/plain",
	"text":"'very'"
}
6.2 {
	"class":"file",
	"name":"unknown",
	"size":7,
	"mode":"binary",
	"content-type":"unknown",
	"text":"\"never\""
}
6.3 Type: parser.runtime,
Source: sqlite://****,
Comment: result must contain not more then 3 columns
6.4 Type: parser.runtime,
Source: sql,
Comment: produced no result
6.5 {
	"class":"file",
	"name":"1",
	"size":1,
	"mode":"binary",
	"content-type":"1",
	"text":"1"
} - bug!
6.6 Type: parser.runtime,
Source: sqlite://****,
Comment: result must not contain more then one row, three columns
6.7 Type: parser.runtime,
Source: sql,
Comment: called with invalid option
6.8 "''test''"
7. string
7.1 Type: parser.runtime,
Source: sqlite://****,
Comment: result must contain exactly one column
7.2 Type: parser.runtime,
Source: sqlite://****,
Comment: result must not contain more then one row
7.3 Type: sql.execute,
Source: select 2+2,
Comment: bind variables not supported yet
7.4 Type: parser.runtime,
Source: sql,
Comment: called with invalid option
7.5 Type: parser.runtime,
Source: sql,
Comment: produced no result, but no default option specified
7.6 "default"

E-mail: