DocRaptor is an awesome Python package which allows you to convert your HTML document to PDF. It works with Python 2 and Python 3.
Here are some features of DocRaptor:
Learn Python on Your Own – What Do You Need for This?
source: https://cdn.pixabay.com/photo/2016/07/13/08/48/mobile-phone-1513945_960_720.jpg
Last week I stumbled upon livecoding.tv – a website that teaches students coding live. Here is how it works: Developers stream live video and users can ask questions and provide feedback.
You can teach yourself almost anything. Currently, the site has tutorials about Python, Java, Ruby, C, C++, C#, WordPress etc. etc.
Using a free account you can view live videos and chat with members. If you want more support or want to create your own private channel then you can sign up for a pro account which cost around $10/m. Overall the site is excellent not only for beginners but for skilled professionals who want to sharpen their skills. So what are you waiting for ? Go ahead sign up and start streaming.
Up until now we have been using fetchall() method of cursor object to fetch the records. This process of accessing all records in one go is not every efficient. As a result MySQLdb has fetchone() and fetchmany() methods of cursor object to fetch records more efficiently.
| Method | Description |
|---|---|
| fetchone() | This method returns one record as a tuple, If there are no more records then it returns None |
| fetchmany(number_of_records) | This method accepts number of records to fetch and returns tuple where each records itself is a tuple. If there are not more records then it returns an empty tuple. |
Interacting with a database is an error prone process, so we must always implement some mechanism to handle errors gracefully.
MySQLdb has MySQLdb.Error exception, a top level exception that can be used to catch all database exception raised by MySQLdb module. Continue reading
Insert statement is used to insert records in mysql.
Syntax: INSERT INTO <some table> (<some column names>) VALUES("<some values>");
Example 1: Continue reading
In the previous post we have seen how to execute sql queries using execute() method. execute() method returns affected rows, it doesn’t return the result. To fetch result we use the fetchall() method of the cursor object
Syntax: cursor.fetchall()
On success it returns tuple of rows where each row is a tuple. Continue reading
Before we start using our database with python we must connect to it. There are four stages of database communication with python:
Note: We will be using world mysql database so first download and import database as follows:
First login to your mysql server Continue reading
MySQLdb is an api for accessing MySQL database using python. It is built on top of MySQL C API.
MySQLdb don’t yet have support for python 3, it supports only python 2.4 – 2.7 . As a result you need to use python 2 for this tutorial. We will be using python 2.7.9, which you can download from here. Continue reading
format() method allows you format string in any way you want.
Syntax: template.format(p1, p1, .... , k1=v1, k2=v2)
template is a string containing format codes, format() method uses it’s argument to substitute value for each format codes. For e.g
|
1 |
>>> 'Sam has {0} red balls and {1} yellow balls'.format(12, 31) |
{0} and {1} are format codes. The format code {0} is replaced by the first argument of format() i.e 12 , while {1} is replaced by the second argument of format() i.e 31 . Continue reading