Skip to main content

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

Project description

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
          / |    ||
         *  /\---/\
            ~~   ~~
..."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('') # or: execute(script='')

Any ideas are welcome

Hugo Shamrock


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

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

python-moo-0.4.tar.gz (18.2 kB view hashes)

Uploaded source

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page