PIXNET Logo登入

DanBrother的部落格

跳到主文

歡迎光臨DanBrother在痞客邦的小天地. 部落格文章同步於=> http://blog.xuite.net/gem083/dba

部落格全站分類:數位生活

  • 相簿
  • 部落格
  • 留言
  • 名片
  • 6月 15 週五 201811:22
  • Download mp3 file from the url using Python 3.6

download_mp3.py
>>
###################################################
# Download mp3 file from the url using Python 3.6
###################################################
import datetime
from urllib.request import urlretrieve

today = datetime.datetime.now().strftime("%Y%m%d")
url = 'http://www.changelife.org.tw/data/files/morning_bible_study/%s.mp3' %today
filename="%s.mp3" %today
response = urlretrieve(url,filename)

download_mp3.bat
>>
python download_mp3.py

(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(328)

  • 個人分類:Python
▲top
  • 9月 29 週五 201716:30
  • Introduction to Matplotlib for Python


If you have Python 2 >=2.7.9 or Python 3 >=3.4 installed from python.org, you will already have pip and setuptools, but will need to upgrade to the latest version:
C:\Users\danbrother>pip install -U pip setuptools
Requirement already up-to-date: pip in f:\python\python36-32\lib\site-packages
Collecting setuptools
  Downloading setuptools-36.5.0-py2.py3-none-any.whl (478kB)
    100% |████████████████████████████████| 481kB 1.2MB/s
Installing collected packages: setuptools
  Found existing installation: setuptools 28.8.0
    Uninstalling setuptools-28.8.0:
      Successfully uninstalled setuptools-28.8.0
Successfully installed setuptools-36.5.0
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(50)

  • 個人分類:Python
▲top
  • 9月 26 週二 201713:35
  • Introduction to NumPy Package for Python

NumPy is the fundamental general-purpose array_processing package for scientific computing with Python
designed to efficiently manipulate large multi-dimensional arrays of arbitrary records 
without sacrificing too much speed for small multi-dimensional arrays. 
NumPy is built on the Numeric code base and adds features introduced by numarray 
as well as an extended C-API and the ability to create arrays of arbitrary type 
which also makes NumPy suitable for interfacing with general-purpose data-base applications.
To download NumPy wheels, go to the URL:
https://pypi.python.org/pypi/numpy
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(10)

  • 個人分類:Python
▲top
  • 9月 14 週四 201715:06
  • Solved Python 3.6.2 Issue : pyinstaller IndexError: tuple index out of range

Pyinstaller works fine in Python 3.5 (e.g. pyinstall report.py)
whereas in Python 3.6.2 it ran into problem with the error message:  IndexError: tuple index out of range
To solve the problem, cx_Freeze module needs to be installed and setup as follows:
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(867)

  • 個人分類:Python
▲top
  • 9月 08 週五 201714:44
  • Python 3.6.2 Script for Generating Directories and Files Used by Oracle SQL*Loader

Python 3.6.2 Script for Generating Directories and Files Used by Oracle SQL*Loader
E:\pytest>type GEN_FILES.py
###############################################################################
# Python 3.6.2  Script for Generating Directories and Files Used by Oracle SQL*Loader
# Syntax: GEN_FILES.py {LOTTERY_TYPE} {DATE}
# e.g. python GEN_FILES.py BIG_Lottery 20170908
# Programmed by DanBrother
###############################################################################
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(21)

  • 個人分類:Python
▲top
  • 6月 21 週三 201712:23
  • Python - Connect to SQL Server DB Example


Python - Connect to SQL Server DB Example
pyodbc is an open source Python extension module that makes access to ODBC databases easier.
It implements the DB API 2.0 specification but is packed with even more Pythonic convenience.

(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(55)

  • 個人分類:Python
▲top
  • 6月 03 週六 201717:19
  • Python - Connect to Oracle DB Examples


Python - Connect to Oracle DB Examples
cx_Oracle is a Python extension module that enables access to Oracle Database and conforms to the Python database API specification. This module is currently built against version for Oracle Client 11.2 onwards and Python 2.7, 3.4, 3.5 and 3.6.
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(2,648)

  • 個人分類:Python
▲top
  • 5月 26 週五 201716:50
  • Introducing to Python Text Sequence Type — str

Introducing to Python Text Sequence Type — str


Strings are mutable sequences of Unicode code points.
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(9)

  • 個人分類:Python
▲top
  • 5月 08 週一 201716:47
  • Introducing to Python Sequence Types — List, Tuple & Range

Introducing to Python Sequence Types — List, Tuple & Range


(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(48)

  • 個人分類:Python
▲top
  • 5月 04 週四 201713:34
  • Python >>> a, b = b, a + b

Python >>>  a, b = b, a + b
>>> a , b = 0 , 1
>>> a
0
>>> b
1
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(1) 人氣(14)

  • 個人分類:Python
▲top
1

廣告

個人資訊

DanBrother
暱稱:
DanBrother
分類:
數位生活
好友:
累積中
地區:

熱門文章

  • (58,074)祝福禱告文-為工作祝福
  • (49,259)Excel 2007 中文字顯示亂碼之修復步驟
  • (2,928)ORA-24247: 存取控制清單 (ACL) 拒絕網路存取
  • (626)OSQL公用程式的使用方法
  • (456)Oracle11g Tracefile Housekeeping by ADRCI (Automatic Diagnostic Repository Command Interpreter)
  • (135)FORFILES command to remove older files or folders (Windows Server 2008)
  • (69)srvctl command usage
  • (19)Use EVERYDAY_WINDOW for DEFAULT_MAINTENANCE_PLAN
  • (17)Re-Installation Issue: you do not have sufficient permissions to access the inventory
  • (5)RPM & SRPM

文章分類

  • Android (1)
  • Java (1)
  • MongoDB (1)
  • MariaDB (7)
  • Python (10)
  • HTML (1)
  • ORDS (1)
  • Apache Tomcat (1)
  • Oracle Streams (1)
  • Javascript (1)
  • Oracle Data Guard (2)
  • Oracle VirtualBox (3)
  • Grid Infrastructure (4)
  • Oracle SQL Tuning (6)
  • OEM11g / 12c (28)
  • IT Links (1)
  • 心靈饗宴 (161)
  • Oracle Clusterware (5)
  • ORACLE RAC (21)
  • Oracle ASM (18)
  • Oracle Export/Import (10)
  • MySQL (22)
  • Windows Series (18)
  • Oracle HTTP Server (8)
  • Linux (49)
  • Microsoft Office (6)
  • SQL SERVER (19)
  • Install Apache & PHP (2)
  • Oracle in General (111)
  • RMAN (15)
  • SQL / PL/SQL (30)
  • 未分類文章 (1)

最新文章

  • MySQL Array Simulation in Stored Procedure
  • Extracts, orders, and then prints grants for MySQL user accounts (pt-show-grants)
  • MySQL Stored Procedure - Nested Loop Example
  • Metabase H2 DB Migration to MySQL 5.7
  • Steps for Upgrading Percona-Toolkit to the Latest Version
  • MySQL Slave - Skip Replication for A Particular Table
  • MySQL - Export & Import Table Data Based on the SQL Query
  • MySQL Table Fragmentation Detection and De-fragmentation Implementation
  • Multiple Log File Viewer (Linux Bash)
  • Solving MySQL slave lag Issues

最新留言

  • [21/08/16] jwang0189 於文章「祝福禱告文-為工作祝福...」留言:
    非常實用的文章,謝謝提供,已點廣告表示支持 https://...
  • [20/04/23] 廣利 於文章「祝福禱告文-為工作祝福...」留言:
    129:8 過路的也不說,願耶和華所賜的福,歸於你們;我們在...
  • [17/10/30] 66國語言翻譯公司 於文章「Download Google Chro...」留言:
    不了走會點中見你隻有果新家而去十走相隻把見作樣 95國...
  • [17/05/06] 50國語言翻譯公司 於文章「Python >>> a, b = b...」留言:
    之的不會然文道果三那大這年來來年物月用理學, 115國...
  • [16/10/13] KK 於文章「How to Change Defaul...」留言:
    感謝您分享的工作禱詞! 真的太感謝了!! 願 平安...
  • [15/08/23] 洪秀柱 於文章「如何在UltraEdit中正常顯示韓文?...」留言:
    此破解法可用於 UEstudio UltraEdit V2...

動態訂閱

文章精選

文章搜尋

誰來我家

參觀人氣

  • 本日人氣:
  • 累積人氣:

留言板