python - input value for LIMIT(unitest) -
i'm confused on one. limit default none, if test in unitest , ask specific number of comments type mismatch. know "int" not correct term. i'm saying limit should integer. proper way of addressing input depending on limit in unitest.
def list_comments(db, limit=none): limit = "int" limit = "int" cur = db.cursor() cur.execute("select id, comment comments order id desc limit ?", (limit,)) results = cur.fetchall() print results return results
remove limit = "int"
behind function, , make limit
parameter default 0
, use placeholder %s
;
def list_comments(db, limit=0): cur = db.cursor() cur.execute("select id, comment comments order id desc limit %s", (str(limit))) results = cur.fetchall() print results return results
also remove comma if it's not needed yet; (limit,)
.
i've parsed limit value string on purpose (you can check if it's integer) let match %s
placeholder.
Comments
Post a Comment