o #=Vc) @sddlmZddlmZmZmZddlZddlmZee Z ddZ e j ddd gd d d Z e j d gdd ddZe dkrHe jdddSdS))curdir)FlaskjsonifyrequestN)rec CsFd}ztd}W|Stjy"}z t|WYd}~|Sd}~ww)Nz books.sqlite)sqlite3connecterrorprint)conner D:\Flask\apiwithdb.py db_connection s rz/booksGETPOST)methodscCst}|}tjdkr"|d}dd|D}|dur"t|StjdkrNtjd}tjd}tjd}d }|||||f}|d |j d d fSdS) NrzSelect * from bookcSs,g|]}t|d|d|d|ddqS)ridauthorlanguagetitle)dict).0rowr r r 2szbooks..rrrrzN INSERT INTO book (author, language, title) VALUES (?,?,?) zBook with the id: z created successfully) rcursorrmethodexecutefetchallrformcommitZ lastrowid)r r booksZ new_authorrZ new_titlesqlr r rr&+s$      r&z/book/)rPUTDELETEc Cst}|}d}tjdkr,|d|f|}|D]}|}q|dur*t|dfSdStjdkr[d}tjd}tjd}tjd } |||| d } ||||| |f|t| Stjd krtd } || |f|d t |dfSdS)NrzSELECT * FROM book WHERE id=?zSomething wrongr(z9 UPDATE book SET title=?, author=?, language=? WHERE id=?rrrrr)z DELETE FROM book WHERE id=? z*the book with the id: {} has been deleted.) rr rr!r"r#rr$r%format) rr r Zbookrowsrr'rrrZ updated_bookZ sql_deleter r r single_bookFs<       r.__main__T)debug)osrflaskrrrrZ markupsafer__name__apprZrouter&r.runr r r rs    (