with inputfile for temporary file content

fabfile.util

@task
def listlocaldbs():
    """
    list dbregistry in $HOME/dbregistry.txt
    """
    registryfile = os.path.expanduser('~/dbregistry.txt')
    with open(registryfile, 'r') as f:
        print f.read()

fabutil.createlocaldb.py

@task
def createlocaldb(dbname=None, username=None, password=None):
    """
    Create a local database and grant all rights to given user with
    given password. Will create/update file $HOME/dbregistry.txt with
    the list of dbs, usernames and passwords. Make sure this is a
    save directory.
    """
    username = username or ("%s" % uuid4())[0:15]
    password = password or ("%s" % uuid4())[0:15]
    while not dbname:
        dbname = dbname or prompt('dbname?')
    sql = (
               "drop database if exists %s" % dbname,
               "create user '%s'@'localhost' IDENTIFIED BY '%s'" % (username, password),
               "create database %s CHARACTER SET utf8 COLLATE utf8_general_ci" % dbname,
               "grant all on %s.* to '%s'@'localhost'" % (dbname, username),
               "exit",
            )
    print sql
    with inputfile(";\n".join(sql)) as sqlf:
        local('cat % s | mysql -udbadmin -pdbadmin ' % sqlf.name)
    print "created db=%s user=%s password=%s" % (dbname, username, password)
    registryfile = os.path.expanduser('~/dbregistry.txt') 
    with open(registryfile, 'a') as f:
        f.write('db=%s,user=%s,password=%s\n' % (dbname, username, password))

fabutil.dbshell

@task
def dbshell(dbname=None):
    """
    connect to a database in $HOME/dbregistry.txt. Simple
    way to connect using just the dbname.
    """
    from parse import parse 
    registryfile = os.path.expanduser('~/dbregistry.txt')
    dbindex = {}
    with open(registryfile, 'r') as f:
        content = f.readlines()
        dbs = [parse('db={},user={},password={}', db) for db in content]
        for db in dbs:
            db, user, password = db
            dbindex[db] = user, password, 
    dbname = dbname or prompt_list('select db', dbindex.keys())
    user, password = dbindex[dbname]
    local('mysql -u%s -p%s %s' % (user, password, dbname))

fabutil.inputfile.py

@contextlib.contextmanager
def inputfile(content=None):
    """
    create a named tempfile with content content.
    returns the File object

    Use:
      from fabic
      from fabutil import inputfile
      with inputfile('some string') as f:
          local('cat %s' % f.name)
    """
    try:
        f = NamedTemporaryFile()
        f.write(content)
        f.flush()
        yield f
    except RuntimeError, err:
        print '[ERROR]', err
    finally:
        f.close()