DEV Community: Ashish Nair

Send Emails with Python : sending emails with just 6 lines of code

Ashish Nair — Tue, 13 Oct 2020 17:45:49 +0000

If you are looking for a way to send emails with python, look no more.

Lets jump into it,

Emails with Python

We'll use the Smtp module a built-in python library to send emails,

So lets start with importing it first,

import smtplib

Now that this is out of the way lets look at the code,

message = f'Subject : Upcoming Due Date Alert : {left} Days \nDear User, \n\n\nThis message is regarding the upcoming due date for {Details} on {Date}. \n\nRegards,\nPython ;)'
        server = smtplib.SMTP(host = 'smtp.gmail.com',port=587)
        server.ehlo()
        server.starttls()
        server.login(sender_mail,sender_password)
        server.sendmail(sender_mail,receiver_mail,alert_message)
        server.quit()

The server variable defines the email host which is 'gmail.com' and the port that we will be using to send the email. The server.ehlo() function is a hostname argument for the email client and the server.starttls() is to encrypt the email.

That is it, that's all it takes to send emails using python. Making sending bulk emails easy, all thanks to python. You can pass a list of receiver emails to the receiver_mail variable which would send the emails to multiple people.

Go and try send some emails with Python.

Sqlite 3 - Python Database

Ashish Nair — Tue, 13 Oct 2020 16:33:21 +0000

If you were using files to store the program data, here is a better way to store the data,

Using built-in Sqlite 3 database in Python.

So lets start with importing the the Sqlite 3 module in python,

import sqlite3

Next, lets connect the database with sqlite.

conn = sqlite3.connect('Client_data.db')
conn.execute('''CREATE TABLE Client_db
                (NAME            BLOB NOT NULL,
                PASSWORD         BLOB NOT NULL,
                EMAIL            VARCHAR(320) NOT NULL);''')
conn.commit()
conn.close()

This creates a sqlite database 'Client_data.db', and creates a table named 'Client_db' with columns Name, password and email.

Adding values to the database

Now that we have created a sqlite database and a table consisting of columns, we can add values to the table.

We can do that like this,

cursor = conn.cursor()
params = (username,password,receiver_mail)
cursor.execute("INSERT INTO Client_db VALUES (?,?,?)",params)
conn.commit()
print('User Creation Successful')
conn.close()

The '?' operator is used to pass the values of a variable, sort of like the 'f' string in Python.

Reading from the Sqlite 3 database

To read from the sqlite database there are two methods,

fetchone() : fetches the first row in the sqlite database that matches the passed in filters.

fetchall() : fetches all the rows in the sqlite database that match with the filter.

Take a look at the code,

conn = sqlite3.connect('Client_data.db')
cur = conn.cursor()
cur.execute("SELECT * FROM Client_db WHERE NAME =:NAME",{'NAME':username})
if cur.fetchone()[1] == password:
     print('LogIn Successful')

This queries the row where the name matches the name passed in, and it fetches the password relating to that username using the fetchone() method from the sqlite database, and matches the password with the one passed into the program and if the passwords match it prints out 'LogIn Successful'.

You can find more on the Sqlite 3 Database in python here.

Peace !

Building A Reddit Bot Using Python & Selenium

Ashish Nair — Mon, 12 Oct 2020 14:55:54 +0000

"The Age of Automation will be the age of Do it Yourself"- Marshall McLuhan

Have you ever tried sharing a post to your friend on Reddit using it's DM? If you have then you know how cumbersome the process of sharing the posts via DM is, I mean you got to first copy the link of the post that you would like to share and then open the inbox and paste the link you just copied and then FINALLY send it to your friend.

So, One day during one of my expeditions on Reddit, was surfing through posts and I thought why not automate the post sharing on Reddit and that is exactly what I did.

I used Selenium to do this using Python. What this does is it basically detects the new posts that you upvote, from the upvotes section and sends the latest post that you upvote to the person whose username you pass to the program in the beginning.

I have provided the link to my code and my blog down below, do check them out.

It would be great if you could provide feedbacks on my code.

Building A Reddit Bot with Selenium Web Driver | by Ashish Nair | Analytics Vidhya | Oct, 2020 | Medium

Ashish Nair ・ Oct 10, 2020 ・ 3 min read
Medium

sectrumsempra / Reddit_Bot.py

Reddit_Bot.py

Sharing files on Reddit just got a whole lot simpler.

This bot automates the process of copying and sharing the posts on Reddit's Direct messaging to your friends. This bots logs in to your Reddit account and sends the link to the post you most recently upvoted and keeps refreshing to get the new upvoted posts in Real Time. The bot was built using Selenium.

View on GitHub