{"id":22609,"date":"2024-04-23T23:45:11","date_gmt":"2024-04-23T23:45:11","guid":{"rendered":"https:\/\/www.writemyessays.app\/blog\/questions\/create-a-docker-based-solution-written-in-python-for-extraction-of-data-from-sql-tables-with-microservices\/"},"modified":"2024-04-23T23:45:11","modified_gmt":"2024-04-23T23:45:11","slug":"create-a-docker-based-solution-written-in-python-for-extraction-of-data-from-sql-tables-with-microservices","status":"publish","type":"questions","link":"https:\/\/www.writemyessays.app\/blog\/questions\/create-a-docker-based-solution-written-in-python-for-extraction-of-data-from-sql-tables-with-microservices\/","title":{"rendered":"Create a docker based solution written in Python for extraction of data from SQL tables with microservices"},"content":{"rendered":"<p><span style=\"cursor: auto; color: inherit;\">Create a docker based solution written in Python for extraction of data from SQL tables with<br \/>\nmicroservices<\/span><span style=\"cursor: auto; color: inherit;\">. The endpoint of the microservice must be accessed outside the container<\/span><span style=\"cursor: auto; color: inherit;\">. When the<br \/>\ndata in the database is accessed<\/span><span style=\"cursor: auto; color: inherit;\">, your code must do some transformations with Pandas <\/span><span style=\"cursor: auto; color: inherit;\">(join tables<\/span><span style=\"cursor: auto; color: inherit;\">,<br \/>\nselect columns<\/span><span style=\"cursor: auto; color: inherit;\">, filter columns etc<\/span><span style=\"cursor: auto; color: inherit;\">.<\/span><span style=\"cursor: auto; color: inherit;\">)<\/span><span style=\"cursor: auto; color: inherit;\">. The output from the microservice is expected to be in json<br \/>\nformat<\/span><span style=\"cursor: auto; color: inherit;\">.<br \/>\nYour project must contain<\/span><span style=\"cursor: auto; color: inherit;\">:<br \/>\n\u2022 Python code of the microservice<\/span><span style=\"cursor: auto; color: inherit;\">.<br \/>\n\u2022 Installed SQL client with created database and tables <\/span><span style=\"cursor: auto; color: inherit;\">(also some data in the tables<\/span><span style=\"cursor: auto; color: inherit;\">)<\/span><span style=\"cursor: auto; color: inherit;\">.<br \/>\n\u2022 Pandas transformations with the data from the tables<\/span><span style=\"cursor: auto; color: inherit;\">.<br \/>\n\u2022 Everything must be in the docker container<\/span><span style=\"cursor: auto; color: inherit;\">.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Create a docker based solution written in Python for extraction of data from SQL tables with microservices. The endpoint of the microservice must be accessed outside the container. When the data in the database is accessed, your code must do some transformations with Pandas (join tables, select columns, filter columns etc.). The output from the [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[187],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions\/22609"}],"collection":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/types\/questions"}],"author":[{"embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/comments?post=22609"}],"version-history":[{"count":0,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions\/22609\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/media?parent=22609"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/disciplines?post=22609"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/paper_types?post=22609"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/tagged?post=22609"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}