code-boxx · May 2, 2024 04:02
diff --git a/0-PY-UPLOAD-DB.MD b/0-PY-UPLOAD-DB.MD
diff --git a/1a-database.sql b/1a-database.sql
 CREATE TABLE `storage` (
  `file_name` TEXT PRIMARY KEY,
  `file_mime` TEXT NOT NULL,
  `file_data` BLOB NOT NULL
 );
diff --git a/1b-create.py b/1b-create.py
 # (A) LOAD PACKAGES
 import sqlite3, os
 from sqlite3 import Error

 # (B) DATABASE + SQL FILE
 DBFILE = "demo.db"
 SQLFILE = "1a-database.sql"

 # (C) DELETE OLD DATABASE IF EXIST
 if os.path.exists(DBFILE):
  os.remove(DBFILE)

 # (D) IMPORT SQL
 conn = sqlite3.connect(DBFILE)
 with open(SQLFILE) as f:
  conn.executescript(f.read())
 conn.commit()
 conn.close()
 print("Database created!")
diff --git a/2-upload.html b/2-upload.html
 <!DOCTYPE html>
 <html>
  <head>
    <title>Upload File</title>
    <meta charset="utf-8">
    <link rel="stylesheet" href="static/x-dummy.css">
  </head>
  <body>
    <form method="post" action="/upload" target="_blank" enctype="multipart/form-data">
      <input type="file" name="upload" required>
      <input type="submit" name="submit" value="Upload File">
    </form>
  </body>
 </html>
diff --git a/3-server.py b/3-server.py
 # (A) INIT
 # (A1) LOAD MODULES
 from flask import Flask, render_template, request, make_response
 from werkzeug.utils import secure_filename
 import sqlite3
 
 # (A2) FLASK SETTINGS + INIT
 HOST_NAME = "localhost"
 HOST_PORT = 80
 app = Flask(__name__)
 # app.debug = True

 # (B) ENDPOINTS
 # (B1) FILE UPLOAD PAGE
 @app.route("/", methods=["GET", "POST"])
 def index():
  return render_template("2-upload.html")

 # (B2) SAVE UPLOADED FILE
 @app.route("/upload", methods = ["POST"])
 def saveup():
  # (B2-1) GET FILE INFO
  up = request.files["upload"]
  updata = up.read()
  upname = secure_filename(up.filename)
  upmime = up.content_type

  # (B2-2) SAVE INTO DATABASE
  conn = sqlite3.connect("demo.db")
  cursor = conn.cursor()
  cursor.execute(
    "REPLACE INTO storage (`file_name`, `file_mime`, `file_data`) VALUES (?,?,?)",
    (upname, upmime, updata)
  )
  conn.commit()
  conn.close()
  return "OK"

 # (B3) DOWNLOAD
 @app.route("/download", methods=["GET", "POST"])
 def dl():
  # (B3-1) GET FILE FROM DATABASE
  conn = sqlite3.connect("demo.db")
  cursor = conn.cursor()
  cursor.execute("SELECT * FROM storage WHERE `file_name`=?", ("vegetarian.png",))
  dbfile = cursor.fetchone()

  # (B3-2) FORCE DOWNLOAD
  response = make_response(dbfile[2], 200)
  response.headers["Content-type"] = dbfile[1]
  response.headers["Content-Transfer-Encoding"] = "Binary"
  response.headers["Content-Disposition"] = "attachment; filename=\"%s\"" % dbfile[0]
  return response

 # (C) START
 if __name__ == "__main__":
  app.run(HOST_NAME, HOST_PORT)
diff --git a/unpack.bat b/unpack.bat
 md templates
 md static
 move 2-upload.html templates
 move x-dummy.css static
 curl https://user-images.githubusercontent.com/11156244/280895847-3b52c85a-041b-4f11-bc1a-699dc31bf74a.png --ssl-no-revoke --output vegetarian.png
 virtualenv venv
 call venv\Scripts\activate
 pip install flask werkzeug
 python 1b-create.py
 python 3-server.py
diff --git a/unpack.sh b/unpack.sh
 mkdir -m 777 static
 mkdir -m 777 templates
 mv ./2-upload.html ./templates
 mv ./x-dummy.css ./static
 curl https://user-images.githubusercontent.com/11156244/280895847-3b52c85a-041b-4f11-bc1a-699dc31bf74a.png --ssl-no-revoke --output ./vegetarian.png
 virtualenv venv
 source "venv/bin/activate"
 pip install flask werkzeug
 python 1b-create.py
 python 3-server.py
