Django’s makemigrations and migrate commands are very useful to update existing database tables to reflect model changes. However if you have made many existing table column name changes, migrate will ask you a series of ‘y/N’ questions about which column names are changed. This can be tedious to cycle through especially if there are many […]
Django recreate database table Read More »
Blog post updated to add the following: Updated Python “TCS Members Details” code to get additional information from the List members’ profiles. New Python code “TCS Members Tweets” to download all List members’ Tweets. ————————————————– The Canadian Trade Commissioner Service maintains a Twitter List named CDN TCS FDI Officers that has a bunch of Canadian Trade Commissioners as members.
Canadian TCS FDI Officers Twitter list member analysis Read More »
Google’s APIs make getting Adsense (or any other Google service) data easy to download. The code below downloads Adsense data saving results to csv file. The code uses Google’s AdSense Management API, OAuth 2.0 authorization and the google-api-python-client SDK. Overview When you run this code for the first time it will open a web browser
How to use Google Adsense API to download Adsense data Read More »
I have been using Python 2.7 for most of my Python work but have a few projects where I want to use Python 3.x. In these cases I want to create a Virtualenv virtual environment with Python 3.x. Turns out that is is no problem to have Python 2.7 and Python 3.x installed on the
Create Python 3 Virtualenv on machine with Python 2 & 3 installed Read More »
I have automated uploading files from my web site host’s server to my Office 365 Sharepoint site using scheduled cron jobs running Python scripts on my web host. The Python scripts use Microsoft’s Azure Active Directory Library (ADAL) to authenticate off Azure Active Directory (Azure AD or ADD), and OneDrive API and Python Requests to use the authentication
Use OneDrive API to upload files to Office 365 Sharepoint Site Read More »
