blob: 971ce0cc532a7d5e678232eed21f7c7e94f4b155 (
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
|
# == Schema Information
#
# Table name: outgoing_messages
#
# id :integer not null, primary key
# info_request_id :integer not null
# body :text not null
# status :string(255) not null
# message_type :string(255) not null
# created_at :datetime not null
# updated_at :datetime not null
# last_sent_at :datetime
# incoming_message_followup_id :integer
# what_doing :string(255) not null
#
useless_outgoing_message:
id: 1
info_request_id: 101
message_type: initial_request
status: sent
updated_at: 2007-10-12 01:56:58.586598
body: "Hi,\r\n\
\r\n\
Why do you have such a fancy dog?\r\n\
\r\n\
Thanks!\r\n\
\r\n\
Bob\r\n"
last_sent_at: 2007-10-25 10:41:12.686264
created_at: 2007-10-12 01:56:58.586598
what_doing: normal_sort
silly_outgoing_message:
id: 2
info_request_id: 103
message_type: initial_request
status: sent
updated_at: 2007-10-14 01:56:58.586598
body: "Hey you!\r\n\
\r\n\
I would like a complete breakdown of public sector\r\n\
spending on chickens by type of chicken. Specifically\r\n
I would like to know how much is spent on good \r\n
chickens and how much on naughty chickens.\r\n
\r\n\
Lovingly,\r\n\
\r\n\
Bob\r\n"
last_sent_at: 2007-10-14 10:41:12.686264
created_at: 2007-10-14 01:56:58.586598
what_doing: normal_sort
badger_outgoing_message:
id: 3
info_request_id: 104
message_type: initial_request
status: sent
updated_at: 2011-10-14 01:56:58.586598
body: "Is it true that you are really a badger, in fact?"
last_sent_at: 2011-10-14 10:41:12.686264
created_at: 2011-10-14 01:56:58.586598
what_doing: normal_sort
boring_outgoing_message:
id: 4
info_request_id: 105
message_type: initial_request
status: sent
updated_at: 2012-01-14 01:56:58.586598
body: "How much was spent on boring equipment in the 2010-2011 financial year?"
last_sent_at: 2012-01-14 10:41:12.686264
created_at: 2012-01-14 01:56:58.586598
what_doing: normal_sort
another_boring_outgoing_message:
id: 5
info_request_id: 106
message_type: initial_request
status: sent
body: "How much was spent on boring equipment in the 2010-2011 financial year?"
last_sent_at: 2006-01-12 01:57:58.586598
created_at: 2006-01-12 01:56:58.586598
updated_at: 2006-01-12 01:56:58.586598
what_doing: normal_sort
spam_1_outgoing_message:
id: 6
info_request_id: 107
message_type: initial_request
status: sent
body: "Would you like some cheap v1agra?"
last_sent_at: 2007-01-12 01:57:58.586598
created_at: 2007-01-12 01:56:58.586598
updated_at: 2007-01-12 01:56:58.586598
what_doing: normal_sort
spam_2_outgoing_message:
id: 7
info_request_id: 108
message_type: initial_request
status: sent
body: "Would you like some cheap v1agra?"
last_sent_at: 2007-01-12 02:57:58.586598
created_at: 2007-01-12 02:56:58.586598
updated_at: 2007-01-12 02:56:58.586598
what_doing: normal_sort
external_outgoing_message:
id: 8
info_request_id: 109
message_type: initial_request
status: sent
body: "I should like to know about balalas."
last_sent_at: 2009-01-12 01:57:58.586598
created_at: 2009-01-12 01:56:58.586598
updated_at: 2009-01-12 01:56:58.586598
what_doing: normal_sort
anonymous_external_outgoing_message:
id: 9
info_request_id: 110
message_type: initial_request
status: sent
body: "I do not wish to reveal my name, but would like all your information."
last_sent_at: 2009-01-12 01:57:58.586598
created_at: 2009-01-12 01:56:58.586598
updated_at: 2009-01-12 01:56:58.586598
what_doing: normal_sort
other_outgoing_message:
id: 10
info_request_id: 111
message_type: initial_request
status: sent
body: "Just another request"
last_sent_at: <%= Time.now %>
created_at: 2009-01-12 01:56:58.586598
updated_at: 2009-01-12 01:56:58.586598
what_doing: normal_sort
|
