tech-island.com

import logging
 
def init_logging():
  # create logger
  global logger
  logger = logging.getLogger("script name")
 
  # create handlers
  logfile_handle = logging.FileHandler(filename = "log.log")
  console_handle  = logging.StreamHandler()
 
  # set loglevel
  logger.setLevel(logging.DEBUG)
  logfile_handle.setLevel(logging.DEBUG)
  console_handle.setLevel(logging.INFO)
 
  # add handlers to logger
  logger.addHandler(logfile_handle)
  logger.addHandler(console_handle)
 
  # create Formatting
  format_file    = logging.Formatter("%(asctime)s - %(name)s - %(levelname)s - %(message)s")
  format_console = logging.Formatter("\033[0;32m%(asctime)s\033[0m - %(message)s")
 
  # add formatter to handler
  logfile_handle.setFormatter(format_file)
  console_handle.setFormatter(format_console)
 
  logger.debug("Logging initialized")
 
init_logging()

logger.info("This informational message only goes to console.")
logger.warn("This warning message only goes to console")

import os
import sqlite3
 
###############################################################################
# modifies the delivery database                                              #
# lists, adds and removes projects or recipients                              #
###############################################################################
class sqliteDB:
 
  #############################################################################
  # Creates a new sqlite database                                             #
  #############################################################################
  def create(self, dbfile):
    if not os.path.isfile(dbfile):
      self.sqlquery(dbfile, "CREATE TABLE 'table1' ('TID' INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 'TOtherTableID' INTEGER NOT NULL, 'TName' TEXT NOT NULL, 'TDescription' TEXT)")
      return dbfile
    else:
      return 1
 
 
  ###############################################################################
  # queries the database and returns a dictionary of rows                       #
  #                                                                             #
  # takes:   string            = String of SQL-Code                             #
  # returns: dict              = dict of rows                                   #
  ###############################################################################
  def sqlquery(self, dbfile, sql):
    try:
      con = sqlite3.connect(dbfile)
      con.row_factory = sqlite3.Row
      cur = con.cursor()
      cur.execute(sql)
      con.commit()
 
      rows = cur.fetchall()
      con.close()
 
    except sqlite3.Error, e:
      msg = "Error %d: %s" % (e.args[0], e.args[1])
      print msg
 
    return rows

# Define database file
myDBfile = "sqlite.db"
 
# Create a new database
myDB = sqliteDB().create(myDBfile)
if myDB == myDBfile:
  print "Created database: '{myDB}'".format(myDB = myDB)
else:
  print "DB file already existent. If you want to create a NEW database, please delete the file:\n{filename}\n".format(filename = myDBfile)
 
# Insert data in database
sqliteDB().sqlquery(myDBfile, "INSERT INTO table1 (TOtherTableID, TName) VALUES (1, 'My first row')")
sqliteDB().sqlquery(myDBfile, "INSERT INTO table1 (TOtherTableID, TName) VALUES (2, 'My second row')")
 
# Select data from database
rows = sqliteDB().sqlquery(myDBfile, "SELECT TName FROM table1")
 
# Show data
for row in rows:
  print row['TName']
 
# Delete data
sqliteDB().sqlquery(myDBfile, "DELETE  FROM table1  WHERE TOtherTableID = 2")

def ask_proceed(question, default="yes"):
    valid = {"yes":"yes", "y":"yes", "no":"no", "n":"no"}
    if default == None:
      prompt = " [y/n] "
    elif default == "yes":
      prompt = " [Y/n] "
    elif default == "no":
      prompt = " [y/N] "
    else:
      raise ValueError("invalid default answer: '%s'" % default)
 
    while 1:
      print (question + prompt)
      choice = raw_input().lower()
      if default is not None and choice == '':
        return default
      elif choice in valid.keys():
        return valid[choice]
      else:
        print ("Please respond with 'yes' or 'no' (or 'y' or 'n').\n")
 
 
result = ask_proceed("Do you want to continue?")
if result == "yes":
  print "A good choise! I will continue with whatever I was doing..."
if result == "no":
  print "Ok, bye!"