diff options
| -rw-r--r-- | scripts/fill.image_urls.py | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/scripts/fill.image_urls.py b/scripts/fill.image_urls.py index 7686ecf..952b7ea 100644 --- a/scripts/fill.image_urls.py +++ b/scripts/fill.image_urls.py @@ -12,14 +12,18 @@ def get_num_images_in_db(): return int(ps()[0][0]) def add_url(url): - print(url) + try: + print(url) + except UnicodeEncodeError: + print("i thought python 3 fixed the unicode shit. yet i still get unicode errors everywhere. GOOD JOB FUCKHEADS") ps = db.prepare("DELETE FROM image_urls WHERE url=$1") ps(url) ps2 = db.prepare("INSERT INTO image_urls(url) VALUES($1)") ps2(url) +# NOTE. hardcoded room numbers to index here... only indexing DUMPFM (1) and GIF (8) currently. def get_messages(lower, upper): - ps = db.prepare("SELECT content FROM messages WHERE message_id >= $1 AND message_id <= $2 ORDER BY message_id ASC") + ps = db.prepare("SELECT content FROM messages WHERE message_id >= $1 AND message_id <= $2 AND room_id IN (1,8) ORDER BY message_id ASC") rows = ps(lower, upper) return rows |