sqlayout 0.3.1

Generate SQL-code for creating SQLite databases via Builder API or XML config
Documentation 
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
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
           targetNamespace="https://crates.io/crates/sqlayout">
  <!--region Enums-->

  <xs:simpleType name="non_empty_string">
    <xs:restriction base="xs:string">
      <xs:minLength value="1"/>
      <!-- https://regex101.com/r/aWpakM/1 (remove '^' and '$', they are implied in XML patterns) -->
      <xs:pattern value="(?!sqlite_)[a-zA-Z_]+"/>
    </xs:restriction>
  </xs:simpleType>

  <xs:simpleType name="type">
    <xs:restriction base="xs:string">
      <xs:enumeration value="blob"/>
      <xs:enumeration value="numeric"/>
      <xs:enumeration value="integer"/>
      <xs:enumeration value="real"/>
      <xs:enumeration value="text"/>
    </xs:restriction>
  </xs:simpleType>

  <xs:simpleType name="order">
    <xs:restriction base="xs:string">
      <xs:enumeration value="Ascending"/>
      <xs:enumeration value="Descending"/>
    </xs:restriction>
  </xs:simpleType>

  <xs:simpleType name="on_conflict_type">
    <xs:restriction base="xs:string">
      <xs:enumeration value="Rollback"/>
      <xs:enumeration value="Abort"/>
      <xs:enumeration value="Fail"/>
      <xs:enumeration value="Ignore"/>
      <xs:enumeration value="Replace"/>
    </xs:restriction>
  </xs:simpleType>

  <xs:simpleType name="on_action">
    <xs:restriction base="xs:string">
      <xs:enumeration value="Set Null"/>
      <xs:enumeration value="Set Default"/>
      <xs:enumeration value="Cascade"/>
      <xs:enumeration value="Restrict"/>
      <xs:enumeration value="No Action"/>
    </xs:restriction>
  </xs:simpleType>
  
  <xs:simpleType name="generated_as">
    <xs:restriction base="xs:string">
      <xs:enumeration value="Virtual"/>
      <xs:enumeration value="Stored"/>
    </xs:restriction>
  </xs:simpleType>

  <!--endregion-->

  <xs:attribute name="on_conflict" type="on_conflict_type"/>

  <xs:complexType name="pk">
    <xs:attribute name="order" type="order" use="optional"/>
    <xs:attribute ref="on_conflict" use="optional"/>
    <xs:attribute name="autoincrement" type="xs:boolean" use="optional"/>
  </xs:complexType>

  <xs:complexType name="fk">
    <xs:attribute name="foreign_table" type="non_empty_string" use="required"/>
    <xs:attribute name="foreign_column" type="non_empty_string" use="required"/>
    <xs:attribute name="on_delete" type="on_action" use="optional"/>
    <xs:attribute name="on_update" type="on_action" use="optional"/>
    <xs:attribute name="deferrable" type="xs:boolean" use="optional"/>
  </xs:complexType>

  <xs:complexType name="unique">
    <xs:attribute ref="on_conflict" use="optional"/>
  </xs:complexType>

  <xs:complexType name="not_null">
    <xs:attribute ref="on_conflict" use="optional"/>
  </xs:complexType>
  
  <xs:complexType name="generated">
    <xs:attribute name="as" type="generated_as" use="optional"/>
    <xs:attribute name="expr" type="non_empty_string" use="required"/>
  </xs:complexType>

  <xs:complexType name="column">
    <xs:all>
      <xs:element name="pk" type="pk" minOccurs="0"/>
      <xs:element name="fk" type="fk" minOccurs="0"/>
      <xs:element name="unique" type="unique" minOccurs="0"/>
      <xs:element name="not_null" type="not_null" minOccurs="0"/>
      <xs:element name="generated" type="generated" minOccurs="0"/>
    </xs:all>
    <xs:attribute name="name" type="non_empty_string" use="required"/>
    <xs:attribute name="type" type="type" use="required"/>
  </xs:complexType>

  <xs:complexType name="view_column">
    <xs:attribute name="name" type="non_empty_string" use="required"/>
  </xs:complexType>

  <xs:complexType name="view" >
    <xs:sequence>
      <xs:element name="column" type="view_column" maxOccurs="unbounded"/>
    </xs:sequence>
    <xs:attribute name="name" type="non_empty_string" use="required"/>
    <xs:attribute name="temp" type="xs:boolean" use="optional"/>
    <xs:attribute name="select" type="non_empty_string" use="required"/>
  </xs:complexType>

  <xs:complexType name="table">
    <xs:sequence>
      <xs:element name="column" type="column" minOccurs="1" maxOccurs="unbounded"/>
    </xs:sequence>
    <xs:attribute name="name" type="non_empty_string" use="required"/>
    <xs:attribute name="without_rowid" type="xs:boolean" use="optional"/>
    <xs:attribute name="strict" type="xs:boolean" use="optional"/>
  </xs:complexType>

  <xs:complexType name="schema">
    <xs:sequence>
      <xs:sequence>
        <xs:element name="table" type="table" minOccurs="1" maxOccurs="unbounded"/>
      </xs:sequence>
      <xs:sequence>
        <xs:element name="view" type="view" minOccurs="0" maxOccurs="unbounded"/>
      </xs:sequence>
    </xs:sequence>
  </xs:complexType>

  <!-- Possible root elements -->
  <xs:element name="schema" type="schema"/>
  <xs:element name="table" type="table"/>
  <xs:element name="view" type="view"/>
</xs:schema>