v4 v5: cgi script for sample search form generator, sqlite, minor fixessisu_4.1.1

* affects 'sisu -F' (repairs breakage)

4 files changed, 24 insertions, 26 deletions

diff --git a/lib/sisu/v4/cgi_pgsql.rb b/lib/sisu/v4/cgi_pgsql.rb
index fd688244..70a60d81 100644
--- a/lib/sisu/v4/cgi_pgsql.rb
+++ b/lib/sisu/v4/cgi_pgsql.rb
@@ -158,13 +158,13 @@ module  SiSU_CGI_PgSQL
       require 'cgi'
       require 'fcgi'
       require 'dbi'
-      @stub_default="#{@name_of[:db]}"
-      @image_src="#{@name_of[:host_url_docs]}/_sisu/image_sys"
-      @hosturl_cgi="#{@name_of[:host_url_cgi]}"
-      @hosturl_files="#{@name_of[:host_url_docs]}"
-      @output_dir_structure_by="#{@name_of[:output_dir_structure]}"
-      @port="#{@db.psql.port}"
-      @db_name_prefix="#{Db[:name_prefix]}"
+      @stub_default='#{@name_of[:db]}'
+      @image_src='#{@name_of[:host_url_docs]}/_sisu/image_sys'
+      @hosturl_cgi='#{@name_of[:host_url_cgi]}'
+      @hosturl_files='#{@name_of[:host_url_docs]}'
+      @output_dir_structure_by='#{@name_of[:output_dir_structure]}'
+      @port='#{@db.psql.port}'
+      @db_name_prefix='#{Db[:name_prefix]}'
       user='www-data'  # check user name for access to pg database: e.g. www-data or '#{@env.user}'
       WOK_SQL
     end
diff --git a/lib/sisu/v4/cgi_sqlite.rb b/lib/sisu/v4/cgi_sqlite.rb
index d82cf8ec..05c7e6a7 100644
--- a/lib/sisu/v4/cgi_sqlite.rb
+++ b/lib/sisu/v4/cgi_sqlite.rb
@@ -131,12 +131,11 @@ module  SiSU_CGI_SQLite
       require 'cgi'
       require 'fcgi'
       require 'dbi'
-      @stub_default="#{@name_of[:db]}"
-      @image_src="#{@name_of[:host_url_docs]}/_sisu/image_sys"
-      @hosturl_cgi="#{@name_of[:host_url_cgi]}"
-      @hosturl_files="#{@name_of[:host_url_docs]}"
-      @output_dir_structure_by="#{@name_of[:output_dir_structure]}"
-      @db_name_prefix="#{Db[:name_prefix]}"
+      @stub_default='sisu_sqlite'
+      @image_src='#{@env.url.webserv_cgi}/_sisu/image_sys'
+      @hosturl_cgi='#{@env.url.webserv_base_cgi}/cgi-bin'
+      @hosturl_files='#{@env.url.webserv_files_from_db}'
+      @db_name_prefix='#{Db[:name_prefix]}'
       WOK_SQL
     end
     def search_statement
diff --git a/lib/sisu/v5/cgi_pgsql.rb b/lib/sisu/v5/cgi_pgsql.rb
index 8d09f733..1fa19e0d 100644
--- a/lib/sisu/v5/cgi_pgsql.rb
+++ b/lib/sisu/v5/cgi_pgsql.rb
@@ -158,13 +158,13 @@ module  SiSU_CGI_PgSQL
       require 'cgi'
       require 'fcgi'
       require 'dbi'
-      @stub_default="#{@name_of[:db]}"
-      @image_src="#{@name_of[:host_url_docs]}/_sisu/image_sys"
-      @hosturl_cgi="#{@name_of[:host_url_cgi]}"
-      @hosturl_files="#{@name_of[:host_url_docs]}"
-      @output_dir_structure_by="#{@name_of[:output_dir_structure]}"
-      @port="#{@db.psql.port}"
-      @db_name_prefix="#{Db[:name_prefix]}"
+      @stub_default='#{@name_of[:db]}'
+      @image_src='#{@name_of[:host_url_docs]}/_sisu/image_sys'
+      @hosturl_cgi='#{@name_of[:host_url_cgi]}'
+      @hosturl_files='#{@name_of[:host_url_docs]}'
+      @output_dir_structure_by='#{@name_of[:output_dir_structure]}'
+      @port='#{@db.psql.port}'
+      @db_name_prefix='#{Db[:name_prefix]}'
       user='www-data'  # check user name for access to pg database: e.g. www-data or '#{@env.user}'
       WOK_SQL
     end
diff --git a/lib/sisu/v5/cgi_sqlite.rb b/lib/sisu/v5/cgi_sqlite.rb
index 45f6d1ca..cf891c5a 100644
--- a/lib/sisu/v5/cgi_sqlite.rb
+++ b/lib/sisu/v5/cgi_sqlite.rb
@@ -131,12 +131,11 @@ module  SiSU_CGI_SQLite
       require 'cgi'
       require 'fcgi'
       require 'dbi'
-      @stub_default="#{@name_of[:db]}"
-      @image_src="#{@name_of[:host_url_docs]}/_sisu/image_sys"
-      @hosturl_cgi="#{@name_of[:host_url_cgi]}"
-      @hosturl_files="#{@name_of[:host_url_docs]}"
-      @output_dir_structure_by="#{@name_of[:output_dir_structure]}"
-      @db_name_prefix="#{Db[:name_prefix]}"
+      @stub_default='sisu_sqlite'
+      @image_src='#{@env.url.webserv_cgi}/_sisu/image_sys'
+      @hosturl_cgi='#{@env.url.webserv_base_cgi}/cgi-bin'
+      @hosturl_files='#{@env.url.webserv_files_from_db}'
+      @db_name_prefix='#{Db[:name_prefix]}'
       WOK_SQL
     end
     def search_statement