People
 :bowtie: |
😄 :smile: |
😆 :laughing: |
|---|---|---|
😊 :blush: |
😃 :smiley: |
:relaxed: |
😏 :smirk: |
😍 :heart_eyes: |
😘 :kissing_heart: |
😚 :kissing_closed_eyes: |
😳 :flushed: |
😌 :relieved: |
😆 :satisfied: |
😁 :grin: |
😉 :wink: |
😜 :stuck_out_tongue_winking_eye: |
😝 :stuck_out_tongue_closed_eyes: |
😀 :grinning: |
😗 :kissing: |
😙 :kissing_smiling_eyes: |
😛 :stuck_out_tongue: |
| #!/usr/bin/python3 | |
| def sqlServerConnect(driverType,pip, pdbname, pusername="", ppwd=""): | |
| from pyodbc import connect | |
| try: | |
| #trying to create a cnnection | |
| connection = connect(driver=driverType, host=pip, database=pdbname, user=pusername,password=ppwd) | |
| print("Connection successful : "+driverType+" "+pip+" "+" "+pdbname+" "+pusername) | |
| return connection | |
| except Exception as e: | |
| #connection creation failed |
| { | |
| "cells": [ | |
| { | |
| "cell_type": "code", | |
| "execution_count": null, | |
| "metadata": { | |
| "collapsed": true | |
| }, | |
| "outputs": [], | |
| "source": [ |
| #webbrowser module helps in open default web browser of os | |
| from webbrowser import open | |
| #sys contains command line arguments | |
| from sys import argv | |
| #pyperclip is a third party module used to access clipbord | |
| #pip3 install pyperclip | |
| #python3 -m pip install pyperclip | |
| from pyperclip import paste | |
| if len(argv)>1: | |
| address = " ".join(argv[1:]) |
| import pyperclip | |
| c=input('Enter text you want to copy: ') | |
| pyperclip.copy(c) | |
| print('\n'+c+" is on your clip board now, press any key to paste it on stdoutput") | |
| input('') | |
| print(pyperclip.paste()) |
| #Read birthdate and display birthday manth | |
| import datetime | |
| birthday=input("What is your birthday date['yyyy-mm-dd' format] ") | |
| birthday=datetime.datetime.strptime(birthday,"%Y-%m-%d").date() | |
| print("Birthday month is "+birthday.strftime('%B')) |
| import os | |
| totalSize = 0 | |
| for filename in os.listdir(os.getcwd()): | |
| if not os.path.isfile(os.path.join(os.getcwd(),filename)): | |
| continue | |
| totalSize = totalSize + os.path.getsize(os.path.join(os.getcwd(),filename)) | |
| print("Total Size of current working directory is {0:.2f} Kilo bytes".format(totalSize/1024)) |
