aboutsummaryrefslogtreecommitdiff
blob: 0ff6da009f25ef98d324c6fa8517eb1a53604b68 (plain) (blame)
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
DELETE FROM settings WHERE id = 1234567890123456;
DELETE FROM oauth_access_tokens WHERE id = 6543210987654321;
DELETE FROM oauth_access_tokens WHERE id = 1234567890123456;
DELETE FROM oauth_applications WHERE id = 1234567890123456;
DELETE FROM users WHERE id = 1234567890123456;
DELETE FROM accounts WHERE id = 1234567890123456;

INSERT INTO accounts (
    id,
    username,
    locked,
    created_at,
    updated_at
) VALUES (
    1234567890123456,
    'mastodonpy_test',
    't',
    now(),
    now()
);

INSERT INTO users (
    id,
    email,
    account_id,
    created_at,
    updated_at,
    confirmed_at,
    locale
) VALUES (
    1234567890123456,
    'mastodonpy_test@localhost:3000',
    1234567890123456,
    now(),
    now(),
    now(),
    'ja'  -- japanese locale for unicode testing :p
);



INSERT INTO oauth_applications (
    id,
    name,
    uid,
    secret,
    redirect_uri,
    scopes,
    owner_type,
    owner_id,
    created_at,
    updated_at
) VALUES (
    1234567890123456,
    'Mastodon.py test suite',
    '__MASTODON_PY_TEST_CLIENT_ID',
    '__MASTODON_PY_TEST_CLIENT_SECRET',
    'urn:ietf:wg:oauth:2.0:oob',
    'read write follow',
    'User',
    1234567890123456,
    now(),
    now()
);

INSERT INTO oauth_access_tokens (
    id,
    token,
    scopes,
    application_id,
    resource_owner_id,
    created_at
) VALUES (
    1234567890123456,
    '__MASTODON_PY_TEST_ACCESS_TOKEN',
    'read write follow',
    1234567890123456,
    1234567890123456,
    now()
), (
    6543210987654321,
    '__MASTODON_PY_TEST_ACCESS_TOKEN_2',
    'read write follow',
    1234567890123456,
    1,
    now()
);

INSERT INTO settings (
    id,
    var,
    value,
    thing_type,
    thing_id,
    created_at,
    updated_at
) VALUES (
    1234567890123456,
    'notification_emails',
    E'---\nfollow_request: false',
    'User',
    1234567890123456,
    now(),
    now()
)
Powered by cgit v1.2.3 (git 2.41.0)