<prompt> Unda programu ya wavuti ya Pyramid ambayo inaruhusu watumiaji kuongeza, kuhariri, na kufuta madokezo yenye kichwa na maudhui, na kuyahifadhi katika hifadhidata ya SQLite. PLINFORMAT  <response>: kuagiza oskutoka kwa pyramid.config import Configuratorkutoka kwa pyramid.response import Responsekutoka kwa pyramid.view import view_configkutoka kwa seva ya wsgiref.simple_server make_serverkutoka kwa piramidi.httpisipokuwa ingiza HTTPFoundkuagiza sqlite3def init_db: conn sqlite3.connectnotes.db c conn.cursor c.tekelezaTENGENEZA JEDWALI IKIWA HAIPO id INTEGER PRIMARY KEY, title TEXT, content TEXT conn.commit conn.closeinit_dbview_configroute_namenyumbani, renderertemplateshome.jinja2def nyumbani ombi: conn sqlite3.connectnotes.db c conn.cursor c.row_factory sqlite3.Row c.execute CHAGUA KUTOKA kwa vidokezo matokeo c.fetchall conn.close rudisha noti: matokeoview_configroute_nameadd_note, request_methodPOSTdef add_noteombi: title request.POST.gettitle content request.POST.getcontent conn sqlite3.connectnotes.db c conn.cursor c.tekelezaINGIZA MADOKEZO kichwa, maudhui THAMANI ?, ?, kichwa, maudhui conn.commit conn.close rudisha HTTPFoundlocationrequest.route_urlnyumbaniview_configroute_nameedit_note, request_methodPOSTdef edit_noteombi: note_id intrequest.matchdictid title request.POST.gettitle content request.POST.getcontent conn sqlite3.connectnotes.db c conn.cursor c.executeSASISHA madokezo SET title?, content? WAPI id?, kichwa, maudhui, dokezo_id conn.commit conn.close rudisha HTTPFoundlocationrequest.route_urlnyumbaniview_configroute_namedelete_note, request_methodPOSTdef delete_noteombi: note_id intrequest.matchdictid conn sqlite3.connectnotes.db c conn.cursor c.executeFUTA KUTOKA MADOKEZO WAPI id?, kumbuka_id, conn.commit conn.close rudisha HTTPFoundlocationrequest.route_urlnyumbanikama __name__ __main__: mipangilio pakia_yote upya: Kweli, suluhisha_yote: Kweli, jinja2.directories: os.path.joinos.path.dirname__file__, templates, config Configuratormipangiliomipangilio config.includepyramid_jinja2 config.add_routenyumbani, config.add_routeadd_note, add_note config.add_routeedit_note, edit_noteid config.add_routedelete_note, delete_noteid config.scan app config.make_wsgi_app seva make_server0.0.0.0, 6543, programu server.serve_forever 