def ean_add_to_db(ean):
res = query_db("SELECT * FROM inventory WHERE ean=:ean", {"ean": ean})
if len(res) >= 1:
d = res[0]
else:
d = resolve_ean(ean, "images")
d["added"] = datetime.datetime.now().strftime("%Y-%m-%d %H:%M")
if isinstance(d["artists"], list):
d["artists"] = ",".join(d["artists"])
insert_from_dict("inventory", d, {"type": "category"}, ["imgurl"])
return d
def errors():
cur = get_db().cursor()
#Process POST data when available
resolved_data = []
for oldean, newean in request.form.items():
if newean.strip() != "":
d = resolve_ean(newean, "images")
resolved_data.append(d)
cur.execute("UPDATE inventory SET title=:title, description=:description, duration=:duration, imgfile=:imgfile, studio=:studio WHERE ean=:ean", d)
get_db().commit()
cur.execute("SELECT ean FROM inventory WHERE title IS NULL")
unsorteditems = cur.fetchall()
return render_template("errors.html", eanlist=unsorteditems, resolved_data=resolved_data)
from ean_resolve import resolve_ean
import pathlib
EANS = [
4010232055620,
4010232046369,
5050582871753,
5051890139610,
4045167004429
]
if __name__ == "__main__":
# try:
dl_dir = "images"
dl_dir_path = pathlib.Path(dl_dir)
if not dl_dir_path.exists():
dl_dir_path.mkdir()
for ean in EANS:
print(resolve_ean(ean, dl_dir=dl_dir))
# except:
# import pdb;
# pdb.post_mortem()
import sqlite3
from ean_resolve import resolve_ean, EANNotResolved
#EAN-Liste generieren
db = sqlite3.connect("test.db")
cur = db.cursor()
cur.execute("SELECT ean FROM movies")
eans = [e[0] for e in cur.fetchall()]
import pprint; pprint.pprint(eans)
for ean in eans:
try:
dvd_movie = resolve_ean(ean, dl_dir="images")
cur.execute("UPDATE movies SET title=?, artists=?, duration=?, imgfile=?, studio=?, description=? WHERE ean=?", (dvd_movie["title"], ", ".join(dvd_movie["artists"]) if "artists" in dvd_movie else None, dvd_movie["duration"], dvd_movie["imgfile"], dvd_movie["studio"], dvd_movie["description"], dvd_movie["ean"]))
db.commit()
print("Updating EAN = ", ean)
except Exception as e:
print("EAN {} could not be resolved!".format(ean))
print(e)
