Posts

How to Call SQL Query from Python

Image
Python's top supported database is MySQL. You can run SQL queries from Python. Here're best examples of how to connect to MYSQL and access MYSQL tables from Python. Read:  How to Print String in Next Line Easily Here are Steps Import MySQL connecter Give user id, password details Issue SQL query Python Logic to import MySQL connector import mysql.connector Note: If the MySQL connecter not installed in python, you need to install it using the below command. pip3 install mysql-connector-python --allow-external mysql-connector-python Supply user id and Password conn=mysql.connector.connect(user='root', password='password', host='localhost', database='sakila') mycursor=conn.cursor() Issue SQL Query mycursor.execute("show tables") # you won't see any result. You need to give print. print(mycursor.fetchall()) mycursor.execute("select * from customer") # you won't see any result. You need to give print. print(mycursor.fetchal

Python - How to Print String in Next Line Easily

Image
Here is an idea of how to split long strings into multiple lines. There are two methods - Backslash and Triple quotes. Python made handling strings easier for users. Assigning strings to a variable is accepted. That variable you can call an Object. Python treats everything as an Object. Method1: Backslash Method >>> s = "This is a test of the emergency broadcast system" \ … " and it will display an emergency if you put a line of text" \ … " that is more than 80 characters on a single line" >>> print(s) This is a test of the emergency broadcast system and it will display an emergency if you put a line of text that is more than 80 characters on a single line Method2: Triple Quote Method >>> s1 = """ This is a test of the emergency broadcast system. … and it will display an emergency if you put a line of text … that is more than 80 characters on a single line … """ >>> print(s1) This is a test

Script to Generate Random Number Easily

Image
Here's a bash script to generate a random number. You can use this logic to generate a random number, and it is useful for AWS engineers. Random number Script - Here's sample logic to get a random number RANDOM=$$ # Set the seed to the PID of the script UPPER_LIMIT=$1 RANDOM_NUMBER=$(($RANDOM % $UPPER_LIMIT + 1)) echo "$RANDOM_NUMBER" If you select UPPER_LIMIT as 100, then the result would be a pseudo-random number between 1 and 100. Her is the output after executing the script Related posts Structured Vs. Un-structured data

Structured Vs Unstructured data - 6 Top Differences

Image
Here's a basic interview question for Big data engineers. Why it's basic means many Bachelor degrees now offering courses on Big data, as a beginner, understanding of data is a little tricky. So interviewers stress this point. Don't worry, I made it simplified. So you get a clear concept. I share here a total of six differences between these. In today's world, we have a lot of data. That data is the unstructured format.  Structured Vs Unstructured data - 6 Top Differences Structured Data The major data format is text, which can be string or numeric. The date is also supported. The data model is fixed before inserting the data. Data is stored in the form of a table, making it easy to search. Not easy to scale. Version is maintained as a column in the table. Transaction management and concurrency are easy to support. Unstructured data The data format can be anything from text to images, audio to videos. The data model cannot be fixed since the nature of the data can chan

10 Blockchain Smart Contract Interview Questions

Image
Here are the  top ten interview questions  on Blockchain smart contracts. Here you will know about smart-contract, what language and IDE you need to develop. Useful for interviews as well. 1. What is a Smart Contract? A  smart contract  is an executable code on the blockchain intended to digitally facilitate, verify, validate, and enforce the rules and regulations of an application. Smart contracts allow the performance of credible transactions without third parties . These transactions are trackable and irreversible. 2. Where the smart Contract code resides? The smart contract is deployed in a sandbox environment and identified by a 160-bit account address like any other participants on the blockchain network. It executes on the virtual machine (VM) on the blockchain node and is identified by an account number. 3. Smart Contract is it API? Yes, it is like a class. It has methods. These are useful to process transactions in the Blockchain framework. 4. What are the six functions of Sm

How to Explain String Immutability in Python Correctly

Image
Strings in Python are immutable. That means you can't change the string. So you can use strings in many places of your project securely. How to Test a String is Immutable It's very simple. In Python shell, assign a string to a variable of your choice. Here my choice is myString. Assigned to 'ABCD'. >>> myString = 'ABCD' >>>myString [0] = 'Z' It gives an error. Since you have tried to replace 'A' with 'Z'. It's because the string is immutable. Unlock Key Points This is the ultimate interview question When they ask String is immutable, you need to say 'Yes' Show them the example that I showed above Here are the Hidden Benefits of Strings Immutable It saves a lot of time in fixing and unchanging the storage requirement times. This directly results in high performance. String objects can be reused, as they are safely stored without getting changed. Strings in Python are considered as elemental as numbers. None of

Python: Here are 3 Brilliant Methods to Execute

Image
You can run python commands in three methods. Those are at CLI, Python interface, and as a Script. How to Run Script at CLI? The script extension should be .py. Here is an example xyz.py. When the script is ready, the next step is to run it. How to run it from CLI?  Here is a command to run at CLI. Suppose you have installed Python in Linux OS. Then you need to give: $ python -m xyz.py Here, m means module. That means you are running a script with Python code. How to Run Commands at Script? The Other way, you can execute Python statements directly at CLI. Here's a command for your quick reference. $ python -c "print('Hello world')" Here, the print statement displays " Hello World " on the screen. How to Run commands at Python Interface? You know that the Python interface needs an operating system - Windows or Linux.  $ Python3 >>> 10 + 20 30 References Python Programming: Using Problem Solving Approach