| 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 |
} |