{"id":1687,"date":"2026-01-16T08:19:59","date_gmt":"2026-01-16T08:19:59","guid":{"rendered":"https:\/\/ajaimes.inscastellbisbal.net\/?page_id=1687"},"modified":"2026-02-03T11:11:23","modified_gmt":"2026-02-03T11:11:23","slug":"generar-formularis-dentrada-de-dades-a-la-bbdd","status":"publish","type":"page","link":"https:\/\/ajaimes.inscastellbisbal.net\/?page_id=1687","title":{"rendered":"Generar formularis d’entrada de dades a la BBDD"},"content":{"rendered":"\n
Aquest projecte consisteix en desenvolupar un sistema de gesti\u00f3 integral per a una LAN Party, utilitzant Python per a la interf\u00edcie i SQLite per a l’emmagatzematge de dades. S’ha prioritzat la seguretat, la validaci\u00f3 de dades i la facilitat d’\u00fas.<\/p>\n\n\n\n
Componentes del Sistema<\/h3>\n\n\n\n
El proyecto se divide en tres pilares fundamentales que trabajan en conjunto:<\/p>\n\n\n\n
\n
La Base de Datos (database.py<\/code>):<\/strong>\n
\n
Crea autom\u00e1ticamente un archivo llamado lan_party.db<\/code>.<\/li>\n\n\n\n
Genera 10 tablas<\/strong> relacionadas entre s\u00ed.<\/li>\n\n\n\n
Incluye datos iniciales (roles, juegos, etc.) para que el programa sea funcional desde el primer segundo.<\/li>\n\n\n\n
Transforma conceptos complejos (como los ENUMs) en restricciones CHECK<\/code> para asegurar que los datos sean correctos a nivel de motor de base de datos.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
La L\u00f3gica de Validaci\u00f3n (validacions.py<\/code>):<\/strong>\n
\n
Es el “cerebro” que revisa la informaci\u00f3n antes de guardarla.<\/li>\n\n\n\n
Contiene 17 tests de validaci\u00f3n<\/strong> para asegurar que los correos tengan formato de email, que las fechas sean coherentes y que no haya campos vac\u00edos.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
La Interfaz de Usuario (main.py<\/code>):<\/strong>\n
\n
Creada con la librer\u00eda Tkinter<\/strong>.<\/li>\n\n\n\n
Ofrece 10 formularios distintos<\/strong> (uno para cada tabla: Participantes, Equipos, Torneos, etc.).<\/li>\n\n\n\n
Utiliza elementos modernos como Comboboxes<\/strong> (desplegables) para evitar errores de escritura y garantizar la integridad de las claves for\u00e1neas (FK).<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<\/figure>\n\n\n\n\n\n\n\n\n\n\n\n
Aquest projecte consisteix en desenvolupar un sistema de gesti\u00f3 integral per a una LAN Party, utilitzant Python per a la interf\u00edcie i SQLite per a l’emmagatzematge de dades. S’ha prioritzat la seguretat, la validaci\u00f3 de dades i la facilitat d’\u00fas. Componentes del Sistema El proyecto se divide en tres pilares fundamentales que trabajan en conjunto:<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1577,"menu_order":6,"comment_status":"closed","ping_status":"closed","template":"","meta":{"saved_in_kubio":false,"_dseop_meta":"","_dseop_selected_keywords":"","footnotes":""},"class_list":["post-1687","page","type-page","status-publish","hentry"],"kubio_ai_page_context":{"short_desc":"","purpose":"general"},"yoast_head":"\n
Generar formularis d'entrada de dades a la BBDD - Adrian Jaimes<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ajaimes.inscastellbisbal.net\/?page_id=1687\" \/>\n<meta property=\"og:locale\" content=\"ca_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Generar formularis d'entrada de dades a la BBDD - Adrian Jaimes\" \/>\n<meta property=\"og:description\" content=\"Aquest projecte consisteix en desenvolupar un sistema de gesti\u00f3 integral per a una LAN Party, utilitzant Python per a la interf\u00edcie i SQLite per a l’emmagatzematge de dades. S’ha prioritzat la seguretat, la validaci\u00f3 de dades i la facilitat d’\u00fas. Componentes del Sistema El proyecto se divide en tres pilares fundamentales que trabajan en conjunto:\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ajaimes.inscastellbisbal.net\/?page_id=1687\" \/>\n<meta property=\"og:site_name\" content=\"Adrian Jaimes\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-03T11:11:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ajaimes.inscastellbisbal.net\/wp-content\/uploads\/2026\/02\/imagen-edited.png\" \/>\n\t<meta property=\"og:image:width\" content=\"762\" \/>\n\t<meta property=\"og:image:height\" content=\"429\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Temps estimat de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuts\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/?page_id=1687\",\"url\":\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/?page_id=1687\",\"name\":\"Generar formularis d'entrada de dades a la BBDD - Adrian Jaimes\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/?page_id=1687#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/?page_id=1687#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/imagen-edited.png\",\"datePublished\":\"2026-01-16T08:19:59+00:00\",\"dateModified\":\"2026-02-03T11:11:23+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/?page_id=1687#breadcrumb\"},\"inLanguage\":\"ca\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/?page_id=1687\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ca\",\"@id\":\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/?page_id=1687#primaryimage\",\"url\":\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/imagen-edited.png\",\"contentUrl\":\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/imagen-edited.png\",\"width\":762,\"height\":429},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/?page_id=1687#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Inici\",\"item\":\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"1r SMX\",\"item\":\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/?page_id=1084\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Repte 1.3\",\"item\":\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/?page_id=1491\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"7\ufe0f\u20e3 – \ud83d\udd10 – Intranet de la LAN Party\",\"item\":\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/?page_id=1577\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Generar formularis d’entrada de dades a la BBDD\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/#website\",\"url\":\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/\",\"name\":\"Adrian Jaimes\",\"description\":\"S\u00f3c estudiant d'inform\u00e0tica i aqu\u00ed podr\u00e0s veure el meu cam\u00ed acad\u00e8mic, els projectes que he realitzat i els coneixements que he adquirit durant la meva formaci\u00f3. Aquesta p\u00e0gina \u00e9s un reflex de la meva passi\u00f3 per la tecnologia i el meu comprom\u00eds per seguir aprenent i millorant cada dia. Explora els meus treballs i seguiment acad\u00e8mic!\",\"publisher\":{\"@id\":\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ca\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/#organization\",\"name\":\"Adrian Jaimes\",\"url\":\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ca\",\"@id\":\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/wp-content\\\/uploads\\\/2025\\\/12\\\/cropped-cropped-cropped-width_550_009.webp\",\"contentUrl\":\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/wp-content\\\/uploads\\\/2025\\\/12\\\/cropped-cropped-cropped-width_550_009.webp\",\"width\":512,\"height\":512,\"caption\":\"Adrian Jaimes\"},\"image\":{\"@id\":\"https:\\\/\\\/ajaimes.inscastellbisbal.net\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Generar formularis d'entrada de dades a la BBDD - Adrian Jaimes","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":"https:\/\/ajaimes.inscastellbisbal.net\/?page_id=1687","og_locale":"ca_ES","og_type":"article","og_title":"Generar formularis d'entrada de dades a la BBDD - Adrian Jaimes","og_description":"Aquest projecte consisteix en desenvolupar un sistema de gesti\u00f3 integral per a una LAN Party, utilitzant Python per a la interf\u00edcie i SQLite per a l’emmagatzematge de dades. S’ha prioritzat la seguretat, la validaci\u00f3 de dades i la facilitat d’\u00fas. Componentes del Sistema El proyecto se divide en tres pilares fundamentales que trabajan en conjunto:","og_url":"https:\/\/ajaimes.inscastellbisbal.net\/?page_id=1687","og_site_name":"Adrian Jaimes","article_modified_time":"2026-02-03T11:11:23+00:00","og_image":[{"width":762,"height":429,"url":"https:\/\/ajaimes.inscastellbisbal.net\/wp-content\/uploads\/2026\/02\/imagen-edited.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Temps estimat de lectura":"2 minuts"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ajaimes.inscastellbisbal.net\/?page_id=1687","url":"https:\/\/ajaimes.inscastellbisbal.net\/?page_id=1687","name":"Generar formularis d'entrada de dades a la BBDD - Adrian Jaimes","isPartOf":{"@id":"https:\/\/ajaimes.inscastellbisbal.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ajaimes.inscastellbisbal.net\/?page_id=1687#primaryimage"},"image":{"@id":"https:\/\/ajaimes.inscastellbisbal.net\/?page_id=1687#primaryimage"},"thumbnailUrl":"https:\/\/ajaimes.inscastellbisbal.net\/wp-content\/uploads\/2026\/02\/imagen-edited.png","datePublished":"2026-01-16T08:19:59+00:00","dateModified":"2026-02-03T11:11:23+00:00","breadcrumb":{"@id":"https:\/\/ajaimes.inscastellbisbal.net\/?page_id=1687#breadcrumb"},"inLanguage":"ca","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ajaimes.inscastellbisbal.net\/?page_id=1687"]}]},{"@type":"ImageObject","inLanguage":"ca","@id":"https:\/\/ajaimes.inscastellbisbal.net\/?page_id=1687#primaryimage","url":"https:\/\/ajaimes.inscastellbisbal.net\/wp-content\/uploads\/2026\/02\/imagen-edited.png","contentUrl":"https:\/\/ajaimes.inscastellbisbal.net\/wp-content\/uploads\/2026\/02\/imagen-edited.png","width":762,"height":429},{"@type":"BreadcrumbList","@id":"https:\/\/ajaimes.inscastellbisbal.net\/?page_id=1687#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Inici","item":"https:\/\/ajaimes.inscastellbisbal.net\/"},{"@type":"ListItem","position":2,"name":"1r SMX","item":"https:\/\/ajaimes.inscastellbisbal.net\/?page_id=1084"},{"@type":"ListItem","position":3,"name":"Repte 1.3","item":"https:\/\/ajaimes.inscastellbisbal.net\/?page_id=1491"},{"@type":"ListItem","position":4,"name":"7\ufe0f\u20e3 – \ud83d\udd10 – Intranet de la LAN Party","item":"https:\/\/ajaimes.inscastellbisbal.net\/?page_id=1577"},{"@type":"ListItem","position":5,"name":"Generar formularis d’entrada de dades a la BBDD"}]},{"@type":"WebSite","@id":"https:\/\/ajaimes.inscastellbisbal.net\/#website","url":"https:\/\/ajaimes.inscastellbisbal.net\/","name":"Adrian Jaimes","description":"S\u00f3c estudiant d'inform\u00e0tica i aqu\u00ed podr\u00e0s veure el meu cam\u00ed acad\u00e8mic, els projectes que he realitzat i els coneixements que he adquirit durant la meva formaci\u00f3. Aquesta p\u00e0gina \u00e9s un reflex de la meva passi\u00f3 per la tecnologia i el meu comprom\u00eds per seguir aprenent i millorant cada dia. Explora els meus treballs i seguiment acad\u00e8mic!","publisher":{"@id":"https:\/\/ajaimes.inscastellbisbal.net\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ajaimes.inscastellbisbal.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ca"},{"@type":"Organization","@id":"https:\/\/ajaimes.inscastellbisbal.net\/#organization","name":"Adrian Jaimes","url":"https:\/\/ajaimes.inscastellbisbal.net\/","logo":{"@type":"ImageObject","inLanguage":"ca","@id":"https:\/\/ajaimes.inscastellbisbal.net\/#\/schema\/logo\/image\/","url":"https:\/\/ajaimes.inscastellbisbal.net\/wp-content\/uploads\/2025\/12\/cropped-cropped-cropped-width_550_009.webp","contentUrl":"https:\/\/ajaimes.inscastellbisbal.net\/wp-content\/uploads\/2025\/12\/cropped-cropped-cropped-width_550_009.webp","width":512,"height":512,"caption":"Adrian Jaimes"},"image":{"@id":"https:\/\/ajaimes.inscastellbisbal.net\/#\/schema\/logo\/image\/"}}]}},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ajaimes.inscastellbisbal.net\/index.php?rest_route=\/wp\/v2\/pages\/1687","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ajaimes.inscastellbisbal.net\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/ajaimes.inscastellbisbal.net\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/ajaimes.inscastellbisbal.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ajaimes.inscastellbisbal.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1687"}],"version-history":[{"count":3,"href":"https:\/\/ajaimes.inscastellbisbal.net\/index.php?rest_route=\/wp\/v2\/pages\/1687\/revisions"}],"predecessor-version":[{"id":1894,"href":"https:\/\/ajaimes.inscastellbisbal.net\/index.php?rest_route=\/wp\/v2\/pages\/1687\/revisions\/1894"}],"up":[{"embeddable":true,"href":"https:\/\/ajaimes.inscastellbisbal.net\/index.php?rest_route=\/wp\/v2\/pages\/1577"}],"wp:attachment":[{"href":"https:\/\/ajaimes.inscastellbisbal.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1687"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/ajaimes.inscastellbisbal.net\/wp-content\/uploads\/2026\/02\/imagen-edited.png\" "\\"imagen\\"")
<\/figure>\n\n\n\n\n\n\n\n\n\n\n\n