Thanks to antville.org
Saturday, 15. February 2020
Using boto

In the bad old days, the glacier class used to have different layers.

import boto.glacier.layer2
l2 = boto.glacier.layer2.Layer2(aws_access_key_id='xxx', aws_secret_access_key='xxx')

Now the client is all you need!

import boto3
gc = boto3.client("glacier",
aws_access_key_id="xxx", aws_secret_access_key="xxx",)

... Link (0 comments) ... Comment


Thursday, 13. February 2020
backup mysql users 

3 steps to install percona utility...

yum install perl-DBI perl-Data-Dumper perl-DBD-MySQL

wget percona.com/get/pt-show-grants 

perl pt-show-grants -h 1.2.3.4 -uroot -pPasswd

... Link (0 comments) ... Comment


Steps to be used for generating AWS API gateway

a) Method Execution - Get Method Request - URL Query String Parameters - add a variable: cmnumber

b) Method Execution - Get Integration Request - Mapping Templates - Content-Type - application/json - Mapping template

{"mnumber": "$input.params('cmnumber')"}

"requestTemplates": {
     "application/json": {
        "querystring": "$input.params().querystring"
      }
 }

... Link (0 comments) ... Comment


Wednesday, 12. February 2020
apply colors to pandas

Here is how to change the color of negative values to red in pandas.

def color_negative_red(val):
color = 'red' if val < 0 else 'black'
return 'color: %s' % color

df = df.style.applymap(color_negative_red)

... Link (0 comments) ... Comment


Tuesday, 11. February 2020
change log file size in MySQL

Here are the steps to be followed while changing the log file size in mysql:

1) SET GLOBAL innodb_fast_shutdwn = 1;
2) Stop the mysqld server and check the end of the error log file to ensure that the shutdown was clean.
3) Move the existing log files to another location for extra safety.
4) Make the size change in the my.cnf and restart.

... Link (0 comments) ... Comment


Holidays in India

These are the common holidays celebrated in India (Mumbai) during 2016 - 17

08-April Friday Guddi Padwa
1-May Sunday Maharashtra Day
15-Aug Monday Independence Day
05-Sept Monday Ganesh Chaturthi
02-Oct Sunday Gandhi Jayanti
11-Oct Tuesday Dussehra
30-Oct Sunday Diwali
31-Oct Monday Lakshmi Pooja
25-Dec Sunday Christmas
26-Jan Thursday Republic Day
13-March Monday Holi
_____

List FY 2013- 14           
Gudi Padwa    11-Apr    Thursday
Maharshtra Day    1-May    Wednesday
Independence Day    15-Aug    Thursday
Rakshabandhan    21-Aug    Wednesday
Ganesh Chaturthi    9-Sep    Monday
Gandhi Jayanti    2-Oct    Wednesday
Dasera    14-Oct    Monday
Laxmi Puja    3-Nov    Sunday
New Year    4-Nov    Monday
Bhai Duj    5-Nov    Tuesday
Chirstmas    25-Dec    Wednesday
Republic Day    26-Jan    Sunday
Holi    17-Mar    Monday
Gudi Padwa    31- Mar-2014    Monday

... Link (0 comments) ... Comment


MySQL common error messages

1146 Table does not exist
1054 column does not exist
1062 duplicate entry for primary key
1406 Data too long for column
1064 sql syntax error
1111 invalid use of group function
1366 incorrect integer value
1046 No database selected

... Link (0 comments) ... Comment


Sunday, 9. February 2020
ipython parallel demo

First start ipython in cluster mode

ipcluster start -n 4

from IPython.parallel import Client
rc = Client()
v=rc.load_balanced_view()
@v.parallel(block=True)
def f(x): return 2*x
result = f.map(range(10))
print("Using a parallel function: ", result)

... Link (0 comments) ... Comment


djanog settings

You may see this message if you have DEBUG = True in your Django settings file and you haven't configured any URLs.

django-admin.py startproject todo

python manage.py runserver localhost:8000

$$   If you plan to use a database, edit the DATABASES setting in todo/settings.py.
python manage.py startapp todoapp

$$ syncdb and flush are other 2 parameters accepted by manage.py

