{"id":5588,"date":"2023-03-06T19:45:43","date_gmt":"2023-03-06T18:45:43","guid":{"rendered":"https:\/\/arduino.net.pl\/?p=5588"},"modified":"2023-08-06T12:21:24","modified_gmt":"2023-08-06T10:21:24","slug":"flask-i-sqlalchemy","status":"publish","type":"post","link":"https:\/\/arduino.net.pl\/index.php\/flask-i-sqlalchemy\/","title":{"rendered":"Flask i SQLAlchemy"},"content":{"rendered":"\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/flask-sqlalchemy.palletsprojects.com\/en\/3.0.x\/_static\/flask-sqlalchemy-logo.png\" alt=\"https:\/\/flask-sqlalchemy.palletsprojects.com\/en\/3.0.x\/_static\/flask-sqlalchemy-logo.png\" width=\"170\" height=\"148\"\/><figcaption class=\"wp-element-caption\"><a href=\"https:\/\/flask-sqlalchemy.palletsprojects.com\/en\/3.0.x\/\" title=\"\">https:\/\/flask-sqlalchemy.palletsprojects.com\/en\/3.0.x\/<\/a><\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Ka\u017cda kolumna w tabeli ma okre\u015blony typ danych, na przyk\u0142ad tekstowy, liczbowy lub datowy. Typ danych okre\u015bla, jakie rodzaje danych mo\u017cna przechowywa\u0107 w danej kolumnie.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bazy danych SQL sk\u0142adaj\u0105 si\u0119 z trzech podstawowych element\u00f3w:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Tabele &#8211; to struktury przechowuj\u0105ce dane w postaci wierszy i kolumn. Ka\u017cda tabela ma unikaln\u0105 nazw\u0119 i sk\u0142ada si\u0119 z jednego lub wielu kolumn.<\/li>\n\n\n\n<li>Kolumny &#8211; ka\u017cda kolumna ma swoj\u0105 nazw\u0119 oraz okre\u015blony typ danych, kt\u00f3ry okre\u015bla rodzaj danych, kt\u00f3re mo\u017cna przechowywa\u0107 w tej kolumnie.<\/li>\n\n\n\n<li>Wiersze &#8211; to pojedyncze rekordy w tabeli, kt\u00f3re sk\u0142adaj\u0105 si\u0119 z danych przechowywanych w ka\u017cdej z kolumn. Ka\u017cdy wiersz ma unikalny identyfikator (klucz g\u0142\u00f3wny), kt\u00f3ry s\u0142u\u017cy do identyfikowania go w bazie danych.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Bazy danych SQL umo\u017cliwiaj\u0105 manipulowanie danymi za pomoc\u0105 j\u0119zyka SQL, kt\u00f3ry umo\u017cliwia wykonywanie operacji takich jak tworzenie, aktualizowanie i usuwanie danych z tabel.&#8221; Koniec cytatu z inteligencji;)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Poni\u017cej bardzo dobre narz\u0119dzie do pracy z bazami danych SQLite:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>DB Browser for SQLite. \n<ul class=\"wp-block-list\">\n<li><em><a href=\"https:\/\/sqlitebrowser.org\/dl\/\" title=\"\">The Official home of the DB Browser for SQLite<\/a><\/em><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">KOD<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Poni\u017cej kod, kt\u00f3ry pokazuje istot\u0119 dzia\u0142ania biblioteki SQLAlchemy. Tworzymy baz\u0119, kreujemy klas\u0119, kt\u00f3ra buduje struktur\u0119 bazy. Serwer dla czujnik\u00f3w na ESP8266 albo ESP32<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; light: false; title: Kod:; toolbar: true; notranslate\" title=\"Kod:\">\nfrom flask import Flask, request, jsonify\nfrom flask_sqlalchemy import SQLAlchemy\nfrom datetime import datetime\nimport json\n\napp = Flask(__name__)\n\n# Konfiguracja bazy danych\napp.config&#x5B;&#039;SQLALCHEMY_DATABASE_URI&#039;] = &#039;sqlite:\/\/\/iot_data.db&#039;  # U\u017cyj SQLite jako przyk\u0142adowej bazy danych\ndb = SQLAlchemy(app)\n\n# Model danych\nclass SensorData(db.Model):\n    id = db.Column(db.Integer, primary_key=True)\n    device_name = db.Column(db.String(50), nullable=False)\n    data = db.Column(db.String(200), nullable=False)\n    timestamp = db.Column(db.DateTime, default=datetime.utcnow)\n\n# Endpoint do dodawania danych pomiarowych\n@app.route(&#039;\/add_data&#039;, methods=&#x5B;&#039;POST&#039;])\ndef add_data():\n    data = request.json\n    device_name = data.get(&#039;device_name&#039;)\n    data_json = json.dumps(data.get(&#039;data&#039;))  # Konwersja s\u0142ownika na JSON\n\n    new_data = SensorData(device_name=device_name, data=data_json)\n\n    db.session.add(new_data)\n    db.session.commit()\n\n    return jsonify({&#039;message&#039;: &#039;Dane pomiarowe dodane poprawnie.&#039;}), 201\n\n@app.route(&#039;\/get_data&#039;, methods=&#x5B;&#039;GET&#039;])\ndef get_data():\n    all_data = SensorData.query.all()\n    data_list = &#x5B;]\n    for data in all_data:\n        data_list.append({&#039;device_name&#039;: data.device_name, &#039;data&#039;: data.data, &#039;timestamp&#039;: data.timestamp})\n    \n    return jsonify(data_list)\n\nif __name__ == &#039;__main__&#039;:\n    with app.app_context():\n        db.create_all()  # Tworzenie tabeli w bazie danych, je\u015bli nie istnieje\n    app.run(debug=True)\n\n\n\n<\/pre><\/div>\n\n\n<h4 class=\"wp-block-heading\">Typy danych<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><a href=\"https:\/\/docs.sqlalchemy.org\/en\/14\/core\/type_basics.html#sqlalchemy.types.Integer\"><code>Integer<\/code><\/a><\/td><td>an integer<\/td><\/tr><tr><td><a href=\"https:\/\/docs.sqlalchemy.org\/en\/14\/core\/type_basics.html#sqlalchemy.types.String\"><code>String(size)<\/code><\/a><\/td><td>a string with a maximum length (optional in some databases, e.g. PostgreSQL)<\/td><\/tr><tr><td><a href=\"https:\/\/docs.sqlalchemy.org\/en\/14\/core\/type_basics.html#sqlalchemy.types.Text\"><code>Text<\/code><\/a><\/td><td>some longer unicode text<\/td><\/tr><tr><td><a href=\"https:\/\/docs.sqlalchemy.org\/en\/14\/core\/type_basics.html#sqlalchemy.types.DateTime\"><code>DateTime<\/code><\/a><\/td><td>date and time expressed as Python <a href=\"https:\/\/docs.python.org\/3\/library\/datetime.html#datetime.datetime\"><code>datetime<\/code><\/a> object.<\/td><\/tr><tr><td><a href=\"https:\/\/docs.sqlalchemy.org\/en\/14\/core\/type_basics.html#sqlalchemy.types.Float\"><code>Float<\/code><\/a><\/td><td>stores floating point values<\/td><\/tr><tr><td><a href=\"https:\/\/docs.sqlalchemy.org\/en\/14\/core\/type_basics.html#sqlalchemy.types.Boolean\"><code>Boolean<\/code><\/a><\/td><td>stores a boolean value<\/td><\/tr><tr><td><a href=\"https:\/\/docs.sqlalchemy.org\/en\/14\/core\/type_basics.html#sqlalchemy.types.PickleType\"><code>PickleType<\/code><\/a><\/td><td>stores a pickled Python object<\/td><\/tr><tr><td><a href=\"https:\/\/docs.sqlalchemy.org\/en\/14\/core\/type_basics.html#sqlalchemy.types.LargeBinary\"><code>LargeBinary<\/code><\/a><\/td><td>stores large arbitrary binary data<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Ka\u017cda kolumna w tabeli ma okre\u015blony typ danych, na przyk\u0142ad tekstowy, liczbowy lub datowy. Typ danych okre\u015bla, jakie rodzaje danych mo\u017cna przechowywa\u0107 w danej kolumnie. Bazy danych SQL sk\u0142adaj\u0105 si\u0119&#8230;<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[141,65],"tags":[154,159],"class_list":["post-5588","post","type-post","status-publish","format-standard","hentry","category-micropython","category-programowanie","tag-flask","tag-sqlalchemy"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"Ka\u017cda kolumna w tabeli ma okre\u015blony typ danych, na przyk\u0142ad tekstowy, liczbowy lub datowy. Typ danych okre\u015bla, jakie rodzaje danych mo\u017cna przechowywa\u0107 w danej kolumnie. Bazy danych SQL sk\u0142adaj\u0105 si\u0119 z trzech podstawowych element\u00f3w: Tabele - to struktury przechowuj\u0105ce dane w postaci wierszy i kolumn. Ka\u017cda tabela ma unikaln\u0105 nazw\u0119 i sk\u0142ada si\u0119 z jednego\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"yarogniew_anpl\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/arduino.net.pl\/index.php\/flask-i-sqlalchemy\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"pl_PL\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Arduino dla strasznych lamer\u00f3w - www.arduino.net.pl\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Flask i SQLAlchemy - Arduino dla strasznych lamer\u00f3w\" \/>\n\t\t<meta property=\"og:description\" content=\"Ka\u017cda kolumna w tabeli ma okre\u015blony typ danych, na przyk\u0142ad tekstowy, liczbowy lub datowy. Typ danych okre\u015bla, jakie rodzaje danych mo\u017cna przechowywa\u0107 w danej kolumnie. Bazy danych SQL sk\u0142adaj\u0105 si\u0119 z trzech podstawowych element\u00f3w: Tabele - to struktury przechowuj\u0105ce dane w postaci wierszy i kolumn. Ka\u017cda tabela ma unikaln\u0105 nazw\u0119 i sk\u0142ada si\u0119 z jednego\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/arduino.net.pl\/index.php\/flask-i-sqlalchemy\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2023-03-06T18:45:43+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2023-08-06T10:21:24+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Flask i SQLAlchemy - Arduino dla strasznych lamer\u00f3w\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Ka\u017cda kolumna w tabeli ma okre\u015blony typ danych, na przyk\u0142ad tekstowy, liczbowy lub datowy. Typ danych okre\u015bla, jakie rodzaje danych mo\u017cna przechowywa\u0107 w danej kolumnie. Bazy danych SQL sk\u0142adaj\u0105 si\u0119 z trzech podstawowych element\u00f3w: Tabele - to struktury przechowuj\u0105ce dane w postaci wierszy i kolumn. Ka\u017cda tabela ma unikaln\u0105 nazw\u0119 i sk\u0142ada si\u0119 z jednego\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/index.php\\\/flask-i-sqlalchemy\\\/#blogposting\",\"name\":\"Flask i SQLAlchemy - Arduino dla strasznych lamer\\u00f3w\",\"headline\":\"Flask i SQLAlchemy\",\"author\":{\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/index.php\\\/author\\\/yarogniew_anpl\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/flask-sqlalchemy.palletsprojects.com\\\/en\\\/3.0.x\\\/_static\\\/flask-sqlalchemy-logo.png\",\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/index.php\\\/flask-i-sqlalchemy\\\/#articleImage\"},\"datePublished\":\"2023-03-06T19:45:43+01:00\",\"dateModified\":\"2023-08-06T12:21:24+02:00\",\"inLanguage\":\"pl-PL\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/index.php\\\/flask-i-sqlalchemy\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/index.php\\\/flask-i-sqlalchemy\\\/#webpage\"},\"articleSection\":\"MicroPython, PROGRAMOWANIE, flask, SQLAlchemy\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/index.php\\\/flask-i-sqlalchemy\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/arduino.net.pl#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/arduino.net.pl\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/index.php\\\/category\\\/programowanie\\\/#listItem\",\"name\":\"PROGRAMOWANIE\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/index.php\\\/category\\\/programowanie\\\/#listItem\",\"position\":2,\"name\":\"PROGRAMOWANIE\",\"item\":\"https:\\\/\\\/arduino.net.pl\\\/index.php\\\/category\\\/programowanie\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/index.php\\\/category\\\/programowanie\\\/micropython\\\/#listItem\",\"name\":\"MicroPython\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/arduino.net.pl#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/index.php\\\/category\\\/programowanie\\\/micropython\\\/#listItem\",\"position\":3,\"name\":\"MicroPython\",\"item\":\"https:\\\/\\\/arduino.net.pl\\\/index.php\\\/category\\\/programowanie\\\/micropython\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/index.php\\\/flask-i-sqlalchemy\\\/#listItem\",\"name\":\"Flask i SQLAlchemy\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/index.php\\\/category\\\/programowanie\\\/#listItem\",\"name\":\"PROGRAMOWANIE\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/index.php\\\/flask-i-sqlalchemy\\\/#listItem\",\"position\":4,\"name\":\"Flask i SQLAlchemy\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/index.php\\\/category\\\/programowanie\\\/micropython\\\/#listItem\",\"name\":\"MicroPython\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/#person\",\"name\":\"yarogniew_anpl\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/index.php\\\/flask-i-sqlalchemy\\\/#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/daf42a0de5021721fc53447fe7cf000e09055bf4fb96ef98490902a9e4de3bf2?s=96&d=identicon&r=g\",\"width\":96,\"height\":96,\"caption\":\"yarogniew_anpl\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/index.php\\\/author\\\/yarogniew_anpl\\\/#author\",\"url\":\"https:\\\/\\\/arduino.net.pl\\\/index.php\\\/author\\\/yarogniew_anpl\\\/\",\"name\":\"yarogniew_anpl\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/index.php\\\/flask-i-sqlalchemy\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/daf42a0de5021721fc53447fe7cf000e09055bf4fb96ef98490902a9e4de3bf2?s=96&d=identicon&r=g\",\"width\":96,\"height\":96,\"caption\":\"yarogniew_anpl\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/index.php\\\/flask-i-sqlalchemy\\\/#webpage\",\"url\":\"https:\\\/\\\/arduino.net.pl\\\/index.php\\\/flask-i-sqlalchemy\\\/\",\"name\":\"Flask i SQLAlchemy - Arduino dla strasznych lamer\\u00f3w\",\"description\":\"Ka\\u017cda kolumna w tabeli ma okre\\u015blony typ danych, na przyk\\u0142ad tekstowy, liczbowy lub datowy. Typ danych okre\\u015bla, jakie rodzaje danych mo\\u017cna przechowywa\\u0107 w danej kolumnie. Bazy danych SQL sk\\u0142adaj\\u0105 si\\u0119 z trzech podstawowych element\\u00f3w: Tabele - to struktury przechowuj\\u0105ce dane w postaci wierszy i kolumn. Ka\\u017cda tabela ma unikaln\\u0105 nazw\\u0119 i sk\\u0142ada si\\u0119 z jednego\",\"inLanguage\":\"pl-PL\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/index.php\\\/flask-i-sqlalchemy\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/index.php\\\/author\\\/yarogniew_anpl\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/index.php\\\/author\\\/yarogniew_anpl\\\/#author\"},\"datePublished\":\"2023-03-06T19:45:43+01:00\",\"dateModified\":\"2023-08-06T12:21:24+02:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/#website\",\"url\":\"https:\\\/\\\/arduino.net.pl\\\/\",\"name\":\"Arduino dla strasznych lamer\\u00f3w\",\"description\":\"www.arduino.net.pl\",\"inLanguage\":\"pl-PL\",\"publisher\":{\"@id\":\"https:\\\/\\\/arduino.net.pl\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Flask i SQLAlchemy - Arduino dla strasznych lamer\u00f3w","description":"Ka\u017cda kolumna w tabeli ma okre\u015blony typ danych, na przyk\u0142ad tekstowy, liczbowy lub datowy. Typ danych okre\u015bla, jakie rodzaje danych mo\u017cna przechowywa\u0107 w danej kolumnie. Bazy danych SQL sk\u0142adaj\u0105 si\u0119 z trzech podstawowych element\u00f3w: Tabele - to struktury przechowuj\u0105ce dane w postaci wierszy i kolumn. Ka\u017cda tabela ma unikaln\u0105 nazw\u0119 i sk\u0142ada si\u0119 z jednego","canonical_url":"https:\/\/arduino.net.pl\/index.php\/flask-i-sqlalchemy\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/arduino.net.pl\/index.php\/flask-i-sqlalchemy\/#blogposting","name":"Flask i SQLAlchemy - Arduino dla strasznych lamer\u00f3w","headline":"Flask i SQLAlchemy","author":{"@id":"https:\/\/arduino.net.pl\/index.php\/author\/yarogniew_anpl\/#author"},"publisher":{"@id":"https:\/\/arduino.net.pl\/#person"},"image":{"@type":"ImageObject","url":"https:\/\/flask-sqlalchemy.palletsprojects.com\/en\/3.0.x\/_static\/flask-sqlalchemy-logo.png","@id":"https:\/\/arduino.net.pl\/index.php\/flask-i-sqlalchemy\/#articleImage"},"datePublished":"2023-03-06T19:45:43+01:00","dateModified":"2023-08-06T12:21:24+02:00","inLanguage":"pl-PL","mainEntityOfPage":{"@id":"https:\/\/arduino.net.pl\/index.php\/flask-i-sqlalchemy\/#webpage"},"isPartOf":{"@id":"https:\/\/arduino.net.pl\/index.php\/flask-i-sqlalchemy\/#webpage"},"articleSection":"MicroPython, PROGRAMOWANIE, flask, SQLAlchemy"},{"@type":"BreadcrumbList","@id":"https:\/\/arduino.net.pl\/index.php\/flask-i-sqlalchemy\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/arduino.net.pl#listItem","position":1,"name":"Home","item":"https:\/\/arduino.net.pl","nextItem":{"@type":"ListItem","@id":"https:\/\/arduino.net.pl\/index.php\/category\/programowanie\/#listItem","name":"PROGRAMOWANIE"}},{"@type":"ListItem","@id":"https:\/\/arduino.net.pl\/index.php\/category\/programowanie\/#listItem","position":2,"name":"PROGRAMOWANIE","item":"https:\/\/arduino.net.pl\/index.php\/category\/programowanie\/","nextItem":{"@type":"ListItem","@id":"https:\/\/arduino.net.pl\/index.php\/category\/programowanie\/micropython\/#listItem","name":"MicroPython"},"previousItem":{"@type":"ListItem","@id":"https:\/\/arduino.net.pl#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/arduino.net.pl\/index.php\/category\/programowanie\/micropython\/#listItem","position":3,"name":"MicroPython","item":"https:\/\/arduino.net.pl\/index.php\/category\/programowanie\/micropython\/","nextItem":{"@type":"ListItem","@id":"https:\/\/arduino.net.pl\/index.php\/flask-i-sqlalchemy\/#listItem","name":"Flask i SQLAlchemy"},"previousItem":{"@type":"ListItem","@id":"https:\/\/arduino.net.pl\/index.php\/category\/programowanie\/#listItem","name":"PROGRAMOWANIE"}},{"@type":"ListItem","@id":"https:\/\/arduino.net.pl\/index.php\/flask-i-sqlalchemy\/#listItem","position":4,"name":"Flask i SQLAlchemy","previousItem":{"@type":"ListItem","@id":"https:\/\/arduino.net.pl\/index.php\/category\/programowanie\/micropython\/#listItem","name":"MicroPython"}}]},{"@type":"Person","@id":"https:\/\/arduino.net.pl\/#person","name":"yarogniew_anpl","image":{"@type":"ImageObject","@id":"https:\/\/arduino.net.pl\/index.php\/flask-i-sqlalchemy\/#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/daf42a0de5021721fc53447fe7cf000e09055bf4fb96ef98490902a9e4de3bf2?s=96&d=identicon&r=g","width":96,"height":96,"caption":"yarogniew_anpl"}},{"@type":"Person","@id":"https:\/\/arduino.net.pl\/index.php\/author\/yarogniew_anpl\/#author","url":"https:\/\/arduino.net.pl\/index.php\/author\/yarogniew_anpl\/","name":"yarogniew_anpl","image":{"@type":"ImageObject","@id":"https:\/\/arduino.net.pl\/index.php\/flask-i-sqlalchemy\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/daf42a0de5021721fc53447fe7cf000e09055bf4fb96ef98490902a9e4de3bf2?s=96&d=identicon&r=g","width":96,"height":96,"caption":"yarogniew_anpl"}},{"@type":"WebPage","@id":"https:\/\/arduino.net.pl\/index.php\/flask-i-sqlalchemy\/#webpage","url":"https:\/\/arduino.net.pl\/index.php\/flask-i-sqlalchemy\/","name":"Flask i SQLAlchemy - Arduino dla strasznych lamer\u00f3w","description":"Ka\u017cda kolumna w tabeli ma okre\u015blony typ danych, na przyk\u0142ad tekstowy, liczbowy lub datowy. Typ danych okre\u015bla, jakie rodzaje danych mo\u017cna przechowywa\u0107 w danej kolumnie. Bazy danych SQL sk\u0142adaj\u0105 si\u0119 z trzech podstawowych element\u00f3w: Tabele - to struktury przechowuj\u0105ce dane w postaci wierszy i kolumn. Ka\u017cda tabela ma unikaln\u0105 nazw\u0119 i sk\u0142ada si\u0119 z jednego","inLanguage":"pl-PL","isPartOf":{"@id":"https:\/\/arduino.net.pl\/#website"},"breadcrumb":{"@id":"https:\/\/arduino.net.pl\/index.php\/flask-i-sqlalchemy\/#breadcrumblist"},"author":{"@id":"https:\/\/arduino.net.pl\/index.php\/author\/yarogniew_anpl\/#author"},"creator":{"@id":"https:\/\/arduino.net.pl\/index.php\/author\/yarogniew_anpl\/#author"},"datePublished":"2023-03-06T19:45:43+01:00","dateModified":"2023-08-06T12:21:24+02:00"},{"@type":"WebSite","@id":"https:\/\/arduino.net.pl\/#website","url":"https:\/\/arduino.net.pl\/","name":"Arduino dla strasznych lamer\u00f3w","description":"www.arduino.net.pl","inLanguage":"pl-PL","publisher":{"@id":"https:\/\/arduino.net.pl\/#person"}}]},"og:locale":"pl_PL","og:site_name":"Arduino dla strasznych lamer\u00f3w - www.arduino.net.pl","og:type":"article","og:title":"Flask i SQLAlchemy - Arduino dla strasznych lamer\u00f3w","og:description":"Ka\u017cda kolumna w tabeli ma okre\u015blony typ danych, na przyk\u0142ad tekstowy, liczbowy lub datowy. Typ danych okre\u015bla, jakie rodzaje danych mo\u017cna przechowywa\u0107 w danej kolumnie. Bazy danych SQL sk\u0142adaj\u0105 si\u0119 z trzech podstawowych element\u00f3w: Tabele - to struktury przechowuj\u0105ce dane w postaci wierszy i kolumn. Ka\u017cda tabela ma unikaln\u0105 nazw\u0119 i sk\u0142ada si\u0119 z jednego","og:url":"https:\/\/arduino.net.pl\/index.php\/flask-i-sqlalchemy\/","article:published_time":"2023-03-06T18:45:43+00:00","article:modified_time":"2023-08-06T10:21:24+00:00","twitter:card":"summary_large_image","twitter:title":"Flask i SQLAlchemy - Arduino dla strasznych lamer\u00f3w","twitter:description":"Ka\u017cda kolumna w tabeli ma okre\u015blony typ danych, na przyk\u0142ad tekstowy, liczbowy lub datowy. Typ danych okre\u015bla, jakie rodzaje danych mo\u017cna przechowywa\u0107 w danej kolumnie. Bazy danych SQL sk\u0142adaj\u0105 si\u0119 z trzech podstawowych element\u00f3w: Tabele - to struktury przechowuj\u0105ce dane w postaci wierszy i kolumn. Ka\u017cda tabela ma unikaln\u0105 nazw\u0119 i sk\u0142ada si\u0119 z jednego"},"aioseo_meta_data":{"post_id":"5588","title":null,"description":null,"keywords":[],"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":[],"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2023-03-06 18:19:46","updated":"2025-06-03 22:53:06","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/arduino.net.pl\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/arduino.net.pl\/index.php\/category\/programowanie\/\" title=\"PROGRAMOWANIE\">PROGRAMOWANIE<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/arduino.net.pl\/index.php\/category\/programowanie\/micropython\/\" title=\"MicroPython\">MicroPython<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tFlask i SQLAlchemy\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/arduino.net.pl"},{"label":"PROGRAMOWANIE","link":"https:\/\/arduino.net.pl\/index.php\/category\/programowanie\/"},{"label":"MicroPython","link":"https:\/\/arduino.net.pl\/index.php\/category\/programowanie\/micropython\/"},{"label":"Flask i SQLAlchemy","link":"https:\/\/arduino.net.pl\/index.php\/flask-i-sqlalchemy\/"}],"_links":{"self":[{"href":"https:\/\/arduino.net.pl\/index.php\/wp-json\/wp\/v2\/posts\/5588","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/arduino.net.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/arduino.net.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/arduino.net.pl\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/arduino.net.pl\/index.php\/wp-json\/wp\/v2\/comments?post=5588"}],"version-history":[{"count":11,"href":"https:\/\/arduino.net.pl\/index.php\/wp-json\/wp\/v2\/posts\/5588\/revisions"}],"predecessor-version":[{"id":5807,"href":"https:\/\/arduino.net.pl\/index.php\/wp-json\/wp\/v2\/posts\/5588\/revisions\/5807"}],"wp:attachment":[{"href":"https:\/\/arduino.net.pl\/index.php\/wp-json\/wp\/v2\/media?parent=5588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/arduino.net.pl\/index.php\/wp-json\/wp\/v2\/categories?post=5588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/arduino.net.pl\/index.php\/wp-json\/wp\/v2\/tags?post=5588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}