Skip to content

Instantly share code, notes, and snippets.

View smzn's full-sized avatar

smzn

2 followers · 0 following
View GitHub Profile
@smzn
smzn / gist:fd65dcfd72262fa27de547f40467328c
Created December 9, 2025 03:29
from flask import Flask, render_template
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
# ==========================================
# 1. データベース接続設定
# ==========================================
# 接続先の設定 (products データベースへ接続)
# ※パスワードやエンドポイントはご自身の環境に合わせて書き換えてください
@smzn
smzn / gist:7e14e7acee63ae910464bc5f9a7b86a9
Created December 9, 2025 02:40
# ==========================================
# 0. 事前準備 (ターミナルで実行)
# ==========================================
# 必要なライブラリをインストールします
# pip install flask flask-sqlalchemy mysql-connector-python
from flask import Flask, render_template
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
@smzn
smzn / gist:41f34fedf17aa2c9bcef1dc9713996f5
Created December 9, 2025 01:19
# ==========================================
# 0. 事前準備 (ターミナルで実行)
# ==========================================
# 必要なライブラリをインストールします
# pip install flask flask-sqlalchemy mysql-connector-python
from flask import Flask, render_template
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
@smzn
smzn / gist:c854d82e7713fef7dd1d29333b2a0f64
Created December 1, 2025 07:27
import pandas as pd
import mysql.connector
from mysql.connector import Error
import os
# データベース接続設定
DB_CONFIG = {
'host': 'endpoint',
'user': 'admin', # ← 変更してください
'password': 'LinuxOS99', # ← 変更してください
@smzn
smzn / gist:589fd8124055491e40857f97cd106b35
Last active December 1, 2025 07:22
-- データベース作成
CREATE DATABASE IF NOT EXISTS disaster_agreements_db DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
USE disaster_agreements_db;
-- 区分マスタテーブル
CREATE TABLE IF NOT EXISTS classifications (
id INT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
@smzn
smzn / gist:8ad291dc185ca17ca86db07450d8cb70
Created November 25, 2025 05:28
-- データベース作成
CREATE DATABASE IF NOT EXISTS disaster_agreements_db DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
USE disaster_agreements_db;
-- 区分マスタテーブル
CREATE TABLE IF NOT EXISTS classifications (
classification_id INT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
@smzn
smzn / gist:5b9084dc5c24090d42e0038a2cc2cfc4
Created November 18, 2025 02:51
<!DOCTYPE html>
<html lang="ja">
<head>
<meta charset="utf-8">
<title>{{ category.name }} | カテゴリ別アプリ一覧</title>
</head>
<body>
<h1>カテゴリ：{{ category.name }}</h1>
<h2>このカテゴリのアプリ一覧</h2>
@smzn
smzn / gist:3def269a1fd81da5b5019e2ffd1e44bf
Created November 18, 2025 02:50
<!DOCTYPE html>
<html lang="ja">
<head>
<meta charset="utf-8">
<title>{{ application.title }} | アプリ詳細</title>
</head>
<body>
<h1>{{ application.title }}</h1>
<p>カテゴリ：{{ application.category_name }}</p>
@smzn
smzn / gist:5e84dde00e706cff44c829e16a131aa0
Created November 18, 2025 02:48
<!DOCTYPE html>
<html lang="ja">
<head>
<meta charset="utf-8">
<title>アプリ一覧</title>
</head>
<body>
<h1>アプリ一覧</h1>
{% if applications %}
@smzn
smzn / gist:83a9f7a71122e90a41e425f66bf63e0a
Created November 17, 2025 06:55
from flask import Flask, render_template
import mysql.connector
app = Flask(__name__)
# データベース接続設定
db_config = {
'host': 'myendpoint.rds.amazonaws.com',
'user': 'admin', # あなたのMySQLユーザー名
'password': 'pass', # あなたのMySQLパスワード