Perform the exact same modification to your SQL statement due to the fact ahead of, after that change the past printing() form to show the item ID and the value of over :
None of the items could have been noted since the complete and so the property value accomplished for per goods try 0 , meaning that untrue . So that pages to improve which value and you may draw points since finished, might put an alternative approach to this new document.
New perform() evaluate means requires a keen id disagreement-this is the ID of one’s goods we want to mark as done. When you look at the function, you open a database commitment, then chances are you explore an improve SQL declaration to create the benefits of one’s complete line to at least one into items as designated just like the accomplished.
You employ the new ? placeholder about perform() means and you will admission an effective tuple that features the brand new ID to help you properly submit analysis into databases. You then going the order and you can personal the connection and you may reroute for the list page.
Shortly after incorporating a route to mark points because the accomplished, you desire several other approach to undo this step and you can go back the newest items so you’re able to a non-completed standing.
This channel is a lot like brand new /do/ channel, while the undo() view means is strictly like the fresh new perform() means apart from you place the worth of done to 0 in lieu of step 1 .
You now you want a key in order to mark to help you-create situations given that finished otherwise uncompleted with respect to the state away from the item, discover brand new index.html template document:
In this for cycle, you utilize a line-as a consequence of CSS value toward text message-design assets in the event your item is designated as completed, that you see on value of goods[‘done’] . Then you use the Jinja syntax set to state a couple of details, Hyperlink and Option . In case your items isn’t marked since accomplished the brand new option often have the really worth Perform plus the Url will lead towards the /do/ station, incase the thing is marked given that accomplished, the fresh switch will have a worth of Undo and can part so you’re able to /undo/ . Once, make use of these two variables during the an insight function you to submits ideal consult with respect to the condition of one’s items.
Add the adopting the station at the end of new document:
You can now mark activities since complete on the directory webpage . Next you can truly add the capability to edit in order to-carry out things.
Step three – Modifying To help you-Create Points
Within action, you are going to put yet another webpage to possess editing facts so that you can modify the www.datingranking.net/fr/rencontres-dans-la-trentaine/ fresh belongings in each items and you will designate things to some other listings.
You’ll put another /edit/ approach to the newest file, that’ll provide yet another modify.code where a person can transform existing items. Additionally modify this new index.html document to include an edit switch every single item.
Within this new evaluate form, you utilize the id dispute to fetch the ID of the to-manage goods we wish to revise, the ID of the list they falls under, the worth of the newest over line, the content of your own item, and listing title having fun with an effective SQL Sign up . It can save you these records in the todo varying. Then you certainly score all the so you can-create listings in the databases and you can save yourself them on the directories varying.
In case your consult is a frequent Score consult, the issue in the event that consult.method == ‘POST’ will not manage, therefore the application runs the past provide_template() function, passing each other todo and you will directories to help you a change.html file.
In the event that however, a type are filed, the challenge demand.method == ‘POST’ gets real , then you definitely pull the message as well as the number label an individual filed. If zero content was recorded, your flash the message Content is necessary! and redirect on the same modify web page. Or even, your fetch the brand new ID of your own record the user submitted; this enables the user to maneuver a towards-create product in one checklist to some other. Upcoming, make use of an upgrade SQL declaration to set the content out of the newest so you can-perform product with the the latest posts the consumer registered. You are doing an equivalent with the listing ID. Finally, your commit the changes and you can close the partnership, and you can redirect an individual into the index page.
