-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathminimal-cmake.sql
63 lines (60 loc) · 2.38 KB
/
minimal-cmake.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
create temp table temp_blocks(row_number serial, t_content text, t_type flashback.block_type, t_language varchar(10));
create procedure add_block(type flashback.block_type, language varchar(10), content text) language plpgsql as $$ begin insert into temp_blocks (t_type, t_language, t_content) values (type, language, content); end; $$;
-- target types
call add_block('text', 'txt', '');
call add_block('code', 'cmake', '');
call create_note_with_name('Minimal CMake', 1, '');
--
--call add_block('text', 'txt', '');
--call add_block('code', 'cmake', '');
--call create_note_with_name('Minimal CMake', 2, '');
--
--call add_block('text', 'txt', '');
--call add_block('code', 'cmake', '');
--call create_note_with_name('Minimal CMake', 3, '');
--
--call add_block('text', 'txt', '');
--call add_block('code', 'cmake', '');
--call create_note_with_name('Minimal CMake', 4, '');
--
--call add_block('text', 'txt', '');
--call add_block('code', 'cmake', '');
--call create_note_with_name('Minimal CMake', 5, '');
--
--call add_block('text', 'txt', '');
--call add_block('code', 'cmake', '');
--call create_note_with_name('Minimal CMake', 6, '');
--
--call add_block('text', 'txt', '');
--call add_block('code', 'cmake', '');
--call create_note_with_name('Minimal CMake', 7, '');
--
--call add_block('text', 'txt', '');
--call add_block('code', 'cmake', '');
--call create_note_with_name('Minimal CMake', 8, '');
--
--call add_block('text', 'txt', '');
--call add_block('code', 'cmake', '');
--call create_note_with_name('Minimal CMake', 9, '');
--
--call add_block('text', 'txt', '');
--call add_block('code', 'cmake', '');
--call create_note_with_name('Minimal CMake', 10, '');
--
--call add_block('text', 'txt', '');
--call add_block('code', 'cmake', '');
--call create_note_with_name('Minimal CMake', 11, '');
--
--call set_section_as_complete('Minimal CMake', 1);
--call set_section_as_complete('Minimal CMake', 2);
--call set_section_as_complete('Minimal CMake', 3);
--call set_section_as_complete('Minimal CMake', 4);
--call set_section_as_complete('Minimal CMake', 5);
--call set_section_as_complete('Minimal CMake', 6);
--call set_section_as_complete('Minimal CMake', 7);
--call set_section_as_complete('Minimal CMake', 8);
--call set_section_as_complete('Minimal CMake', 9);
--call set_section_as_complete('Minimal CMake', 10);
--call set_section_as_complete('Minimal CMake', 11);
drop procedure add_block;
drop table temp_blocks;