skip to navigation
skip to content

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
 
File Type Py Version Uploaded on Size
python-moo-0.4.tar.gz (md5) Source 2016-11-22 17KB