From afaf82538d09cd77ee4f5a435b79995e88be84f5 Mon Sep 17 00:00:00 2001 From: Akshay Nair Date: Sun, 7 Jun 2026 17:46:08 +0530 Subject: Rename the files --- src/circle.image.sql | 17 +++++++++++++++++ src/circle.sql | 17 ----------------- src/gradient.image.sql | 11 +++++++++++ src/gradient.sql | 11 ----------- src/mandelbrot.image.sql | 30 ++++++++++++++++++++++++++++++ src/mandelbrot.sql | 30 ------------------------------ src/polka.image.sql | 24 ++++++++++++++++++++++++ src/polka.sql | 24 ------------------------ src/rave.sql | 32 -------------------------------- src/rave.video.sql | 32 ++++++++++++++++++++++++++++++++ src/voronoi.image.sql | 23 +++++++++++++++++++++++ src/voronoi.sql | 23 ----------------------- src/wavey.sql | 33 --------------------------------- src/wavey.video.sql | 33 +++++++++++++++++++++++++++++++++ 14 files changed, 170 insertions(+), 170 deletions(-) create mode 100644 src/circle.image.sql delete mode 100644 src/circle.sql create mode 100644 src/gradient.image.sql delete mode 100644 src/gradient.sql create mode 100644 src/mandelbrot.image.sql delete mode 100644 src/mandelbrot.sql create mode 100644 src/polka.image.sql delete mode 100644 src/polka.sql delete mode 100644 src/rave.sql create mode 100644 src/rave.video.sql create mode 100644 src/voronoi.image.sql delete mode 100644 src/voronoi.sql delete mode 100644 src/wavey.sql create mode 100644 src/wavey.video.sql (limited to 'src') diff --git a/src/circle.image.sql b/src/circle.image.sql new file mode 100644 index 0000000..c4ac18a --- /dev/null +++ b/src/circle.image.sql @@ -0,0 +1,17 @@ +INSERT OR REPLACE INTO images (id, width, height) VALUES ('circle', 400, 400) RETURNING id; + +WITH RECURSIVE + image AS (SELECT * FROM images WHERE id = 'circle'), + circle AS (SELECT width/2 AS cx, height/2 AS cy, 160 AS radius FROM image), + horizontal(x) AS + (SELECT width FROM image UNION ALL SELECT x - 1 FROM horizontal WHERE x > 1), + vertical(y) AS + (SELECT height FROM image UNION ALL SELECT y - 1 FROM vertical WHERE y > 1), + _pixels(x, y, r, g, b) AS (SELECT + x, y, + 150, + 255 * MAX(0, MIN(1, (SELECT (x - cx)*(x - cx) + (y - cy)*(y - cy) - radius*radius FROM circle))), + 150 + FROM vertical, horizontal + ) +INSERT INTO pixels (image_id, x, y, r, g, b) SELECT 'circle', x, y, r, g, b FROM _pixels; diff --git a/src/circle.sql b/src/circle.sql deleted file mode 100644 index c4ac18a..0000000 --- a/src/circle.sql +++ /dev/null @@ -1,17 +0,0 @@ -INSERT OR REPLACE INTO images (id, width, height) VALUES ('circle', 400, 400) RETURNING id; - -WITH RECURSIVE - image AS (SELECT * FROM images WHERE id = 'circle'), - circle AS (SELECT width/2 AS cx, height/2 AS cy, 160 AS radius FROM image), - horizontal(x) AS - (SELECT width FROM image UNION ALL SELECT x - 1 FROM horizontal WHERE x > 1), - vertical(y) AS - (SELECT height FROM image UNION ALL SELECT y - 1 FROM vertical WHERE y > 1), - _pixels(x, y, r, g, b) AS (SELECT - x, y, - 150, - 255 * MAX(0, MIN(1, (SELECT (x - cx)*(x - cx) + (y - cy)*(y - cy) - radius*radius FROM circle))), - 150 - FROM vertical, horizontal - ) -INSERT INTO pixels (image_id, x, y, r, g, b) SELECT 'circle', x, y, r, g, b FROM _pixels; diff --git a/src/gradient.image.sql b/src/gradient.image.sql new file mode 100644 index 0000000..4ad1820 --- /dev/null +++ b/src/gradient.image.sql @@ -0,0 +1,11 @@ +INSERT OR REPLACE INTO images (id, width, height) VALUES ('gradient', 400, 400) RETURNING id; + +WITH RECURSIVE + image AS (SELECT * FROM images WHERE id = 'gradient'), + horizontal(x) AS + (SELECT width FROM image UNION ALL SELECT x - 1 FROM horizontal WHERE x > 1), + vertical(y) AS + (SELECT height FROM image UNION ALL SELECT y - 1 FROM vertical WHERE y > 1), + _pixels(x, y, r, g, b) AS + (SELECT x, y, x*255/width, y*255/height, 100 FROM vertical, horizontal, image) +INSERT INTO pixels (image_id, x, y, r, g, b) SELECT 'gradient', x, y, r, g, b FROM _pixels; diff --git a/src/gradient.sql b/src/gradient.sql deleted file mode 100644 index 4ad1820..0000000 --- a/src/gradient.sql +++ /dev/null @@ -1,11 +0,0 @@ -INSERT OR REPLACE INTO images (id, width, height) VALUES ('gradient', 400, 400) RETURNING id; - -WITH RECURSIVE - image AS (SELECT * FROM images WHERE id = 'gradient'), - horizontal(x) AS - (SELECT width FROM image UNION ALL SELECT x - 1 FROM horizontal WHERE x > 1), - vertical(y) AS - (SELECT height FROM image UNION ALL SELECT y - 1 FROM vertical WHERE y > 1), - _pixels(x, y, r, g, b) AS - (SELECT x, y, x*255/width, y*255/height, 100 FROM vertical, horizontal, image) -INSERT INTO pixels (image_id, x, y, r, g, b) SELECT 'gradient', x, y, r, g, b FROM _pixels; diff --git a/src/mandelbrot.image.sql b/src/mandelbrot.image.sql new file mode 100644 index 0000000..b83b751 --- /dev/null +++ b/src/mandelbrot.image.sql @@ -0,0 +1,30 @@ +INSERT OR REPLACE INTO images (id, width, height) VALUES ('mandelbrot', 400, 400) RETURNING id; + +WITH RECURSIVE + image AS (SELECT *, 0.008 AS scale, (width * 5)/7 AS ox, (height / 2) AS oy FROM images WHERE id = 'mandelbrot'), + horizontal(x) AS + (SELECT width FROM image UNION ALL SELECT x - 1 FROM horizontal WHERE x > 1), + vertical(y) AS + (SELECT height FROM image UNION ALL SELECT y - 1 FROM vertical WHERE y > 1), + mando(i, px, py, cx, cy, x, y) AS ( + SELECT 0, 0.0, 0.0, + (SELECT (horizontal.x - ox)*scale FROM image), (SELECT (vertical.y - oy)*scale FROM image), + horizontal.x, vertical.y + FROM vertical, horizontal + UNION ALL + SELECT i + 1, px*px - py*py + cx, 2.0*px*py + cy, cx, cy, x, y FROM mando + WHERE (px*px + py*py) < 4.0 AND i < 20 + ), + mandogrouped(x, y, i) AS (SELECT x, y, max(i) FROM mando GROUP BY x, y), + colors(i, r, g, b) AS ( + SELECT 19, 255, 150, 150 UNION ALL + SELECT 10, 150, 120, 120 UNION ALL + SELECT 7, 50, 100, 100 UNION ALL + SELECT 0 , 0, 50, 50 + ), + _pixels(x, y, r, g, b) AS ( + SELECT x, y, c.r, c.g, c.b + FROM mandogrouped g + JOIN colors c ON c.i = (SELECT max(i) FROM colors WHERE i <= g.i) + ) +INSERT INTO pixels (image_id, x, y, r, g, b) SELECT 'mandelbrot', x, y, r, g, b FROM _pixels; diff --git a/src/mandelbrot.sql b/src/mandelbrot.sql deleted file mode 100644 index b83b751..0000000 --- a/src/mandelbrot.sql +++ /dev/null @@ -1,30 +0,0 @@ -INSERT OR REPLACE INTO images (id, width, height) VALUES ('mandelbrot', 400, 400) RETURNING id; - -WITH RECURSIVE - image AS (SELECT *, 0.008 AS scale, (width * 5)/7 AS ox, (height / 2) AS oy FROM images WHERE id = 'mandelbrot'), - horizontal(x) AS - (SELECT width FROM image UNION ALL SELECT x - 1 FROM horizontal WHERE x > 1), - vertical(y) AS - (SELECT height FROM image UNION ALL SELECT y - 1 FROM vertical WHERE y > 1), - mando(i, px, py, cx, cy, x, y) AS ( - SELECT 0, 0.0, 0.0, - (SELECT (horizontal.x - ox)*scale FROM image), (SELECT (vertical.y - oy)*scale FROM image), - horizontal.x, vertical.y - FROM vertical, horizontal - UNION ALL - SELECT i + 1, px*px - py*py + cx, 2.0*px*py + cy, cx, cy, x, y FROM mando - WHERE (px*px + py*py) < 4.0 AND i < 20 - ), - mandogrouped(x, y, i) AS (SELECT x, y, max(i) FROM mando GROUP BY x, y), - colors(i, r, g, b) AS ( - SELECT 19, 255, 150, 150 UNION ALL - SELECT 10, 150, 120, 120 UNION ALL - SELECT 7, 50, 100, 100 UNION ALL - SELECT 0 , 0, 50, 50 - ), - _pixels(x, y, r, g, b) AS ( - SELECT x, y, c.r, c.g, c.b - FROM mandogrouped g - JOIN colors c ON c.i = (SELECT max(i) FROM colors WHERE i <= g.i) - ) -INSERT INTO pixels (image_id, x, y, r, g, b) SELECT 'mandelbrot', x, y, r, g, b FROM _pixels; diff --git a/src/polka.image.sql b/src/polka.image.sql new file mode 100644 index 0000000..3d72540 --- /dev/null +++ b/src/polka.image.sql @@ -0,0 +1,24 @@ +INSERT OR REPLACE INTO images (id, width, height) VALUES ('polka', 400, 400) RETURNING id; + +WITH RECURSIVE + image AS (SELECT *, width/10 AS gapx, height/10 AS gapy, 16.0 AS size FROM images WHERE id = 'polka'), + horizontal(x) AS + (SELECT width FROM image UNION ALL SELECT x - 1 FROM horizontal WHERE x > 1), + vertical(y) AS + (SELECT height FROM image UNION ALL SELECT y - 1 FROM vertical WHERE y > 1), + dotsx(dotx, column) AS ( + SELECT 0, 0 UNION ALL + SELECT dotx + gapx, column + 1 FROM dotsx, image WHERE dotx < width + ), + dotsy(doty, row) AS ( + SELECT 0, 0 UNION ALL + SELECT doty + gapy, row + 1 FROM dotsy, image WHERE doty < height + ), + _pixels(x, y, r, g, b) AS ( + SELECT x, y, + IFNULL((SELECT 60 * abs((row % 5) - (column % 5)) FROM dotsx, dotsy + WHERE POW(x - dotx - gapx*(row%2)/2.0, 2) + POW(y - doty, 2) < size*size LIMIT 1), 0), + 50, 70 + FROM vertical, horizontal, image + ) +INSERT INTO pixels (image_id, x, y, r, g, b) SELECT 'polka', x, y, r, g, b FROM _pixels; diff --git a/src/polka.sql b/src/polka.sql deleted file mode 100644 index 3d72540..0000000 --- a/src/polka.sql +++ /dev/null @@ -1,24 +0,0 @@ -INSERT OR REPLACE INTO images (id, width, height) VALUES ('polka', 400, 400) RETURNING id; - -WITH RECURSIVE - image AS (SELECT *, width/10 AS gapx, height/10 AS gapy, 16.0 AS size FROM images WHERE id = 'polka'), - horizontal(x) AS - (SELECT width FROM image UNION ALL SELECT x - 1 FROM horizontal WHERE x > 1), - vertical(y) AS - (SELECT height FROM image UNION ALL SELECT y - 1 FROM vertical WHERE y > 1), - dotsx(dotx, column) AS ( - SELECT 0, 0 UNION ALL - SELECT dotx + gapx, column + 1 FROM dotsx, image WHERE dotx < width - ), - dotsy(doty, row) AS ( - SELECT 0, 0 UNION ALL - SELECT doty + gapy, row + 1 FROM dotsy, image WHERE doty < height - ), - _pixels(x, y, r, g, b) AS ( - SELECT x, y, - IFNULL((SELECT 60 * abs((row % 5) - (column % 5)) FROM dotsx, dotsy - WHERE POW(x - dotx - gapx*(row%2)/2.0, 2) + POW(y - doty, 2) < size*size LIMIT 1), 0), - 50, 70 - FROM vertical, horizontal, image - ) -INSERT INTO pixels (image_id, x, y, r, g, b) SELECT 'polka', x, y, r, g, b FROM _pixels; diff --git a/src/rave.sql b/src/rave.sql deleted file mode 100644 index 84cca9e..0000000 --- a/src/rave.sql +++ /dev/null @@ -1,32 +0,0 @@ -INSERT OR REPLACE INTO videos (id, width, height, fps) VALUES ('rave', 400, 400, 10) RETURNING id; - -WITH RECURSIVE - video AS (SELECT * FROM videos WHERE id = 'rave'), - _frames(frame) AS ( - SELECT 1 UNION ALL - SELECT frame + 1 FROM _frames, video WHERE frame < 50 - ) -INSERT INTO images (id, width, height, frame, video_id) SELECT CONCAT('rave/', frame), width, height, frame, 'rave' FROM _frames, video; - -WITH RECURSIVE - video AS (SELECT * FROM videos WHERE id = 'rave'), - horizontal(x) AS (SELECT width FROM video UNION ALL SELECT x - 1 FROM horizontal WHERE x > 1), - vertical(y) AS (SELECT height FROM video UNION ALL SELECT y - 1 FROM vertical WHERE y > 1), - _frames(id, frame) AS (SELECT id, frame FROM images WHERE video_id = (SELECT id FROM video)), - _pixels(frame_id, x, y, r, g, b) AS - (SELECT - frames_id, - x, y, - ROUND(255 * value)*middle, - ROUND(20 * value), - ROUND(180 * value)*(NOT middle) + 75 - FROM (SELECT *, - _frames.id AS frames_id, - (CASE - WHEN SIN((x - 200.0)*(x - 200.0)*0.0004) + TAN((y - 200.0)*(y - 200.0)*0.0004) - 0.1 < COS((10.0 + frame)*(x - 200.0)/(y - 200.0)) THEN 1.0 - ELSE 0.0 - END) AS value, - (y > 140 AND y < 260) AS middle - FROM vertical, horizontal, _frames) - ) -INSERT INTO pixels (image_id, x, y, r, g, b) SELECT frame_id, x, y, r, g, b FROM _pixels; diff --git a/src/rave.video.sql b/src/rave.video.sql new file mode 100644 index 0000000..84cca9e --- /dev/null +++ b/src/rave.video.sql @@ -0,0 +1,32 @@ +INSERT OR REPLACE INTO videos (id, width, height, fps) VALUES ('rave', 400, 400, 10) RETURNING id; + +WITH RECURSIVE + video AS (SELECT * FROM videos WHERE id = 'rave'), + _frames(frame) AS ( + SELECT 1 UNION ALL + SELECT frame + 1 FROM _frames, video WHERE frame < 50 + ) +INSERT INTO images (id, width, height, frame, video_id) SELECT CONCAT('rave/', frame), width, height, frame, 'rave' FROM _frames, video; + +WITH RECURSIVE + video AS (SELECT * FROM videos WHERE id = 'rave'), + horizontal(x) AS (SELECT width FROM video UNION ALL SELECT x - 1 FROM horizontal WHERE x > 1), + vertical(y) AS (SELECT height FROM video UNION ALL SELECT y - 1 FROM vertical WHERE y > 1), + _frames(id, frame) AS (SELECT id, frame FROM images WHERE video_id = (SELECT id FROM video)), + _pixels(frame_id, x, y, r, g, b) AS + (SELECT + frames_id, + x, y, + ROUND(255 * value)*middle, + ROUND(20 * value), + ROUND(180 * value)*(NOT middle) + 75 + FROM (SELECT *, + _frames.id AS frames_id, + (CASE + WHEN SIN((x - 200.0)*(x - 200.0)*0.0004) + TAN((y - 200.0)*(y - 200.0)*0.0004) - 0.1 < COS((10.0 + frame)*(x - 200.0)/(y - 200.0)) THEN 1.0 + ELSE 0.0 + END) AS value, + (y > 140 AND y < 260) AS middle + FROM vertical, horizontal, _frames) + ) +INSERT INTO pixels (image_id, x, y, r, g, b) SELECT frame_id, x, y, r, g, b FROM _pixels; diff --git a/src/voronoi.image.sql b/src/voronoi.image.sql new file mode 100644 index 0000000..ffe621b --- /dev/null +++ b/src/voronoi.image.sql @@ -0,0 +1,23 @@ +INSERT OR REPLACE INTO images (id, width, height) VALUES ('voronoi', 400, 400) RETURNING id; + +WITH RECURSIVE + image AS (SELECT *, 100 AS segments FROM images WHERE id = 'voronoi'), + horizontal(x) AS + (SELECT width FROM image UNION ALL SELECT x - 1 FROM horizontal WHERE x > 1), + vertical(y) AS + (SELECT height FROM image UNION ALL SELECT y - 1 FROM vertical WHERE y > 1), + points(px, py, count) AS ( + SELECT 0, 0, 0 UNION ALL + SELECT abs(RANDOM())%width, abs(RANDOM())%height, count + 1 FROM points, image WHERE count < segments + ), + _pixels(x, y, r, g, b) AS ( + SELECT x, y, + 0, + (SELECT color FROM + (SELECT (100*(px + 1)*(py + 1)) % 255 AS color, + POW(x - px, 2) + POW(y - py, 2) as distance + FROM points ORDER BY distance ASC LIMIT 1)), + 40 + FROM vertical, horizontal, image + ) +INSERT INTO pixels (image_id, x, y, r, g, b) SELECT 'voronoi', x, y, r, g, b FROM _pixels; diff --git a/src/voronoi.sql b/src/voronoi.sql deleted file mode 100644 index ffe621b..0000000 --- a/src/voronoi.sql +++ /dev/null @@ -1,23 +0,0 @@ -INSERT OR REPLACE INTO images (id, width, height) VALUES ('voronoi', 400, 400) RETURNING id; - -WITH RECURSIVE - image AS (SELECT *, 100 AS segments FROM images WHERE id = 'voronoi'), - horizontal(x) AS - (SELECT width FROM image UNION ALL SELECT x - 1 FROM horizontal WHERE x > 1), - vertical(y) AS - (SELECT height FROM image UNION ALL SELECT y - 1 FROM vertical WHERE y > 1), - points(px, py, count) AS ( - SELECT 0, 0, 0 UNION ALL - SELECT abs(RANDOM())%width, abs(RANDOM())%height, count + 1 FROM points, image WHERE count < segments - ), - _pixels(x, y, r, g, b) AS ( - SELECT x, y, - 0, - (SELECT color FROM - (SELECT (100*(px + 1)*(py + 1)) % 255 AS color, - POW(x - px, 2) + POW(y - py, 2) as distance - FROM points ORDER BY distance ASC LIMIT 1)), - 40 - FROM vertical, horizontal, image - ) -INSERT INTO pixels (image_id, x, y, r, g, b) SELECT 'voronoi', x, y, r, g, b FROM _pixels; diff --git a/src/wavey.sql b/src/wavey.sql deleted file mode 100644 index 70da417..0000000 --- a/src/wavey.sql +++ /dev/null @@ -1,33 +0,0 @@ -INSERT OR REPLACE INTO videos (id, width, height, fps) VALUES ('wavey', 400, 400, 10) RETURNING id; - -WITH RECURSIVE - video AS (SELECT * FROM videos WHERE id = 'wavey'), - _frames(frame) AS ( - SELECT 1 UNION ALL - SELECT frame + 1 FROM _frames, video WHERE frame < 50 - ) -INSERT INTO images (id, width, height, frame, video_id) SELECT CONCAT('wavey/', frame), width, height, frame, 'wavey' FROM _frames, video; - -WITH RECURSIVE - video AS (SELECT * FROM videos WHERE id = 'wavey'), - horizontal(x) AS (SELECT width FROM video UNION ALL SELECT x - 1 FROM horizontal WHERE x > 1), - vertical(y) AS (SELECT height FROM video UNION ALL SELECT y - 1 FROM vertical WHERE y > 1), - _frames(id, frame) AS (SELECT id, frame FROM images WHERE video_id = (SELECT id FROM video)), - _pixels(frame_id, x, y, r, g, b) AS - (SELECT - frames_id, - x, y, - ROUND(100 * value), - ROUND(240 * value*value), - ROUND(255 * value) - FROM (SELECT *, - (CASE - WHEN SIN((x - 4.0*frame) / 20.0)*10.0 > y - 150 THEN 1.0 - WHEN SIN((x - 0.5*frame) / 20.0)*10.0 > y - 200 THEN 0.75 - WHEN SIN((x + 8.0*frame) / 20.0)*10.0 > y - 280 THEN 0.5 - ELSE 0.3 - END) AS value, - _frames.id AS frames_id - FROM vertical, horizontal, _frames) - ) -INSERT INTO pixels (image_id, x, y, r, g, b) SELECT frame_id, x, y, r, g, b FROM _pixels; diff --git a/src/wavey.video.sql b/src/wavey.video.sql new file mode 100644 index 0000000..70da417 --- /dev/null +++ b/src/wavey.video.sql @@ -0,0 +1,33 @@ +INSERT OR REPLACE INTO videos (id, width, height, fps) VALUES ('wavey', 400, 400, 10) RETURNING id; + +WITH RECURSIVE + video AS (SELECT * FROM videos WHERE id = 'wavey'), + _frames(frame) AS ( + SELECT 1 UNION ALL + SELECT frame + 1 FROM _frames, video WHERE frame < 50 + ) +INSERT INTO images (id, width, height, frame, video_id) SELECT CONCAT('wavey/', frame), width, height, frame, 'wavey' FROM _frames, video; + +WITH RECURSIVE + video AS (SELECT * FROM videos WHERE id = 'wavey'), + horizontal(x) AS (SELECT width FROM video UNION ALL SELECT x - 1 FROM horizontal WHERE x > 1), + vertical(y) AS (SELECT height FROM video UNION ALL SELECT y - 1 FROM vertical WHERE y > 1), + _frames(id, frame) AS (SELECT id, frame FROM images WHERE video_id = (SELECT id FROM video)), + _pixels(frame_id, x, y, r, g, b) AS + (SELECT + frames_id, + x, y, + ROUND(100 * value), + ROUND(240 * value*value), + ROUND(255 * value) + FROM (SELECT *, + (CASE + WHEN SIN((x - 4.0*frame) / 20.0)*10.0 > y - 150 THEN 1.0 + WHEN SIN((x - 0.5*frame) / 20.0)*10.0 > y - 200 THEN 0.75 + WHEN SIN((x + 8.0*frame) / 20.0)*10.0 > y - 280 THEN 0.5 + ELSE 0.3 + END) AS value, + _frames.id AS frames_id + FROM vertical, horizontal, _frames) + ) +INSERT INTO pixels (image_id, x, y, r, g, b) SELECT frame_id, x, y, r, g, b FROM _pixels; -- cgit v1.3.1