projects
/
mercuryms.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
de99d6c
)
Write media URLs to database, not media to disk
author
Jacob Casper
<dev@jacobcasper.com>
Fri, 3 Apr 2020 06:20:39 +0000
(
01:20
-0500)
committer
Jacob Casper
<dev@jacobcasper.com>
Sun, 5 Apr 2020 08:28:15 +0000
(
03:28
-0500)
mms-download.py
patch
|
blob
|
blame
|
history
diff --git
a/mms-download.py
b/mms-download.py
index
86c2a3d
..
eb03ae3
100644
(file)
--- a/
mms-download.py
+++ b/
mms-download.py
@@
-1,5
+1,5
@@
import os
import os
-import
requests
+import
sqlite3
from flask import Flask, request
from twilio.twiml.messaging_response import MessagingResponse
from flask import Flask, request
from twilio.twiml.messaging_response import MessagingResponse
@@
-8,12
+8,17
@@
app = Flask(__name__)
@app.route("/mms", methods=['POST'])
def sms_reply():
"""Respond to incoming multimedia messages with a confirmed download text."""
@app.route("/mms", methods=['POST'])
def sms_reply():
"""Respond to incoming multimedia messages with a confirmed download text."""
+ sender = request.form['From']
if request.form['NumMedia'] is not None:
urls = [request.form['MediaUrl' + str(idx)] for idx in range(int(request.form['NumMedia']))]
if request.form['NumMedia'] is not None:
urls = [request.form['MediaUrl' + str(idx)] for idx in range(int(request.form['NumMedia']))]
- photos = {url.split("/")[-1]: requests.get(url) for url in urls}
- for identifier, photo in photos.items():
- with open(identifier + '.jpg', 'wb') as f:
- f.write(photo.content)
+
+ conn = sqlite3.connect("mercuryms.sqlite")
+ cursor = conn.cursor()
+ for url in urls:
+ cursor.execute('INSERT INTO MEDIA (PHONE_NUMBER, URI) VALUES (?, ?)', (sender, url))
+ conn.commit()
+ conn.close()
+
resp = MessagingResponse()
resp.message("Upload received!")
return str(resp)
resp = MessagingResponse()
resp.message("Upload received!")
return str(resp)