Created
September 17, 2024 12:30
-
-
Save thewh1teagle/f6d065c09dab7afbae50ac4bb7fd0a0a to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import { remember } from "@epic-web/remember"; | |
import mysql from "mysql2/promise"; | |
import "./config"; | |
import { Player } from "./types"; | |
import { nomrmalizeNumber } from "./utils"; | |
var conn: mysql.Connection; | |
export async function initMySQL() { | |
conn = await remember("mysql", async () => { | |
return await mysql.createConnection({ | |
host: process.env.WP_MYSQL_HOST, | |
user: process.env.WP_MYSQL_USERNAME, | |
password: process.env.WP_MYSQL_PASSWORD, | |
database: process.env.WP_MYSQL_DB, | |
charset: "utf8mb4", // Use utf8mb4 to support a wider range of Unicode characters | |
}); | |
}); | |
} | |
// config | |
import dotenv from "dotenv"; | |
import invariant from "tiny-invariant"; | |
dotenv.config({ path: ".env" }); | |
invariant(process.env.WP_MYSQL_HOST, "WP_MYSQL_HOST must be set in .env!"); | |
invariant(process.env.WP_MYSQL_DB, "WP_MYSQL_DB must be set in .env!"); | |
invariant( | |
process.env.WP_MYSQL_USERNAME, | |
"WP_MYSQL_USERNAME must be set in .env!" | |
); | |
invariant( | |
process.env.WP_MYSQL_PASSWORD, | |
"WP_MYSQL_PASSWORD must be set in .env!" | |
); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment