From c576c003716851863c832b5e0dacb9186516f167 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Wed, 19 Jul 2023 23:50:14 +0300
Subject: Migrate to Twitter API 2.0

---
 src/main/resources/db/migration/V1.48__twitter_refresh_token.sql | 1 +
 src/main/resources/schema-h2.sql                                 | 1 +
 src/main/resources/schema-mysql.sql                              | 1 +
 src/main/resources/schema-sqlite.sql                             | 1 +
 src/main/resources/schema-sqlserver.sql                          | 1 +
 src/main/resources/templates/views/post.html                     | 3 +++
 6 files changed, 8 insertions(+)
 create mode 100644 src/main/resources/db/migration/V1.48__twitter_refresh_token.sql

(limited to 'src/main/resources')

diff --git a/src/main/resources/db/migration/V1.48__twitter_refresh_token.sql b/src/main/resources/db/migration/V1.48__twitter_refresh_token.sql
new file mode 100644
index 00000000..a01efb64
--- /dev/null
+++ b/src/main/resources/db/migration/V1.48__twitter_refresh_token.sql
@@ -0,0 +1 @@
+alter table twitter add column refresh_token character varying(255) not null default '';
\ No newline at end of file
diff --git a/src/main/resources/schema-h2.sql b/src/main/resources/schema-h2.sql
index 97b16799..7aaee493 100644
--- a/src/main/resources/schema-h2.sql
+++ b/src/main/resources/schema-h2.sql
@@ -212,6 +212,7 @@ CREATE MEMORY TABLE "PUBLIC"."FACEBOOK"(
 CREATE MEMORY TABLE "PUBLIC"."TWITTER"(
     "USER_ID" INTEGER NOT NULL,
     "ACCESS_TOKEN" CHARACTER VARYING(255),
+    "REFRESH_TOKEN" CHARACTER VARYING(255) NOT NULL DEFAULT '',
     "ACCESS_TOKEN_SECRET" CHARACTER(64) NOT NULL,
     "UNAME" CHARACTER(64) NOT NULL,
     "TS" TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
diff --git a/src/main/resources/schema-mysql.sql b/src/main/resources/schema-mysql.sql
index 0bee0ed6..0e035d5e 100644
--- a/src/main/resources/schema-mysql.sql
+++ b/src/main/resources/schema-mysql.sql
@@ -517,6 +517,7 @@ DROP TABLE IF EXISTS `twitter`;
 CREATE TABLE `twitter` (
   `user_id` int(10) unsigned NOT NULL,
   `access_token` varchar(255) DEFAULT NULL,
+  `refresh_token` varchar(255) NOT NULL DEFAULT '',
   `access_token_secret` char(64) NOT NULL,
   `uname` char(64) NOT NULL,
   `ts` timestamp NOT NULL DEFAULT current_timestamp(),
diff --git a/src/main/resources/schema-sqlite.sql b/src/main/resources/schema-sqlite.sql
index 2b32635e..b0858f1b 100644
--- a/src/main/resources/schema-sqlite.sql
+++ b/src/main/resources/schema-sqlite.sql
@@ -211,6 +211,7 @@ CREATE TABLE telegram (
 CREATE TABLE twitter (
     user_id INTEGER NOT NULL,
     access_token character varying(64) NOT NULL,
+    refresh_token character varying(255) NOT NULL DEFAULT '',
     access_token_secret character varying(64) NOT NULL,
     uname character varying(64) NOT NULL,
     ts DEFAULT (strftime('%s','now') || substr(strftime('%f','now'),4)) NOT NULL,
diff --git a/src/main/resources/schema-sqlserver.sql b/src/main/resources/schema-sqlserver.sql
index 11e07b7b..947e5403 100644
--- a/src/main/resources/schema-sqlserver.sql
+++ b/src/main/resources/schema-sqlserver.sql
@@ -223,6 +223,7 @@ CREATE TABLE telegram (
 CREATE TABLE twitter (
     user_id bigint NOT NULL,
     access_token character varying(64) NOT NULL,
+    refresh_token character varying(255) NOT NULL DEFAULT '',
     access_token_secret character varying(64) NOT NULL,
     uname character varying(64) NOT NULL,
     ts datetimeoffset DEFAULT CURRENT_TIMESTAMP NOT NULL,
diff --git a/src/main/resources/templates/views/post.html b/src/main/resources/templates/views/post.html
index a77fa3bd..10f1ccb0 100644
--- a/src/main/resources/templates/views/post.html
+++ b/src/main/resources/templates/views/post.html
@@ -2,6 +2,9 @@
 {% import "views/macros/tags" %}
 {% block content %}
 <article>
+{%if twitter1 %}
+    <h2 style="color: red; padding: 20px;">Reconnect or disable your Twitter account</h2>
+{% endif %}
 <form id="postmsg">
     <p style="text-align: left;">
         <b>Фото:</b> <span id="attachmentfile">
-- 
cgit v1.2.3