Debian Codegraph @

qlite/src/column.vala

raw
1 using Sqlite;
2
3 namespace Qlite {
4
5 public abstract class Column<T> {
6 public const string DEFAULT_TABLE_NAME = "";
7
8 public string name { get; private set; }
9 public string? default { get; set; }
10 public int sqlite_type { get; private set; }
11 public bool primary_key { get; set; }
12 public bool auto_increment { get; set; }
13 public bool unique { get; set; }
14 public virtual bool not_null { get; set; }
15 public long min_version { get; set; default = -1; }
16 public long max_version { get; set; default = long.MAX; }
17 internal Table table { get; set; }
18
19 public abstract T get(Row row, string? table_name = DEFAULT_TABLE_NAME);
20
21 public virtual bool is_null(Row row, string? table_name = DEFAULT_TABLE_NAME) {
22 return false;
23 }
24
25 internal abstract void bind(Statement stmt, int index, T value);
26
27 public string to_string() {
28 return table == null ? name : (table.name + "." + name);
29 }
30
31 public string to_column_definition() {
32 string res = name;
33 switch (sqlite_type) {
34 case INTEGER:
35 res += " INTEGER";
36 break;
37 case FLOAT:
38 res += " REAL";
39 break;
40 case TEXT:
41 res += " TEXT";
42 break;
43 default:
44 res += " UNKNOWN";
45 break;
46 }
47 if (primary_key) {
48 res += " PRIMARY KEY";
49 if (auto_increment) res += " AUTOINCREMENT";
50 }
51 if (not_null) res += " NOT NULL";
52 if (unique) res += " UNIQUE";
53 if (default != null) res += @" DEFAULT $((!) default)";
54
55 return res;
56 }
57
58 Column(string name, int type) {
59 this.name = name;
60 this.sqlite_type = type;
61 }
62
63 public class Integer : Column<int> {
64 public Integer(string name) {
65 base(name, INTEGER);
66 }
67
68 public override int get(Row row, string? table_name = DEFAULT_TABLE_NAME) {
69 return (int) row.get_integer(name, table_name == DEFAULT_TABLE_NAME ? table.name : table_name);
70 }
71
72 public override bool is_null(Row row, string? table_name = DEFAULT_TABLE_NAME) {
73 return !row.has_integer(name, table_name == DEFAULT_TABLE_NAME ? table.name : table_name);
74 }
75
76 internal override void bind(Statement stmt, int index, int value) {
77 stmt.bind_int(index, value);
78 }
79 }
80
81 public class Long : Column<long> {
82 public Long(string name) {
83 base(name, INTEGER);
84 }
85
86 public override long get(Row row, string? table_name = DEFAULT_TABLE_NAME) {
87 return (long) row.get_integer(name, table_name == DEFAULT_TABLE_NAME ? table.name : table_name);
88 }
89
90 public override bool is_null(Row row, string? table_name = DEFAULT_TABLE_NAME) {
91 return !row.has_integer(name, table_name == DEFAULT_TABLE_NAME ? table.name : table_name);
92 }
93
94 internal override void bind(Statement stmt, int index, long value) {
95 stmt.bind_int64(index, value);
96 }
97 }
98
99 public class NullableReal : Column<double?> {
100 public NullableReal(string name) {
101 base(name, FLOAT);
102 }
103
104 public override bool not_null { get { return false; } set {} }
105
106 public override double? get(Row row, string? table_name = DEFAULT_TABLE_NAME) {
107 return row.get_real(name, table_name == DEFAULT_TABLE_NAME ? table.name : table_name);
108 }
109
110 public override bool is_null(Row row, string? table_name = DEFAULT_TABLE_NAME) {
111 return !row.has_real(name, table_name == DEFAULT_TABLE_NAME ? table.name : table_name);
112 }
113
114 internal override void bind(Statement stmt, int index, double? value) {
115 stmt.bind_double(index, value);
116 }
117 }
118
119 public class Text : Column<string?> {
120 public Text(string name) {
121 base(name, TEXT);
122 }
123
124 public override string? get(Row row, string? table_name = DEFAULT_TABLE_NAME) {
125 return row.get_text(name, table_name == DEFAULT_TABLE_NAME ? table.name : table_name);
126 }
127
128 public override bool is_null(Row row, string? table_name = DEFAULT_TABLE_NAME) {
129 return get(row, table_name == DEFAULT_TABLE_NAME ? table.name : table_name) == null;
130 }
131
132 internal override void bind(Statement stmt, int index, string? value) {
133 if (value != null) {
134 stmt.bind_text(index, (!) value);
135 } else {
136 stmt.bind_null(index);
137 }
138 }
139 }
140
141 public class NonNullText : Column<string> {
142 public NonNullText(string name) {
143 base(name, TEXT);
144 }
145
146 public override bool not_null { get { return true; } set {} }
147
148 public override string get(Row row, string? table_name = DEFAULT_TABLE_NAME) {
149 return (!)row.get_text(name, table_name == DEFAULT_TABLE_NAME ? table.name : table_name);
150 }
151
152 public override bool is_null(Row row, string? table_name = DEFAULT_TABLE_NAME) {
153 return false;
154 }
155
156 internal override void bind(Statement stmt, int index, string value) {
157 stmt.bind_text(index, (!) value);
158 }
159 }
160
161 public class BoolText : Column<bool> {
162 public BoolText(string name) {
163 base(name, TEXT);
164 }
165
166 public override bool get(Row row, string? table_name = DEFAULT_TABLE_NAME) {
167 return row.get_text(name, table_name == DEFAULT_TABLE_NAME ? table.name : table_name) == "1";
168 }
169
170 internal override void bind(Statement stmt, int index, bool value) {
171 stmt.bind_text(index, value ? "1" : "0");
172 }
173 }
174
175 public class BoolInt : Column<bool> {
176 public BoolInt(string name) {
177 base(name, INTEGER);
178 }
179
180 public override bool get(Row row, string? table_name = DEFAULT_TABLE_NAME) {
181 return row.get_integer(name, table_name == DEFAULT_TABLE_NAME ? table.name : table_name) == 1;
182 }
183
184 internal override void bind(Statement stmt, int index, bool value) {
185 stmt.bind_int(index, value ? 1 : 0);
186 }
187 }
188 }
189
190 }