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 @@
 DELETE FROM settings WHERE thing_id = 1234567890123456;
+DELETE FROM settings WHERE thing_id = 1234567890123457;
 DELETE FROM oauth_access_tokens WHERE id = 6543210987654321;
 DELETE FROM oauth_access_tokens WHERE id = 1234567890123456;
+DELETE FROM oauth_access_tokens WHERE id = 1234567890123457;
 DELETE FROM oauth_applications WHERE id = 1234567890123456;
 DELETE FROM users WHERE id = 1234567890123456;
+DELETE FROM users WHERE id = 1234567890123457;
 DELETE FROM accounts WHERE id = 1234567890123456;
+DELETE FROM accounts WHERE id = 1234567890123457;
 
 INSERT INTO accounts (
     id,
@@ -37,6 +41,37 @@ INSERT INTO users (
     'ja'  -- japanese locale for unicode testing :p
 );
 
+INSERT INTO accounts (
+    id,
+    username,
+    locked,
+    created_at,
+    updated_at
+) VALUES (
+    1234567890123457,
+    'mastodonpy_test_2',
+    't',
+    now(),
+    now()
+);
+
+INSERT INTO users (
+    id,
+    email,
+    account_id,
+    created_at,
+    updated_at,
+    confirmed_at,
+    locale
+) VALUES (
+    1234567890123457,
+    'mastodonpy_test_2@localhost:3000',
+    1234567890123457,
+    now(),
+    now(),
+    now(),
+    'ja'  -- japanese locale for unicode testing :p
+);
 
 INSERT INTO oauth_applications (
     id,
@@ -61,6 +96,7 @@ INSERT INTO oauth_applications (
     now(),
     now()
 );
+
 INSERT INTO oauth_access_tokens (
     id,
     token,
@@ -75,7 +111,16 @@ INSERT INTO oauth_access_tokens (
     1234567890123456,
     1234567890123456,
     now()
-), (
+),
+(
+    1234567890123457,
+    '__MASTODON_PY_TEST_ACCESS_TOKEN_3',
+    'read write follow push',
+    1234567890123456,
+    1234567890123457,
+    now()
+),
+(
     6543210987654321,
     '__MASTODON_PY_TEST_ACCESS_TOKEN_2',
     'read write follow push admin:read admin:write',
@@ -135,3 +180,56 @@ INSERT INTO settings (
     now(),
     now()
 );
+
+
+INSERT INTO settings (
+    id,
+    var,
+    value,
+    thing_type,
+    thing_id,
+    created_at,
+    updated_at
+) VALUES (
+    1234567890123459,
+    'notification_emails',
+    E'---\nfollow_request: false',
+    'User',
+    1234567890123457,
+    now(),
+    now()
+);
+INSERT INTO settings (
+    id, 
+    var, 
+    value, 
+    thing_type,
+    thing_id,
+    created_at,
+    updated_at
+) VALUES (
+    1234567890123460, 
+    'default_privacy', 
+    E'--- public\n...\n', 
+    'User',
+    1234567890123457,
+    now(),
+    now()
+);
+INSERT INTO settings (
+    id, 
+    var, 
+    value, 
+    thing_type,
+    thing_id,    
+    created_at, 
+    updated_at
+) VALUES (
+    1234567890123461,
+    'default_sensitive',
+    E'--- false\n...\n',
+    'User',
+    1234567890123457,
+    now(),
+    now()
+);