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
|
---
layout: guide
doc_stub: false
search: true
section: GraphQL Pro - OperationStore
title: ActiveRecord Backend
desc: Storing persisted queries with ActiveRecord
index: 2
pro: true
---
GraphQL-Pro's `OperationStore` can use ActiveRecord to store persisted queries. After setting up the database, it will read and write using those tables as needed.
## Database Setup
To use ActiveRecord, `GraphQL::Pro::OperationStore` requires some database tables. You can add these with a migration:
```bash
$ rails generate migration SetupOperationStore
```
Then open the migration file and add:
```ruby
# ...
# implement the change method with:
def change
create_table :graphql_clients, primary_key: :id do |t|
t.column :name, :string, null: false
t.column :secret, :string, null: false
t.timestamps
end
add_index :graphql_clients, :name, unique: true
add_index :graphql_clients, :secret, unique: true
create_table :graphql_operations, primary_key: :id do |t|
t.column :digest, :string, null: false
t.column :body, :text, null: false
t.column :name, :string, null: false
t.timestamps
end
add_index :graphql_operations, :digest, unique: true
create_table :graphql_client_operations, primary_key: :id do |t|
t.references :graphql_client, null: false
t.references :graphql_operation, null: false
t.column :alias, :string, null: false
t.column :last_used_at, :datetime
t.column :is_archived, :boolean, default: false
t.timestamps
end
add_index :graphql_client_operations, [:graphql_client_id, :alias], unique: true, name: "graphql_client_operations_pairs"
add_index :graphql_client_operations, :is_archived
create_table :graphql_index_entries, primary_key: :id do |t|
t.column :name, :string, null: false
end
add_index :graphql_index_entries, :name, unique: true
create_table :graphql_index_references, primary_key: :id do |t|
t.references :graphql_index_entry, null: false
t.references :graphql_operation, null: false
end
add_index :graphql_index_references, [:graphql_index_entry_id, :graphql_operation_id], unique: true, name: "graphql_index_reference_pairs"
end
```
Then run the migration:
```
$ bundle exec rake db:migrate
```
(You'll have to run that migration on any staging or production servers, too.)
Now, `OperationStore` has what it needs to save queries using ActiveRecord!
## Database Update
GraphQL-Pro 1.15.0 introduced new features for the OperationStore. To enable them, add some columns to your database:
```ruby
add_column :graphql_client_operations, :is_archived, :boolean, default: false
add_column :graphql_client_operations, :last_used_at, :datetime
```
## Updating `last_used_at`
By default, GraphQL-Pro updates `last_used_at` values in a background thread every 5 seconds. You can customize this by passing a number of seconds to `update_last_used_at_every:` when installing the OperationStore:
```ruby
use GraphQL::Pro::OperationStore, update_last_used_at_every: 1 # seconds
```
To update that column inline each time an operation is accessed, pass `0`.
|
