{"id":6772,"date":"2026-07-31T17:00:43","date_gmt":"2026-07-31T13:30:43","guid":{"rendered":"https:\/\/parmin.cloud\/blog\/?p=6772"},"modified":"2026-07-31T17:00:43","modified_gmt":"2026-07-31T13:30:43","slug":"%d8%a2%d9%85%d9%88%d8%b2%d8%b4-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-%d9%85%d8%a7%da%98%d9%88%d9%84-sqlite3-%d8%af%d8%b1-%d9%be%d8%a7%db%8c%d8%aa%d9%88%d9%86-3","status":"publish","type":"post","link":"https:\/\/parmin.cloud\/blog\/%d8%a2%d9%85%d9%88%d8%b2%d8%b4-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-%d9%85%d8%a7%da%98%d9%88%d9%84-sqlite3-%d8%af%d8%b1-%d9%be%d8%a7%db%8c%d8%aa%d9%88%d9%86-3\/","title":{"rendered":"\u0622\u0645\u0648\u0632\u0634 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u0627\u0698\u0648\u0644 sqlite3 \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 3"},"content":{"rendered":"<p class=\"svelte-4sys19\" dir=\"auto\"><strong>\u0645\u0642\u062f\u0645\u0647<\/strong> \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQLite \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQL \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u0641\u0627\u06cc\u0644 \u0648 \u0645\u0633\u062a\u0642\u0644 \u0627\u0633\u062a. SQLite \u0628\u0647 \u0635\u0648\u0631\u062a \u067e\u06cc\u0634\u200c\u0641\u0631\u0636 \u0647\u0645\u0631\u0627\u0647 \u0628\u0627 \u067e\u0627\u06cc\u062a\u0648\u0646 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f \u0648 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u062f\u0648\u0646 \u0646\u0635\u0628 \u0647\u06cc\u0686 \u0646\u0631\u0645\u200c\u0627\u0641\u0632\u0627\u0631 \u0627\u0636\u0627\u0641\u06cc\u060c \u0627\u0632 \u0622\u0646 \u062f\u0631 \u0627\u067e\u0644\u06cc\u06a9\u06cc\u0634\u0646\u200c\u0647\u0627\u06cc \u067e\u0627\u06cc\u062a\u0648\u0646 \u062e\u0648\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634\u060c \u0645\u0627\u0698\u0648\u0644 <code class=\"cursor-pointer codespan\">sqlite3<\/code> \u0631\u0627 \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 3 \u0628\u0631\u0631\u0633\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f. \u0645\u0627 \u06cc\u06a9 \u0627\u062a\u0635\u0627\u0644 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQLite \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645\u060c \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0628\u0647 \u0622\u0646 \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645\u060c \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc\u06cc \u0631\u0627 \u062f\u0631 \u0622\u0646 \u062c\u062f\u0648\u0644 \u062f\u0631\u062c \u06a9\u0631\u062f\u0647 \u0648 \u0633\u067e\u0633 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0645\u06cc\u200c\u062e\u0648\u0627\u0646\u06cc\u0645 \u0648 \u062a\u063a\u06cc\u06cc\u0631 \u0645\u06cc\u200c\u062f\u0647\u06cc\u0645.<\/p>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634\u060c \u0645\u0627 \u0639\u0645\u062f\u062a\u0627\u064b \u0628\u0627 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0645\u0648\u062c\u0648\u062f\u06cc \u0645\u0627\u0647\u06cc\u200c\u0647\u0627 \u06a9\u0627\u0631 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0628\u0627\u06cc\u062f \u0628\u0627 \u0627\u0636\u0627\u0641\u0647 \u06cc\u0627 \u06a9\u0645 \u0634\u062f\u0646 \u0645\u0627\u0647\u06cc\u200c\u0647\u0627 \u062f\u0631 \u06cc\u06a9 \u0622\u06a9\u0648\u0627\u0631\u06cc\u0648\u0645 \u0641\u0631\u0636\u06cc\u060c \u0622\u0646 \u0631\u0627 \u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u06a9\u0646\u06cc\u0645.<\/p>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\"><strong>\u067e\u06cc\u0634\u200c\u0646\u06cc\u0627\u0632\u0647\u0627<\/strong> \u0628\u0631\u0627\u06cc \u062f\u0631\u06a9 \u0628\u0647\u062a\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634\u060c \u062f\u0627\u0634\u062a\u0646 \u0622\u0634\u0646\u0627\u06cc\u06cc \u0627\u0648\u0644\u06cc\u0647 \u0628\u0627 \u0628\u0631\u0646\u0627\u0645\u0647\u200c\u0646\u0648\u06cc\u0633\u06cc \u067e\u0627\u06cc\u062a\u0648\u0646 \u0648 \u062f\u0627\u0646\u0634 \u067e\u0627\u06cc\u0647\u200c\u0627\u06cc \u062f\u0631 \u0645\u0648\u0631\u062f SQL \u062a\u0648\u0635\u06cc\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n<div><\/div>\n<hr class=\"border-[#EBEBEB] dark:border-[#EBEBEB]\/16\" \/>\n<h3 class=\"svelte-4sys19\" dir=\"auto\">\u0645\u0631\u062d\u0644\u0647 \u06f1 \u2014 \u0627\u06cc\u062c\u0627\u062f \u0627\u062a\u0635\u0627\u0644 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQLite<\/h3>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u0628\u0647 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQLite \u0645\u062a\u0635\u0644 \u0645\u06cc\u200c\u0634\u0648\u06cc\u062f\u060c \u062f\u0631 \u0648\u0627\u0642\u0639 \u0628\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc\u06cc \u062f\u0633\u062a\u0631\u0633\u06cc \u067e\u06cc\u062f\u0627 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f \u06a9\u0647 \u062f\u0631 \u0646\u0647\u0627\u06cc\u062a \u062f\u0631 \u06cc\u06a9 \u0641\u0627\u06cc\u0644 \u0631\u0648\u06cc \u0633\u06cc\u0633\u062a\u0645 \u0634\u0645\u0627 \u0630\u062e\u06cc\u0631\u0647 \u0634\u062f\u0647\u200c\u0627\u0646\u062f. \u067e\u0627\u06cc\u06af\u0627\u0647\u200c\u0647\u0627\u06cc \u062f\u0627\u062f\u0647 SQLite \u0645\u0648\u062a\u0648\u0631\u0647\u0627\u06cc SQL \u06a9\u0627\u0645\u0644\u06cc \u0647\u0633\u062a\u0646\u062f \u06a9\u0647 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0628\u0631\u0627\u06cc \u0627\u0647\u062f\u0627\u0641 \u0645\u062e\u062a\u0644\u0641\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u0648\u0646\u062f. \u062f\u0631 \u062d\u0627\u0644 \u062d\u0627\u0636\u0631\u060c \u0645\u0627 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u062f\u0631 \u0646\u0638\u0631 \u0645\u06cc\u200c\u06af\u06cc\u0631\u06cc\u0645 \u06a9\u0647 \u0645\u0648\u062c\u0648\u062f\u06cc \u0645\u0627\u0647\u06cc\u200c\u0647\u0627\u06cc \u06cc\u06a9 \u0622\u06a9\u0648\u0627\u0631\u06cc\u0648\u0645 \u0641\u0631\u0636\u06cc \u0631\u0627 \u0631\u062f\u06cc\u0627\u0628\u06cc \u0645\u06cc\u200c\u06a9\u0646\u062f.<\/p>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u0627\u0698\u0648\u0644 <code class=\"cursor-pointer codespan\">sqlite3<\/code> \u067e\u0627\u06cc\u062a\u0648\u0646 \u0628\u0647 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQLite \u0645\u062a\u0635\u0644 \u0634\u0648\u06cc\u0645:<\/p>\n<div><\/div>\n<div class=\"relative my-2 flex flex-col rounded-xl border border-[#0000000A] bg-[#F7F7F7] dark:bg-[#202123] p-2\" dir=\"ltr\">\n<div class=\"absolute pl-2 py-1 text-xs font-medium text-text-300 dark:text-white\">python<\/div>\n<div class=\"sticky top-8 mb-1 flex items-center justify-end z-11 text-xs text-black dark:text-white\">\n<div class=\"flex items-center gap-0.5 translate-y-[1px]\">\n<div id=\"bits-c520\" class=\"flex\" tabindex=\"0\" data-state=\"closed\" data-delay-duration=\"200\" data-tooltip-trigger=\"\" aria-label=\"Copy\"><\/div>\n<\/div>\n<\/div>\n<div class=\"language-python rounded-b-lg overflow-hidden\">\n<div class=\"h-full w-full\">\n<div class=\"cm-editor \u037c1 \u037c2 \u037c4 \u037c8l \u037c5k\">\n<div class=\"cm-announced\" aria-live=\"polite\"><\/div>\n<div class=\"cm-scroller\" tabindex=\"-1\">\n<div class=\"cm-content\" role=\"textbox\" contenteditable=\"false\" spellcheck=\"false\" translate=\"no\" aria-multiline=\"true\" data-language=\"python\">\n<div class=\"cm-line\"><span class=\"\u037c5s\">import<\/span> <span class=\"\u037c5m\">sqlite3<\/span><\/div>\n<div class=\"cm-line\"><\/div>\n<div class=\"cm-line\"><span class=\"\u037c5m\">connection<\/span> <span class=\"\u037c5q\">=<\/span> <span class=\"\u037c5m\">sqlite3<\/span><span class=\"\u037c5t\">.<\/span><span class=\"\u037c5m\">connect<\/span>(<span class=\"\u037c5p\">&#8220;aquarium.db&#8221;<\/span>)<\/div>\n<\/div>\n<div class=\"cm-layer cm-layer-above cm-cursorLayer\" aria-hidden=\"true\"><\/div>\n<div class=\"cm-layer cm-selectionLayer\" aria-hidden=\"true\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"plt-canvas-10611d94-a3e1-4af7-bd5e-8400ccb379c9-16\" class=\"bg-gray-50 dark:bg-[#202123] text-gray-900 dark:text-white max-w-full overflow-x-auto scrollbar-hidden\"><\/div>\n<\/div>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u062f\u0633\u062a\u0648\u0631 <code class=\"cursor-pointer codespan\">import sqlite3<\/code> \u0628\u0647 \u0628\u0631\u0646\u0627\u0645\u0647 \u067e\u0627\u06cc\u062a\u0648\u0646 \u0645\u0627 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc\u200c\u062f\u0647\u062f \u0628\u0647 \u0645\u0627\u0698\u0648\u0644 <code class=\"cursor-pointer codespan\">sqlite3<\/code> \u062f\u0633\u062a\u0631\u0633\u06cc \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f. \u062a\u0627\u0628\u0639 <code class=\"cursor-pointer codespan\">sqlite3.connect()<\/code> \u06cc\u06a9 \u0634\u06cc\u0621 <code class=\"cursor-pointer codespan\">Connection<\/code> (\u0627\u062a\u0635\u0627\u0644) \u0631\u0627 \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f \u06a9\u0647 \u0645\u0627 \u0627\u0632 \u0622\u0646 \u0628\u0631\u0627\u06cc \u062a\u0639\u0627\u0645\u0644 \u0628\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQLite \u0630\u062e\u06cc\u0631\u0647 \u0634\u062f\u0647 \u062f\u0631 \u0641\u0627\u06cc\u0644 <code class=\"cursor-pointer codespan\">aquarium.db<\/code> \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f. \u0627\u06af\u0631 \u0641\u0627\u06cc\u0644 <code class=\"cursor-pointer codespan\">aquarium.db<\/code> \u0627\u0632 \u0642\u0628\u0644 \u0631\u0648\u06cc \u0633\u06cc\u0633\u062a\u0645 \u0634\u0645\u0627 \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f\u060c \u062a\u0648\u0633\u0637 \u062a\u0627\u0628\u0639 <code class=\"cursor-pointer codespan\">sqlite3.connect()<\/code> \u0628\u0647 \u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0628\u0627 \u0627\u062c\u0631\u0627\u06cc \u06a9\u062f \u0632\u06cc\u0631\u060c \u0645\u0648\u0641\u0642\u06cc\u062a\u200c\u0622\u0645\u06cc\u0632 \u0628\u0648\u062f\u0646 \u0627\u06cc\u062c\u0627\u062f \u0634\u06cc\u0621 \u0627\u062a\u0635\u0627\u0644 \u062e\u0648\u062f \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u0645:<\/p>\n<div><\/div>\n<div class=\"relative my-2 flex flex-col rounded-xl border border-[#0000000A] bg-[#F7F7F7] dark:bg-[#202123] p-2\" dir=\"ltr\">\n<div class=\"absolute pl-2 py-1 text-xs font-medium text-text-300 dark:text-white\">python<\/div>\n<div class=\"sticky top-8 mb-1 flex items-center justify-end z-11 text-xs text-black dark:text-white\">\n<div class=\"flex items-center gap-0.5 translate-y-[1px]\">\n<div id=\"bits-c522\" class=\"flex\" tabindex=\"0\" data-state=\"closed\" data-delay-duration=\"200\" data-tooltip-trigger=\"\" aria-label=\"Copy\"><\/div>\n<\/div>\n<\/div>\n<div class=\"language-python rounded-b-lg overflow-hidden\">\n<div class=\"h-full w-full\">\n<div class=\"cm-editor \u037c1 \u037c2 \u037c4 \u037c8m \u037c5k\">\n<div class=\"cm-announced\" aria-live=\"polite\"><\/div>\n<div class=\"cm-scroller\" tabindex=\"-1\">\n<div class=\"cm-content\" role=\"textbox\" contenteditable=\"false\" spellcheck=\"false\" translate=\"no\" aria-multiline=\"true\">\n<div class=\"cm-line\">print(connection.total_changes)<\/div>\n<\/div>\n<div class=\"cm-layer cm-layer-above cm-cursorLayer\" aria-hidden=\"true\"><\/div>\n<div class=\"cm-layer cm-selectionLayer\" aria-hidden=\"true\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"plt-canvas-10611d94-a3e1-4af7-bd5e-8400ccb379c9-22\" class=\"bg-gray-50 dark:bg-[#202123] text-gray-900 dark:text-white max-w-full overflow-x-auto scrollbar-hidden\"><\/div>\n<\/div>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0627\u06af\u0631 \u0627\u06cc\u0646 \u06a9\u062f \u067e\u0627\u06cc\u062a\u0648\u0646 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u0645\u060c \u062e\u0631\u0648\u062c\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u062e\u0648\u0627\u0647\u06cc\u0645 \u062f\u06cc\u062f:<\/p>\n<div><\/div>\n<div class=\"relative my-2 flex flex-col rounded-xl border border-[#0000000A] bg-[#F7F7F7] dark:bg-[#202123] p-2\" dir=\"ltr\">\n<div class=\"absolute pl-2 py-1 text-xs font-medium text-text-300 dark:text-white\">text<\/div>\n<div class=\"sticky top-8 mb-1 flex items-center justify-end z-11 text-xs text-black dark:text-white\">\n<div class=\"flex items-center gap-0.5 translate-y-[1px]\">\n<div id=\"bits-c524\" class=\"flex\" tabindex=\"0\" data-state=\"closed\" data-delay-duration=\"200\" data-tooltip-trigger=\"\" aria-label=\"Copy\"><\/div>\n<\/div>\n<\/div>\n<div class=\"language-text rounded-b-lg overflow-hidden\">\n<div class=\"h-full w-full\">\n<div class=\"cm-editor \u037c1 \u037c2 \u037c4 \u037c8n \u037c5k\">\n<div class=\"cm-announced\" aria-live=\"polite\"><\/div>\n<div class=\"cm-scroller\" tabindex=\"-1\">\n<div class=\"cm-content\" role=\"textbox\" contenteditable=\"false\" spellcheck=\"false\" translate=\"no\" aria-multiline=\"true\">\n<div class=\"cm-line\">Output<\/div>\n<div class=\"cm-line\">0<\/div>\n<\/div>\n<div class=\"cm-layer cm-layer-above cm-cursorLayer\" aria-hidden=\"true\"><\/div>\n<div class=\"cm-layer cm-selectionLayer\" aria-hidden=\"true\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"plt-canvas-10611d94-a3e1-4af7-bd5e-8400ccb379c9-26\" class=\"bg-gray-50 dark:bg-[#202123] text-gray-900 dark:text-white max-w-full overflow-x-auto scrollbar-hidden\"><\/div>\n<\/div>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0639\u0628\u0627\u0631\u062a <code class=\"cursor-pointer codespan\">connection.total_changes<\/code> \u062a\u0639\u062f\u0627\u062f \u06a9\u0644 \u0631\u062f\u06cc\u0641\u200c\u0647\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a \u06a9\u0647 \u062a\u0648\u0633\u0637 \u0627\u06cc\u0646 \u0627\u062a\u0635\u0627\u0644 \u062a\u063a\u06cc\u06cc\u0631 \u06a9\u0631\u062f\u0647\u200c\u0627\u0646\u062f. \u0627\u0632 \u0622\u0646\u062c\u0627\u06cc\u06cc \u06a9\u0647 \u0647\u0646\u0648\u0632 \u0647\u06cc\u0686 \u062f\u0633\u062a\u0648\u0631 SQL\u06cc \u0631\u0627 \u0627\u062c\u0631\u0627 \u0646\u06a9\u0631\u062f\u0647\u200c\u0627\u06cc\u0645\u060c \u0645\u0642\u062f\u0627\u0631 <code class=\"cursor-pointer codespan\">0<\/code> \u06a9\u0627\u0645\u0644\u0627\u064b \u062f\u0631\u0633\u062a \u0627\u0633\u062a.<\/p>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0627\u06af\u0631 \u062f\u0631 \u0647\u0631 \u0632\u0645\u0627\u0646\u06cc \u062e\u0648\u0627\u0633\u062a\u06cc\u062f \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0631\u0627 \u0627\u0632 \u0646\u0648 \u0634\u0631\u0648\u0639 \u06a9\u0646\u06cc\u062f\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0641\u0627\u06cc\u0644 <code class=\"cursor-pointer codespan\">aquarium.db<\/code> \u0631\u0627 \u0627\u0632 \u0633\u06cc\u0633\u062a\u0645 \u062e\u0648\u062f \u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f.<\/p>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\"><em>\u0646\u06a9\u062a\u0647: \u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0628\u0627 \u0627\u0631\u0633\u0627\u0644 \u0631\u0634\u062a\u0647 \u062e\u0627\u0635 <code class=\"cursor-pointer codespan\">\":memory:\"<\/code> \u0628\u0647 \u062a\u0627\u0628\u0639 <code class=\"cursor-pointer codespan\">sqlite3.connect()<\/code>\u060c \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQLite \u06a9\u0647 \u06a9\u0627\u0645\u0644\u0627\u064b \u062f\u0631 \u062d\u0627\u0641\u0638\u0647 \u0645\u0648\u0642\u062a (RAM) \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u062f (\u0648 \u0646\u0647 \u062f\u0631 \u06cc\u06a9 \u0641\u0627\u06cc\u0644) \u0645\u062a\u0635\u0644 \u0634\u062f. \u0628\u0631\u0627\u06cc \u0645\u062b\u0627\u0644: <code class=\"cursor-pointer codespan\">sqlite3.connect(\":memory:\")<\/code>. \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 <code class=\"cursor-pointer codespan\">\":memory:\"<\/code> \u0628\u0647 \u0645\u062d\u0636 \u062e\u0631\u0648\u062c \u0628\u0631\u0646\u0627\u0645\u0647 \u067e\u0627\u06cc\u062a\u0648\u0646 \u0634\u0645\u0627 \u0646\u0627\u067e\u062f\u06cc\u062f \u0645\u06cc\u200c\u0634\u0648\u062f. \u0627\u06cc\u0646 \u0645\u0648\u0636\u0648\u0639 \u062f\u0631 \u0635\u0648\u0631\u062a\u06cc \u06a9\u0647 \u06cc\u06a9 \u0645\u062d\u06cc\u0637 \u0645\u0648\u0642\u062a (Sandbox) \u0628\u0631\u0627\u06cc \u0622\u0632\u0645\u0627\u06cc\u0634 \u0686\u06cc\u0632\u06cc \u062f\u0631 SQLite \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u0648 \u0646\u06cc\u0627\u0632\u06cc \u0628\u0647 \u0630\u062e\u06cc\u0631\u0647 \u062f\u0627\u0626\u0645\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0646\u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f\u060c \u0628\u0633\u06cc\u0627\u0631 \u0645\u0641\u06cc\u062f \u0627\u0633\u062a.<\/em><\/p>\n<div><\/div>\n<hr class=\"border-[#EBEBEB] dark:border-[#EBEBEB]\/16\" \/>\n<h3 class=\"svelte-4sys19\" dir=\"auto\">\u0645\u0631\u062d\u0644\u0647 \u06f2 \u2014 \u0627\u0641\u0632\u0648\u062f\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQLite<\/h3>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0627\u06a9\u0646\u0648\u0646 \u06a9\u0647 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQLite \u0628\u0627 \u0646\u0627\u0645 <code class=\"cursor-pointer codespan\">aquarium.db<\/code> \u0645\u062a\u0635\u0644 \u0634\u062f\u0647\u200c\u0627\u06cc\u0645\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u062f\u0631 \u0622\u0646 \u062f\u0631\u062c \u0648 \u0628\u062e\u0648\u0627\u0646\u06cc\u0645.<\/p>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u062f\u0631 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQL\u060c \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 \u062c\u062f\u0627\u0648\u0644 (Tables) \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f. \u062c\u062f\u0627\u0648\u0644 \u0645\u062c\u0645\u0648\u0639\u0647\u200c\u0627\u06cc \u0627\u0632 \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0631\u0627 \u062a\u0639\u0631\u06cc\u0641 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f \u0648 \u0634\u0627\u0645\u0644 \u06f0 \u06cc\u0627 \u0686\u0646\u062f \u0631\u062f\u06cc\u0641 (Row) \u0628\u0627 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc\u06cc \u0628\u0631\u0627\u06cc \u0647\u0631 \u06cc\u06a9 \u0627\u0632 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc \u062a\u0639\u0631\u06cc\u0641 \u0634\u062f\u0647 \u0647\u0633\u062a\u0646\u062f.<\/p>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0645\u0627 \u062c\u062f\u0648\u0644\u06cc \u0628\u0647 \u0646\u0627\u0645 <code class=\"cursor-pointer codespan\">fish<\/code> (\u0645\u0627\u0647\u06cc) \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u0631\u062f\u06cc\u0627\u0628\u06cc \u0645\u06cc\u200c\u06a9\u0646\u062f:<\/p>\n<div><\/div>\n<div class=\"relative w-full group\/table mb-5\">\n<div class=\"overflow-x-auto relative w-full scrollbar-hidden\">\n<table class=\"min-w-full text-sm text-left text-gray-500 w-fit dark:text-gray-400\">\n<thead class=\"text-gray-700 uppercase border-none dark:text-gray-400\">\n<tr class=\"border-none bg-[#f7f7f7] dark:bg-[#F7F7F70F]\">\n<th class=\"px-3! py-1.5!\" scope=\"col\">\n<div class=\"gap-1.5 text-left\">\n<div class=\"break-normal shrink-0\">name<\/div>\n<\/div>\n<\/th>\n<th class=\"px-3! py-1.5!\" scope=\"col\">\n<div class=\"gap-1.5 text-left\">\n<div class=\"break-normal shrink-0\">species<\/div>\n<\/div>\n<\/th>\n<th class=\"px-3! py-1.5!\" scope=\"col\">\n<div class=\"gap-1.5 text-left\">\n<div class=\"break-normal shrink-0\">tank_number<\/div>\n<\/div>\n<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr class=\"border-b-1 border-[#d1d5dc] dark:border-gray-850\">\n<td class=\"px-3! py-3! border-none text-gray-900 dark:text-white border border-[#EBEBEB] dark:border-[#FFFFFF0D] max-w-[500px] min-w-[180px]\">Sammy<\/td>\n<td class=\"px-3! py-3! border-none text-gray-900 dark:text-white border border-[#EBEBEB] dark:border-[#FFFFFF0D] max-w-[500px] min-w-[180px]\">shark<\/td>\n<td class=\"px-3! py-3! border-none text-gray-900 dark:text-white border border-[#EBEBEB] dark:border-[#FFFFFF0D] max-w-[500px] min-w-[180px]\">1<\/td>\n<\/tr>\n<tr class=\"border-b-1 border-[#d1d5dc] dark:border-gray-850\">\n<td class=\"px-3! py-3! border-none text-gray-900 dark:text-white border border-[#EBEBEB] dark:border-[#FFFFFF0D] max-w-[500px] min-w-[180px]\">Jamie<\/td>\n<td class=\"px-3! py-3! border-none text-gray-900 dark:text-white border border-[#EBEBEB] dark:border-[#FFFFFF0D] max-w-[500px] min-w-[180px]\">cuttlefish<\/td>\n<td class=\"px-3! py-3! border-none text-gray-900 dark:text-white border border-[#EBEBEB] dark:border-[#FFFFFF0D] max-w-[500px] min-w-[180px]\">7<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p><button class=\"absolute top-1 right-1 z-10 p-1.5 rounded-lg bg-[#f7f7f7] dark:bg-[#272A2F] hover:bg-[#E5E5E5] dark:hover:bg-[#272A2F] opacity-0 group-hover\/table:opacity-100 transition-opacity duration-200\"><\/button><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u062c\u062f\u0648\u0644 <code class=\"cursor-pointer codespan\">fish<\/code> \u0645\u0642\u062f\u0627\u0631 <code class=\"cursor-pointer codespan\">name<\/code> (\u0646\u0627\u0645)\u060c <code class=\"cursor-pointer codespan\">species<\/code> (\u06af\u0648\u0646\u0647) \u0648 <code class=\"cursor-pointer codespan\">tank_number<\/code> (\u0634\u0645\u0627\u0631\u0647 \u062a\u0627\u0646\u06a9) \u0631\u0627 \u0628\u0631\u0627\u06cc \u0647\u0631 \u0645\u0627\u0647\u06cc \u062f\u0631 \u0622\u06a9\u0648\u0627\u0631\u06cc\u0648\u0645 \u062b\u0628\u062a \u0645\u06cc\u200c\u06a9\u0646\u062f. \u062f\u0648 \u0631\u062f\u06cc\u0641 \u0646\u0645\u0648\u0646\u0647 \u0628\u0631\u0627\u06cc \u0645\u0627\u0647\u06cc\u200c\u0647\u0627 \u0644\u06cc\u0633\u062a \u0634\u062f\u0647 \u0627\u0633\u062a: \u06cc\u06a9 \u0631\u062f\u06cc\u0641 \u0628\u0631\u0627\u06cc \u06a9\u0648\u0633\u0647\u200c\u0627\u06cc \u0628\u0647 \u0646\u0627\u0645 \u0633\u0627\u0645\u06cc (Sammy) \u0648 \u06cc\u06a9 \u0631\u062f\u06cc\u0641 \u0628\u0631\u0627\u06cc \u0645\u0627\u0647\u06cc \u0645\u0631\u06a9\u0628 \u0628\u0647 \u0646\u0627\u0645 \u062c\u06cc\u0645\u06cc (Jamie).<\/p>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u06cc\u0646 \u062c\u062f\u0648\u0644 <code class=\"cursor-pointer codespan\">fish<\/code> \u0631\u0627 \u062f\u0631 SQLite \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u062a\u0635\u0627\u0644\u06cc \u06a9\u0647 \u062f\u0631 \u0645\u0631\u062d\u0644\u0647 1 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u06cc\u0645\u060c \u0628\u0633\u0627\u0632\u06cc\u0645:<\/p>\n<div><\/div>\n<div class=\"relative my-2 flex flex-col rounded-xl border border-[#0000000A] bg-[#F7F7F7] dark:bg-[#202123] p-2\" dir=\"ltr\">\n<div class=\"absolute pl-2 py-1 text-xs font-medium text-text-300 dark:text-white\">python<\/div>\n<div class=\"sticky top-8 mb-1 flex items-center justify-end z-11 text-xs text-black dark:text-white\">\n<div class=\"flex items-center gap-0.5 translate-y-[1px]\">\n<div id=\"bits-c526\" class=\"flex\" tabindex=\"0\" data-state=\"closed\" data-delay-duration=\"200\" data-tooltip-trigger=\"\" aria-label=\"Copy\"><\/div>\n<\/div>\n<\/div>\n<div class=\"language-python rounded-b-lg overflow-hidden\">\n<div class=\"h-full w-full\">\n<div class=\"cm-editor \u037c1 \u037c2 \u037c4 \u037c8o \u037c5k\">\n<div class=\"cm-announced\" aria-live=\"polite\"><\/div>\n<div class=\"cm-scroller\" tabindex=\"-1\">\n<div class=\"cm-content\" role=\"textbox\" contenteditable=\"false\" spellcheck=\"false\" translate=\"no\" aria-multiline=\"true\">\n<div class=\"cm-line\">cursor = connection.cursor()<\/div>\n<div class=\"cm-line\">cursor.execute(&#8220;CREATE TABLE fish (name TEXT, species TEXT, tank_number INTEGER)&#8221;)<\/div>\n<\/div>\n<div class=\"cm-layer cm-layer-above cm-cursorLayer\" aria-hidden=\"true\"><\/div>\n<div class=\"cm-layer cm-selectionLayer\" aria-hidden=\"true\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"plt-canvas-10611d94-a3e1-4af7-bd5e-8400ccb379c9-47\" class=\"bg-gray-50 dark:bg-[#202123] text-gray-900 dark:text-white max-w-full overflow-x-auto scrollbar-hidden\"><\/div>\n<\/div>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u062f\u0633\u062a\u0648\u0631 <code class=\"cursor-pointer codespan\">connection.cursor()<\/code> \u06cc\u06a9 \u0634\u06cc\u0621 <code class=\"cursor-pointer codespan\">Cursor<\/code> (\u0645\u06a9\u0627\u0646\u200c\u0646\u0645\u0627) \u0631\u0627 \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f. \u0627\u0634\u06cc\u0627\u0621 Cursor \u0628\u0647 \u0645\u0627 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc\u200c\u062f\u0647\u0646\u062f \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 <code class=\"cursor-pointer codespan\">cursor.execute()<\/code> \u062f\u0633\u062a\u0648\u0631\u0627\u062a SQL \u0631\u0627 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQLite \u0627\u0631\u0633\u0627\u0644 \u06a9\u0646\u06cc\u0645. \u0631\u0634\u062a\u0647 <code class=\"cursor-pointer codespan\">\"CREATE TABLE fish ...\"<\/code> \u06cc\u06a9 \u062f\u0633\u062a\u0648\u0631 SQL \u0627\u0633\u062a \u06a9\u0647 \u062c\u062f\u0648\u0644\u06cc \u0628\u0647 \u0646\u0627\u0645 <code class=\"cursor-pointer codespan\">fish<\/code> \u0628\u0627 \u0633\u0647 \u0633\u062a\u0648\u0646 \u062a\u0648\u0636\u06cc\u062d \u062f\u0627\u062f\u0647 \u0634\u062f\u0647 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc\u200c\u06a9\u0646\u062f: <code class=\"cursor-pointer codespan\">name<\/code> \u0627\u0632 \u0646\u0648\u0639 <code class=\"cursor-pointer codespan\">TEXT<\/code>\u060c <code class=\"cursor-pointer codespan\">species<\/code> \u0627\u0632 \u0646\u0648\u0639 <code class=\"cursor-pointer codespan\">TEXT<\/code> \u0648 <code class=\"cursor-pointer codespan\">tank_number<\/code> \u0627\u0632 \u0646\u0648\u0639 <code class=\"cursor-pointer codespan\">INTEGER<\/code>.<\/p>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0627\u06a9\u0646\u0648\u0646 \u06a9\u0647 \u062c\u062f\u0648\u0644 \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u0647\u200c\u0627\u06cc\u0645\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0631\u062f\u06cc\u0641\u200c\u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0631\u0627 \u062f\u0631 \u0622\u0646 \u062f\u0631\u062c \u06a9\u0646\u06cc\u0645:<\/p>\n<div><\/div>\n<div class=\"relative my-2 flex flex-col rounded-xl border border-[#0000000A] bg-[#F7F7F7] dark:bg-[#202123] p-2\" dir=\"ltr\">\n<div class=\"absolute pl-2 py-1 text-xs font-medium text-text-300 dark:text-white\">python<\/div>\n<div class=\"sticky top-8 mb-1 flex items-center justify-end z-11 text-xs text-black dark:text-white\">\n<div class=\"flex items-center gap-0.5 translate-y-[1px]\">\n<div id=\"bits-c528\" class=\"flex\" tabindex=\"0\" data-state=\"closed\" data-delay-duration=\"200\" data-tooltip-trigger=\"\" aria-label=\"Copy\"><\/div>\n<\/div>\n<\/div>\n<div class=\"language-python rounded-b-lg overflow-hidden\">\n<div class=\"h-full w-full\">\n<div class=\"cm-editor \u037c1 \u037c2 \u037c4 \u037c8p \u037c5k\">\n<div class=\"cm-announced\" aria-live=\"polite\"><\/div>\n<div class=\"cm-scroller\" tabindex=\"-1\">\n<div class=\"cm-content\" role=\"textbox\" contenteditable=\"false\" spellcheck=\"false\" translate=\"no\" aria-multiline=\"true\">\n<div class=\"cm-line\">cursor.execute(&#8220;INSERT INTO fish VALUES (&#8216;Sammy&#8217;, &#8216;shark&#8217;, 1)&#8221;)<\/div>\n<div class=\"cm-line\">cursor.execute(&#8220;INSERT INTO fish VALUES (&#8216;Jamie&#8217;, &#8216;cuttlefish&#8217;, 7)&#8221;)<\/div>\n<\/div>\n<div class=\"cm-layer cm-layer-above cm-cursorLayer\" aria-hidden=\"true\"><\/div>\n<div class=\"cm-layer cm-selectionLayer\" aria-hidden=\"true\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"plt-canvas-10611d94-a3e1-4af7-bd5e-8400ccb379c9-53\" class=\"bg-gray-50 dark:bg-[#202123] text-gray-900 dark:text-white max-w-full overflow-x-auto scrollbar-hidden\"><\/div>\n<\/div>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0645\u0627 <code class=\"cursor-pointer codespan\">cursor.execute()<\/code> \u0631\u0627 \u062f\u0648 \u0628\u0627\u0631 \u0641\u0631\u0627\u062e\u0648\u0627\u0646\u06cc \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645: \u06cc\u06a9 \u0628\u0627\u0631 \u0628\u0631\u0627\u06cc \u062f\u0631\u062c \u0631\u062f\u06cc\u0641 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u06a9\u0648\u0633\u0647 \u0633\u0627\u0645\u06cc \u062f\u0631 \u062a\u0627\u0646\u06a9 1 \u0648 \u06cc\u06a9 \u0628\u0627\u0631 \u0628\u0631\u0627\u06cc \u062f\u0631\u062c \u0631\u062f\u06cc\u0641 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0645\u0627\u0647\u06cc \u0645\u0631\u06a9\u0628 \u062c\u06cc\u0645\u06cc \u062f\u0631 \u062a\u0627\u0646\u06a9 7. \u0639\u0628\u0627\u0631\u062a <code class=\"cursor-pointer codespan\">\"INSERT INTO fish VALUES ...\"<\/code> \u06cc\u06a9 \u062f\u0633\u062a\u0648\u0631 SQL \u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u0645\u0627 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc\u200c\u062f\u0647\u062f \u0631\u062f\u06cc\u0641\u200c\u0647\u0627\u06cc\u06cc \u0631\u0627 \u0628\u0647 \u062c\u062f\u0648\u0644 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u0645.<\/p>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u062f\u0631 \u0628\u062e\u0634 \u0628\u0639\u062f\u060c \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 <code class=\"cursor-pointer codespan\">SELECT<\/code> \u062f\u0631 SQL \u0628\u0631\u0627\u06cc \u0628\u0631\u0631\u0633\u06cc \u0631\u062f\u06cc\u0641\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0628\u0647 \u062a\u0627\u0632\u06af\u06cc \u062f\u0631 \u062c\u062f\u0648\u0644 <code class=\"cursor-pointer codespan\">fish<\/code> \u062f\u0631\u062c \u06a9\u0631\u062f\u0647\u200c\u0627\u06cc\u0645 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f.<\/p>\n<div><\/div>\n<hr class=\"border-[#EBEBEB] dark:border-[#EBEBEB]\/16\" \/>\n<h3 class=\"svelte-4sys19\" dir=\"auto\">\u0645\u0631\u062d\u0644\u0647 \u06f3 \u2014 \u062e\u0648\u0627\u0646\u062f\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0627\u0632 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQLite<\/h3>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u062f\u0631 \u0645\u0631\u062d\u0644\u0647 2\u060c \u062f\u0648 \u0631\u062f\u06cc\u0641 \u0628\u0647 \u062c\u062f\u0648\u0644\u06cc \u0628\u0647 \u0646\u0627\u0645 <code class=\"cursor-pointer codespan\">fish<\/code> \u062f\u0631 SQLite \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u06cc\u0645. \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u06cc\u0646 \u0631\u062f\u06cc\u0641\u200c\u0647\u0627 \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 SQL \u0632\u06cc\u0631 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u06a9\u0646\u06cc\u0645:<\/p>\n<div><\/div>\n<div class=\"relative my-2 flex flex-col rounded-xl border border-[#0000000A] bg-[#F7F7F7] dark:bg-[#202123] p-2\" dir=\"ltr\">\n<div class=\"absolute pl-2 py-1 text-xs font-medium text-text-300 dark:text-white\">python<\/div>\n<div class=\"sticky top-8 mb-1 flex items-center justify-end z-11 text-xs text-black dark:text-white\">\n<div class=\"flex items-center gap-0.5 translate-y-[1px]\">\n<div id=\"bits-c530\" class=\"flex\" tabindex=\"0\" data-state=\"closed\" data-delay-duration=\"200\" data-tooltip-trigger=\"\" aria-label=\"Copy\"><\/div>\n<\/div>\n<\/div>\n<div class=\"language-python rounded-b-lg overflow-hidden\">\n<div class=\"h-full w-full\">\n<div class=\"cm-editor \u037c1 \u037c2 \u037c4 \u037c8q \u037c5k\">\n<div class=\"cm-announced\" aria-live=\"polite\"><\/div>\n<div class=\"cm-scroller\" tabindex=\"-1\">\n<div class=\"cm-content\" role=\"textbox\" contenteditable=\"false\" spellcheck=\"false\" translate=\"no\" aria-multiline=\"true\" data-language=\"python\">\n<div class=\"cm-line\"><span class=\"\u037c5m\">rows<\/span> <span class=\"\u037c5q\">=<\/span> <span class=\"\u037c5m\">cursor<\/span><span class=\"\u037c5t\">.<\/span><span class=\"\u037c5m\">execute<\/span>(<span class=\"\u037c5p\">&#8220;SELECT name, species, tank_number FROM fish&#8221;<\/span>)<span class=\"\u037c5t\">.<\/span><span class=\"\u037c5m\">fetchall<\/span>()<\/div>\n<div class=\"cm-line\"><span class=\"\u037c5r\">print<\/span>(<span class=\"\u037c5m\">rows<\/span>)<\/div>\n<\/div>\n<div class=\"cm-layer cm-layer-above cm-cursorLayer\" aria-hidden=\"true\"><\/div>\n<div class=\"cm-layer cm-selectionLayer\" aria-hidden=\"true\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"plt-canvas-10611d94-a3e1-4af7-bd5e-8400ccb379c9-63\" class=\"bg-gray-50 dark:bg-[#202123] text-gray-900 dark:text-white max-w-full overflow-x-auto scrollbar-hidden\"><\/div>\n<\/div>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0627\u06af\u0631 \u0627\u06cc\u0646 \u06a9\u062f \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u0645\u060c \u062e\u0631\u0648\u062c\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u0645\u0634\u0627\u0647\u062f\u0647 \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f:<\/p>\n<div><\/div>\n<div class=\"relative my-2 flex flex-col rounded-xl border border-[#0000000A] bg-[#F7F7F7] dark:bg-[#202123] p-2\" dir=\"ltr\">\n<div class=\"absolute pl-2 py-1 text-xs font-medium text-text-300 dark:text-white\">text<\/div>\n<div class=\"sticky top-8 mb-1 flex items-center justify-end z-11 text-xs text-black dark:text-white\">\n<div class=\"flex items-center gap-0.5 translate-y-[1px]\">\n<div id=\"bits-c532\" class=\"flex\" tabindex=\"0\" data-state=\"closed\" data-delay-duration=\"200\" data-tooltip-trigger=\"\" aria-label=\"Copy\"><\/div>\n<\/div>\n<\/div>\n<div class=\"language-text rounded-b-lg overflow-hidden\">\n<div class=\"h-full w-full\">\n<div class=\"cm-editor \u037c1 \u037c2 \u037c4 \u037c8r \u037c5k\">\n<div class=\"cm-announced\" aria-live=\"polite\"><\/div>\n<div class=\"cm-scroller\" tabindex=\"-1\">\n<div class=\"cm-content\" role=\"textbox\" contenteditable=\"false\" spellcheck=\"false\" translate=\"no\" aria-multiline=\"true\">\n<div class=\"cm-line\">Output<\/div>\n<div class=\"cm-line\">[(&#8216;Sammy&#8217;, &#8216;shark&#8217;, 1), (&#8216;Jamie&#8217;, &#8216;cuttlefish&#8217;, 7)]<\/div>\n<\/div>\n<div class=\"cm-layer cm-layer-above cm-cursorLayer\" aria-hidden=\"true\"><\/div>\n<div class=\"cm-layer cm-selectionLayer\" aria-hidden=\"true\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"plt-canvas-10611d94-a3e1-4af7-bd5e-8400ccb379c9-67\" class=\"bg-gray-50 dark:bg-[#202123] text-gray-900 dark:text-white max-w-full overflow-x-auto scrollbar-hidden\"><\/div>\n<\/div>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u062a\u0627\u0628\u0639 <code class=\"cursor-pointer codespan\">cursor.execute()<\/code> \u062f\u0633\u062a\u0648\u0631 <code class=\"cursor-pointer codespan\">SELECT<\/code> \u0631\u0627 \u0627\u062c\u0631\u0627 \u0645\u06cc\u200c\u06a9\u0646\u062f \u062a\u0627 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc <code class=\"cursor-pointer codespan\">name<\/code>\u060c <code class=\"cursor-pointer codespan\">species<\/code> \u0648 <code class=\"cursor-pointer codespan\">tank_number<\/code> \u0631\u0627 \u0627\u0632 \u062c\u062f\u0648\u0644 <code class=\"cursor-pointer codespan\">fish<\/code> \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u06a9\u0646\u062f. \u0645\u062a\u062f <code class=\"cursor-pointer codespan\">fetchall()<\/code> \u062a\u0645\u0627\u0645 \u0646\u062a\u0627\u06cc\u062c \u062f\u0633\u062a\u0648\u0631 <code class=\"cursor-pointer codespan\">SELECT<\/code> \u0631\u0627 \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f. \u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 <code class=\"cursor-pointer codespan\">print(rows)<\/code> \u0631\u0627 \u0627\u062c\u0631\u0627 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645\u060c \u0644\u06cc\u0633\u062a\u06cc \u0627\u0632 \u062f\u0648 \u062a\u0627\u067e\u0644 (Tuple) \u0631\u0627 \u0645\u06cc\u200c\u0628\u06cc\u0646\u06cc\u0645. \u0647\u0631 \u062a\u0627\u067e\u0644 \u062f\u0627\u0631\u0627\u06cc \u0633\u0647 \u0648\u0631\u0648\u062f\u06cc \u0627\u0633\u062a\u061b \u06cc\u06a9 \u0648\u0631\u0648\u062f\u06cc \u0628\u0631\u0627\u06cc \u0647\u0631 \u0633\u062a\u0648\u0646\u06cc \u06a9\u0647 \u0627\u0632 \u062c\u062f\u0648\u0644 <code class=\"cursor-pointer codespan\">fish<\/code> \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0631\u062f\u0647\u200c\u0627\u06cc\u0645. \u0627\u06cc\u0646 \u062f\u0648 \u062a\u0627\u067e\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc\u06cc \u0631\u0627 \u062f\u0627\u0631\u0646\u062f \u06a9\u0647 \u062f\u0631 \u0645\u0631\u062d\u0644\u0647 2 \u062f\u0631\u062c \u06a9\u0631\u062f\u06cc\u0645: \u06cc\u06a9 \u062a\u0627\u067e\u0644 \u0628\u0631\u0627\u06cc \u06a9\u0648\u0633\u0647 \u0633\u0627\u0645\u06cc \u0648 \u06cc\u06a9 \u062a\u0627\u067e\u0644 \u0628\u0631\u0627\u06cc \u0645\u0627\u0647\u06cc \u0645\u0631\u06a9\u0628 \u062c\u06cc\u0645\u06cc.<\/p>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u0645 \u0631\u062f\u06cc\u0641\u200c\u0647\u0627\u06cc\u06cc \u0631\u0627 \u062f\u0631 \u062c\u062f\u0648\u0644 <code class=\"cursor-pointer codespan\">fish<\/code> \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0628\u0627 \u0645\u0639\u06cc\u0627\u0631\u0647\u0627\u06cc \u062e\u0627\u0635\u06cc \u0645\u0637\u0627\u0628\u0642\u062a \u062f\u0627\u0631\u0646\u062f\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u0632 \u0628\u0646\u062f <code class=\"cursor-pointer codespan\">WHERE<\/code> \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645:<\/p>\n<div><\/div>\n<div class=\"relative my-2 flex flex-col rounded-xl border border-[#0000000A] bg-[#F7F7F7] dark:bg-[#202123] p-2\" dir=\"ltr\">\n<div class=\"absolute pl-2 py-1 text-xs font-medium text-text-300 dark:text-white\">python<\/div>\n<div class=\"sticky top-8 mb-1 flex items-center justify-end z-11 text-xs text-black dark:text-white\">\n<div class=\"flex items-center gap-0.5 translate-y-[1px]\">\n<div id=\"bits-c534\" class=\"flex\" tabindex=\"0\" data-state=\"closed\" data-delay-duration=\"200\" data-tooltip-trigger=\"\" aria-label=\"Copy\"><\/div>\n<\/div>\n<\/div>\n<div class=\"language-python rounded-b-lg overflow-hidden\">\n<div class=\"h-full w-full\">\n<div class=\"cm-editor \u037c1 \u037c2 \u037c4 \u037c8s \u037c5k\">\n<div class=\"cm-announced\" aria-live=\"polite\"><\/div>\n<div class=\"cm-scroller\" tabindex=\"-1\">\n<div class=\"cm-content\" role=\"textbox\" contenteditable=\"false\" spellcheck=\"false\" translate=\"no\" aria-multiline=\"true\">\n<div class=\"cm-line\">target_fish_name = &#8220;Jamie&#8221;<\/div>\n<div class=\"cm-line\">rows = cursor.execute(<\/div>\n<div class=\"cm-line\">&#8220;SELECT name, species, tank_number FROM fish WHERE name = ?&#8221;,<\/div>\n<div class=\"cm-line\">(target_fish_name,),<\/div>\n<div class=\"cm-line\">).fetchall()<\/div>\n<div class=\"cm-line\">print(rows)<\/div>\n<\/div>\n<div class=\"cm-layer cm-layer-above cm-cursorLayer\" aria-hidden=\"true\"><\/div>\n<div class=\"cm-layer cm-selectionLayer\" aria-hidden=\"true\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"plt-canvas-10611d94-a3e1-4af7-bd5e-8400ccb379c9-73\" class=\"bg-gray-50 dark:bg-[#202123] text-gray-900 dark:text-white max-w-full overflow-x-auto scrollbar-hidden\"><\/div>\n<\/div>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0627\u06af\u0631 \u0627\u06cc\u0646 \u06a9\u062f \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u0645\u060c \u062e\u0631\u0648\u062c\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u062e\u0648\u0627\u0647\u06cc\u0645 \u062f\u06cc\u062f:<\/p>\n<div><\/div>\n<div class=\"relative my-2 flex flex-col rounded-xl border border-[#0000000A] bg-[#F7F7F7] dark:bg-[#202123] p-2\" dir=\"ltr\">\n<div class=\"absolute pl-2 py-1 text-xs font-medium text-text-300 dark:text-white\">text<\/div>\n<div class=\"sticky top-8 mb-1 flex items-center justify-end z-11 text-xs text-black dark:text-white\">\n<div class=\"flex items-center gap-0.5 translate-y-[1px]\">\n<div id=\"bits-c536\" class=\"flex\" tabindex=\"0\" data-state=\"closed\" data-delay-duration=\"200\" data-tooltip-trigger=\"\" aria-label=\"Copy\"><\/div>\n<\/div>\n<\/div>\n<div class=\"language-text rounded-b-lg overflow-hidden\">\n<div class=\"h-full w-full\">\n<div class=\"cm-editor \u037c1 \u037c2 \u037c4 \u037c8t \u037c5k\">\n<div class=\"cm-announced\" aria-live=\"polite\"><\/div>\n<div class=\"cm-scroller\" tabindex=\"-1\">\n<div class=\"cm-content\" role=\"textbox\" contenteditable=\"false\" spellcheck=\"false\" translate=\"no\" aria-multiline=\"true\">\n<div class=\"cm-line\">Output<\/div>\n<div class=\"cm-line\">[(&#8216;Jamie&#8217;, &#8216;cuttlefish&#8217;, 7)]<\/div>\n<\/div>\n<div class=\"cm-layer cm-layer-above cm-cursorLayer\" aria-hidden=\"true\"><\/div>\n<div class=\"cm-layer cm-selectionLayer\" aria-hidden=\"true\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"plt-canvas-10611d94-a3e1-4af7-bd5e-8400ccb379c9-77\" class=\"bg-gray-50 dark:bg-[#202123] text-gray-900 dark:text-white max-w-full overflow-x-auto scrollbar-hidden\"><\/div>\n<\/div>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0645\u0627\u0646\u0646\u062f \u0645\u062b\u0627\u0644 \u0642\u0628\u0644\u06cc\u060c <code class=\"cursor-pointer codespan\">cursor.execute(&lt;SQL statement&gt;).fetchall()<\/code> \u0628\u0647 \u0645\u0627 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc\u200c\u062f\u0647\u062f \u062a\u0645\u0627\u0645 \u0646\u062a\u0627\u06cc\u062c \u06cc\u06a9 \u062f\u0633\u062a\u0648\u0631 <code class=\"cursor-pointer codespan\">SELECT<\/code> \u0631\u0627 \u0648\u0627\u06a9\u0634\u06cc \u06a9\u0646\u06cc\u0645. \u0628\u0646\u062f <code class=\"cursor-pointer codespan\">WHERE<\/code> \u062f\u0631 \u062f\u0633\u062a\u0648\u0631 <code class=\"cursor-pointer codespan\">SELECT<\/code>\u060c \u0631\u062f\u06cc\u0641\u200c\u0647\u0627\u06cc\u06cc \u0631\u0627 \u0641\u06cc\u0644\u062a\u0631 \u0645\u06cc\u200c\u06a9\u0646\u062f \u06a9\u0647 \u0645\u0642\u062f\u0627\u0631 <code class=\"cursor-pointer codespan\">name<\/code> \u062f\u0631 \u0622\u0646\u200c\u0647\u0627 \u0628\u0631\u0627\u0628\u0631 \u0628\u0627 \u0645\u062a\u063a\u06cc\u0631 <code class=\"cursor-pointer codespan\">target_fish_name<\/code> \u0628\u0627\u0634\u062f. \u062f\u0642\u062a \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0645\u0627 \u0627\u0632 \u0639\u0644\u0627\u0645\u062a <code class=\"cursor-pointer codespan\">?<\/code> \u0628\u0631\u0627\u06cc \u062c\u0627\u06cc\u06af\u0630\u0627\u0631\u06cc \u0627\u06cc\u0645\u0646 \u0645\u062a\u063a\u06cc\u0631 <code class=\"cursor-pointer codespan\">target_fish_name<\/code> \u062f\u0631 \u062f\u0633\u062a\u0648\u0631 <code class=\"cursor-pointer codespan\">SELECT<\/code> \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f\u0647\u200c\u0627\u06cc\u0645. \u0645\u0627 \u0627\u0646\u062a\u0638\u0627\u0631 \u062f\u0627\u0631\u06cc\u0645 \u0641\u0642\u0637 \u06cc\u06a9 \u0631\u062f\u06cc\u0641 \u0645\u0637\u0627\u0628\u0642\u062a \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f \u0648 \u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u0645\u06cc\u200c\u0628\u06cc\u0646\u06cc\u062f\u060c \u0641\u0642\u0637 \u0631\u062f\u06cc\u0641 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u062c\u06cc\u0645\u06cc \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a.<\/p>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\"><em>\u0647\u0634\u062f\u0627\u0631: \u0647\u0631\u06af\u0632 \u0627\u0632 \u0639\u0645\u0644\u06cc\u0627\u062a \u0631\u0634\u062a\u0647\u200c\u0627\u06cc (String Operations) \u067e\u0627\u06cc\u062a\u0648\u0646 \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u067e\u0648\u06cc\u0627 \u06cc\u06a9 \u062f\u0633\u062a\u0648\u0631 SQL \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0646\u06a9\u0646\u06cc\u062f. \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u0631\u0648\u0634 \u0634\u0645\u0627 \u0631\u0627 \u062f\u0631 \u0628\u0631\u0627\u0628\u0631 \u062d\u0645\u0644\u0627\u062a \u062a\u0632\u0631\u06cc\u0642 SQL (SQL Injection) \u0622\u0633\u06cc\u0628\u200c\u067e\u0630\u06cc\u0631 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u062d\u0645\u0644\u0627\u062a \u062a\u0632\u0631\u06cc\u0642 SQL \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0628\u0631\u0627\u06cc \u0633\u0631\u0642\u062a\u060c \u062a\u063a\u06cc\u06cc\u0631 \u06cc\u0627 \u0627\u0635\u0644\u0627\u062d \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u0634\u062f\u0647 \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0634\u0645\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u0648\u0646\u062f. \u0647\u0645\u06cc\u0634\u0647 \u0627\u0632 \u062c\u0627\u06cc\u200c\u062f\u0627\u0631 <code class=\"cursor-pointer codespan\">?<\/code> \u062f\u0631 \u062f\u0633\u062a\u0648\u0631\u0627\u062a SQL \u062e\u0648\u062f \u0628\u0631\u0627\u06cc \u062c\u0627\u06cc\u06af\u0630\u0627\u0631\u06cc \u067e\u0648\u06cc\u0627\u06cc \u0645\u0642\u0627\u062f\u06cc\u0631 \u0627\u0632 \u0628\u0631\u0646\u0627\u0645\u0647 \u067e\u0627\u06cc\u062a\u0648\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f. \u06cc\u06a9 \u062a\u0627\u067e\u0644 \u0627\u0632 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0631\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0622\u0631\u06af\u0648\u0645\u0627\u0646 \u062f\u0648\u0645 \u0628\u0647 <code class=\"cursor-pointer codespan\">Cursor.execute()<\/code> \u067e\u0627\u0633 \u062f\u0647\u06cc\u062f \u062a\u0627 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0634\u0645\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0627\u06cc\u0645\u0646 \u0628\u0647 \u062f\u0633\u062a\u0648\u0631 SQL \u0645\u062a\u0635\u0644 \u0634\u0648\u0646\u062f.<\/em><\/p>\n<div><\/div>\n<hr class=\"border-[#EBEBEB] dark:border-[#EBEBEB]\/16\" \/>\n<h3 class=\"svelte-4sys19\" dir=\"auto\">\u0645\u0631\u062d\u0644\u0647 \u06f4 \u2014 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQLite<\/h3>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0631\u062f\u06cc\u0641\u200c\u0647\u0627\u06cc \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQLite \u0631\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631\u0627\u062a <code class=\"cursor-pointer codespan\">UPDATE<\/code> \u0648 <code class=\"cursor-pointer codespan\">DELETE<\/code> \u062f\u0631 SQL \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0627\u062f.<\/p>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644\u060c \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u06a9\u0648\u0633\u0647 \u0633\u0627\u0645\u06cc \u0628\u0647 \u062a\u0627\u0646\u06a9 \u0634\u0645\u0627\u0631\u0647 2 \u0645\u0646\u062a\u0642\u0644 \u0634\u062f\u0647 \u0627\u0633\u062a. \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0631\u062f\u06cc\u0641 \u0633\u0627\u0645\u06cc \u0631\u0627 \u062f\u0631 \u062c\u062f\u0648\u0644 <code class=\"cursor-pointer codespan\">fish<\/code> \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u0645 \u062a\u0627 \u0627\u06cc\u0646 \u062a\u063a\u06cc\u06cc\u0631 \u0631\u0627 \u0645\u0646\u0639\u06a9\u0633 \u06a9\u0646\u062f:<\/p>\n<div><\/div>\n<div class=\"relative my-2 flex flex-col rounded-xl border border-[#0000000A] bg-[#F7F7F7] dark:bg-[#202123] p-2\" dir=\"ltr\">\n<div class=\"absolute pl-2 py-1 text-xs font-medium text-text-300 dark:text-white\">python<\/div>\n<div class=\"sticky top-8 mb-1 flex items-center justify-end z-11 text-xs text-black dark:text-white\">\n<div class=\"flex items-center gap-0.5 translate-y-[1px]\">\n<div id=\"bits-c538\" class=\"flex\" tabindex=\"0\" data-state=\"closed\" data-delay-duration=\"200\" data-tooltip-trigger=\"\" aria-label=\"Copy\"><\/div>\n<\/div>\n<\/div>\n<div class=\"language-python rounded-b-lg overflow-hidden\">\n<div class=\"h-full w-full\">\n<div class=\"cm-editor \u037c1 \u037c2 \u037c4 \u037c8u \u037c5k\">\n<div class=\"cm-announced\" aria-live=\"polite\"><\/div>\n<div class=\"cm-scroller\" tabindex=\"-1\">\n<div class=\"cm-content\" role=\"textbox\" contenteditable=\"false\" spellcheck=\"false\" translate=\"no\" aria-multiline=\"true\">\n<div class=\"cm-line\">new_tank_number = 2<\/div>\n<div class=\"cm-line\">moved_fish_name = &#8220;Sammy&#8221;<\/div>\n<div class=\"cm-line\">cursor.execute(<\/div>\n<div class=\"cm-line\">&#8220;UPDATE fish SET tank_number = ? WHERE name = ?&#8221;,<\/div>\n<div class=\"cm-line\">(new_tank_number, moved_fish_name)<\/div>\n<div class=\"cm-line\">)<\/div>\n<\/div>\n<div class=\"cm-layer cm-layer-above cm-cursorLayer\" aria-hidden=\"true\"><\/div>\n<div class=\"cm-layer cm-selectionLayer\" aria-hidden=\"true\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"plt-canvas-10611d94-a3e1-4af7-bd5e-8400ccb379c9-89\" class=\"bg-gray-50 dark:bg-[#202123] text-gray-900 dark:text-white max-w-full overflow-x-auto scrollbar-hidden\"><\/div>\n<\/div>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0645\u0627 \u06cc\u06a9 \u062f\u0633\u062a\u0648\u0631 <code class=\"cursor-pointer codespan\">UPDATE<\/code> \u0635\u0627\u062f\u0631 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645 \u062a\u0627 <code class=\"cursor-pointer codespan\">tank_number<\/code> \u0633\u0627\u0645\u06cc \u0631\u0627 \u0628\u0647 \u0645\u0642\u062f\u0627\u0631 \u062c\u062f\u06cc\u062f \u06cc\u0639\u0646\u06cc 2 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u0645. \u0628\u0646\u062f <code class=\"cursor-pointer codespan\">WHERE<\/code> \u062f\u0631 \u062f\u0633\u062a\u0648\u0631 <code class=\"cursor-pointer codespan\">UPDATE<\/code> \u062a\u0636\u0645\u06cc\u0646 \u0645\u06cc\u200c\u06a9\u0646\u062f \u06a9\u0647 \u0641\u0642\u0637 \u062f\u0631 \u0635\u0648\u0631\u062a\u06cc \u0645\u0642\u062f\u0627\u0631 <code class=\"cursor-pointer codespan\">tank_number<\/code> \u0631\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u0645 \u06a9\u0647 \u0631\u062f\u06cc\u0641 \u062f\u0627\u0631\u0627\u06cc <code class=\"cursor-pointer codespan\">name = \"Sammy\"<\/code> \u0628\u0627\u0634\u062f.<\/p>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0627\u06af\u0631 \u062f\u0633\u062a\u0648\u0631 <code class=\"cursor-pointer codespan\">SELECT<\/code> \u0632\u06cc\u0631 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u0645\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0635\u062d\u062a \u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u062e\u0648\u062f \u0631\u0627 \u062a\u0627\u06cc\u06cc\u062f \u06a9\u0646\u06cc\u0645:<\/p>\n<div><\/div>\n<div class=\"relative my-2 flex flex-col rounded-xl border border-[#0000000A] bg-[#F7F7F7] dark:bg-[#202123] p-2\" dir=\"ltr\">\n<div class=\"absolute pl-2 py-1 text-xs font-medium text-text-300 dark:text-white\">python<\/div>\n<div class=\"sticky top-8 mb-1 flex items-center justify-end z-11 text-xs text-black dark:text-white\">\n<div class=\"flex items-center gap-0.5 translate-y-[1px]\">\n<div id=\"bits-c540\" class=\"flex\" tabindex=\"0\" data-state=\"closed\" data-delay-duration=\"200\" data-tooltip-trigger=\"\" aria-label=\"Copy\"><\/div>\n<\/div>\n<\/div>\n<div class=\"language-python rounded-b-lg overflow-hidden\">\n<div class=\"h-full w-full\">\n<div class=\"cm-editor \u037c1 \u037c2 \u037c4 \u037c8v \u037c5k\">\n<div class=\"cm-announced\" aria-live=\"polite\"><\/div>\n<div class=\"cm-scroller\" tabindex=\"-1\">\n<div class=\"cm-content\" role=\"textbox\" contenteditable=\"false\" spellcheck=\"false\" translate=\"no\" aria-multiline=\"true\">\n<div class=\"cm-line\">rows = cursor.execute(&#8220;SELECT name, species, tank_number FROM fish&#8221;).fetchall()<\/div>\n<div class=\"cm-line\">print(rows)<\/div>\n<\/div>\n<div class=\"cm-layer cm-layer-above cm-cursorLayer\" aria-hidden=\"true\"><\/div>\n<div class=\"cm-layer cm-selectionLayer\" aria-hidden=\"true\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"plt-canvas-10611d94-a3e1-4af7-bd5e-8400ccb379c9-95\" class=\"bg-gray-50 dark:bg-[#202123] text-gray-900 dark:text-white max-w-full overflow-x-auto scrollbar-hidden\"><\/div>\n<\/div>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u062e\u0631\u0648\u062c\u06cc \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f:<\/p>\n<div><\/div>\n<div class=\"relative my-2 flex flex-col rounded-xl border border-[#0000000A] bg-[#F7F7F7] dark:bg-[#202123] p-2\" dir=\"ltr\">\n<div class=\"absolute pl-2 py-1 text-xs font-medium text-text-300 dark:text-white\">text<\/div>\n<div class=\"sticky top-8 mb-1 flex items-center justify-end z-11 text-xs text-black dark:text-white\">\n<div class=\"flex items-center gap-0.5 translate-y-[1px]\">\n<div id=\"bits-c542\" class=\"flex\" tabindex=\"0\" data-state=\"closed\" data-delay-duration=\"200\" data-tooltip-trigger=\"\" aria-label=\"Copy\"><\/div>\n<\/div>\n<\/div>\n<div class=\"language-text rounded-b-lg overflow-hidden\">\n<div class=\"h-full w-full\">\n<div class=\"cm-editor \u037c1 \u037c2 \u037c4 \u037c8w \u037c5k\">\n<div class=\"cm-announced\" aria-live=\"polite\"><\/div>\n<div class=\"cm-scroller\" tabindex=\"-1\">\n<div class=\"cm-content\" role=\"textbox\" contenteditable=\"false\" spellcheck=\"false\" translate=\"no\" aria-multiline=\"true\">\n<div class=\"cm-line\">Output<\/div>\n<div class=\"cm-line\">[(&#8216;Sammy&#8217;, &#8216;shark&#8217;, 2), (&#8216;Jamie&#8217;, &#8216;cuttlefish&#8217;, 7)]<\/div>\n<\/div>\n<div class=\"cm-layer cm-layer-above cm-cursorLayer\" aria-hidden=\"true\"><\/div>\n<div class=\"cm-layer cm-selectionLayer\" aria-hidden=\"true\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"plt-canvas-10611d94-a3e1-4af7-bd5e-8400ccb379c9-99\" class=\"bg-gray-50 dark:bg-[#202123] text-gray-900 dark:text-white max-w-full overflow-x-auto scrollbar-hidden\"><\/div>\n<\/div>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u062a\u0648\u062c\u0647 \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0631\u062f\u06cc\u0641 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0633\u0627\u0645\u06cc \u0627\u06a9\u0646\u0648\u0646 \u062f\u0627\u0631\u0627\u06cc \u0645\u0642\u062f\u0627\u0631 2 \u0628\u0631\u0627\u06cc \u0633\u062a\u0648\u0646 <code class=\"cursor-pointer codespan\">tank_number<\/code> \u0627\u0633\u062a.<\/p>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u062d\u0627\u0644\u0627 \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u06a9\u0648\u0633\u0647 \u0633\u0627\u0645\u06cc \u0628\u0647 \u0637\u0628\u06cc\u0639\u062a \u0631\u0647\u0627 \u0634\u062f\u0647 \u0627\u0633\u062a \u0648 \u062f\u06cc\u06af\u0631 \u062f\u0631 \u0622\u06a9\u0648\u0627\u0631\u06cc\u0648\u0645 \u0646\u06af\u0647\u062f\u0627\u0631\u06cc \u0646\u0645\u06cc\u200c\u0634\u0648\u062f. \u0627\u0632 \u0622\u0646\u062c\u0627\u06cc\u06cc \u06a9\u0647 \u0633\u0627\u0645\u06cc \u062f\u06cc\u06af\u0631 \u062f\u0631 \u0622\u06a9\u0648\u0627\u0631\u06cc\u0648\u0645 \u0632\u0646\u062f\u06af\u06cc \u0646\u0645\u06cc\u200c\u06a9\u0646\u062f\u060c \u0645\u0646\u0637\u0642\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0631\u062f\u06cc\u0641 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0627\u0648 \u0631\u0627 \u0627\u0632 \u062c\u062f\u0648\u0644 <code class=\"cursor-pointer codespan\">fish<\/code> \u062d\u0630\u0641 \u06a9\u0646\u06cc\u0645.<\/p>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0628\u0631\u0627\u06cc \u062d\u0630\u0641 \u06cc\u06a9 \u0631\u062f\u06cc\u0641\u060c \u062f\u0633\u062a\u0648\u0631 <code class=\"cursor-pointer codespan\">DELETE<\/code> \u0631\u0627 \u0635\u0627\u062f\u0631 \u06a9\u0646\u06cc\u062f:<\/p>\n<div><\/div>\n<div class=\"relative my-2 flex flex-col rounded-xl border border-[#0000000A] bg-[#F7F7F7] dark:bg-[#202123] p-2\" dir=\"ltr\">\n<div class=\"absolute pl-2 py-1 text-xs font-medium text-text-300 dark:text-white\">python<\/div>\n<div class=\"sticky top-8 mb-1 flex items-center justify-end z-11 text-xs text-black dark:text-white\">\n<div class=\"flex items-center gap-0.5 translate-y-[1px]\">\n<div id=\"bits-c544\" class=\"flex\" tabindex=\"0\" data-state=\"closed\" data-delay-duration=\"200\" data-tooltip-trigger=\"\" aria-label=\"Copy\"><\/div>\n<\/div>\n<\/div>\n<div class=\"language-python rounded-b-lg overflow-hidden\">\n<div class=\"h-full w-full\">\n<div class=\"cm-editor \u037c1 \u037c2 \u037c4 \u037c8x \u037c5k\">\n<div class=\"cm-announced\" aria-live=\"polite\"><\/div>\n<div class=\"cm-scroller\" tabindex=\"-1\">\n<div class=\"cm-content\" role=\"textbox\" contenteditable=\"false\" spellcheck=\"false\" translate=\"no\" aria-multiline=\"true\">\n<div class=\"cm-line\">released_fish_name = &#8220;Sammy&#8221;<\/div>\n<div class=\"cm-line\">cursor.execute(<\/div>\n<div class=\"cm-line\">&#8220;DELETE FROM fish WHERE name = ?&#8221;,<\/div>\n<div class=\"cm-line\">(released_fish_name,)<\/div>\n<div class=\"cm-line\">)<\/div>\n<\/div>\n<div class=\"cm-layer cm-layer-above cm-cursorLayer\" aria-hidden=\"true\"><\/div>\n<div class=\"cm-layer cm-selectionLayer\" aria-hidden=\"true\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"plt-canvas-10611d94-a3e1-4af7-bd5e-8400ccb379c9-107\" class=\"bg-gray-50 dark:bg-[#202123] text-gray-900 dark:text-white max-w-full overflow-x-auto scrollbar-hidden\"><\/div>\n<\/div>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0645\u0627 \u06cc\u06a9 \u062f\u0633\u062a\u0648\u0631 <code class=\"cursor-pointer codespan\">DELETE<\/code> \u0635\u0627\u062f\u0631 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645 \u062a\u0627 \u0631\u062f\u06cc\u0641 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u06a9\u0648\u0633\u0647 \u0633\u0627\u0645\u06cc \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u0645. \u0628\u0646\u062f <code class=\"cursor-pointer codespan\">WHERE<\/code> \u062f\u0631 \u062f\u0633\u062a\u0648\u0631 <code class=\"cursor-pointer codespan\">DELETE<\/code> \u062a\u0636\u0645\u06cc\u0646 \u0645\u06cc\u200c\u06a9\u0646\u062f \u06a9\u0647 \u0641\u0642\u0637 \u0631\u062f\u06cc\u0641\u06cc \u062d\u0630\u0641 \u0634\u0648\u062f \u06a9\u0647 \u062f\u0627\u0631\u0627\u06cc <code class=\"cursor-pointer codespan\">name = \"Sammy\"<\/code> \u0628\u0627\u0634\u062f.<\/p>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0627\u06af\u0631 \u062f\u0633\u062a\u0648\u0631 <code class=\"cursor-pointer codespan\">SELECT<\/code> \u0632\u06cc\u0631 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u0645\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0635\u062d\u062a \u062d\u0630\u0641 \u062e\u0648\u062f \u0631\u0627 \u062a\u0627\u06cc\u06cc\u062f \u06a9\u0646\u06cc\u0645:<\/p>\n<div><\/div>\n<div class=\"relative my-2 flex flex-col rounded-xl border border-[#0000000A] bg-[#F7F7F7] dark:bg-[#202123] p-2\" dir=\"ltr\">\n<div class=\"absolute pl-2 py-1 text-xs font-medium text-text-300 dark:text-white\">python<\/div>\n<div class=\"sticky top-8 mb-1 flex items-center justify-end z-11 text-xs text-black dark:text-white\">\n<div class=\"flex items-center gap-0.5 translate-y-[1px]\">\n<div id=\"bits-c546\" class=\"flex\" tabindex=\"0\" data-state=\"closed\" data-delay-duration=\"200\" data-tooltip-trigger=\"\" aria-label=\"Copy\"><\/div>\n<\/div>\n<\/div>\n<div class=\"language-python rounded-b-lg overflow-hidden\">\n<div class=\"h-full w-full\">\n<div class=\"cm-editor \u037c1 \u037c2 \u037c4 \u037c8y \u037c5k\">\n<div class=\"cm-announced\" aria-live=\"polite\"><\/div>\n<div class=\"cm-scroller\" tabindex=\"-1\">\n<div class=\"cm-content\" role=\"textbox\" contenteditable=\"false\" spellcheck=\"false\" translate=\"no\" aria-multiline=\"true\">\n<div class=\"cm-line\">rows = cursor.execute(&#8220;SELECT name, species, tank_number FROM fish&#8221;).fetchall()<\/div>\n<div class=\"cm-line\">print(rows)<\/div>\n<\/div>\n<div class=\"cm-layer cm-layer-above cm-cursorLayer\" aria-hidden=\"true\"><\/div>\n<div class=\"cm-layer cm-selectionLayer\" aria-hidden=\"true\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"plt-canvas-10611d94-a3e1-4af7-bd5e-8400ccb379c9-113\" class=\"bg-gray-50 dark:bg-[#202123] text-gray-900 dark:text-white max-w-full overflow-x-auto scrollbar-hidden\"><\/div>\n<\/div>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u062e\u0631\u0648\u062c\u06cc \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f:<\/p>\n<div><\/div>\n<div class=\"relative my-2 flex flex-col rounded-xl border border-[#0000000A] bg-[#F7F7F7] dark:bg-[#202123] p-2\" dir=\"ltr\">\n<div class=\"absolute pl-2 py-1 text-xs font-medium text-text-300 dark:text-white\">text<\/div>\n<div class=\"sticky top-8 mb-1 flex items-center justify-end z-11 text-xs text-black dark:text-white\">\n<div class=\"flex items-center gap-0.5 translate-y-[1px]\">\n<div id=\"bits-c548\" class=\"flex\" tabindex=\"0\" data-state=\"closed\" data-delay-duration=\"200\" data-tooltip-trigger=\"\" aria-label=\"Copy\"><\/div>\n<\/div>\n<\/div>\n<div class=\"language-text rounded-b-lg overflow-hidden\">\n<div class=\"h-full w-full\">\n<div class=\"cm-editor \u037c1 \u037c2 \u037c4 \u037c8z \u037c5k\">\n<div class=\"cm-announced\" aria-live=\"polite\"><\/div>\n<div class=\"cm-scroller\" tabindex=\"-1\">\n<div class=\"cm-content\" role=\"textbox\" contenteditable=\"false\" spellcheck=\"false\" translate=\"no\" aria-multiline=\"true\">\n<div class=\"cm-line\">Output<\/div>\n<div class=\"cm-line\">[(&#8216;Jamie&#8217;, &#8216;cuttlefish&#8217;, 7)]<\/div>\n<\/div>\n<div class=\"cm-layer cm-layer-above cm-cursorLayer\" aria-hidden=\"true\"><\/div>\n<div class=\"cm-layer cm-selectionLayer\" aria-hidden=\"true\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"plt-canvas-10611d94-a3e1-4af7-bd5e-8400ccb379c9-117\" class=\"bg-gray-50 dark:bg-[#202123] text-gray-900 dark:text-white max-w-full overflow-x-auto scrollbar-hidden\"><\/div>\n<\/div>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u0645\u06cc\u200c\u0628\u06cc\u0646\u06cc\u062f\u060c \u0631\u062f\u06cc\u0641 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u06a9\u0648\u0633\u0647 \u0633\u0627\u0645\u06cc \u062d\u0630\u0641 \u0634\u062f\u0647 \u0627\u0633\u062a \u0648 \u0641\u0642\u0637 \u0645\u0627\u0647\u06cc \u0645\u0631\u06a9\u0628 \u062c\u06cc\u0645\u06cc \u0628\u0627\u0642\u06cc \u0645\u0627\u0646\u062f\u0647 \u0627\u0633\u062a.<\/p>\n<div><\/div>\n<hr class=\"border-[#EBEBEB] dark:border-[#EBEBEB]\/16\" \/>\n<h3 class=\"svelte-4sys19\" dir=\"auto\">\u0645\u0631\u062d\u0644\u0647 \u06f5 \u2014 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631\u0627\u062a <code class=\"cursor-pointer codespan\">with<\/code> \u0628\u0631\u0627\u06cc \u067e\u0627\u06a9\u0633\u0627\u0632\u06cc \u062e\u0648\u062f\u06a9\u0627\u0631<\/h3>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634\u060c \u0645\u0627 \u0627\u0632 \u062f\u0648 \u0634\u06cc\u0621 \u0627\u0635\u0644\u06cc \u0628\u0631\u0627\u06cc \u062a\u0639\u0627\u0645\u0644 \u0628\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQLite <code class=\"cursor-pointer codespan\">\"aquarium.db\"<\/code> \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f\u0647\u200c\u0627\u06cc\u0645: \u06cc\u06a9 \u0634\u06cc\u0621 <code class=\"cursor-pointer codespan\">Connection<\/code> \u0628\u0647 \u0646\u0627\u0645 <code class=\"cursor-pointer codespan\">connection<\/code> \u0648 \u06cc\u06a9 \u0634\u06cc\u0621 <code class=\"cursor-pointer codespan\">Cursor<\/code> \u0628\u0647 \u0646\u0627\u0645 <code class=\"cursor-pointer codespan\">cursor<\/code>.<\/p>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u0641\u0627\u06cc\u0644\u200c\u0647\u0627\u06cc \u067e\u0627\u06cc\u062a\u0648\u0646 \u0628\u0627\u06cc\u062f \u067e\u0633 \u0627\u0632 \u0627\u062a\u0645\u0627\u0645 \u06a9\u0627\u0631 \u0628\u0627 \u0622\u0646\u200c\u0647\u0627 \u0628\u0633\u062a\u0647 \u0634\u0648\u0646\u062f\u060c \u0627\u0634\u06cc\u0627\u0621 <code class=\"cursor-pointer codespan\">Connection<\/code> \u0648 <code class=\"cursor-pointer codespan\">Cursor<\/code> \u0646\u06cc\u0632 \u0628\u0627\u06cc\u062f \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u062f\u06cc\u06af\u0631 \u0628\u0647 \u0622\u0646\u200c\u0647\u0627 \u0646\u06cc\u0627\u0632 \u0646\u06cc\u0633\u062a\u060c \u0628\u0633\u062a\u0647 \u0634\u0648\u0646\u062f.<\/p>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 <code class=\"cursor-pointer codespan\">with<\/code> \u0628\u0631\u0627\u06cc \u06a9\u0645\u06a9 \u0628\u0647 \u0628\u0633\u062a\u0647 \u0634\u062f\u0646 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0627\u0634\u06cc\u0627\u0621 <code class=\"cursor-pointer codespan\">Connection<\/code> \u0648 <code class=\"cursor-pointer codespan\">Cursor<\/code> \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645:<\/p>\n<div><\/div>\n<div class=\"relative my-2 flex flex-col rounded-xl border border-[#0000000A] bg-[#F7F7F7] dark:bg-[#202123] p-2\" dir=\"ltr\">\n<div class=\"absolute pl-2 py-1 text-xs font-medium text-text-300 dark:text-white\">python<\/div>\n<div class=\"sticky top-8 mb-1 flex items-center justify-end z-11 text-xs text-black dark:text-white\">\n<div class=\"flex items-center gap-0.5 translate-y-[1px]\">\n<div id=\"bits-c550\" class=\"flex\" tabindex=\"0\" data-state=\"closed\" data-delay-duration=\"200\" data-tooltip-trigger=\"\" aria-label=\"Copy\"><\/div>\n<\/div>\n<\/div>\n<div class=\"language-python rounded-b-lg overflow-hidden\">\n<div class=\"h-full w-full\">\n<div class=\"cm-editor \u037c1 \u037c2 \u037c4 \u037c90 \u037c5k\">\n<div class=\"cm-announced\" aria-live=\"polite\"><\/div>\n<div class=\"cm-scroller\" tabindex=\"-1\">\n<div class=\"cm-content\" role=\"textbox\" contenteditable=\"false\" spellcheck=\"false\" translate=\"no\" aria-multiline=\"true\">\n<div class=\"cm-line\">from contextlib import closing<\/div>\n<div class=\"cm-line\"><\/div>\n<div class=\"cm-line\">with closing(sqlite3.connect(&#8220;aquarium.db&#8221;)) as connection:<\/div>\n<div class=\"cm-line\">with closing(connection.cursor()) as cursor:<\/div>\n<div class=\"cm-line\">rows = cursor.execute(&#8220;SELECT 1&#8221;).fetchall()<\/div>\n<div class=\"cm-line\">print(rows)<\/div>\n<\/div>\n<div class=\"cm-layer cm-layer-above cm-cursorLayer\" aria-hidden=\"true\"><\/div>\n<div class=\"cm-layer cm-selectionLayer\" aria-hidden=\"true\">\n<div class=\"cm-selectionBackground\"><\/div>\n<div class=\"cm-selectionBackground\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"plt-canvas-10611d94-a3e1-4af7-bd5e-8400ccb379c9-129\" class=\"bg-gray-50 dark:bg-[#202123] text-gray-900 dark:text-white max-w-full overflow-x-auto scrollbar-hidden\"><\/div>\n<\/div>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u062a\u0627\u0628\u0639 <code class=\"cursor-pointer codespan\">closing<\/code> \u06cc\u06a9 \u062a\u0627\u0628\u0639 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u0627\u0633\u062a \u06a9\u0647 \u062a\u0648\u0633\u0637 \u0645\u0627\u0698\u0648\u0644 <code class=\"cursor-pointer codespan\">contextlib<\/code> \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u06cc\u06a9 \u0628\u0644\u0648\u06a9 <code class=\"cursor-pointer codespan\">with<\/code> \u0628\u0647 \u067e\u0627\u06cc\u0627\u0646 \u0645\u06cc\u200c\u0631\u0633\u062f\u060c <code class=\"cursor-pointer codespan\">closing<\/code> \u062a\u0636\u0645\u06cc\u0646 \u0645\u06cc\u200c\u06a9\u0646\u062f \u06a9\u0647 \u0645\u062a\u062f <code class=\"cursor-pointer codespan\">close()<\/code> \u0631\u0648\u06cc \u0647\u0631 \u0634\u06cc\u0626\u06cc \u06a9\u0647 \u0628\u0647 \u0622\u0646 \u067e\u0627\u0633 \u062f\u0627\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a \u0641\u0631\u0627\u062e\u0648\u0627\u0646\u06cc \u0634\u0648\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0645\u062b\u0627\u0644\u060c \u0627\u0632 \u062a\u0627\u0628\u0639 <code class=\"cursor-pointer codespan\">closing<\/code> \u062f\u0648 \u0628\u0627\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a. \u06cc\u06a9 \u0628\u0627\u0631 \u0628\u0631\u0627\u06cc \u0627\u0637\u0645\u06cc\u0646\u0627\u0646 \u0627\u0632 \u0628\u0633\u062a\u0647 \u0634\u062f\u0646 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0634\u06cc\u0621 <code class=\"cursor-pointer codespan\">Connection<\/code> \u0648 \u0628\u0627\u0631 \u062f\u0648\u0645 \u0628\u0631\u0627\u06cc \u0627\u0637\u0645\u06cc\u0646\u0627\u0646 \u0627\u0632 \u0628\u0633\u062a\u0647 \u0634\u062f\u0646 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0634\u06cc\u0621 <code class=\"cursor-pointer codespan\">Cursor<\/code>.<\/p>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0627\u06af\u0631 \u0627\u06cc\u0646 \u06a9\u062f \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u0645\u060c \u062e\u0631\u0648\u062c\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u0645\u0634\u0627\u0647\u062f\u0647 \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f:<\/p>\n<div><\/div>\n<div class=\"relative my-2 flex flex-col rounded-xl border border-[#0000000A] bg-[#F7F7F7] dark:bg-[#202123] p-2\" dir=\"ltr\">\n<div class=\"absolute pl-2 py-1 text-xs font-medium text-text-300 dark:text-white\">text<\/div>\n<div class=\"sticky top-8 mb-1 flex items-center justify-end z-11 text-xs text-black dark:text-white\">\n<div class=\"flex items-center gap-0.5 translate-y-[1px]\">\n<div id=\"bits-c552\" class=\"flex\" tabindex=\"0\" data-state=\"closed\" data-delay-duration=\"200\" data-tooltip-trigger=\"\" aria-label=\"Copy\"><\/div>\n<\/div>\n<\/div>\n<div class=\"language-text rounded-b-lg overflow-hidden\">\n<div class=\"h-full w-full\">\n<div class=\"cm-editor \u037c1 \u037c2 \u037c4 \u037c91 \u037c5k\">\n<div class=\"cm-announced\" aria-live=\"polite\"><\/div>\n<div class=\"cm-scroller\" tabindex=\"-1\">\n<div class=\"cm-content\" role=\"textbox\" contenteditable=\"false\" spellcheck=\"false\" translate=\"no\" aria-multiline=\"true\">\n<div class=\"cm-line\">Output<\/div>\n<div class=\"cm-line\">[(1,)]<\/div>\n<\/div>\n<div class=\"cm-layer cm-layer-above cm-cursorLayer\" aria-hidden=\"true\"><\/div>\n<div class=\"cm-layer cm-selectionLayer\" aria-hidden=\"true\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"plt-canvas-10611d94-a3e1-4af7-bd5e-8400ccb379c9-135\" class=\"bg-gray-50 dark:bg-[#202123] text-gray-900 dark:text-white max-w-full overflow-x-auto scrollbar-hidden\"><\/div>\n<\/div>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u0627\u0632 \u0622\u0646\u062c\u0627\u06cc\u06cc \u06a9\u0647 <code class=\"cursor-pointer codespan\">\"SELECT 1\"<\/code> \u06cc\u06a9 \u062f\u0633\u062a\u0648\u0631 SQL \u0627\u0633\u062a \u06a9\u0647 \u0647\u0645\u06cc\u0634\u0647 \u06cc\u06a9 \u0631\u062f\u06cc\u0641 \u0628\u0627 \u06cc\u06a9 \u0633\u062a\u0648\u0646 \u0648 \u0645\u0642\u062f\u0627\u0631 1 \u0631\u0627 \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f\u060c \u062f\u06cc\u062f\u0646 \u06cc\u06a9 \u062a\u0627\u067e\u0644 \u062a\u06a9\u200c\u0639\u0636\u0648\u06cc \u0628\u0627 \u0645\u0642\u062f\u0627\u0631 1 \u062f\u0631 \u062e\u0631\u0648\u062c\u06cc \u06a9\u0627\u0645\u0644\u0627\u064b \u0645\u0646\u0637\u0642\u06cc \u0627\u0633\u062a.<\/p>\n<div><\/div>\n<hr class=\"border-[#EBEBEB] dark:border-[#EBEBEB]\/16\" \/>\n<p class=\"svelte-4sys19\" dir=\"auto\"><strong>\u0646\u062a\u06cc\u062c\u0647\u200c\u06af\u06cc\u0631\u06cc<\/strong> \u0645\u0627\u0698\u0648\u0644 <code class=\"cursor-pointer codespan\">sqlite3<\/code> \u0628\u062e\u0634 \u0642\u062f\u0631\u062a\u0645\u0646\u062f\u06cc \u0627\u0632 \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f \u067e\u0627\u06cc\u062a\u0648\u0646 \u0627\u0633\u062a\u061b \u0627\u06cc\u0646 \u0645\u0627\u0698\u0648\u0644 \u0628\u0647 \u0645\u0627 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc\u200c\u062f\u0647\u062f \u0628\u062f\u0648\u0646 \u0646\u0635\u0628 \u0647\u06cc\u0686 \u0646\u0631\u0645\u200c\u0627\u0641\u0632\u0627\u0631 \u0627\u0636\u0627\u0641\u06cc\u060c \u0628\u0627 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQL \u06a9\u0627\u0645\u0644 \u0631\u0648\u06cc \u062f\u06cc\u0633\u06a9 \u06a9\u0627\u0631 \u06a9\u0646\u06cc\u0645.<\/p>\n<div><\/div>\n<p class=\"svelte-4sys19\" dir=\"auto\">\u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634\u060c \u06cc\u0627\u062f \u06af\u0631\u0641\u062a\u06cc\u0645 \u06a9\u0647 \u0686\u06af\u0648\u0646\u0647 \u0627\u0632 \u0645\u0627\u0698\u0648\u0644 <code class=\"cursor-pointer codespan\">sqlite3<\/code> \u0628\u0631\u0627\u06cc \u0627\u062a\u0635\u0627\u0644 \u0628\u0647 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQLite\u060c \u0627\u0641\u0632\u0648\u062f\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0628\u0647 \u0622\u0646\u060c \u0648 \u0647\u0645\u0686\u0646\u06cc\u0646 \u062e\u0648\u0627\u0646\u062f\u0646 \u0648 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 \u0622\u0646 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645. \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0633\u06cc\u0631\u060c \u0645\u0627 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0628\u0627 \u062e\u0637\u0631\u0627\u062a \u062d\u0645\u0644\u0627\u062a \u062a\u0632\u0631\u06cc\u0642 SQL \u0648 \u0646\u062d\u0648\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 <code class=\"cursor-pointer codespan\">contextlib.closing<\/code> \u0628\u0631\u0627\u06cc \u0641\u0631\u0627\u062e\u0648\u0627\u0646\u06cc \u062e\u0648\u062f\u06a9\u0627\u0631 \u0645\u062a\u062f <code class=\"cursor-pointer codespan\">close()<\/code> \u0631\u0648\u06cc \u0627\u0634\u06cc\u0627\u0621 \u067e\u0627\u06cc\u062a\u0648\u0646 \u062f\u0631 \u0628\u0644\u0648\u06a9\u200c\u0647\u0627\u06cc <code class=\"cursor-pointer codespan\">with<\/code> \u0622\u0634\u0646\u0627 \u0634\u062f\u06cc\u0645.<\/p>\n<p dir=\"auto\">\n<p dir=\"auto\">\n<p dir=\"auto\">\n<p dir=\"auto\">\n<p dir=\"auto\">\n<p dir=\"auto\">\n<p dir=\"auto\">\n<p dir=\"auto\">\n<p dir=\"auto\">\n<p dir=\"auto\">\n<p dir=\"auto\">\n<p dir=\"auto\">\u0627\u0632 \u0647\u0645\u0631\u0627\u0647\u06cc \u0634\u0645\u0627 \u0628\u0627 <strong><a href=\"https:\/\/parmin.cloud\/\">\u067e\u0627\u0631\u0645\u06cc\u0646 \u06a9\u0644\u0648\u062f<\/a><\/strong> \u0633\u067e\u0627\u0633\u06af\u0632\u0627\u0631\u06cc\u0645.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0645\u0642\u062f\u0645\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQLite \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQL \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u0641\u0627\u06cc\u0644 \u0648 \u0645\u0633\u062a\u0642\u0644 \u0627\u0633\u062a. SQLite \u0628\u0647 \u0635\u0648\u0631\u062a \u067e\u06cc\u0634\u200c\u0641\u0631\u0636 \u0647\u0645\u0631\u0627\u0647 \u0628\u0627 \u067e\u0627\u06cc\u062a\u0648\u0646 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f \u0648 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u062f\u0648\u0646 \u0646\u0635\u0628 \u0647\u06cc\u0686 \u0646\u0631\u0645\u200c\u0627\u0641\u0632\u0627\u0631 \u0627\u0636\u0627\u0641\u06cc\u060c \u0627\u0632 \u0622\u0646 \u062f\u0631 \u0627\u067e\u0644\u06cc\u06a9\u06cc\u0634\u0646\u200c\u0647\u0627\u06cc \u067e\u0627\u06cc\u062a\u0648\u0646 \u062e\u0648\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634\u060c \u0645\u0627\u0698\u0648\u0644 sqlite3 \u0631\u0627 \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 3 \u0628\u0631\u0631\u0633\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f. \u0645\u0627 \u06cc\u06a9 \u0627\u062a\u0635\u0627\u0644 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 &hellip;<\/p>\n","protected":false},"author":9,"featured_media":6773,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,343,376],"tags":[],"class_list":["post-6772","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-8","category-python","category-376"],"_links":{"self":[{"href":"https:\/\/parmin.cloud\/blog\/wp-json\/wp\/v2\/posts\/6772","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/parmin.cloud\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/parmin.cloud\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/parmin.cloud\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/parmin.cloud\/blog\/wp-json\/wp\/v2\/comments?post=6772"}],"version-history":[{"count":0,"href":"https:\/\/parmin.cloud\/blog\/wp-json\/wp\/v2\/posts\/6772\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/parmin.cloud\/blog\/wp-json\/wp\/v2\/media\/6773"}],"wp:attachment":[{"href":"https:\/\/parmin.cloud\/blog\/wp-json\/wp\/v2\/media?parent=6772"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/parmin.cloud\/blog\/wp-json\/wp\/v2\/categories?post=6772"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/parmin.cloud\/blog\/wp-json\/wp\/v2\/tags?post=6772"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}