... Link (0 comments) ... Comment


Saturday, 8. February 2020
clear tmp folder

Here is following commands to clear unwanted stuff from the /tmp partition on the server?

tmpwatch –mtime –all 48 /tmp

The above command will remove all files and folders from the /tmp which have not been accessed in the last couple of days (24×2=48). You can modify the number of hours as required.

... Link (0 comments) ... Comment


Online for 6918 days
Last modified: 7/23/21, 10:31 AM
Status
Youre not logged in ... Login
Menu
... Home
... Tags

Search
Calendar
August 2021
SunMonTueWedThuFriSat
1234567
891011121314
15161718192021
22232425262728
293031
July
Recent updates
wikipedia tools 1) Collection of
useful utilities https://wikipediatools.appspot.com/ 2) all history of a user https://xtools.wmflabs.org/ec/mr.wikisource.org/Shantanuo...
by shantanuo (7/23/21, 10:31 AM)
Preserve seeds 6 types of
seeds to be preserved for next season. 1) laal Mula...
by shantanuo (5/7/21, 5:46 AM)
Why do I care for
Linux? I don't care that much for other software. Linux...
by shantanuo (12/17/20, 9:27 AM)
important leafy vegetables 1. Amaranthus
caudatus: rajgira. 2. Amaranthus tricolor: Math.  (Chhoti Chulai- Hindi, Cheera-...
by shantanuo (4/12/20, 2:01 PM)
program creek program creek
seems to be a good site for handy references of python...
by shantanuo (4/11/20, 11:24 AM)
Standard out to a file
This code will change the standard out to a file...
by shantanuo (4/11/20, 11:18 AM)
Create config file for AWS
command line tool While creating amazon config file in a...
by shantanuo (2/20/20, 6:00 AM)
setting colors in pandas This
is how to set the colors in pandas mapper =...
by shantanuo (2/20/20, 5:53 AM)
log mysql output tee output.txt
show global variables; show engine innodb status\G show full processlist;...
by shantanuo (2/19/20, 10:33 AM)
access AWS API gateway using
python Amazon API gateway allows us to host serverless API's...
by shantanuo (2/16/20, 9:41 AM)
Using boto In the bad
old days, the glacier class used to have different layers....
by shantanuo (2/15/20, 10:28 AM)
backup mysql users  3
steps to install percona utility... yum install perl-DBI perl-Data-Dumper perl-DBD-MySQL wget...
by shantanuo (2/13/20, 1:49 PM)
Steps to be used for
generating AWS API gateway a) Method Execution - Get Method...
by shantanuo (2/13/20, 1:30 PM)
apply colors to pandas Here
is how to change the color of negative values to...
by shantanuo (2/12/20, 8:57 AM)
Holidays in India These are
the common holidays celebrated in India (Mumbai) during 2016 -...
by shantanuo (2/11/20, 1:53 PM)
change log file size in
MySQL Here are the steps to be followed while changing...
by shantanuo (2/11/20, 10:38 AM)
MySQL common error messages 1146
Table does not exist 1054 column does not exist 1062...
by shantanuo (2/11/20, 10:13 AM)
ipython parallel demo First start
ipython in cluster mode ipcluster start -n 4 from IPython.parallel...
by shantanuo (2/9/20, 9:02 AM)
djanog settings You may see
this message if you have DEBUG = True in your...
by shantanuo (2/9/20, 4:07 AM)
clear tmp folder Here is
following commands to clear unwanted stuff from the /tmp partition...
by shantanuo (2/8/20, 2:41 PM)
change your server time to
IST If you need to change your server clock to...
by shantanuo (2/8/20, 2:39 PM)
Transfer root emails to another
email address If you have root access to the server...
by shantanuo (2/8/20, 2:32 PM)
special strings in cron Instead
of the first five fields, you can use any one...
by shantanuo (2/8/20, 2:30 PM)
LibreOffice version conflict I am
not able to install latest version of Libre office. I...
by shantanuo (1/29/20, 9:15 AM)
while loop This is
a sample shell script while loop while read mydb do echo...
by shantanuo (1/26/20, 12:24 PM)

RSS feed

Made with Antville
Helma Object Publisher