{"id":4179,"date":"2023-11-04T23:14:07","date_gmt":"2023-11-04T23:14:07","guid":{"rendered":"http:\/\/localhost:10003\/how-to-implement-crud-operations-with-sqlite-and-python\/"},"modified":"2023-11-05T05:47:57","modified_gmt":"2023-11-05T05:47:57","slug":"how-to-implement-crud-operations-with-sqlite-and-python","status":"publish","type":"post","link":"http:\/\/localhost:10003\/how-to-implement-crud-operations-with-sqlite-and-python\/","title":{"rendered":"How to Implement CRUD Operations with SQLite and Python"},"content":{"rendered":"<p>SQLite is a lightweight, file-based database engine that is widely used in various applications and development scenarios due to its simplicity and ease of use. In this tutorial, we will explore how to implement CRUD (Create, Read, Update, and Delete) operations with SQLite using Python.<\/p>\n<h2>Prerequisites<\/h2>\n<p>Before we begin, make sure you have the following installed on your system:<\/p>\n<ul>\n<li>Python: You can download and install Python from the <a href=\"https:\/\/www.python.org\/downloads\/\">official website<\/a>.<\/li>\n<li>SQLite: Most Linux distributions come with SQLite pre-installed. For Windows, you can download SQLite from its <a href=\"https:\/\/sqlite.org\/download.html\">official website<\/a>.<\/li>\n<\/ul>\n<p>Once you have these prerequisites set up, let&#8217;s proceed with implementing CRUD operations with SQLite and Python.<\/p>\n<h2>Step 1: Creating a Database and Connecting to it<\/h2>\n<p>The first step is to create a SQLite database file and establish a connection to it using Python. To do this, follow the steps below:<\/p>\n<ol>\n<li>Open your favorite text editor or IDE and create a new Python file, such as <code>database.py<\/code>.<\/li>\n<li>Import the <code>sqlite3<\/code> module by adding the following line at the top of your file:<\/li>\n<\/ol>\n<pre><code class=\"language-python\">import sqlite3\n<\/code><\/pre>\n<ol>\n<li>Create a connection to the database by running the following code:<\/li>\n<\/ol>\n<pre><code class=\"language-python\">connection = sqlite3.connect('mydatabase.db')\n<\/code><\/pre>\n<p>This code establishes a connection to a SQLite database file named <code>mydatabase.db<\/code>. If the file doesn&#8217;t exist, SQLite will create it automatically.<\/p>\n<h2>Step 2: Creating a Table<\/h2>\n<p>In this step, we will create a table in the database to store our data. For demonstration purposes, let&#8217;s imagine we want to create a simple <strong>contacts<\/strong> table with the following columns:<\/p>\n<ul>\n<li><strong>id<\/strong>: A unique identifier for each contact.<\/li>\n<li><strong>name<\/strong>: The contact&#8217;s name.<\/li>\n<li><strong>email<\/strong>: The contact&#8217;s email address.<\/li>\n<li><strong>phone<\/strong>: The contact&#8217;s phone number.<\/li>\n<\/ul>\n<p>To create this table, add the following code after establishing the database connection:<\/p>\n<pre><code class=\"language-python\">cursor = connection.cursor()\n\ncreate_table_query = '''\nCREATE TABLE IF NOT EXISTS contacts (\n    id INTEGER PRIMARY KEY AUTOINCREMENT,\n    name TEXT NOT NULL,\n    email TEXT NOT NULL,\n    phone TEXT NOT NULL\n);\n'''\n\ncursor.execute(create_table_query)\n<\/code><\/pre>\n<p>The <code>cursor<\/code> object is used to execute SQL queries. In the <code>create_table_query<\/code> variable, we define the SQL statement to create the <strong>contacts<\/strong> table if it doesn&#8217;t exist already.<\/p>\n<p>Note that we use the <code>IF NOT EXISTS<\/code> clause in the <code>CREATE TABLE<\/code> statement to avoid re-creating the table if it already exists.<\/p>\n<h2>Step 3: Inserting Data<\/h2>\n<p>In this step, we will learn how to insert data into the <strong>contacts<\/strong> table. Suppose we have the following contact information:<\/p>\n<ul>\n<li>Name: John Doe<\/li>\n<li>Email: john.doe@example.com<\/li>\n<li>Phone: 123-456-7890<\/li>\n<\/ul>\n<p>To insert this data into the table, add the following code:<\/p>\n<pre><code class=\"language-python\">insert_query = '''\nINSERT INTO contacts (name, email, phone)\nVALUES (?, ?, ?)\n'''\n\nvalues = ('John Doe', 'john.doe@example.com', '123-456-7890')\n\ncursor.execute(insert_query, values)\n\nconnection.commit()\n<\/code><\/pre>\n<p>In the <code>insert_query<\/code> variable, we define the SQL statement to insert a new row into the <strong>contacts<\/strong> table with the provided values. The <code>?<\/code> placeholders are used as parameter markers to safely insert values into the query.<\/p>\n<p>We then define the values to be inserted in the <code>values<\/code> variable. In this case, we use a tuple to store the name, email, and phone values.<\/p>\n<p>Finally, we execute the query by calling the <code>execute()<\/code> method on the <code>cursor<\/code> object and pass the query and values as arguments. After executing the query, we commit the changes to the database using the <code>commit()<\/code> method of the connection object.<\/p>\n<h2>Step 4: Retrieving Data<\/h2>\n<p>Now that we have inserted some data into the table, let&#8217;s learn how to retrieve it. To retrieve data from the <strong>contacts<\/strong> table, add the following code:<\/p>\n<pre><code class=\"language-python\">select_query = '''\nSELECT * FROM contacts\n'''\n\ncursor.execute(select_query)\n\nrows = cursor.fetchall()\n\nfor row in rows:\n    print(row)\n<\/code><\/pre>\n<p>In the <code>select_query<\/code> variable, we define the SQL statement to retrieve all rows from the <strong>contacts<\/strong> table.<\/p>\n<p>We then execute the query by calling the <code>execute()<\/code> method on the <code>cursor<\/code> object. After executing the query, we call the <code>fetchall()<\/code> method to retrieve all rows returned by the query.<\/p>\n<p>Finally, we iterate over the rows using a simple for loop and print each row to the console.<\/p>\n<h2>Step 5: Updating Data<\/h2>\n<p>In this step, we will learn how to update existing data in the <strong>contacts<\/strong> table. Suppose we want to update the phone number of the contact with an ID of 1 to &#8220;987-654-3210&#8221;.<\/p>\n<p>To update the data, add the following code:<\/p>\n<pre><code class=\"language-python\">update_query = '''\nUPDATE contacts\nSET phone = ?\nWHERE id = ?\n'''\n\nvalues = ('987-654-3210', 1)\n\ncursor.execute(update_query, values)\n\nconnection.commit()\n<\/code><\/pre>\n<p>In the <code>update_query<\/code> variable, we define the SQL statement to update the <strong>phone<\/strong> column of a row in the <strong>contacts<\/strong> table where the <strong>id<\/strong> matches a given value.<\/p>\n<p>We then define the new phone number and the ID of the contact to update in the <code>values<\/code> variable.<\/p>\n<p>After executing the query using the <code>execute()<\/code> method, we commit the changes to the database using the <code>commit()<\/code> method of the connection object.<\/p>\n<h2>Step 6: Deleting Data<\/h2>\n<p>In this step, we will learn how to delete data from the <strong>contacts<\/strong> table. Suppose we want to delete the contact with an ID of 1.<\/p>\n<p>To delete the data, add the following code:<\/p>\n<pre><code class=\"language-python\">delete_query = '''\nDELETE FROM contacts\nWHERE id = ?\n'''\n\nvalues = (1,)\n\ncursor.execute(delete_query, values)\n\nconnection.commit()\n<\/code><\/pre>\n<p>In the <code>delete_query<\/code> variable, we define the SQL statement to delete a row from the <strong>contacts<\/strong> table where the <strong>id<\/strong> matches a given value.<\/p>\n<p>We then define the ID of the contact to delete in the <code>values<\/code> variable. Note that we use a comma after the ID value to create a tuple with a single element.<\/p>\n<p>After executing the query using the <code>execute()<\/code> method, we commit the changes to the database using the <code>commit()<\/code> method of the connection object.<\/p>\n<h2>Step 7: Closing the Connection<\/h2>\n<p>Once you have finished working with the database, it&#8217;s important to close the connection properly. This ensures that all changes are saved, and the database file is released.<\/p>\n<p>To close the connection, add the following code at the end of your Python file:<\/p>\n<pre><code class=\"language-python\">connection.close()\n<\/code><\/pre>\n<p>This will close the connection to the SQLite database.<\/p>\n<h2>Conclusion<\/h2>\n<p>In this tutorial, we have explored how to implement CRUD operations with SQLite and Python. We learned how to create a database, establish a connection, create a table, insert data, retrieve data, update data, and delete data.<\/p>\n<p>SQLite provides a simple and efficient way to store and manage data in various applications and scenarios. By combining SQLite with Python, you can build powerful and flexible data storage solutions.<\/p>\n<p>Remember to always handle errors and exceptions properly when working with databases, as they can help you identify and resolve potential issues in your code.<\/p>\n<p>I hope you found this tutorial helpful. Now you have the knowledge to implement CRUD operations with SQLite using Python. Happy coding!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQLite is a lightweight, file-based database engine that is widely used in various applications and development scenarios due to its simplicity and ease of use. In this tutorial, we will explore how to implement CRUD (Create, Read, Update, and Delete) operations with SQLite using Python. Prerequisites Before we begin, make <a href=\"http:\/\/localhost:10003\/how-to-implement-crud-operations-with-sqlite-and-python\/\" class=\"btn btn-link continue-link\">Continue Reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[1575,1576,85,75,1574],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Implement CRUD Operations with SQLite and Python - Pantherax Blogs<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/localhost:10003\/how-to-implement-crud-operations-with-sqlite-and-python\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Implement CRUD Operations with SQLite and Python\" \/>\n<meta property=\"og:description\" content=\"SQLite is a lightweight, file-based database engine that is widely used in various applications and development scenarios due to its simplicity and ease of use. In this tutorial, we will explore how to implement CRUD (Create, Read, Update, and Delete) operations with SQLite using Python. Prerequisites Before we begin, make Continue Reading\" \/>\n<meta property=\"og:url\" content=\"http:\/\/localhost:10003\/how-to-implement-crud-operations-with-sqlite-and-python\/\" \/>\n<meta property=\"og:site_name\" content=\"Pantherax Blogs\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-04T23:14:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-05T05:47:57+00:00\" \/>\n<meta name=\"author\" content=\"Panther\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Panther\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\n\t    \"@context\": \"https:\/\/schema.org\",\n\t    \"@graph\": [\n\t        {\n\t            \"@type\": \"Article\",\n\t            \"@id\": \"http:\/\/localhost:10003\/how-to-implement-crud-operations-with-sqlite-and-python\/#article\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"http:\/\/localhost:10003\/how-to-implement-crud-operations-with-sqlite-and-python\/\"\n\t            },\n\t            \"author\": {\n\t                \"name\": \"Panther\",\n\t                \"@id\": \"http:\/\/localhost:10003\/#\/schema\/person\/b63d816f4964b163e53cbbcffaa0f3d7\"\n\t            },\n\t            \"headline\": \"How to Implement CRUD Operations with SQLite and Python\",\n\t            \"datePublished\": \"2023-11-04T23:14:07+00:00\",\n\t            \"dateModified\": \"2023-11-05T05:47:57+00:00\",\n\t            \"mainEntityOfPage\": {\n\t                \"@id\": \"http:\/\/localhost:10003\/how-to-implement-crud-operations-with-sqlite-and-python\/\"\n\t            },\n\t            \"wordCount\": 961,\n\t            \"publisher\": {\n\t                \"@id\": \"http:\/\/localhost:10003\/#organization\"\n\t            },\n\t            \"keywords\": [\n\t                \"\\\"CRUD Operations\\\"\",\n\t                \"\\\"Implement\\\"\",\n\t                \"\\\"Python tutorial\\\"]\",\n\t                \"\\\"Python\\\"\",\n\t                \"\\\"SQLite\\\"\"\n\t            ],\n\t            \"inLanguage\": \"en-US\"\n\t        },\n\t        {\n\t            \"@type\": \"WebPage\",\n\t            \"@id\": \"http:\/\/localhost:10003\/how-to-implement-crud-operations-with-sqlite-and-python\/\",\n\t            \"url\": \"http:\/\/localhost:10003\/how-to-implement-crud-operations-with-sqlite-and-python\/\",\n\t            \"name\": \"How to Implement CRUD Operations with SQLite and Python - Pantherax Blogs\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"http:\/\/localhost:10003\/#website\"\n\t            },\n\t            \"datePublished\": \"2023-11-04T23:14:07+00:00\",\n\t            \"dateModified\": \"2023-11-05T05:47:57+00:00\",\n\t            \"breadcrumb\": {\n\t                \"@id\": \"http:\/\/localhost:10003\/how-to-implement-crud-operations-with-sqlite-and-python\/#breadcrumb\"\n\t            },\n\t            \"inLanguage\": \"en-US\",\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"ReadAction\",\n\t                    \"target\": [\n\t                        \"http:\/\/localhost:10003\/how-to-implement-crud-operations-with-sqlite-and-python\/\"\n\t                    ]\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"BreadcrumbList\",\n\t            \"@id\": \"http:\/\/localhost:10003\/how-to-implement-crud-operations-with-sqlite-and-python\/#breadcrumb\",\n\t            \"itemListElement\": [\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 1,\n\t                    \"name\": \"Home\",\n\t                    \"item\": \"http:\/\/localhost:10003\/\"\n\t                },\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 2,\n\t                    \"name\": \"How to Implement CRUD Operations with SQLite and Python\"\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"WebSite\",\n\t            \"@id\": \"http:\/\/localhost:10003\/#website\",\n\t            \"url\": \"http:\/\/localhost:10003\/\",\n\t            \"name\": \"Pantherax Blogs\",\n\t            \"description\": \"\",\n\t            \"publisher\": {\n\t                \"@id\": \"http:\/\/localhost:10003\/#organization\"\n\t            },\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"SearchAction\",\n\t                    \"target\": {\n\t                        \"@type\": \"EntryPoint\",\n\t                        \"urlTemplate\": \"http:\/\/localhost:10003\/?s={search_term_string}\"\n\t                    },\n\t                    \"query-input\": \"required name=search_term_string\"\n\t                }\n\t            ],\n\t            \"inLanguage\": \"en-US\"\n\t        },\n\t        {\n\t            \"@type\": \"Organization\",\n\t            \"@id\": \"http:\/\/localhost:10003\/#organization\",\n\t            \"name\": \"Pantherax Blogs\",\n\t            \"url\": \"http:\/\/localhost:10003\/\",\n\t            \"logo\": {\n\t                \"@type\": \"ImageObject\",\n\t                \"inLanguage\": \"en-US\",\n\t                \"@id\": \"http:\/\/localhost:10003\/#\/schema\/logo\/image\/\",\n\t                \"url\": \"http:\/\/localhost:10003\/wp-content\/uploads\/2023\/11\/cropped-9e7721cb-2d62-4f72-ab7f-7d1d8db89226.jpeg\",\n\t                \"contentUrl\": \"http:\/\/localhost:10003\/wp-content\/uploads\/2023\/11\/cropped-9e7721cb-2d62-4f72-ab7f-7d1d8db89226.jpeg\",\n\t                \"width\": 1024,\n\t                \"height\": 1024,\n\t                \"caption\": \"Pantherax Blogs\"\n\t            },\n\t            \"image\": {\n\t                \"@id\": \"http:\/\/localhost:10003\/#\/schema\/logo\/image\/\"\n\t            }\n\t        },\n\t        {\n\t            \"@type\": \"Person\",\n\t            \"@id\": \"http:\/\/localhost:10003\/#\/schema\/person\/b63d816f4964b163e53cbbcffaa0f3d7\",\n\t            \"name\": \"Panther\",\n\t            \"image\": {\n\t                \"@type\": \"ImageObject\",\n\t                \"inLanguage\": \"en-US\",\n\t                \"@id\": \"http:\/\/localhost:10003\/#\/schema\/person\/image\/\",\n\t                \"url\": \"http:\/\/2.gravatar.com\/avatar\/b8c0eda5a49f8f31ec32d0a0f9d6f838?s=96&d=mm&r=g\",\n\t                \"contentUrl\": \"http:\/\/2.gravatar.com\/avatar\/b8c0eda5a49f8f31ec32d0a0f9d6f838?s=96&d=mm&r=g\",\n\t                \"caption\": \"Panther\"\n\t            },\n\t            \"sameAs\": [\n\t                \"http:\/\/localhost:10003\"\n\t            ],\n\t            \"url\": \"http:\/\/localhost:10003\/author\/pepethefrog\/\"\n\t        }\n\t    ]\n\t}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Implement CRUD Operations with SQLite and Python - Pantherax Blogs","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/localhost:10003\/how-to-implement-crud-operations-with-sqlite-and-python\/","og_locale":"en_US","og_type":"article","og_title":"How to Implement CRUD Operations with SQLite and Python","og_description":"SQLite is a lightweight, file-based database engine that is widely used in various applications and development scenarios due to its simplicity and ease of use. In this tutorial, we will explore how to implement CRUD (Create, Read, Update, and Delete) operations with SQLite using Python. Prerequisites Before we begin, make Continue Reading","og_url":"http:\/\/localhost:10003\/how-to-implement-crud-operations-with-sqlite-and-python\/","og_site_name":"Pantherax Blogs","article_published_time":"2023-11-04T23:14:07+00:00","article_modified_time":"2023-11-05T05:47:57+00:00","author":"Panther","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Panther","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/localhost:10003\/how-to-implement-crud-operations-with-sqlite-and-python\/#article","isPartOf":{"@id":"http:\/\/localhost:10003\/how-to-implement-crud-operations-with-sqlite-and-python\/"},"author":{"name":"Panther","@id":"http:\/\/localhost:10003\/#\/schema\/person\/b63d816f4964b163e53cbbcffaa0f3d7"},"headline":"How to Implement CRUD Operations with SQLite and Python","datePublished":"2023-11-04T23:14:07+00:00","dateModified":"2023-11-05T05:47:57+00:00","mainEntityOfPage":{"@id":"http:\/\/localhost:10003\/how-to-implement-crud-operations-with-sqlite-and-python\/"},"wordCount":961,"publisher":{"@id":"http:\/\/localhost:10003\/#organization"},"keywords":["\"CRUD Operations\"","\"Implement\"","\"Python tutorial\"]","\"Python\"","\"SQLite\""],"inLanguage":"en-US"},{"@type":"WebPage","@id":"http:\/\/localhost:10003\/how-to-implement-crud-operations-with-sqlite-and-python\/","url":"http:\/\/localhost:10003\/how-to-implement-crud-operations-with-sqlite-and-python\/","name":"How to Implement CRUD Operations with SQLite and Python - Pantherax Blogs","isPartOf":{"@id":"http:\/\/localhost:10003\/#website"},"datePublished":"2023-11-04T23:14:07+00:00","dateModified":"2023-11-05T05:47:57+00:00","breadcrumb":{"@id":"http:\/\/localhost:10003\/how-to-implement-crud-operations-with-sqlite-and-python\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/localhost:10003\/how-to-implement-crud-operations-with-sqlite-and-python\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/localhost:10003\/how-to-implement-crud-operations-with-sqlite-and-python\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/localhost:10003\/"},{"@type":"ListItem","position":2,"name":"How to Implement CRUD Operations with SQLite and Python"}]},{"@type":"WebSite","@id":"http:\/\/localhost:10003\/#website","url":"http:\/\/localhost:10003\/","name":"Pantherax Blogs","description":"","publisher":{"@id":"http:\/\/localhost:10003\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/localhost:10003\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"http:\/\/localhost:10003\/#organization","name":"Pantherax Blogs","url":"http:\/\/localhost:10003\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/localhost:10003\/#\/schema\/logo\/image\/","url":"http:\/\/localhost:10003\/wp-content\/uploads\/2023\/11\/cropped-9e7721cb-2d62-4f72-ab7f-7d1d8db89226.jpeg","contentUrl":"http:\/\/localhost:10003\/wp-content\/uploads\/2023\/11\/cropped-9e7721cb-2d62-4f72-ab7f-7d1d8db89226.jpeg","width":1024,"height":1024,"caption":"Pantherax Blogs"},"image":{"@id":"http:\/\/localhost:10003\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"http:\/\/localhost:10003\/#\/schema\/person\/b63d816f4964b163e53cbbcffaa0f3d7","name":"Panther","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/localhost:10003\/#\/schema\/person\/image\/","url":"http:\/\/2.gravatar.com\/avatar\/b8c0eda5a49f8f31ec32d0a0f9d6f838?s=96&d=mm&r=g","contentUrl":"http:\/\/2.gravatar.com\/avatar\/b8c0eda5a49f8f31ec32d0a0f9d6f838?s=96&d=mm&r=g","caption":"Panther"},"sameAs":["http:\/\/localhost:10003"],"url":"http:\/\/localhost:10003\/author\/pepethefrog\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/localhost:10003\/wp-json\/wp\/v2\/posts\/4179"}],"collection":[{"href":"http:\/\/localhost:10003\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/localhost:10003\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/localhost:10003\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/localhost:10003\/wp-json\/wp\/v2\/comments?post=4179"}],"version-history":[{"count":1,"href":"http:\/\/localhost:10003\/wp-json\/wp\/v2\/posts\/4179\/revisions"}],"predecessor-version":[{"id":4355,"href":"http:\/\/localhost:10003\/wp-json\/wp\/v2\/posts\/4179\/revisions\/4355"}],"wp:attachment":[{"href":"http:\/\/localhost:10003\/wp-json\/wp\/v2\/media?parent=4179"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/localhost:10003\/wp-json\/wp\/v2\/categories?post=4179"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/localhost:10003\/wp-json\/wp\/v2\/tags?post=4179"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}