8 files changed, 45 insertions, 27 deletions

diff --git a/src/util/connections/Connection.ts b/src/util/connections/Connection.ts
index 02104d39..e8d41c36 100644
--- a/src/util/connections/Connection.ts
+++ b/src/util/connections/Connection.ts
@@ -1,7 +1,7 @@
 import crypto from "crypto";
 import { ConnectedAccount } from "../entities";
 import { OrmUtils } from "../imports";
-import { ConnectionCallbackSchema } from "../schemas";
+import { ConnectedAccountSchema, ConnectionCallbackSchema } from "../schemas";
 import { DiscordApiErrors } from "../util";
 
 export default abstract class Connection {
@@ -54,7 +54,7 @@ export default abstract class Connection {
 		this.states.delete(state);
 	}
 
-	async createConnection(data: any): Promise<void> {
+	async createConnection(data: ConnectedAccountSchema): Promise<void> {
 		const ca = OrmUtils.mergeDeep(new ConnectedAccount(), data);
 		await ca.save();
 	}
diff --git a/src/util/connections/ConnectionConfig.ts b/src/util/connections/ConnectionConfig.ts
index 9b120c93..dd372ff7 100644
--- a/src/util/connections/ConnectionConfig.ts
+++ b/src/util/connections/ConnectionConfig.ts
@@ -21,7 +21,6 @@ export const ConnectionConfig = {
 	set: function set(val: Partial<any>) {
 		if (!config || !val) return;
 		config = val.merge(config);
-		console.debug("config", config); // TODO: if no more issues with sql, remove this or find the reason why it's happening
 
 		return applyConfig(config);
 	},
diff --git a/src/util/connections/ConnectionLoader.ts b/src/util/connections/ConnectionLoader.ts
index d06a6446..7467739c 100644
--- a/src/util/connections/ConnectionLoader.ts
+++ b/src/util/connections/ConnectionLoader.ts
@@ -23,7 +23,6 @@ export class ConnectionLoader {
 
 		dirs.forEach(async (x) => {
 			let modPath = path.resolve(path.join(root, x));
-			console.log(`Loading connection: ${modPath}`);
 			const mod = new (require(modPath).default)() as Connection;
 			ConnectionStore.connections.set(mod.id, mod);
 
@@ -55,11 +54,13 @@ export class ConnectionLoader {
 			console.log(
 				`[ConnectionConfig/WARN] ${id} tried to set config=null!`,
 			);
-		await ConnectionConfig.set({
+
+		const a = {
 			[id]: OrmUtils.mergeDeep(
 				ConnectionLoader.getConnectionConfig(id) || {},
 				config,
 			),
-		});
+		};
+		await ConnectionConfig.set(a);
 	}
 }
diff --git a/src/util/dtos/ConnectedAccountDTO.ts b/src/util/dtos/ConnectedAccountDTO.ts
index a0287086..36a4e6b3 100644
--- a/src/util/dtos/ConnectedAccountDTO.ts
+++ b/src/util/dtos/ConnectedAccountDTO.ts
@@ -4,17 +4,17 @@ export class ConnectedAccountDTO {
 	id: string;
 	user_id: string;
 	access_token?: string;
-	friend_sync: boolean;
+	friend_sync?: boolean;
 	name: string;
-	revoked: boolean;
-	show_activity: boolean;
+	revoked?: boolean;
+	show_activity?: boolean;
 	type: string;
-	verified: boolean;
-	visibility: boolean;
-	integrations: string[];
-	metadata_: any;
-	metadata_visibility: boolean;
-	two_way_link: boolean;
+	verified?: boolean;
+	visibility?: number;
+	integrations?: string[];
+	metadata_?: any;
+	metadata_visibility?: number;
+	two_way_link?: boolean;
 
 	constructor(
 		connectedAccount: ConnectedAccount,
diff --git a/src/util/entities/ConnectedAccount.ts b/src/util/entities/ConnectedAccount.ts
index 70923d2c..25d5a0c7 100644
--- a/src/util/entities/ConnectedAccount.ts
+++ b/src/util/entities/ConnectedAccount.ts
@@ -40,39 +40,39 @@ export class ConnectedAccount extends BaseClass {
 	})
 	user: User;
 
-	@Column({ select: false })
-	access_token: string;
+	@Column({ select: false, nullable: true })
+	access_token?: string;
 
 	@Column({ select: false })
-	friend_sync: boolean = false;
+	friend_sync?: boolean = false;
 
 	@Column()
 	name: string;
 
 	@Column({ select: false })
-	revoked: boolean = false;
+	revoked?: boolean = false;
 
 	@Column({ select: false })
-	show_activity: boolean = true;
+	show_activity?: boolean = true;
 
 	@Column()
 	type: string;
 
 	@Column()
-	verified: boolean;
+	verified?: boolean = true;
 
 	@Column({ select: false })
-	visibility: boolean = true;
+	visibility?: number = 0;
 
 	@Column({ type: "simple-array" })
-	integrations: string[];
+	integrations?: string[] = [];
 
-	@Column({ type: "simple-json", name: "metadata" })
-	metadata_: any;
+	@Column({ type: "simple-json", name: "metadata", nullable: true })
+	metadata_?: any;
 
 	@Column()
-	metadata_visibility: boolean = true;
+	metadata_visibility?: number = 0;
 
 	@Column()
-	two_way_link: boolean = false;
+	two_way_link?: boolean = false;
 }
diff --git a/src/util/index.ts b/src/util/index.ts
index a3495a0c..cb180ee8 100644
--- a/src/util/index.ts
+++ b/src/util/index.ts
@@ -25,3 +25,4 @@ export * from "./dtos/index";
 export * from "./schemas";
 export * from "./imports";
 export * from "./config";
+export * from "./connections"
\ No newline at end of file
diff --git a/src/util/schemas/ConnectedAccountSchema.ts b/src/util/schemas/ConnectedAccountSchema.ts
new file mode 100644
index 00000000..e00e4fa1
--- /dev/null
+++ b/src/util/schemas/ConnectedAccountSchema.ts
@@ -0,0 +1,16 @@
+export interface ConnectedAccountSchema {
+	external_id: string;
+	user_id: string;
+	access_token?: string;
+	friend_sync?: boolean;
+	name: string;
+	revoked?: boolean;
+	show_activity?: boolean;
+	type: string;
+	verified?: boolean;
+	visibility?: number;
+	integrations?: string[];
+	metadata_?: any;
+	metadata_visibility?: number;
+	two_way_link?: boolean;
+}
diff --git a/src/util/schemas/index.ts b/src/util/schemas/index.ts
index 2831d42a..71b4c2ce 100644
--- a/src/util/schemas/index.ts
+++ b/src/util/schemas/index.ts
@@ -30,6 +30,7 @@ export * from "./ChannelModifySchema";
 export * from "./ChannelPermissionOverwriteSchema";
 export * from "./ChannelReorderSchema";
 export * from "./CodesVerificationSchema";
+export * from "./ConnectedAccountSchema";
 export * from "./ConnectionCallbackSchema";
 export * from "./DmChannelCreateSchema";
 export * from "./EmojiCreateSchema";