Found 27104 Articles for Server Side Programming

Assuming that MySQL database named as test is present on server and a table named employee is also created. The table has five fields fname, lname, age, gender, and salary.A tuple object containing data of a record is defined ast1=('Mac', 'Mohan', 20, 'M', 2000)To establish interface between MySQL  and Python 3, you need to install PyMySQL module. Then you can set up the connection using following statementsimport PyMySQL # Open database connection db = PyMySQL.connect("localhost", "root", "", "test" ) # prepare a cursor object using cursor() method cursor = db.cursor()Next step is to set up the insert query using data ... Read More

PostgreSql database is by default installed on port number 5432. Python interface to PostgreSql is provided by installing psycopg2 module. Assuming that test database and employee table with fname, sname, age, gender and salary fields is available.First establish connection and obtain cursor object by following statements in Python script.import psycopg2 conn = psycopg2.connect(database = "test", user = "postgres", password = "pass123", host = "localhost", port = "5432") cur = conn.cursor()Data to be inserted in employee table is stored in the form of tuple objectt1=('Mac', 'Mohan', 20, 'M', 2000)Next set up the insert query using this tuplesql="insert into employee values(%s, %s, ... Read More

A Tuple can be used within a Tuple easily. Any item of a Tuple can be a Tuple. Tuples are sequences i.e. a collection of objects which ordered and immutable. To access the Tuple within a Tuple, use the square brackets and the index number of that specific inner Tuple. A tuple is a sequence of immutable Python objects. Tuples are sequences, just like lists. The main difference between the tuples and the lists is that the tuples cannot be changed unlike lists. Tuples use parentheses, whereas lists use square brackets. Create a basic Tuple Let us first create a ... Read More

The correct syntax to create a Python Dictionary is storing values in the form of key:value pairs. On the left of colon, we store keys and on the right, values i.e. key:value Dictionary is enclosed by curly bracket and do not allow duplicates. According to the 3.7 Python update, dictionaries are now ordered. Consider Dictionary as a set of key: value pairs, with the requirement that the keys are unique (within one dictionary). Each key in a Dictionary is separated from its value by a colon (:), the items are separated by commas, and the whole thing is enclosed ... Read More

The correct syntax to create a Python List is using the square brackets. Creating a list is as simple as putting different comma-separated values between square brackets. Through this, using Lists you can store multiple items. A list can have integer, string or float elements. With that, we can also create a List with mixed datatypes. The list can be written as a list of comma-separated values (items) between square brackets. Important thing about a list is that the items in a list need not be of the same type Create a Python List with Integer elements We will create ... Read More

To count elements in a Nested Dictionary, we can use the Built-in function len(). With that, we can also use a function that recursively calls and calculates the elements in an arbitrary depth nested dictionary. Count Elements in a Dictionary Let us first create a Python Dictionary and count its values using the len() method. Here, we have included 4 key-value pairs in the Dictionary and displayed them. Product, Model, Units, and Available are keys of the Dictionary. Except the Units key, all are having String values − Example # Creating a Dictionary myprod = { "Product":"Mobile", "Model": "XUT", ... Read More

To truncate a Python Dictionary at a given length, use the itertools module. This module implements a number of iterator building blocks inspired by constructs from APL, Haskell, and SML. For truncating at a given length, we will use the islice() method of the itertools module. The module standardizes a core set of fast, memory efficient tools that are useful by themselves or in combination. Together, they form an iterator algebra making it possible to construct specialized tools succinctly and efficiently in pure Python. Syntax Here’s the syntax − itertools.islice(sequence, stop) or itertools.islice(sequence, start, stop, step) Above, the sequence ... Read More

To insert new keys/values into a Dictionary, use the square brackets and the assignment operator. With that, the update() method can also be used. Remember, if the key is already in the dictionary, its value will get updated, else the new pair gets inserted. Consider a Dictionary as a set of key: value pairs, with the requirement that the keys are unique (within one dictionary). Each key in a Dictionary is separated from its value by a colon (:), the items are separated by commas, and the whole thing is enclosed in curly braces. Let us first create a Python ... Read More

Values of a Python Dictionary can be updated using the following two ways i.e. using the update() method and also, using square brackets. Dictionary represents the key-value pair in Python, enclosed in curly braces. The keys are unique and a colon separates it from value, whereas comma separates the items. With that, the left size before the colon are keys, whereas right its corresponding values. Let us first create a Python Dictionary and fetch all the values. Here, we have included 4 key-value pairs in the Dictionary and displayed them. Product, Model, Units, and Available are keys of the Dictionary. ... Read More

The Python Dictionary can be easily displayed into JSON format using the json Python Module. The json module is a JSON encoder/decoder. JSON is JavaScript Object Notation, a lightweight text-based open standard designed for human-readable data interchange. The JSON format was specified by Douglas Crockford. It has been extended from the JavaScript scripting language. Consider Dictionary as a set of key: value pairs, with the requirement that the keys are unique (within one dictionary). Each key in a Dictionary is separated from its value by a colon (:), the items are separated by commas, and the whole thing is enclosed ... Read More