python-moo 0.4

Easy way how to run the same query in multiple SQL databases

Return to the goals of foo (implemented)

• SSH connector for execution remote Unix/Linux shell commands

What is moo

• Easy way how to run the same query in multiple SQL databases

• Python object created for accessing SQL databases (used internally SQLAlchemy)

• Simplification of the existing project called foo by using an agile approach to programming

What is foo

• One of my first projects in Python (the best way how to learn programming in any language is, that you try to create something useful)

• A project with big ambitions (to be universal interface between the database administrator and the rest of the world, foo has connectors to many SQL databases, connectors for SSH, FTP, etc.)

• A project with a very low quality of source code

• Still and probably never finished project

Why the name moo

• It is similar to foo, you need only change one letter

• Mnemonically: results from the database are moo-ed you

• It is my favorite Linux Easter egg ;)

root@work:~# apt-get moo
                 (__)
                 (oo)
           /------\/
          / |    ||
         *  /\---/\
            ~~   ~~
..."Have you mooed today?"...

How to use moo.database

#!/usr/bin/env python3

import moo.database
execute = moo.database.execute(config='./examples/oracle.moo', script_directory='./examples/')

execute('select host_name from v$instance')
execute.script('hostname.sql') # or: execute(script='hostname.sql')

How to use moo.ssh

#!/usr/bin/env python3

import moo.ssh
execute = moo.ssh.execute(config='./examples/ssh.moo', script_directory='./examples/')

execute('df -h')
execute.script('freespace.sh') # or: execute(script='freespace.sh')

Any ideas are welcome

Hugo Shamrock

Changelog

0.4 (2016 Nov 22)

• add configurator as submodule

• modify the source code by pep8

• print raised exception

• fix print datetime values

0.3 (2015 Jan 16)

• create ‘moo’ package

• bugfix: new version of paramiko

• add ssh connector

0.2 (2014 May 27)

• several attempts to resolve the crashes on encfs

• add multiprocessing support

0.1 (2014 Apr 17)

• initial release ~> basic functionality