Skip to main content
This is a pre-production deployment of Warehouse. Changes made here affect the production instance of PyPI (pypi.python.org).
Help us improve Python packaging - Donate today!

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
                 (__)
                 (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
Release History

Release History

This version
History Node

0.4

History Node

0.3

Download Files

Download Files

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

File Name & Checksum SHA256 Checksum Help Version File Type Upload Date
python-moo-0.4.tar.gz (18.2 kB) Copy SHA256 Checksum SHA256 Source Nov 22, 2016

Supported By

WebFaction WebFaction Technical Writing Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Rackspace Rackspace Cloud Servers DreamHost DreamHost Log Hosting