{"id":12059,"date":"2022-06-21T17:48:51","date_gmt":"2022-06-21T15:48:51","guid":{"rendered":"https:\/\/pythonprogramming.altervista.org\/?p=12059"},"modified":"2022-06-21T17:51:35","modified_gmt":"2022-06-21T15:51:35","slug":"pyscript-using-sqlite-with-pyscript","status":"publish","type":"post","link":"https:\/\/pythonprogramming.altervista.org\/pyscript-using-sqlite-with-pyscript\/","title":{"rendered":"Pyscript: using sqlite with Pyscript"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-3.png\"><img loading=\"lazy\" decoding=\"async\" width=\"849\" height=\"272\" src=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-3.png\" alt=\"\" class=\"wp-image-12060\" srcset=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-3.png 849w, https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-3-320x103.png 320w, https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-3-768x246.png 768w\" sizes=\"auto, (max-width: 849px) 100vw, 849px\" \/><\/a><figcaption>import pandas<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-4.png\"><img loading=\"lazy\" decoding=\"async\" width=\"621\" height=\"187\" src=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-4.png\" alt=\"\" class=\"wp-image-12061\" srcset=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-4.png 621w, https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-4-320x96.png 320w\" sizes=\"auto, (max-width: 621px) 100vw, 621px\" \/><\/a><figcaption>here we will put the output, into the div called csv<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-5.png\"><img loading=\"lazy\" decoding=\"async\" width=\"507\" height=\"353\" src=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-5.png\" alt=\"\" class=\"wp-image-12062\" srcset=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-5.png 507w, https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-5-320x223.png 320w\" sizes=\"auto, (max-width: 507px) 100vw, 507px\" \/><\/a><figcaption>Let&#8217;s import this stuff<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-6.png\"><img loading=\"lazy\" decoding=\"async\" width=\"960\" height=\"116\" src=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-6-960x116.png\" alt=\"\" class=\"wp-image-12063\" srcset=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-6-960x116.png 960w, https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-6-320x39.png 320w, https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-6-768x93.png 768w, https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-6.png 970w\" sizes=\"auto, (max-width: 960px) 100vw, 960px\" \/><\/a><figcaption>let&#8217;s get some data<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-7.png\"><img loading=\"lazy\" decoding=\"async\" width=\"499\" height=\"209\" src=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-7.png\" alt=\"\" class=\"wp-image-12064\" srcset=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-7.png 499w, https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-7-320x134.png 320w\" sizes=\"auto, (max-width: 499px) 100vw, 499px\" \/><\/a><figcaption>we create the database and the connection to the db (and we create a table?)<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-8.png\"><img loading=\"lazy\" decoding=\"async\" width=\"678\" height=\"83\" src=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-8.png\" alt=\"\" class=\"wp-image-12065\" srcset=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-8.png 678w, https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-8-320x39.png 320w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/a><figcaption>we get a dataframe out of the diamonds table<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-9.png\"><img loading=\"lazy\" decoding=\"async\" width=\"361\" height=\"235\" src=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-9.png\" alt=\"\" class=\"wp-image-12066\" srcset=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-9.png 361w, https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-9-320x208.png 320w\" sizes=\"auto, (max-width: 361px) 100vw, 361px\" \/><\/a><figcaption>let&#8217;s print the dataframe<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Code 1<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;html>\n\n&lt;head>\n\n&lt;title>\n\nRead CSV with Pandas using PyScript\n    \n&lt;\/title>\n\n&lt;link rel=\"stylesheet\" href=\"https:\/\/pyscript.net\/alpha\/pyscript.css\" \/>\n&lt;script defer src=\"https:\/\/pyscript.net\/alpha\/pyscript.js\">&lt;\/script>\n\n&lt;!---pyodide--> \n\n&lt;py-env>\n    - pandas\n&lt;\/py-env>\n\n&lt;\/head>\n\n&lt;body>\n    \n    &lt;h1>Read CSV with Pandas using PyScript&lt;\/h1>\n\n    &lt;p id=\"csv\">&lt;\/p>\n\n    &lt;py-script>\n\n        import pandas as pd \n\n        import sqlite3 as sql\n\n\n        from pyodide.http import open_url\n\n        # read csv using pandas \n\n        url_content = open_url(\"https:\/\/raw.githubusercontent.com\/mwaskom\/seaborn-data\/master\/diamonds.csv\")\n\n        diamonds = pd.read_csv(url_content)\n\n        # create a sqllite table \n\n        conn = sql.connect('diamonds.db')\n        diamonds.to_sql('diamonds', conn)\n\n        # read from sql into a pandas dataframe\n\n        df = pd.read_sql('SELECT * FROM diamonds LIMIT 7', conn)\n\n        # print the output back\n        \n        csv = Element('csv')\n\n        csv.write(df)\n\n        print(df.shape)\n\n    &lt;\/py-script>\n\n&lt;\/body>\n\n&lt;\/html><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-10.png\"><img loading=\"lazy\" decoding=\"async\" width=\"517\" height=\"259\" src=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-10.png\" alt=\"\" class=\"wp-image-12067\" srcset=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-10.png 517w, https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-10-320x160.png 320w\" sizes=\"auto, (max-width: 517px) 100vw, 517px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Code 2<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;html>\n\n&lt;head>\n\n&lt;title>\n\nRead CSV with Pandas using PyScript\n    \n&lt;\/title>\n\n&lt;link rel=\"stylesheet\" href=\"https:\/\/pyscript.net\/alpha\/pyscript.css\" \/>\n&lt;script defer src=\"https:\/\/pyscript.net\/alpha\/pyscript.js\">&lt;\/script>\n\n&lt;!---pyodide--> \n\n&lt;py-env>\n    - pandas\n&lt;\/py-env>\n\n&lt;\/head>\n\n&lt;body>\n    \n    &lt;h1>Read CSV with Pandas using PyScript&lt;\/h1>\n\n    &lt;p id=\"csv\">&lt;\/p>\n\n    &lt;py-script>\n\n        import pandas as pd \n\n        import sqlite3 as sql\n\n\n        from pyodide.http import open_url\n\n        # read csv using pandas \n\n        url_content = open_url(\"https:\/\/raw.githubusercontent.com\/mwaskom\/seaborn-data\/master\/diamonds.csv\")\n\n        diamonds = pd.read_csv(url_content)\n\n        # create a sqllite table \n\n        conn = sql.connect('diamonds.db')\n        diamonds.to_sql('diamonds', conn)\n\n        # read from sql into a pandas dataframe\n\n        df = pd.read_sql('SELECT cut, avg(price) as avg_price FROM diamonds group by 1', conn)\n\n        # print the output back\n        \n        csv = Element('csv')\n\n        csv.write(df)\n\n        print(df.shape)\n\n    &lt;\/py-script>\n\n&lt;\/body>\n\n&lt;\/html><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-11.png\"><img loading=\"lazy\" decoding=\"async\" width=\"338\" height=\"341\" src=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-11.png\" alt=\"\" class=\"wp-image-12068\" srcset=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-11.png 338w, https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-11-320x323.png 320w, https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2022\/06\/image-11-150x150.png 150w\" sizes=\"auto, (max-width: 338px) 100vw, 338px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"PyScript Tutorial - SQLite Database in PyScript - CSV to SQL Table in Python Web #11\" width=\"747\" height=\"420\" src=\"https:\/\/www.youtube.com\/embed\/tXheKBIEbAQ?feature=oembed&amp;enablejsapi=1\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n\n<\/div><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><!-- se vuoi mettere un testo scorrevole\r\n[hoops name=\"typeWriterGen\"]\r\n\r\npoi metti un id diverso per ogni testo nella stessa pagina\r\n\r\n<div id=\"div01\">\r\n<script>\r\n\r\ntypeWriterGen(\"div01\",\"Esempio di testo scorrevole\");\r\n<\/script>\r\n\r\n-->\r\n<style>\r\n.avatar {\r\n  vertical-align: middle;\r\n  width: 100px;\r\n  height: 100px;\r\n  border-radius: 50%;\r\n}\r\n<\/style>\r\n\r\n<hr>\r\n\r\n<!-- NEWSLETTER LINK -->\r\n<a href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSf7TniIPCWHDzCSGh2dYZaCwDvi9yLKS5ovFdKuK1sdfOvwEg\/viewform\">\r\n<img decoding=\"async\" src=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2023\/08\/image-13.png\" class=\"avatar\">\r\nSubscribe to the <b>newsletter<\/b> for updates<\/a><br>\r\n\r\n<!-- TKINTER TEMPLATE LINK -->\r\n<a href=\"https:\/\/pythonprogramming.altervista.org\/tkinter-templates\/\">\r\n<img decoding=\"async\" src=\"https:\/\/i0.wp.com\/pythonprogramming.altervista.org\/wp-content\/uploads\/2023\/07\/image-26.png\" class=\"avatar\">\r\nTkinter templates<\/a><br>\r\n\r\n<!-- MY AVATAR PUT A LINK TO YOUTUBE CHANNEL-->\r\n<iframe loading=\"lazy\" frameborder=\"0\" src=\"https:\/\/itch.io\/embed\/711828\" width=\"552\" height=\"167\"><a href=\"https:\/\/pythonprogrammi.itch.io\/pysnake\">PySnake by PythonProgrammi<\/a><\/iframe>\r\n<br>\r\n<style>\r\n.avatar {\r\n  vertical-align: middle;\r\n  width: 100px;\r\n  height: 100px;\r\n  border-radius: 50%;\r\n}\r\n<\/style>\r\n\r\n\r\n<a href=\"https:\/\/www.youtube.com\/channel\/UCzbxq5e9gLiY-je2-br1rvg\">\r\n\t<img decoding=\"async\" src=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2020\/10\/avatar64x64.png\" alt=\"Avatar\" class=\"avatar\">\r\n\t My youtube channel<\/a><br>\r\n\r\n<br>\r\n\r\nTwitter: <a href=\"https:\/\/twitter.com\/pythonprogrammi\">@pythonprogrammi - python_pygame<\/a>\r\n<h3>Claude's Games<\/h3>\r\n<p><a href=\"https:\/\/pythonprogramming.altervista.org\/random-daily-game-1-arkanoid\/\">Arkanoid<\/a><br>\r\n<a href=\"https:\/\/pythonprogramming.altervista.org\/platform-2d-with-pygame-made-with-claude\/\">Platform 2d<\/a><\/p> <!-- videogames made with claude -->\r\n<a href=\"https:\/\/pythonprogramming.altervista.org\/artifacts-games-day-1-memory-game\/\">1. Memory game<\/a>\r\n<h4>Videos<\/h4>\r\n<a href=\"https:\/\/youtu.be\/ciLjWWw5pLY\">Speech recognition game<\/a>\r\n<h3>Pygame's Platform Game<\/h3>\r\n\r\n<a href=\"https:\/\/pythonprogramming.altervista.org\/pygame-platform-game-5-sounds-and-mixer\/\"><img decoding=\"async\" src=\"https:\/\/i1.wp.com\/pythonprogramming.altervista.org\/wp-content\/uploads\/2020\/01\/climbercover.png?w=557&ssl=1\"\/ width=\"50%\"><\/a>\r\n<script>\r\nvar title = \"Platform Pygame\";\r\n\t\tvar links = [\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-animation-of-a-sprite-v-1-3\/\",\"Animation 1.3\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-sprite-animation-v-2-better-coding-test-it-checking-fps-on-the-screen\/\",\"Animation 1.2\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-how-to-display-the-frame-rate-fps-on-the-screen\/\",\"Display Frame rate\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-sprite-animation-update\/\",\"Animation 1.1\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-platformer-1\/\",\"Pygame Platform Game 1\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/python-platform-game-2\/\",\"Pygame Platform 2\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-platform-game-3-recap-cheatsheet\/\",\"Pygame PLatform 3 - recap and some Cheat Sheet\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-platform-game-4-background-and-stuffs\/\",\"Pygame Platform 4 - Background & organizing code\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-platform-game-5-sounds-and-mixer\/\",\"Pygame Platform 5 - Sounds\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/platform-game-in-detail-part-1\/\",\"Game in detail part 1\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/map-maker-1-2\/\", \"Map maker 1.2\"]\r\n\t\t];\r\n\t\t<\/script>\r\n<script>\r\n\t\r\nif (typeof next2 != \"undefined\"){let next2 = 0;}\r\n\t\r\nnext2 = 0;\r\n\thtml = \"\";\/\/<b style='color:coral;font-size:1.2em'>Other posts about \" + title + \"<\/b><br>\";\r\nfor (address of links) \r\n{\r\n\r\n\tif (next2 == 1){\r\n\t\thtml += \"<div style='background:coral'>\";\r\n\t\thtml += \"Next link => <a href='\" + address[0] + \"'>\" + address[1] + \"<\/a>\";\r\n\t\thtml += \"<\/div><br>\";\r\n\t\tnext2 = 0;\r\n\t}\r\n\tif (address[0] == document.URL) {\r\n\t\tnext2 = 1;\r\n\t}\r\n}\r\n\r\nif (typeof next != \"undefined\") {let next = 0;}\r\nif (typeof addressStart != \"undefined\") {let addressStart = \"\";}\r\nnext = 0;\r\naddressStart = \"<a href='\";\r\nfor (address of links) {\r\n\tif (next == 1){\r\n\t\thtml += \">>>\" + addressStart + address[0] + \"'>\" + address[1] + \"<\/a><br>\";\r\n\t\tnext = 0;\r\n\t}\r\n\telse if (addressStart + address[0] != document.URL)\r\n\t{\r\n\t\thtml += addressStart + address[0] + \"'>\" + address[1] + \"<\/a><br>\";\r\n\t}\r\n\telse\r\n\t{\r\n\t\tnext = 1;\r\n\t\tnext_address = address[0]\r\n\t\tnext_title = address[1]\r\n\t\thtml += \"<span style='color:gray'>\" + address[1] + \"<\/span><br>\";\r\n\t}\r\n\r\n}\r\n\r\n\thtml += `<span style=\"font-size:8px\">Powered by <a href=\"https:\/\/pythonprogramming.altervista.org\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2673\" src=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2019\/06\/altervista2.png\" alt=\"\" width=\"70\" height=\"25\" srcset=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2019\/06\/altervista2.png 156w, https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2019\/06\/altervista2-150x56.png 150w\" sizes=\"auto, (max-width: 70px) 100vw, 70px\" \/>pythonprogramming.altervista.org<\/a><\/span>`\r\n\thtml = \"<div style='background:yellow'>\" + html + \"<\/div>\";\r\n\tdocument.write(html)\r\n<\/script>\r\n\r\n<h3>Other Pygame's posts<\/h3>\r\n\r\n<script>\r\nvar title = \"Pygame's Posts\"\r\nvar links = [\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-platformer-1\/\",\"Platform game 1\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/make-a-platform-game-with-pygame-dafluffypotato\/\",\"DaFluffyPotato Platform Tutorials\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/python-and-classic-arcade-games-pong\/\",\"Pong Game Full\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/python-draws-in-colors-app-to-draw-with-pygame\/\",\"PyGameGIF 2\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-draw-app-with-animation\/\",\"PyGameGIF 1\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pydraw-2-0-app-to-draw-gif\/\",\"PyDraw 2.0\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-drawing-2\/\",\"Draw with Pygame\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/animation-with-pygame\",\"Sprite animation 1\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/animation-on-pygame-2-free-characters-and-more-actions\/\",\"Sprite animation 2\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/starting-with-pygame\/\",\"Starting movements with Pygame\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-3-move-sprite\/\", \"Move a Sprite\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-4-fonts\/\",\"Text and Fonts\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-animate-a-sprite\/\", \"Animate a sprite\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-and-mouse-events\/\",\"Mouse events\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pgp-aka-pygamepresentation-project\/\",\"Pygame presentation\"],\r\n\t[\"https:\/\/pythonprogramming.altervista.org\/moving-the-player-in-pygame-with-key-get_pressed\/\",\"How to use key.get_pressed()\"]\r\n]\r\n<\/script>\r\n\r\n\r\n<script>\r\n\t\r\nif (typeof next2 != \"undefined\"){let next2 = 0;}\r\n\t\r\nnext2 = 0;\r\n\thtml = \"\";\/\/<b style='color:coral;font-size:1.2em'>Other posts about \" + title + \"<\/b><br>\";\r\nfor (address of links) \r\n{\r\n\r\n\tif (next2 == 1){\r\n\t\thtml += \"<div style='background:coral'>\";\r\n\t\thtml += \"Next link => <a href='\" + address[0] + \"'>\" + address[1] + \"<\/a>\";\r\n\t\thtml += \"<\/div><br>\";\r\n\t\tnext2 = 0;\r\n\t}\r\n\tif (address[0] == document.URL) {\r\n\t\tnext2 = 1;\r\n\t}\r\n}\r\n\r\nif (typeof next != \"undefined\") {let next = 0;}\r\nif (typeof addressStart != \"undefined\") {let addressStart = \"\";}\r\nnext = 0;\r\naddressStart = \"<a href='\";\r\nfor (address of links) {\r\n\tif (next == 1){\r\n\t\thtml += \">>>\" + addressStart + address[0] + \"'>\" + address[1] + \"<\/a><br>\";\r\n\t\tnext = 0;\r\n\t}\r\n\telse if (addressStart + address[0] != document.URL)\r\n\t{\r\n\t\thtml += addressStart + address[0] + \"'>\" + address[1] + \"<\/a><br>\";\r\n\t}\r\n\telse\r\n\t{\r\n\t\tnext = 1;\r\n\t\tnext_address = address[0]\r\n\t\tnext_title = address[1]\r\n\t\thtml += \"<span style='color:gray'>\" + address[1] + \"<\/span><br>\";\r\n\t}\r\n\r\n}\r\n\r\n\thtml += `<span style=\"font-size:8px\">Powered by <a href=\"https:\/\/pythonprogramming.altervista.org\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2673\" src=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2019\/06\/altervista2.png\" alt=\"\" width=\"70\" height=\"25\" srcset=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2019\/06\/altervista2.png 156w, https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2019\/06\/altervista2-150x56.png 150w\" sizes=\"auto, (max-width: 70px) 100vw, 70px\" \/>pythonprogramming.altervista.org<\/a><\/span>`\r\n\thtml = \"<div style='background:yellow'>\" + html + \"<\/div>\";\r\n\tdocument.write(html)\r\n<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"Code 1 Code 2\n<a class=\"moretag\" href=\"https:\/\/pythonprogramming.altervista.org\/pyscript-using-sqlite-with-pyscript\/\"> [...]<\/a>","protected":false},"author":1,"featured_media":12067,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-12059","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-examples"],"avopt_banners_inside_post":true,"avopt_banners_on_page":true,"av_copy_from":"","av_sharing_message":"","av_sharing_allowed":true,"av_sharing_on":{"fb":[],"tw":[]},"av_allow_affiliate_banner":false,"av_allow_affiliate_multi_banner":false,"av_show_affiliation_buy_button":false,"av_post_rating":true,"av_have_post_rating_value":false,"av_is_artificial_intelligence_content":false,"_links":{"self":[{"href":"https:\/\/pythonprogramming.altervista.org\/wp-json\/wp\/v2\/posts\/12059","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pythonprogramming.altervista.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pythonprogramming.altervista.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pythonprogramming.altervista.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pythonprogramming.altervista.org\/wp-json\/wp\/v2\/comments?post=12059"}],"version-history":[{"count":2,"href":"https:\/\/pythonprogramming.altervista.org\/wp-json\/wp\/v2\/posts\/12059\/revisions"}],"predecessor-version":[{"id":12070,"href":"https:\/\/pythonprogramming.altervista.org\/wp-json\/wp\/v2\/posts\/12059\/revisions\/12070"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pythonprogramming.altervista.org\/wp-json\/wp\/v2\/media\/12067"}],"wp:attachment":[{"href":"https:\/\/pythonprogramming.altervista.org\/wp-json\/wp\/v2\/media?parent=12059"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pythonprogramming.altervista.org\/wp-json\/wp\/v2\/categories?post=12059"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pythonprogramming.altervista.org\/wp-json\/wp\/v2\/tags?post=12059"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}