1 files changed, 37 insertions, 0 deletions

diff --git a/tests/setup_app.sql b/tests/setup_app.sql
new file mode 100644
index 0000000..b9f3db9
--- /dev/null
+++ b/tests/setup_app.sql
@@ -0,0 +1,37 @@
+WITH new_app AS (
+    INSERT INTO oauth_applications (
+            name,
+            uid,
+            secret,
+            redirect_uri,
+            scopes,
+            owner_type,
+            owner_id,
+            created_at,
+            updated_at
+        ) VALUES (
+            'Mastodon.py test suite',
+            '__MASTODON_PY_TEST_ID',
+            '__MASTODON_PY_TEST_SECRET',
+            'urn:itef:wg:oauth:2.0:oob',
+            'read write follow',
+            'User',
+            1,
+            now(),
+            now()
+        )
+    RETURNING id
+)
+INSERT INTO oauth_access_tokens (
+    token,
+    scopes,
+    application_id,
+    resource_owner_id,
+    created_at
+) SELECT
+    '__MASTODON_PY_TEST_TOKEN',
+    'read write follow',
+    new_app.id,
+    1,
+    now()
+FROM new_app;