Changeset 2783 for TOOLS/ConsoGENCI/trunk/bin/libconso_db.py

Timestamp:

03/21/16 15:55:15 (8 years ago)

Author:

labetoulle

Message:

• Run everything (DB inserts + plots) from single bash script
• Change exit codes (unsigned in bash, so no negative values...) :
  • 0: everything was ok;
  • 1: nothing done, 'cause nothing to do => ok;
  • >= 2: error.
• DB access now needs password
• plot_bilan: added date of production and plotted range to image
• Cleaning (useless comments, ...)

File:

• TOOLS/ConsoGENCI/trunk/bin/libconso_db.py (modified) (6 diffs)

TOOLS/ConsoGENCI/trunk/bin/libconso_db.py

@@ -29 +29 @@
 
 #######################################################################
-def connect_db(db_host, db_name, db_user):
+def connect_db(db_host, db_name, db_user, db_pwd):
 
-  conn_string = "host={} dbname={} user={}".format(
-    db_host, db_name, db_user
+  conn_string = "host={} dbname={} user={} password={}".format(
+    db_host, db_name, db_user, db_pwd
   )
 
@@ -44 +44 @@
   except Exception as rc:
     print("Problem with DB connect:\n{}".format(rc))
-    exit(1)
+    exit(9)
 
   # conn.cursor will return a cursor object, you can use this cursor
@@ -63 +63 @@
   except Exception as rc:
     print("Problem with select:\n{}".format(rc))
-    exit(1)
+    exit(9)
 
   # # retrieve the records from the database
@@ -85 +85 @@
   except Exception as rc:
     print("Problem with insert:\n{}".format(rc))
-    exit(1)
+    exit(9)
 
 
@@ -98 +98 @@
   except Exception as rc:
     print("Problem with commit:\n{}".format(rc))
-    exit(1)
+    exit(9)
 
 
@@ -110 +110 @@
   except Exception as rc:
     print("Problem with close:\n{}".format(rc))
-    exit(1)
+    exit(9)