リビジョン | 4b47425d9c639f60d0f2251c02c733ded05d945a (tree) |
---|---|
日時 | 2020-02-16 23:42:31 |
作者 | Dreas Nielsen <dreas.nielsen@gmai...> |
コミッター | Dreas Nielsen |
Modified documentation.
@@ -65,6 +65,8 @@ | ||
65 | 65 | lexer_parser/_reference.mkd |
66 | 66 | lexer_parser/logical_eval.py |
67 | 67 | lexer_parser/logical_grammar.txt |
68 | +templates/execsql.log | |
69 | +templates/junk.db | |
68 | 70 | *~ |
69 | 71 | .directory |
70 | 72 | *.pyc |
@@ -202,7 +202,7 @@ | ||
202 | 202 | |
203 | 203 | .. _batch: |
204 | 204 | |
205 | -BATCH | |
205 | +BEGIN BATCH and END BATCH | |
206 | 206 | ------------------------------ |
207 | 207 | |
208 | 208 | :: |
@@ -22,7 +22,7 @@ | ||
22 | 22 | -- or use the CONNECT metacommand to connect to that database |
23 | 23 | -- yourself with an alias of "config_db". |
24 | 24 | -- c. Possibly change the 'usage' argument for the 'prompt_config" |
25 | --- script to be "Import" or "Export" instead of "All." | |
25 | +-- script to be "Import", "Export", or "AllButDAO" instead of "All." | |
26 | 26 | -- |
27 | 27 | -- AUTHOR |
28 | 28 | -- Dreas Nielsen (RDN) |
@@ -31,6 +31,7 @@ | ||
31 | 31 | -- Date Remarks |
32 | 32 | -- ---------- ----------------------------------------------------- |
33 | 33 | -- 2020-02-15 Created. RDN. |
34 | +-- 2020-02-16 Modified documentation. RDN. | |
34 | 35 | -- ================================================================== |
35 | 36 | |
36 | 37 |
@@ -70,7 +71,7 @@ | ||
70 | 71 | -- Argument |
71 | 72 | -- usage : Values of the 'usage' column in the 'configusage' |
72 | 73 | -- table of the configuration settings database. |
73 | --- This should be 'All', 'Import', or 'Export'. | |
74 | +-- This should be 'All', 'AllButDAO', 'Import', or 'Export'. | |
74 | 75 | -- Other values may be used if they have been added |
75 | 76 | -- to the 'configusage' table |
76 | 77 | -- |
@@ -77,16 +77,30 @@ | ||
77 | 77 | ('All', '~boolean_int'), |
78 | 78 | ('All', '~boolean_words'), |
79 | 79 | ('All', '~clean_col_hdrs'), |
80 | + ('All', '~import_common'), | |
80 | 81 | ('All', '~empty_strings'), |
81 | 82 | ('All', '~empty_rows'), |
82 | - ('All', '~import_common'), | |
83 | 83 | ('All', '~console_wait_done'), |
84 | 84 | ('All', '~console_wait_err'), |
85 | 85 | ('All', '~log_write'), |
86 | + ('All', '~make_dirs'), | |
86 | 87 | ('All', '~quote_all'), |
87 | 88 | ('All', '~write_warnings'), |
88 | 89 | ('All', '~dao_flush'), |
89 | 90 | |
91 | + ('AllButDAO', '~boolean_int'), | |
92 | + ('AllButDAO', '~boolean_words'), | |
93 | + ('AllButDAO', '~clean_col_hdrs'), | |
94 | + ('AllButDAO', '~import_common'), | |
95 | + ('AllButDAO', '~empty_strings'), | |
96 | + ('AllButDAO', '~empty_rows'), | |
97 | + ('AllButDAO', '~console_wait_done'), | |
98 | + ('AllButDAO', '~console_wait_err'), | |
99 | + ('AllButDAO', '~log_write'), | |
100 | + ('AllButDAO', '~make_dirs'), | |
101 | + ('AllButDAO', '~quote_all'), | |
102 | + ('AllButDAO', '~write_warnings'), | |
103 | + | |
90 | 104 | ('Import', '~boolean_int'), |
91 | 105 | ('Import', '~boolean_words'), |
92 | 106 | ('Import', '~clean_col_hdrs'), |
@@ -106,6 +120,14 @@ | ||
106 | 120 | where |
107 | 121 | usage = 'All'; |
108 | 122 | |
123 | +drop view if exists allbutdao_config; | |
124 | +create view allbutdao_config as | |
125 | +select cs.* | |
126 | +from configspecs cs inner join configusage cu | |
127 | + on cu.sub_var = cs.sub_var | |
128 | +where | |
129 | + usage = 'AllButDAO'; | |
130 | + | |
109 | 131 | drop view if exists import_config; |
110 | 132 | create view import_config as |
111 | 133 | select cs.* |