diff --git a/x-dummy.css b/x-dummy.css
 /* NOT IMPORTANT */
 * {
  font-family: Arial, Helvetica, sans-serif;
  box-sizing: border-box;
 }
 body {
  max-width: 400px;
 }
 form {
  padding: 20px;
  border: 1px solid #ededed;
  background: #f2f2f2;
 }
 input, select {
  display: block;
  width: 100%;
  padding: 10px;
 }
 input[type=file], select {
  border: 1px solid #c9c9c9;
  background: #fff;
 }
 input[type=submit] {
  margin-top: 20px;
  border: 0;
  color: #fff;
  background: #3c56b7;
  cursor: pointer;
 }
 div.note {
  padding: 10px;
  margin-bottom: 20px;
  border: 1px solid #a9dfff;
  background: #edf7ff;
 }
	CREATE TABLE `storage` (
	`file_name` TEXT PRIMARY KEY,
	`file_mime` TEXT NOT NULL,
	`file_data` BLOB NOT NULL
	);
	# (A) LOAD PACKAGES
	import sqlite3, os
	from sqlite3 import Error

	# (B) DATABASE + SQL FILE
	DBFILE = "demo.db"
	SQLFILE = "1a-database.sql"

	# (C) DELETE OLD DATABASE IF EXIST
	if os.path.exists(DBFILE):
	os.remove(DBFILE)

	# (D) IMPORT SQL
	conn = sqlite3.connect(DBFILE)
	with open(SQLFILE) as f:
	conn.executescript(f.read())
	conn.commit()
	conn.close()
	print("Database created!")
	<!DOCTYPE html>
	<html>
	<head>
	<title>Upload File</title>
	<meta charset="utf-8">
	<link rel="stylesheet" href="static/x-dummy.css">
	</head>
	<body>
	<form method="post" action="/upload" target="_blank" enctype="multipart/form-data">
	<input type="file" name="upload" required>
	<input type="submit" name="submit" value="Upload File">
	</form>
	</body>
	</html>
	# (A) INIT
	# (A1) LOAD MODULES
	from flask import Flask, render_template, request, make_response
	from werkzeug.utils import secure_filename
	import sqlite3

	# (A2) FLASK SETTINGS + INIT
	HOST_NAME = "localhost"
	HOST_PORT = 80
	app = Flask(__name__)
	# app.debug = True

	# (B) ENDPOINTS
	# (B1) FILE UPLOAD PAGE
	@app.route("/", methods=["GET", "POST"])
	def index():
	return render_template("2-upload.html")

	# (B2) SAVE UPLOADED FILE
	@app.route("/upload", methods = ["POST"])
	def saveup():
	# (B2-1) GET FILE INFO
	up = request.files["upload"]
	updata = up.read()
	upname = secure_filename(up.filename)
	upmime = up.content_type

	# (B2-2) SAVE INTO DATABASE
	conn = sqlite3.connect("demo.db")
	cursor = conn.cursor()
	cursor.execute(
	"REPLACE INTO storage (`file_name`, `file_mime`, `file_data`) VALUES (?,?,?)",
	(upname, upmime, updata)
	)
	conn.commit()
	conn.close()
	return "OK"

	# (B3) DOWNLOAD
	@app.route("/download", methods=["GET", "POST"])
	def dl():
	# (B3-1) GET FILE FROM DATABASE
	conn = sqlite3.connect("demo.db")
	cursor = conn.cursor()
	cursor.execute("SELECT * FROM storage WHERE `file_name`=?", ("vegetarian.png",))
	dbfile = cursor.fetchone()

	# (B3-2) FORCE DOWNLOAD
	response = make_response(dbfile[2], 200)
	response.headers["Content-type"] = dbfile[1]
	response.headers["Content-Transfer-Encoding"] = "Binary"
	response.headers["Content-Disposition"] = "attachment; filename=\"%s\"" % dbfile[0]
	return response

	# (C) START
	if __name__ == "__main__":
	app.run(HOST_NAME, HOST_PORT)
	md templates
	md static
	move 2-upload.html templates
	move x-dummy.css static
	curl https://user-images.githubusercontent.com/11156244/280895847-3b52c85a-041b-4f11-bc1a-699dc31bf74a.png --ssl-no-revoke --output vegetarian.png
	virtualenv venv
	call venv\Scripts\activate
	pip install flask werkzeug
	python 1b-create.py
	python 3-server.py
	mkdir -m 777 static
	mkdir -m 777 templates
	mv ./2-upload.html ./templates
	mv ./x-dummy.css ./static
	curl https://user-images.githubusercontent.com/11156244/280895847-3b52c85a-041b-4f11-bc1a-699dc31bf74a.png --ssl-no-revoke --output ./vegetarian.png
	virtualenv venv
	source "venv/bin/activate"
	pip install flask werkzeug
	python 1b-create.py
	python 3-server.py
	/* NOT IMPORTANT */
	* {
	font-family: Arial, Helvetica, sans-serif;
	box-sizing: border-box;
	}
	body {
	max-width: 400px;
	}
	form {
	padding: 20px;
	border: 1px solid #ededed;
	background: #f2f2f2;
	}
	input, select {
	display: block;
	width: 100%;
	padding: 10px;
	}
	input[type=file], select {
	border: 1px solid #c9c9c9;
	background: #fff;
	}
	input[type=submit] {
	margin-top: 20px;
	border: 0;
	color: #fff;
	background: #3c56b7;
	cursor: pointer;
	}
	div.note {
	padding: 10px;
	margin-bottom: 20px;
	border: 1px solid #a9dfff;
	background: #edf7ff;
	}