diff options
author | Lorenz Diener <[email protected]> | 2019-06-22 23:16:47 +0200 |
---|---|---|
committer | Lorenz Diener <[email protected]> | 2019-06-22 23:16:47 +0200 |
commit | 225c8ca76a8fc6eb2a87a8156b7ce808d3b06507 (patch) | |
tree | 58a331db57609ca038d9428f27b064a4c1b32854 /tests/setup.sql | |
parent | f920f8b58429b5d7dea43442765df824ac04bf91 (diff) | |
download | mastodon.py-225c8ca76a8fc6eb2a87a8156b7ce808d3b06507.tar.gz |
Fresh batch of test runs
Diffstat (limited to 'tests/setup.sql')
-rw-r--r-- | tests/setup.sql | 100 |
1 files changed, 99 insertions, 1 deletions
diff --git a/tests/setup.sql b/tests/setup.sql index 591f4d0..74b1d80 100644 --- a/tests/setup.sql +++ b/tests/setup.sql | |||
@@ -1,9 +1,13 @@ | |||
1 | DELETE FROM settings WHERE thing_id = 1234567890123456; | 1 | DELETE FROM settings WHERE thing_id = 1234567890123456; |
2 | DELETE FROM settings WHERE thing_id = 1234567890123457; | ||
2 | DELETE FROM oauth_access_tokens WHERE id = 6543210987654321; | 3 | DELETE FROM oauth_access_tokens WHERE id = 6543210987654321; |
3 | DELETE FROM oauth_access_tokens WHERE id = 1234567890123456; | 4 | DELETE FROM oauth_access_tokens WHERE id = 1234567890123456; |
5 | DELETE FROM oauth_access_tokens WHERE id = 1234567890123457; | ||
4 | DELETE FROM oauth_applications WHERE id = 1234567890123456; | 6 | DELETE FROM oauth_applications WHERE id = 1234567890123456; |
5 | DELETE FROM users WHERE id = 1234567890123456; | 7 | DELETE FROM users WHERE id = 1234567890123456; |
8 | DELETE FROM users WHERE id = 1234567890123457; | ||
6 | DELETE FROM accounts WHERE id = 1234567890123456; | 9 | DELETE FROM accounts WHERE id = 1234567890123456; |
10 | DELETE FROM accounts WHERE id = 1234567890123457; | ||
7 | 11 | ||
8 | INSERT INTO accounts ( | 12 | INSERT INTO accounts ( |
9 | id, | 13 | id, |
@@ -37,6 +41,37 @@ INSERT INTO users ( | |||
37 | 'ja' -- japanese locale for unicode testing :p | 41 | 'ja' -- japanese locale for unicode testing :p |
38 | ); | 42 | ); |
39 | 43 | ||
44 | INSERT INTO accounts ( | ||
45 | id, | ||
46 | username, | ||
47 | locked, | ||
48 | created_at, | ||
49 | updated_at | ||
50 | ) VALUES ( | ||
51 | 1234567890123457, | ||
52 | 'mastodonpy_test_2', | ||
53 | 't', | ||
54 | now(), | ||
55 | now() | ||
56 | ); | ||
57 | |||
58 | INSERT INTO users ( | ||
59 | id, | ||
60 | email, | ||
61 | account_id, | ||
62 | created_at, | ||
63 | updated_at, | ||
64 | confirmed_at, | ||
65 | locale | ||
66 | ) VALUES ( | ||
67 | 1234567890123457, | ||
68 | 'mastodonpy_test_2@localhost:3000', | ||
69 | 1234567890123457, | ||
70 | now(), | ||
71 | now(), | ||
72 | now(), | ||
73 | 'ja' -- japanese locale for unicode testing :p | ||
74 | ); | ||
40 | 75 | ||
41 | INSERT INTO oauth_applications ( | 76 | INSERT INTO oauth_applications ( |
42 | id, | 77 | id, |
@@ -61,6 +96,7 @@ INSERT INTO oauth_applications ( | |||
61 | now(), | 96 | now(), |
62 | now() | 97 | now() |
63 | ); | 98 | ); |
99 | |||
64 | INSERT INTO oauth_access_tokens ( | 100 | INSERT INTO oauth_access_tokens ( |
65 | id, | 101 | id, |
66 | token, | 102 | token, |
@@ -75,7 +111,16 @@ INSERT INTO oauth_access_tokens ( | |||
75 | 1234567890123456, | 111 | 1234567890123456, |
76 | 1234567890123456, | 112 | 1234567890123456, |
77 | now() | 113 | now() |
78 | ), ( | 114 | ), |
115 | ( | ||
116 | 1234567890123457, | ||
117 | '__MASTODON_PY_TEST_ACCESS_TOKEN_3', | ||
118 | 'read write follow push', | ||
119 | 1234567890123456, | ||
120 | 1234567890123457, | ||
121 | now() | ||
122 | ), | ||
123 | ( | ||
79 | 6543210987654321, | 124 | 6543210987654321, |
80 | '__MASTODON_PY_TEST_ACCESS_TOKEN_2', | 125 | '__MASTODON_PY_TEST_ACCESS_TOKEN_2', |
81 | 'read write follow push admin:read admin:write', | 126 | 'read write follow push admin:read admin:write', |
@@ -135,3 +180,56 @@ INSERT INTO settings ( | |||
135 | now(), | 180 | now(), |
136 | now() | 181 | now() |
137 | ); | 182 | ); |
183 | |||
184 | |||
185 | INSERT INTO settings ( | ||
186 | id, | ||
187 | var, | ||
188 | value, | ||
189 | thing_type, | ||
190 | thing_id, | ||
191 | created_at, | ||
192 | updated_at | ||
193 | ) VALUES ( | ||
194 | 1234567890123459, | ||
195 | 'notification_emails', | ||
196 | E'---\nfollow_request: false', | ||
197 | 'User', | ||
198 | 1234567890123457, | ||
199 | now(), | ||
200 | now() | ||
201 | ); | ||
202 | INSERT INTO settings ( | ||
203 | id, | ||
204 | var, | ||
205 | value, | ||
206 | thing_type, | ||
207 | thing_id, | ||
208 | created_at, | ||
209 | updated_at | ||
210 | ) VALUES ( | ||
211 | 1234567890123460, | ||
212 | 'default_privacy', | ||
213 | E'--- public\n...\n', | ||
214 | 'User', | ||
215 | 1234567890123457, | ||
216 | now(), | ||
217 | now() | ||
218 | ); | ||
219 | INSERT INTO settings ( | ||
220 | id, | ||
221 | var, | ||
222 | value, | ||
223 | thing_type, | ||
224 | thing_id, | ||
225 | created_at, | ||
226 | updated_at | ||
227 | ) VALUES ( | ||
228 | 1234567890123461, | ||
229 | 'default_sensitive', | ||
230 | E'--- false\n...\n', | ||
231 | 'User', | ||
232 | 1234567890123457, | ||
233 | now(), | ||
234 | now() | ||
235 | ); | ||