PyMySQL is a python library that can connect to the MySQL database. But these days when I execute the select SQL command through PyMySQL, I found the execution does not return any records from the database table, but the data really exists in the database table. And when I run the SQL command in the […]
Pymysql Cursor.fetchall() / Fetchone() Returns None Read More »
When I connect MySQL databases in source code, such as Java code or Python code. I encounter an error which I do not meet when I use MySQL client tool software to connect it. The error message is Access Denied For User ‘root’@’localhost’ (using Password: Yes). To resolve this issue is not hard, this example
1. What Is A Django Model. A Django model is used to represent a data model. In general, one model is mapped to one database table. The Django model can make data manipulation easy and flexible. You do not need to care about the database table operation. What you need to do is define and
How To Manage Models In Django Admin Site Read More »
When I develop the Django application and use the browser (for example google chrome) to browse my local Django website such as http://127.0.0.1:8000/user/register/, I got an error page that shows error message 502 Server dropped connection. I googled some time and finally find that the error reason is that my web browser uses a polipo
How To Resolve 502 Server Dropped Connection Read More »
I have two machines for Django example development, one is a macOS the other is a Linux Ubuntu. I create a Django project in the macOS machine but now I need to develop this Django project in Linux Ubuntu, so I need to import the project in Ubuntu to edit and run, this article will
How To Import Existing Django Project And Enable Django Support In PyCharm Read More »
Django framework provides built-in user management and authorization feature. You can use it to add a user group and user account to the Django project admin web page. You can also use the module django.contrib.auth to integrate the user authorization feature in your python source code. This article will tell you how to use it
Django User Registration And Login Use Built-in Authorization Example Read More »
This example is a user login and registration example implemented with Python Django, it demos below key points. How to set/get cookie and session values in Django. How to avoid cross-site request forgery attacks. How to include other template Html pages in the Django template Html page. How to map the root url of the
Django Cookie Session Example Read More »
This example will tell you how to use python code to retrieve emails from the pop3 email server and parse out the email info such as from/to email address, subject, text content, and attachment files. In this example, I create a local SMTP and pop3 email server with apache James. You can refer article How
Python Parse Emails And Attachments From POP3 Server Example Read More »
When I develop a Python application, sometimes I need to access my Gmail account from the Python source code. But this is not allowed by google by default, you need to configure some settings to make it happen. This article will tell you how to make your Gmail account accessed by less secure apps such
How Do I Enable Less Secure Apps On Gmail Read More »
This article will tell you how to send emails to multiple contacts which are saved in a CSV file, and how to use email subject and content templates to make the email content personalized in Python. There are mainly two steps in this example, the first step is to read user contacts in a CSV
Python Send Email To Multiple Contact In CSV File With Personalized Content Example Read More »