{"id":632,"date":"2023-02-17T22:37:42","date_gmt":"2023-02-17T21:37:42","guid":{"rendered":"https:\/\/numa-bord.com\/miniblog\/?p=632"},"modified":"2023-02-17T22:37:42","modified_gmt":"2023-02-17T21:37:42","slug":"mon-premier-script-python","status":"publish","type":"post","link":"https:\/\/numa-bord.com\/miniblog\/mon-premier-script-python\/","title":{"rendered":"Mon premier script Python"},"content":{"rendered":"

Pour marquer la date d’une pierre blanche !<\/p>\n

Apr\u00e8s plus de 15 ans de bons et loyaux service en PHP (et ce n’est pas termin\u00e9), j’ai l\u2019occasion de travailler sur mon premier projet Python, et en ce mercredi 15 F\u00e9vrier 2023 j’ai d\u00e9velopp\u00e9 mon premier script dans ce langage.<\/p>\n

Alors oui c’est basique mais je le pose ici pour le souvenir<\/p>\n

import<\/span> psycopg2
\nimport<\/span> csv<\/span>
\n
\nfrom<\/span> psycopg2 import<\/span> Error
\n#config : <\/span>
\n# id de la liste que l'on veux remplir<\/span>
\nid_liste =<\/span> 300<\/span>
\n# nom du fichier csv<\/span>
\nfilename =<\/span> 'liste300.csv'<\/span>
\n#<\/span>
\ntry<\/span>:
\n    #connexion \u00e0 la base<\/span>
\n    conn =<\/span> psycopg2.connect<\/span>(<\/span>database=<\/span>"nom_de_la_base"<\/span>,<\/span>
\n                        host=<\/span>"localhost"<\/span>,<\/span>
\n                        user<\/span>=<\/span>"user_base"<\/span>,<\/span>
\n                        password=<\/span>"pass_base"<\/span>,<\/span>
\n                        port=<\/span>"5432"<\/span>)<\/span>
\n
\n    cursor =<\/span> conn.cursor<\/span>(<\/span>)<\/span>
\n    #on vidange la liste au cas ou elle ne soit pas vierge<\/span>
\n    cursor.execute<\/span>(<\/span>"DELETE FROM taxonomie.cor_nom_liste WHERE id_liste = %s"<\/span>,<\/span> (<\/span>id_liste,<\/span>)<\/span>)<\/span>
\n
\n    #parcours CSV<\/span>
\n    nbInsert =<\/span> 0<\/span>
\n    nbError =<\/span> 0<\/span>;<\/span>
\n    with<\/span> open<\/span>(<\/span>filename,<\/span> 'r'<\/span>)<\/span> as<\/span> csvfile:
\n        datareader =<\/span> csv<\/span>.reader<\/span>(<\/span>csvfile)<\/span>
\n        for<\/span> row in<\/span> datareader:
\n            if<\/span> row[<\/span>0<\/span>]<\/span> !=<\/span> "cd_nom"<\/span>:
\n                #on recherche le cd_nom dans la table bib_nom pour r\u00e9cup\u00e9rer la valeur id_nom<\/span>
\n                cd_nom =<\/span> row[<\/span>0<\/span>]<\/span>
\n                cursor.execute<\/span>(<\/span>"SELECT * FROM taxonomie.bib_noms WHERE cd_nom = %s"<\/span>,<\/span> (<\/span>cd_nom,<\/span>)<\/span>)<\/span>
\n                #on indique si la valeur n'existe pas<\/span>
\n                nom =<\/span> cursor.fetchone<\/span>(<\/span>)<\/span>
\n                if<\/span> nom is<\/span> None<\/span>:
\n                    #raise Exception('cd_nom "' + str(cd_nom) + '" introuvable')<\/span>
\n                    print<\/span>(<\/span>'cd_nom "'<\/span> + str<\/span>(<\/span>cd_nom)<\/span> + '" introuvable ('<\/span>+row[<\/span>16<\/span>]<\/span>+') '<\/span>)<\/span>
\n                    nbError +=<\/span> 1<\/span>
\n                else<\/span>:
\n                    #ins\u00e9rer les donn\u00e9es<\/span>
\n                    id_nom =<\/span> nom[<\/span>0<\/span>]<\/span>
\n                    cursor.execute<\/span>(<\/span>"INSERT INTO taxonomie.cor_nom_liste (id_nom, id_liste) VALUES(%s, %s)"<\/span>,<\/span> (<\/span>id_nom,<\/span> id_liste,<\/span>)<\/span>)<\/span>
\n                    nbInsert +=<\/span> 1<\/span>
\n
\n    #commit<\/span>
\n    conn.commit<\/span>(<\/span>)<\/span>
\n    print<\/span>(<\/span>str<\/span>(<\/span>nbInsert)<\/span>+" lignes ins\u00e9r\u00e9es"<\/span>)<\/span>
\n    print<\/span>(<\/span>str<\/span>(<\/span>nbError)<\/span>+" lignes ignor\u00e9es"<\/span>)<\/span>
\n
\nexcept<\/span> (<\/span>Exception<\/span>,<\/span> Error)<\/span> as<\/span> error:
\n    print<\/span>(<\/span>"Le script d'import retourne l'erreur : "<\/span>,<\/span> error)<\/span>
\nfinally<\/span>:
\n    if<\/span> conn:
\n        cursor.close<\/span>(<\/span>)<\/span>
\n        conn.close<\/span>(<\/span>)<\/span><\/div><\/div>\n

J’en profite pour remercier mon partenaire Iulian de me sortir de ma zone de confort, et qui apr\u00e8s le NodeJs me lance sur Python. Je le remercie aussi de me permettre de me r\u00e9galer sur d’autre projets avec l’utilisation de Symfony mon framework ador\u00e9 !<\/p>\n","protected":false},"excerpt":{"rendered":"

Pour marquer la date d’une pierre blanche ! Apr\u00e8s plus de 15 ans de bons et loyaux service en PHP (et ce n’est pas termin\u00e9), j’ai l\u2019occasion de travailler sur mon premier projet Python, et en ce mercredi 15 F\u00e9vrier 2023 j’ai d\u00e9velopp\u00e9 mon premier script dans ce langage. Alors oui c’est basique mais je […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2,27],"tags":[],"class_list":["post-632","post","type-post","status-publish","format-standard","hentry","category-developpement","category-python"],"acf":[],"yoast_head":"\nMon premier script Python - Pense b\u00eate d'un d\u00e9veloppeur web<\/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:\/\/numa-bord.com\/miniblog\/mon-premier-script-python\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mon premier script Python - Pense b\u00eate d'un d\u00e9veloppeur web\" \/>\n<meta property=\"og:description\" content=\"Pour marquer la date d’une pierre blanche ! Apr\u00e8s plus de 15 ans de bons et loyaux service en PHP (et ce n’est pas termin\u00e9), j’ai l\u2019occasion de travailler sur mon premier projet Python, et en ce mercredi 15 F\u00e9vrier 2023 j’ai d\u00e9velopp\u00e9 mon premier script dans ce langage. Alors oui c’est basique mais je […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/numa-bord.com\/miniblog\/mon-premier-script-python\/\" \/>\n<meta property=\"og:site_name\" content=\"Pense b\u00eate d'un d\u00e9veloppeur web\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-17T21:37:42+00:00\" \/>\n<meta name=\"author\" content=\"Numa\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Numa\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/numa-bord.com\/miniblog\/mon-premier-script-python\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/numa-bord.com\/miniblog\/mon-premier-script-python\/\"},\"author\":{\"name\":\"Numa\",\"@id\":\"https:\/\/numa-bord.com\/miniblog\/#\/schema\/person\/f9d00acd1703f17e5a6895283eb46a7e\"},\"headline\":\"Mon premier script Python\",\"datePublished\":\"2023-02-17T21:37:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/numa-bord.com\/miniblog\/mon-premier-script-python\/\"},\"wordCount\":354,\"commentCount\":0,\"articleSection\":[\"D\u00e9veloppement\",\"Python\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/numa-bord.com\/miniblog\/mon-premier-script-python\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/numa-bord.com\/miniblog\/mon-premier-script-python\/\",\"url\":\"https:\/\/numa-bord.com\/miniblog\/mon-premier-script-python\/\",\"name\":\"Mon premier script Python - Pense b\u00eate d'un d\u00e9veloppeur web\",\"isPartOf\":{\"@id\":\"https:\/\/numa-bord.com\/miniblog\/#website\"},\"datePublished\":\"2023-02-17T21:37:42+00:00\",\"author\":{\"@id\":\"https:\/\/numa-bord.com\/miniblog\/#\/schema\/person\/f9d00acd1703f17e5a6895283eb46a7e\"},\"breadcrumb\":{\"@id\":\"https:\/\/numa-bord.com\/miniblog\/mon-premier-script-python\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/numa-bord.com\/miniblog\/mon-premier-script-python\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/numa-bord.com\/miniblog\/mon-premier-script-python\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/numa-bord.com\/miniblog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mon premier script Python\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/numa-bord.com\/miniblog\/#website\",\"url\":\"https:\/\/numa-bord.com\/miniblog\/\",\"name\":\"Pense b\u00eate d'un d\u00e9veloppeur web\",\"description\":\"(php, javascript, Symfony, Wordpress....)\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/numa-bord.com\/miniblog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/numa-bord.com\/miniblog\/#\/schema\/person\/f9d00acd1703f17e5a6895283eb46a7e\",\"name\":\"Numa\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f21d1af4658a7106211915940584534c1e0b3eef3f12eb67a697686cad70b64a?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f21d1af4658a7106211915940584534c1e0b3eef3f12eb67a697686cad70b64a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f21d1af4658a7106211915940584534c1e0b3eef3f12eb67a697686cad70b64a?s=96&d=mm&r=g\",\"caption\":\"Numa\"},\"url\":\"https:\/\/numa-bord.com\/miniblog\/author\/negonner\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Mon premier script Python - Pense b\u00eate d'un d\u00e9veloppeur web","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:\/\/numa-bord.com\/miniblog\/mon-premier-script-python\/","og_locale":"fr_FR","og_type":"article","og_title":"Mon premier script Python - Pense b\u00eate d'un d\u00e9veloppeur web","og_description":"Pour marquer la date d’une pierre blanche ! Apr\u00e8s plus de 15 ans de bons et loyaux service en PHP (et ce n’est pas termin\u00e9), j’ai l\u2019occasion de travailler sur mon premier projet Python, et en ce mercredi 15 F\u00e9vrier 2023 j’ai d\u00e9velopp\u00e9 mon premier script dans ce langage. Alors oui c’est basique mais je […]","og_url":"https:\/\/numa-bord.com\/miniblog\/mon-premier-script-python\/","og_site_name":"Pense b\u00eate d'un d\u00e9veloppeur web","article_published_time":"2023-02-17T21:37:42+00:00","author":"Numa","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Numa","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/numa-bord.com\/miniblog\/mon-premier-script-python\/#article","isPartOf":{"@id":"https:\/\/numa-bord.com\/miniblog\/mon-premier-script-python\/"},"author":{"name":"Numa","@id":"https:\/\/numa-bord.com\/miniblog\/#\/schema\/person\/f9d00acd1703f17e5a6895283eb46a7e"},"headline":"Mon premier script Python","datePublished":"2023-02-17T21:37:42+00:00","mainEntityOfPage":{"@id":"https:\/\/numa-bord.com\/miniblog\/mon-premier-script-python\/"},"wordCount":354,"commentCount":0,"articleSection":["D\u00e9veloppement","Python"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/numa-bord.com\/miniblog\/mon-premier-script-python\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/numa-bord.com\/miniblog\/mon-premier-script-python\/","url":"https:\/\/numa-bord.com\/miniblog\/mon-premier-script-python\/","name":"Mon premier script Python - Pense b\u00eate d'un d\u00e9veloppeur web","isPartOf":{"@id":"https:\/\/numa-bord.com\/miniblog\/#website"},"datePublished":"2023-02-17T21:37:42+00:00","author":{"@id":"https:\/\/numa-bord.com\/miniblog\/#\/schema\/person\/f9d00acd1703f17e5a6895283eb46a7e"},"breadcrumb":{"@id":"https:\/\/numa-bord.com\/miniblog\/mon-premier-script-python\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/numa-bord.com\/miniblog\/mon-premier-script-python\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/numa-bord.com\/miniblog\/mon-premier-script-python\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/numa-bord.com\/miniblog\/"},{"@type":"ListItem","position":2,"name":"Mon premier script Python"}]},{"@type":"WebSite","@id":"https:\/\/numa-bord.com\/miniblog\/#website","url":"https:\/\/numa-bord.com\/miniblog\/","name":"Pense b\u00eate d'un d\u00e9veloppeur web","description":"(php, javascript, Symfony, Wordpress....)","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/numa-bord.com\/miniblog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/numa-bord.com\/miniblog\/#\/schema\/person\/f9d00acd1703f17e5a6895283eb46a7e","name":"Numa","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/f21d1af4658a7106211915940584534c1e0b3eef3f12eb67a697686cad70b64a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f21d1af4658a7106211915940584534c1e0b3eef3f12eb67a697686cad70b64a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f21d1af4658a7106211915940584534c1e0b3eef3f12eb67a697686cad70b64a?s=96&d=mm&r=g","caption":"Numa"},"url":"https:\/\/numa-bord.com\/miniblog\/author\/negonner\/"}]}},"_links":{"self":[{"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/posts\/632","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/comments?post=632"}],"version-history":[{"count":1,"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/posts\/632\/revisions"}],"predecessor-version":[{"id":633,"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/posts\/632\/revisions\/633"}],"wp:attachment":[{"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/media?parent=632"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/categories?post=632"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/tags?post=632"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}