Fixing spacing between views on createdb template

xo · Jul 25, 2021 · f82da19 · f82da19
1 parent b10ab08
commit f82da19
Show file tree

Hide file tree

Showing 6 changed files with 6 additions and 1 deletion.
diff --git a/_examples/a_bit_of_everything/mysql/xo.xo.sql b/_examples/a_bit_of_everything/mysql/xo.xo.sql
@@ -163,6 +163,7 @@ CREATE TABLE a_unique_index_composite (
 -- view a_view_of_everything
 CREATE VIEW a_view_of_everything AS
 select `a_bit_of_everything`.`a_bit_of_everything`.`a_bigint` AS `a_bigint`,`a_bit_of_everything`.`a_bit_of_everything`.`a_bigint_nullable` AS `a_bigint_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_binary` AS `a_binary`,`a_bit_of_everything`.`a_bit_of_everything`.`a_binary_nullable` AS `a_binary_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_bit` AS `a_bit`,`a_bit_of_everything`.`a_bit_of_everything`.`a_bit_nullable` AS `a_bit_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_blob` AS `a_blob`,`a_bit_of_everything`.`a_bit_of_everything`.`a_blob_nullable` AS `a_blob_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_bool` AS `a_bool`,`a_bit_of_everything`.`a_bit_of_everything`.`a_bool_nullable` AS `a_bool_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_char` AS `a_char`,`a_bit_of_everything`.`a_bit_of_everything`.`a_char_nullable` AS `a_char_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_date` AS `a_date`,`a_bit_of_everything`.`a_bit_of_everything`.`a_date_nullable` AS `a_date_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_datetime` AS `a_datetime`,`a_bit_of_everything`.`a_bit_of_everything`.`a_datetime_nullable` AS `a_datetime_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_dec` AS `a_dec`,`a_bit_of_everything`.`a_bit_of_everything`.`a_dec_nullable` AS `a_dec_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_fixed` AS `a_fixed`,`a_bit_of_everything`.`a_bit_of_everything`.`a_fixed_nullable` AS `a_fixed_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_decimal` AS `a_decimal`,`a_bit_of_everything`.`a_bit_of_everything`.`a_decimal_nullable` AS `a_decimal_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_double_precision` AS `a_double_precision`,`a_bit_of_everything`.`a_bit_of_everything`.`a_double_precision_nullable` AS `a_double_precision_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_enum` AS `a_enum`,`a_bit_of_everything`.`a_bit_of_everything`.`a_enum_nullable` AS `a_enum_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_float` AS `a_float`,`a_bit_of_everything`.`a_bit_of_everything`.`a_float_nullable` AS `a_float_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_int` AS `a_int`,`a_bit_of_everything`.`a_bit_of_everything`.`a_int_nullable` AS `a_int_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_integer` AS `a_integer`,`a_bit_of_everything`.`a_bit_of_everything`.`a_integer_nullable` AS `a_integer_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_json` AS `a_json`,`a_bit_of_everything`.`a_bit_of_everything`.`a_json_nullable` AS `a_json_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_longblob` AS `a_longblob`,`a_bit_of_everything`.`a_bit_of_everything`.`a_longblob_nullable` AS `a_longblob_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_longtext` AS `a_longtext`,`a_bit_of_everything`.`a_bit_of_everything`.`a_longtext_nullable` AS `a_longtext_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_mediumblob` AS `a_mediumblob`,`a_bit_of_everything`.`a_bit_of_everything`.`a_mediumblob_nullable` AS `a_mediumblob_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_mediumint` AS `a_mediumint`,`a_bit_of_everything`.`a_bit_of_everything`.`a_mediumint_nullable` AS `a_mediumint_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_mediumtext` AS `a_mediumtext`,`a_bit_of_everything`.`a_bit_of_everything`.`a_mediumtext_nullable` AS `a_mediumtext_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_numeric` AS `a_numeric`,`a_bit_of_everything`.`a_bit_of_everything`.`a_numeric_nullable` AS `a_numeric_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_real` AS `a_real`,`a_bit_of_everything`.`a_bit_of_everything`.`a_real_nullable` AS `a_real_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_set` AS `a_set`,`a_bit_of_everything`.`a_bit_of_everything`.`a_set_nullable` AS `a_set_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_smallint` AS `a_smallint`,`a_bit_of_everything`.`a_bit_of_everything`.`a_smallint_nullable` AS `a_smallint_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_text` AS `a_text`,`a_bit_of_everything`.`a_bit_of_everything`.`a_text_nullable` AS `a_text_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_time` AS `a_time`,`a_bit_of_everything`.`a_bit_of_everything`.`a_time_nullable` AS `a_time_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_timestamp` AS `a_timestamp`,`a_bit_of_everything`.`a_bit_of_everything`.`a_timestamp_nullable` AS `a_timestamp_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_tinyblob` AS `a_tinyblob`,`a_bit_of_everything`.`a_bit_of_everything`.`a_tinyblob_nullable` AS `a_tinyblob_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_tinyint` AS `a_tinyint`,`a_bit_of_everything`.`a_bit_of_everything`.`a_tinyint_nullable` AS `a_tinyint_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_tinytext` AS `a_tinytext`,`a_bit_of_everything`.`a_bit_of_everything`.`a_tinytext_nullable` AS `a_tinytext_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_varbinary` AS `a_varbinary`,`a_bit_of_everything`.`a_bit_of_everything`.`a_varbinary_nullable` AS `a_varbinary_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_varchar` AS `a_varchar`,`a_bit_of_everything`.`a_bit_of_everything`.`a_varchar_nullable` AS `a_varchar_nullable`,`a_bit_of_everything`.`a_bit_of_everything`.`a_year` AS `a_year`,`a_bit_of_everything`.`a_bit_of_everything`.`a_year_nullable` AS `a_year_nullable` from `a_bit_of_everything`.`a_bit_of_everything`;
+
 -- view a_view_of_everything_some
 CREATE VIEW a_view_of_everything_some AS
 select `a_bit_of_everything`.`a_bit_of_everything`.`a_bool` AS `a_bool`,`a_bit_of_everything`.`a_bit_of_everything`.`a_text` AS `a_text` from `a_bit_of_everything`.`a_bit_of_everything`;

diff --git a/_examples/a_bit_of_everything/oracle/xo.xo.sql b/_examples/a_bit_of_everything/oracle/xo.xo.sql
@@ -140,6 +140,7 @@ CREATE TABLE a_unique_index_composite (
 -- view a_view_of_everything
 CREATE VIEW a_view_of_everything AS
 SELECT "A_BOOL","A_BOOL_NULLABLE","A_BLOB","A_BLOB_NULLABLE","A_CHAR","A_CHAR_NULLABLE","A_CHARACTER","A_CHARACTER_NULLABLE","A_CLOB","A_CLOB_NULLABLE","A_DATE","A_DATE_NULLABLE","A_DOUBLE_PRECISION","A_DOUBLE_PRECISION_NULLABLE","A_DECIMAL","A_DECIMAL_NULLABLE","A_FLOAT","A_FLOAT_NULLABLE","A_INT","A_INT_NULLABLE","A_INTEGER","A_INTEGER_NULLABLE","A_LONG_RAW","A_NCHAR","A_NCHAR_NULLABLE","A_NCLOB","A_NCLOB_NULLABLE","A_NUMBER","A_NUMBER_NULLABLE","A_NUMERIC","A_NUMERIC_NULLABLE","A_NVARCHAR2","A_NVARCHAR2_NULLABLE","A_RAW","A_RAW_NULLABLE","A_REAL","A_REAL_NULLABLE","A_ROWID","A_ROWID_NULLABLE","A_SMALLINT","A_SMALLINT_NULLABLE","A_TIMESTAMP","A_TIMESTAMP_NULLABLE","A_TIMESTAMP_WITH_LOCAL_TIME_ZONE","A_TIMESTAMP_WITH_LOCAL_TIME_ZONE_NULLABLE","A_TIMESTAMP_WITH_TIME_ZONE","A_TIMESTAMP_WITH_TIME_ZONE_NULLABLE","A_VARCHAR","A_VARCHAR_NULLABLE","A_VARCHAR2","A_VARCHAR2_NULLABLE","A_XMLTYPE","A_XMLTYPE_NULLABLE" FROM a_bit_of_everything;
+
 -- view a_view_of_everything_some
 CREATE VIEW a_view_of_everything_some AS
 SELECT a_bool, a_nclob FROM a_bit_of_everything;

diff --git a/_examples/a_bit_of_everything/postgres/xo.xo.sql b/_examples/a_bit_of_everything/postgres/xo.xo.sql
@@ -233,6 +233,7 @@ SELECT a_bit_of_everything.a_enum,
     a_bit_of_everything.a_xml,
     a_bit_of_everything.a_xml_nullable
    FROM a_bit_of_everything;
+
 -- view a_view_of_everything_some
 CREATE VIEW a_view_of_everything_some AS
 SELECT a_bit_of_everything.a_bool,

diff --git a/_examples/a_bit_of_everything/sqlite3/xo.xo.sql b/_examples/a_bit_of_everything/sqlite3/xo.xo.sql
@@ -145,6 +145,7 @@ CREATE TABLE a_unique_index_composite (
 -- view a_view_of_everything
 CREATE VIEW a_view_of_everything AS
   SELECT * FROM a_bit_of_everything;
+
 -- view a_view_of_everything_some
 CREATE VIEW a_view_of_everything_some AS
   SELECT a_bool, a_text FROM a_bit_of_everything;
diff --git a/_examples/a_bit_of_everything/sqlserver/xo.xo.sql b/_examples/a_bit_of_everything/sqlserver/xo.xo.sql
@@ -142,6 +142,7 @@ CREATE TABLE a_unique_index_composite (
 -- views
 CREATE VIEW a_view_of_everything AS
   SELECT * FROM a_bit_of_everything;
+
 -- view a_view_of_everything_some
 CREATE VIEW a_view_of_everything_some AS
   SELECT a_bit, a_text FROM a_bit_of_everything;

diff --git a/templates/createdbtpl/xo.xo.sql.tpl b/templates/createdbtpl/xo.xo.sql.tpl
@@ -35,7 +35,7 @@ CREATE INDEX {{ esc $idx.Name }} ON {{ esc $t.Name }} ({{ fields $idx.Fields }})
 {{- range $v := $s.Views }}
 -- view {{ $v.Name }}
 {{ viewdef $v }}
-{{- end }}
+{{ end }}
 {{ end -}}
 {{- if $s.Procs }}
 {{- range $p := $s.Procs }}