embed youtobe videos

6 files changed, 22 insertions, 5 deletions

diff --git a/sql/functions/general.get_galleries.sql b/sql/functions/general.get_galleries.sql
index fc93095..db3ad09 100644
--- a/sql/functions/general.get_galleries.sql
+++ b/sql/functions/general.get_galleries.sql
@@ -9,7 +9,11 @@ begin
         g.description,
         g.filename,
         g.mime_type,
-        substring(g.content::text from 3) as content,
+        g.video_embed_url,
+        case
+          when g.content is null then null
+          else substring(g.content::text from 3)
+        end as content,
         g.created,
         g.modified
     from general.gallery g
diff --git a/sql/functions/general.get_gallery.sql b/sql/functions/general.get_gallery.sql
index 66c9fce..c0972f4 100644
--- a/sql/functions/general.get_gallery.sql
+++ b/sql/functions/general.get_gallery.sql
@@ -13,7 +13,11 @@ begin
         g.description,
         g.filename,
         g.mime_type,
-        substring(g.content::text from 3) as content,
+        g.video_embed_url,
+        case
+          when g.content is null then null
+          else substring(g.content::text from 3)
+        end as content,
         g.created,
         g.modified
     from general.gallery g
diff --git a/sql/functions/general.insert_gallery.sql b/sql/functions/general.insert_gallery.sql
index 0582c6b..26260fb 100644
--- a/sql/functions/general.insert_gallery.sql
+++ b/sql/functions/general.insert_gallery.sql
@@ -2,6 +2,7 @@ drop function general.insert_gallery (
     p_description text,
     p_filename character varying,
     p_mime_type character varying,
+    p_video_embed_url character varying,
     p_hex text
 );
 
@@ -9,6 +10,7 @@ create or replace function general.insert_gallery (
     p_description text,
     p_filename character varying,
     p_mime_type character varying,
+    p_video_embed_url character varying,
     p_hex text
 )
 returns bigint
@@ -20,11 +22,13 @@ begin
         description,
         filename,
         mime_type,
+        video_embed_url,
         content
     ) values (
         p_description,
         p_filename,
         p_mime_type,
+        p_video_embed_url,
         decode(p_hex, 'hex')
     ) returning id into l_id;
 
diff --git a/sql/functions/general.update_gallery.sql b/sql/functions/general.update_gallery.sql
index e8532db..95296c3 100644
--- a/sql/functions/general.update_gallery.sql
+++ b/sql/functions/general.update_gallery.sql
@@ -3,6 +3,7 @@ drop function general.update_gallery (
     p_description text,
     p_filename character varying,
     p_mime_type character varying,
+    p_video_embed_url character varying,
     p_hex text
 );
 
@@ -11,6 +12,7 @@ create or replace function general.update_gallery (
     p_description text,
     p_filename character varying,
     p_mime_type character varying,
+    p_video_embed_url character varying,
     p_hex text
 )
 returns bigint
@@ -27,6 +29,7 @@ begin
         set description = p_description,
             filename = p_filename,
             mime_type = p_mime_type,
+            video_embed_url = p_video_embed_url,
             content = decode(p_hex, 'hex'),
             modified = now()
         where id = p_id;
diff --git a/sql/tables/general.gallery.sql b/sql/tables/general.gallery.sql
index 63b3172..972ae67 100644
--- a/sql/tables/general.gallery.sql
+++ b/sql/tables/general.gallery.sql
@@ -3,9 +3,10 @@ drop table general.gallery cascade;
 create table general.gallery (
     id serial8 primary key,
     description text,
-    filename character varying(255) not null,
-    mime_type character varying(255) not null,
-    content bytea not null,
+    filename character varying(255),
+    mime_type character varying(255),
+    video_embed_url character varying(255),
+    content bytea,
     created timestamp without time zone not null default now(),
     modified timestamp without time zone not null default now()
 );
diff --git a/sql/types/general.gallery_t.sql b/sql/types/general.gallery_t.sql
index a8f2060..3ccb56c 100644
--- a/sql/types/general.gallery_t.sql
+++ b/sql/types/general.gallery_t.sql
@@ -5,6 +5,7 @@ create type general.gallery_t as (
     description text,
     filename character varying,
     mime_type character varying,
+    video_embed_url character varying,
     content text,
     created timestamp without time zone,
     modified timestamp without time zone