blob: d523236b5edd5dd496c93ef29baaa400fc1deb92 (
plain)
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
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
|
# == Schema Information
#
# Table name: info_requests
#
# id :integer not null, primary key
# title :text not null
# user_id :integer
# public_body_id :integer not null
# created_at :datetime not null
# updated_at :datetime not null
# described_state :string(255) not null
# awaiting_description :boolean default(FALSE), not null
# prominence :string(255) default("normal"), not null
# url_title :text not null
# law_used :string(255) default("foi"), not null
# allow_new_responses_from :string(255) default("anybody"), not null
# handle_rejected_responses :string(255) default("bounce"), not null
# idhash :string(255) not null
# external_user_name :string(255)
# external_url :string(255)
# attention_requested :boolean default(FALSE)
# comments_allowed :boolean default(TRUE), not null
# info_request_batch_id :integer
#
fancy_dog_request:
id: 101
title: Why do you have & such a fancy dog?
url_title: why_do_you_have_such_a_fancy_dog
created_at: 2007-10-11 18:15:57
updated_at: 2007-10-11 18:15:57
public_body_id: 2
user_id: 1
described_state: waiting_response
awaiting_description: true
comments_allowed: true
idhash: 50929748
naughty_chicken_request:
id: 103
title: How much public money is wasted on breeding naughty chickens?
url_title: how_much_public_money_is_wasted_o
created_at: 2007-10-13 18:15:57
updated_at: 2007-10-13 18:15:57
public_body_id: 2
user_id: 1
described_state: waiting_response
awaiting_description: false
comments_allowed: true
idhash: e8d18c84
badger_request:
id: 104
title: Are you really a badger?
url_title: are_you_really_a_badger
created_at: 2011-10-13 18:15:57
updated_at: 2011-10-13 18:15:57
public_body_id: 3
user_id: 1
described_state: waiting_response
awaiting_description: false
comments_allowed: true
idhash: e8d18c84
boring_request:
id: 105
title: The cost of boring
url_title: the_cost_of_boring
created_at: 2006-01-12 01:56:58.586598
updated_at: 2008-08-12 12:05:12.879634
public_body_id: 3
user_id: 1
described_state: successful
awaiting_description: false
comments_allowed: true
idhash: 173fd003
another_boring_request:
id: 106
title: The cost of boring
url_title: the_cost_of_boring_two # Not _2, because we want to avoid the search collapsing these two
created_at: 2006-01-12 01:56:58.586598
updated_at: 2007-11-13 18:09:20.042061
public_body_id: 5
user_id: 1
described_state: successful
awaiting_description: false
comments_allowed: true
idhash: 173fd004
# A pair of identical requests (with url_title differing only in the numeric suffix)
# used to test the request de-duplication features.
spam_1_request:
id: 107
title: Cheap v1agra
url_title: spam_1
created_at: 2010-01-01 01:23:45.6789100
updated_at: 2010-01-01 01:23:45.6789100
public_body_id: 5
user_id: 5
described_state: successful
awaiting_description: false
comments_allowed: false
idhash: 173fd005
spam_2_request:
id: 108
title: Cheap v1agra
url_title: spam_2
created_at: 2010-01-01 02:23:45.6789100
updated_at: 2010-01-01 02:23:45.6789100
public_body_id: 6
user_id: 5
described_state: successful
awaiting_description: false
comments_allowed: true
idhash: 173fd005
external_request:
id: 109
title: Balalas
url_title: balalas
external_user_name: Bob Smith
external_url: http://www.example.org/request/balala
public_body_id: 2
described_state: waiting_response
awaiting_description: false
comments_allowed: true
idhash: a1234567
anonymous_external_request:
id: 110
title: Anonymous request
url_title: anonymous_request
external_user_name:
external_url: http://www.example.org/request/anonymous_requesr
public_body_id: 2
described_state: waiting_response
awaiting_description: false
comments_allowed: true
idhash: 7654321a
other_request:
id: 111
title: Another request
url_title: another_request
created_at: 2010-01-01 02:23:45.6789100
updated_at: 2010-01-01 02:23:45.6789100
public_body_id: 7
user_id: 6
described_state: waiting_response
awaiting_description: false
comments_allowed: true
idhash: b234567
|