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
|
#!/usr/bin/gjs
const Lang = imports.lang;
const GLib = imports.gi.GLib;
const GObject = imports.gi.GObject;
const GIRepository = imports.gi.GIRepository;
const Gom = imports.gi.Gom;
const System = imports.system;
const INT32_MAX = (2147483647);
const ItemClass = new Lang.Class({
Name: 'Item',
Extends: Gom.Resource,
Properties: {
'id': GObject.ParamSpec.int('id', 'ID',
'An ID', GObject.ParamFlags.READABLE | GObject.ParamFlags.WRITABLE | GObject.ParamFlags.CONSTRUCT,
0, INT32_MAX, 0),
'url': GObject.ParamSpec.string('url', 'URL',
'A URL',
GObject.ParamFlags.READABLE | GObject.ParamFlags.WRITABLE | GObject.ParamFlags.CONSTRUCT,
''),
},
_instance_init: function() {
},
});
Gom.Resource.set_table.call(ItemClass, 'items');
Gom.Resource.set_primary_key.call(ItemClass, 'id');
// Open
let adapter = new Gom.Adapter;
adapter.open_sync('/tmp/gom-js-test.db');
let repository = new Gom.Repository({adapter: adapter});
let item = new ItemClass({ 'repository': repository });
//item.url = 'http://www.gnome.org';
item.url = 'http://www.gnome.org';
print (item.id);
item.id = 0;
print (item.url);
// Migrate
let object_types = [ ItemClass ];
repository.automatic_migrate_sync(2, object_types);
// Add item
let ret = item.save_sync();
print("New item ID:", item.id, "URL:", item.url);
// Close
adapter.close_sync();
// Open
let adapter = new Gom.Adapter;
adapter.open_sync('/tmp/gom-js-test.db');
let repository = new Gom.Repository({adapter: adapter});
// Find item
let filter = Gom.Filter.new_eq(ItemClass, "id", 1);
let found_item = repository.find_one_sync(ItemClass, filter);
print (found_item.url);
// Close
adapter.close_sync();
|
