Ticket #20: queries.sh

File queries.sh, 10.4 KB (added by Andrei Aiordachioaie, 15 years ago)

Executes lots of rasql queries

Line 
1rasql -q "select png(c[0:450,0:300]) from rgb AS c"
2rasql -q "select png(c[0:450,0:300]) from rgb AS c"
3rasql -q "select png(c[0:450,0:300]) from rgb AS c"
4rasql -q "select png((char)(abs((((c).1)-((c).0))))[0:450,0:300]) from rgb AS c"
5rasql -q "select png((char)(abs((((c).1)-((c).0))))[0:450,0:300]) from rgb AS c"
6rasql -q "select png((char)(abs((((c).1)-((c).0))))[0:450,0:300]) from rgb AS c"
7rasql -q "select count_cells((((c).1)=(0))) from rgb AS c"
8rasql -q "select count_cells((((c).1)=(0))) from rgb AS c"
9rasql -q "select count_cells((((c).1)=(0))) from rgb AS c"
10rasql -q "select png((char)((((((((((c).0)/((float)((((c).0)+((c).1))))))-((((c).1)/((float)((((c).0)+((c).1))))))))>(0.6)))*(255)))) from rgb AS c"
11rasql -q "select png((char)((((((((((c).0)/((float)((((c).0)+((c).1))))))-((((c).1)/((float)((((c).0)+((c).1))))))))>(0.6)))*(255)))) from rgb AS c"
12rasql -q "select png((char)((((((((((c).0)/((float)((((c).0)+((c).1))))))-((((c).1)/((float)((((c).0)+((c).1))))))))>(0.6)))*(255)))) from rgb AS c"
13rasql -q "select jpeg(c) from rgb AS c"
14rasql -q "select jpeg(c) from rgb AS c"
15rasql -q "select jpeg(c) from rgb AS c"
16rasql -q "select jpeg((char)(((255)-((c).red)))[50:150,50:150]) from rgb AS c"
17rasql -q "select jpeg((char)(((255)-((c).red)))[50:150,50:150]) from rgb AS c"
18rasql -q "select jpeg((char)(((255)-((c).red)))[50:150,50:150]) from rgb AS c"
19rasql -q "select jpeg(log((s).2)) from rgb AS s"
20rasql -q "select jpeg(log((s).2)) from rgb AS s"
21rasql -q "select jpeg(log((s).2)) from rgb AS s"
22rasql -q "select jpeg((((s).0)-((s).1))) from rgb AS s"
23rasql -q "select jpeg((((s).0)-((s).1))) from rgb AS s"
24rasql -q "select jpeg((((s).0)-((s).1))) from rgb AS s"
25rasql -q "select jpeg((char)((((((s).0)-((s).1)))/((((s).0)+((s).1)))))) from rgb AS s"
26rasql -q "select jpeg((char)((((((s).0)-((s).1)))/((((s).0)+((s).1)))))) from rgb AS s"
27rasql -q "select jpeg((char)((((((s).0)-((s).1)))/((((s).0)+((s).1)))))) from rgb AS s"
28rasql -q "select jpeg((((((((s).0)-((s).1)))/((((s).0)+((s).1)))))>(0.1))) from rgb AS s"
29rasql -q "select jpeg((((((((s).0)-((s).1)))/((((s).0)+((s).1)))))>(0.1))) from rgb AS s"
30rasql -q "select jpeg((((((((s).0)-((s).1)))/((((s).0)+((s).1)))))>(0.1))) from rgb AS s"
31rasql -q "select jpeg(s) from rgb AS s"
32rasql -q "select jpeg(s) from rgb AS s"
33rasql -q "select jpeg(s) from rgb AS s"
34rasql -q "select count_cells((((((((s).0)+((s).1)))/((((s).0)-((s).1)))))>=(0))) from rgb AS s"
35rasql -q "select count_cells((((((((s).0)+((s).1)))/((((s).0)-((s).1)))))>=(0))) from rgb AS s"
36rasql -q "select count_cells((((((((s).0)+((s).1)))/((((s).0)-((s).1)))))>=(0))) from rgb AS s"
37rasql -q "select jpeg((char)(marray ii in [51:150, 0:99] values ii[0])) from rgb AS c"
38rasql -q "select jpeg((char)(marray ii in [51:150, 0:99] values ii[0])) from rgb AS c"
39rasql -q "select jpeg((char)(marray ii in [51:150, 0:99] values ii[0])) from rgb AS c"
40rasql -q "select csv(marray ii in [0:255] values count_cells(((c)=(ii[0])))) from mr AS c"
41rasql -q "select csv(marray ii in [0:255] values count_cells(((c)=(ii[0])))) from mr AS c"
42rasql -q "select csv(marray ii in [0:255] values count_cells(((c)=(ii[0])))) from mr AS c"
43rasql -q "select jpeg(sin((c).1)) from rgb AS c"
44rasql -q "select jpeg(sin((c).1)) from rgb AS c"
45rasql -q "select jpeg(sin((c).1)) from rgb AS c"
46rasql -q "select jpeg(exp((((c).1)/(100)))) from rgb AS c"
47rasql -q "select jpeg(exp((((c).1)/(100)))) from rgb AS c"
48rasql -q "select jpeg(exp((((c).1)/(100)))) from rgb AS c"
49rasql -q "select max_cells((double)((c).2)) from rgb AS c"
50rasql -q "select max_cells((double)((c).2)) from rgb AS c"
51rasql -q "select max_cells((double)((c).2)) from rgb AS c"
52rasql -q "select jpeg(((r)*((((((((r).green)>(130)))and((((r).red)<(110)))))and((((r).blue)<(140))))))) from rgb AS r"
53rasql -q "select jpeg(((r)*((((((((r).green)>(130)))and((((r).red)<(110)))))and((((r).blue)<(140))))))) from rgb AS r"
54rasql -q "select jpeg(((r)*((((((((r).green)>(130)))and((((r).red)<(110)))))and((((r).blue)<(140))))))) from rgb AS r"
55rasql -q "select condense + over ii in [1:10] using ((ii[0])*(((a) [ii[0],10]).red)) from rgb AS a"
56rasql -q "select condense + over ii in [1:10] using ((ii[0])*(((a) [ii[0],10]).red)) from rgb AS a"
57rasql -q "select condense + over ii in [1:10] using ((ii[0])*(((a) [ii[0],10]).red)) from rgb AS a"
58rasql -q "select condense + over ii in [1:10, 25:75] using ((ii[0])*(((a) [ii[0],ii[1]]).red)) from rgb AS a"
59rasql -q "select condense + over ii in [1:10, 25:75] using ((ii[0])*(((a) [ii[0],ii[1]]).red)) from rgb AS a"
60rasql -q "select condense + over ii in [1:10, 25:75] using ((ii[0])*(((a) [ii[0],ii[1]]).red)) from rgb AS a"
61rasql -q "select csv(< [0:1] 0, 1>) from rgb AS c"
62rasql -q "select csv(< [0:1] 0, 1>) from rgb AS c"
63rasql -q "select csv(< [0:1] 0, 1>) from rgb AS c"
64rasql -q "select csv(marray ii in [0:20] values condense + over ij in [0:20, 0:20] using 1) from mr AS c"
65rasql -q "select csv(marray ii in [0:20] values condense + over ij in [0:20, 0:20] using 1) from mr AS c"
66rasql -q "select csv(marray ii in [0:20] values condense + over ij in [0:20, 0:20] using 1) from mr AS c"
67rasql -q "select csv(marray ii in [-20:20] values condense + over ij in [10:20, 10:20] using (((((c) [ij[0],ij[1]])>((ii[0])-(1))))and((((c) [ij[0],ij[1]])<=(ii[0]))))) from mr AS c"
68rasql -q "select csv(marray ii in [-20:20] values condense + over ij in [10:20, 10:20] using (((((c) [ij[0],ij[1]])>((ii[0])-(1))))and((((c) [ij[0],ij[1]])<=(ii[0]))))) from mr AS c"
69rasql -q "select csv(marray ii in [-20:20] values condense + over ij in [10:20, 10:20] using (((((c) [ij[0],ij[1]])>((ii[0])-(1))))and((((c) [ij[0],ij[1]])<=(ii[0]))))) from mr AS c"
70rasql -q "select jpeg((char)(marray ii in [10:240, 10:230] values condense + over ij in [-1:1, -1:1] using (((< [-1:1, -1:1] 1, 1, 1, 0, 0, 0, -1, -1, -1>) [ij[0],ij[1]])*(((c) [(ii[0])+(ij[0]),(ii[1])+(ij[1])]).red)))) from rgb AS c"
71rasql -q "select jpeg((char)(marray ii in [10:240, 10:230] values condense + over ij in [-1:1, -1:1] using (((< [-1:1, -1:1] 1, 1, 1, 0, 0, 0, -1, -1, -1>) [ij[0],ij[1]])*(((c) [(ii[0])+(ij[0]),(ii[1])+(ij[1])]).red)))) from rgb AS c"
72rasql -q "select jpeg((char)(marray ii in [10:240, 10:230] values condense + over ij in [-1:1, -1:1] using (((< [-1:1, -1:1] 1, 1, 1, 0, 0, 0, -1, -1, -1>) [ij[0],ij[1]])*(((c) [(ii[0])+(ij[0]),(ii[1])+(ij[1])]).red)))) from rgb AS c"
73rasql -q "select jpeg(marray ii in [65:70, 65:70] values condense + over ij in [65:70, 65:70] using (((c) [ij[0],ij[1]])*(cos((((-2)*((22.0)/(7.0)))*((((double)(((ij[0])*(ii[0]))/(((70)-(65))+(1))))+((double)(((ij[1])*(ii[1]))/(((70)-(65))+(1))))))))))) from rgb AS c"
74rasql -q "select jpeg(marray ii in [65:70, 65:70] values condense + over ij in [65:70, 65:70] using (((c) [ij[0],ij[1]])*(cos((((-2)*((22.0)/(7.0)))*((((double)(((ij[0])*(ii[0]))/(((70)-(65))+(1))))+((double)(((ij[1])*(ii[1]))/(((70)-(65))+(1))))))))))) from rgb AS c"
75rasql -q "select jpeg(marray ii in [65:70, 65:70] values condense + over ij in [65:70, 65:70] using (((c) [ij[0],ij[1]])*(cos((((-2)*((22.0)/(7.0)))*((((double)(((ij[0])*(ii[0]))/(((70)-(65))+(1))))+((double)(((ij[1])*(ii[1]))/(((70)-(65))+(1))))))))))) from rgb AS c"
76rasql -q "select jpeg((char)(marray ii in [0:10, 0:10] values condense + over ij in [0:10, 0:10] using cos(0.6))) from mr AS c"
77rasql -q "select jpeg((char)(marray ii in [0:10, 0:10] values condense + over ij in [0:10, 0:10] using cos(0.6))) from mr AS c"
78rasql -q "select jpeg((char)(marray ii in [0:10, 0:10] values condense + over ij in [0:10, 0:10] using cos(0.6))) from mr AS c"
79rasql -q "select jpeg((char)(marray ii in [0:10, 0:10] values condense + over ij in [0:10, 0:10] using 1)) from mr AS c"
80rasql -q "select jpeg((char)(marray ii in [0:10, 0:10] values condense + over ij in [0:10, 0:10] using 1)) from mr AS c"
81rasql -q "select jpeg((char)(marray ii in [0:10, 0:10] values condense + over ij in [0:10, 0:10] using 1)) from mr AS c"
82rasql -q "select png(c[0:450,0:300]) from rgb AS c"
83rasql -q "select png(c[0:450,0:300]) from rgb AS c"
84rasql -q "select png(c[0:450,0:300]) from rgb AS c"
85rasql -q "select png((char)(abs((((c).1)-((c).0))))[0:450,0:300]) from rgb AS c"
86rasql -q "select png((char)(abs((((c).1)-((c).0))))[0:450,0:300]) from rgb AS c"
87#rasql -q "select png((char)(abs((((c).1)-((c).0))))[0:450,0:300]) from rgb AS c"
88#rasql -q "select count_cells((((c).1)=(0))) from rgb AS c"
89#rasql -q "select count_cells((((c).1)=(0))) from rgb AS c"
90#rasql -q "select count_cells((((c).1)=(0))) from rgb AS c"
91#rasql -q "select png((char)((((((((((c).0)/((float)((((c).0)+((c).1))))))-((((c).1)/((float)((((c).0)+((c).1))))))))>(0.6)))*(255)))) from rgb AS c"
92#rasql -q "select png((char)((((((((((c).0)/((float)((((c).0)+((c).1))))))-((((c).1)/((float)((((c).0)+((c).1))))))))>(0.6)))*(255)))) from rgb AS c"
93#rasql -q "select png((char)((((((((((c).0)/((float)((((c).0)+((c).1))))))-((((c).1)/((float)((((c).0)+((c).1))))))))>(0.6)))*(255)))) from rgb AS c"
94#rasql -q "select jpeg(c) from rgb AS c"
95#rasql -q "select jpeg(c) from rgb AS c"
96#rasql -q "select jpeg(c) from rgb AS c"
97#rasql -q "select jpeg((char)(((255)-((c).red)))[50:150,50:150]) from rgb AS c"
98#rasql -q "select jpeg((char)(((255)-((c).red)))[50:150,50:150]) from rgb AS c"
99#rasql -q "select jpeg((char)(((255)-((c).red)))[50:150,50:150]) from rgb AS c"
100#rasql -q "select jpeg(log((s).2)) from rgb AS s"
101#rasql -q "select jpeg(log((s).2)) from rgb AS s"
102#rasql -q "select jpeg(log((s).2)) from rgb AS s"
103#rasql -q "select jpeg((((s).0)-((s).1))) from rgb AS s"
104#rasql -q "select jpeg((((s).0)-((s).1))) from rgb AS s"
105##rasql -q "select jpeg((((s).0)-((s).1))) from rgb AS s"
106#rasql -q "select jpeg((char)((((((s).0)-((s).1)))/((((s).0)+((s).1)))))) from rgb AS s"
107#rasql -q "select jpeg((char)((((((s).0)-((s).1)))/((((s).0)+((s).1)))))) from rgb AS s"
108#rasql -q "select jpeg((char)((((((s).0)-((s).1)))/((((s).0)+((s).1)))))) from rgb AS s"
109#rasql -q "select jpeg((((((((s).0)-((s).1)))/((((s).0)+((s).1)))))>(0.1))) from rgb AS s"
110#rasql -q "select jpeg((((((((s).0)-((s).1)))/((((s).0)+((s).1)))))>(0.1))) from rgb AS s"
111#rasql -q "select jpeg((((((((s).0)-((s).1)))/((((s).0)+((s).1)))))>(0.1))) from rgb AS s"
112#rasql -q "select jpeg(s) from rgb AS s"
113#rasql -q "select jpeg(s) from rgb AS s"
114#rasql -q "select jpeg(s) from rgb AS s"
115#rasql -q "select count_cells((((((((s).0)+((s).1)))/((((s).0)-((s).1)))))>=(0))) from rgb AS s"
116#rasql -q "select count_cells((((((((s).0)+((s).1)))/((((s).0)-((s).1)))))>=(0))) from rgb AS s"
117#rasql -q "select count_cells((((((((s).0)+((s).1)))/((((s).0)-((s).1)))))>=(0))) from rgb AS s"
118#rasql -q "select jpeg((char)(marray ii in [51:150, 0:99] values ii[0])) from rgb AS c"