Yesterday we have requirement to send report to our senior in excel format by retrieving data from database . Since there are only 10 rows so we can also manually create excel. But like other programmers, I am also very lazy, so that we create this script to export values from Mysql in csv format. mysql -u mysqlusername -p mysqlpass databsename -B -e "select * from \` tabalename \`;" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > mysql_exported_table.csv After that we fount that there are many other programming methods to perform this task.
Introduction Lets automate every thing using python and ssh. Fabric is python library and command-line tool, which use SSH for application deployment in remote servers. Install Fabric By default in all unix like machine Python is available. We can install fabric library by using utility 'pip' ## Install library for all users $ sudo pip install fabric python-vagrant ## OR Install library only for login user $ pip install fabric python-vagrant --user Create basic Vagrant file To start with fabric lets start our vagrant guest first. Please refer Vagrant Quickstart for more details on vagrant. Create directory ch2 and create basic Vagrantfile. $ mkdir ch2 ## Create Vagrant file similar to below $ cat Vagrantfile # -*- mode: ruby -*- # vi: set ft=ruby : Vagrant.configure(2) do |config| config.vm.box = "bento/centos-6.7" config.vm.network "forwarded_port", guest: 80, host: 8080 end $ vagrant up Write first Fabric code Firstl...
Kubernetes is an open source software tool for managing containerised workloads. It enables development teams to automate the deployment, scaling and management of applications. The kubeadm tool helps bootstrap a minimum viable Kubernetes cluster that conforms to best practices. This guide will walk you through how to install Kubernetes on Ubuntu 16.04. Prerequisites 3 Linux servers running Ubuntu 16.04 Access to a user account on each system with sudo or root privileges The apt package manager, included by default Command-line/terminal window (Ctrl-Alt-T) Steps to Install Kubernetes on Ubuntu Setup repository Get the Docker gpg key: $ curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo apt-key add - Add the Docker repository: $ sudo add-apt-repository "deb [arch=amd64] https://download.docker.com/linux/ubuntu \ $(lsb_release -cs) \ stable" Get the Kubernetes gpg key: $ curl -s https://packages.cloud.google.com/apt/doc/apt-key.gpg | sudo apt-key add - Add the...
Comments
Post a Comment