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
|
= New Features
* On SQLite, Database#create_table now supports a :strict option to
use the STRICT keyword when creating the table. When this option
is used, SQLite will enforce the types for each column. When using
this option, you are limited to using the following column types:
int, integer, real, text, blob, and any (any allows for dynamic
types).
* An sqlite_json_ops extension has been added, providing DSL support
for JSON functions and operators supported in SQLite 3.38.0. Usage
is similar to the pg_json_ops extension. First, you create an
appropriate object:
j = Sequel.sqlite_json_op(:json_column)
# or:
j = Sequel[:json_column].sqlite_json_op
Then, you call methods on that object to create expressions for the
JSON functions and operators:
j[1] # (json_column ->> 1)
j.get_text(1) # (json_column -> 1)
j.extract('$.a') # json_extract(json_column, '$.a')
j.array_length # json_array_length(json_column)
j.type # json_type(json_column)
j.valid # json_valid(json_column)
j.json # json(json_column)
j.insert('$.a', 1) # json_insert(json_column, '$.a', 1)
j.set('$.a', 1) # json_set(json_column, '$.a', 1)
j.replace('$.a', 1) # json_replace(json_column, '$.a', 1)
j.remove('$.a') # json_remove(json_column, '$.a')
j.patch('{"a":2}') # json_patch(json_column, '{"a":2}')
j.each # json_each(json_column)
j.tree # json_tree(json_column)
= Other Improvements
* The alter_table add_column and add_foreign_key methods now support
the :index option to create an index on the added column, for
compatibility with the :index option on the create_table column and
foreign_key methods.
* The schema_dumper extension now treats the "INTEGER" type the same
as the "integer" type. This fixes some behavior when using SQLite
3.37.0+.
* Sequel's website has a much improved visual design.
|
