Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Python°²×°MySQLDbÄ£¿éµÄÖÖÖÖÎÊÌâ¼°½â¾ö


ÎҵĻ·¾³ÊÇ£ºLinux version 2.4.21-4.EL
(bhcompile@daffy.perf.redhat.com) (gcc version 3.2.3 20030502 (Red Hat
Linux 3.2.3-20)) #1 Fri Oct 3 18:13:58 EDT 2003 + Python2.6.4
±¾ÎĽáºÏÎÒ°²×°Ê±ºòµÄÎÊÌ⣬×Ü½á¶ø³É
Óû§Ä¿Â¼Èç/home/liuguanyu/ , ±£Ö¤Óû§ÓÐrootȨÏÞ
1£¬¿´¿´ÓÐûÓа²×°
   ½øÈëpythonµÄÃüÁîÐУ¬ÊäÈë import MySQLdb Èç¹ûûÓб¨´í£¬Ö¤Ã÷´ËÄ£¿éÒѾ­°²×°£¬¿ÉÒÔÌø¹ýÒÔϲ½Öè¡£
2£¬Çл»µ½Óû§Ä¿Â¼/home/liuguanyu,È¥ÏÂÔØ×îеÄMySQLdb°²×°°ü£ºÎÒÏÂÔØµÄÊÇMySQL-python-1.2.3c1.tar.gz ¡£ÕâÒ»²½ËùÓÐÃüÁÈçÏ£º
   wget -O python-1.2.3c1.tar.gz  http://cdnetworks-kr-1.dl.sourceforge.net/project/mysql-python/mysql-python-test/1.2.3c1/MySQL-python-1.2.3c1.tar.gz
   tar xzvf python-1.2.3c1.tar.gz  
   cd MySQL-python-1.2.3c1
   python setup.py build
3£¬³öÏÖ±¨´í£ºImportError: No module named setuptools
4£¬»Øµ½Óû§Ä¿Â¼/home/liuguanyu£¬°²×°setuptools£¬ÎÒ°²×°µÄÊÇsetuptools-0.6c8 ,ÕâÒ»²½µÄËùÓÐÃüÁÈçÏ£º
   wget -O setuptools-0.6c8.tar.gz  http://pypi.python.org/packages/source/s/setuptools/setuptools-0.6c8.tar.gz
   tar xzvf setuptools-0.6c8.tar.gz
   cd setuptools-0.6c8
   python setup.py build
   sudo python setup.py install
5£¬»Øµ½Óû§MySQLdbÔ´ÂëĿ¼
6£¬ÔËÐÐ python setup.py build
7£¬±¨´í£ºmysql_config not found
8£¬ÉÏÒ»²½±¨´íÒòΪmysql_configÃüÁîûÓÐÕÒµ½¡£
9£¬Ê¹ÓÃwhereis mysqlÃüÁîÕÒµ½mysql°²×°Ä¿Â¼£¬¼ÙÉèmysql°²×°ÔÚ/usr/local/mysql
10, »Øµ½MySQLdbÔ´ÂëĿ¼.
11, vi setup_posix.py »ò vim
setup_posix.py´ò¿ªÅäÖÃÎļþ¡£´Ëʱ£¬ÕÒµ½mysql_config.path
Ò»ÐУ¬°Ñ·¾¶Ç°Ãæ¼ÓÉϵÚ9²½µÄmysql°²×°Â·¾¶£¬binĿ¼¡£¼´mysql_config.path =
"/usr/local/mysql/bin/mysql_config"
12, ÔÙ´ÎÔËÐРpython setup.py build
13, ±¨´í /usr/bin/ld: cannot find -lmysqlclient_r
14, Çл»µ½rootÓû§£¬Ö´ÐÐ
    echo "/usr/local/mysql/lib/mysql" >> /etc/ld.so.conf
#ÇëÖ÷ÒâÕâ¸ö/etc/ld.so.conf£¬Õâ¸öÊÇldµÄĬÈÏÅäÖÃÎÄ


Ïà¹ØÎĵµ£º

Python ʹÓÃC´úÂë——swig

Ref : http://www.swig.org/translations/chinese/tutorial.html
¼ÙÉèÄãÓÐһЩcÄãÏëÔÙ¼ÓPython.¡£¾ÙÀýÀ´ËµÓÐÕâôһ¸öÎļþexample.c
 /* File : example.c */
 #include <time.h>
 double My_variable = 3.0;
 int fact(int n) {
     if (n <= 1) return 1;
&nbs ......

Python Ïß³Ìͬ²½

¶à¸öÖ´ÐÐÏ߳̾­³£Òª¹²ÏíÊý¾Ý£¬Èç¹û½ö½ö¶ÁÈ¡¹²ÏíÊý¾Ý»¹ºÃ£¬µ«ÊÇÈç¹û¶à¸öÏß³ÌÒªÐ޸Ĺ²ÏíÊý¾ÝµÄ»°¾Í¿ÉÄܳöÏÖÎÞ·¨Ô¤ÁϵĽá¹û¡£
    ¼ÙÈçÁ½¸öÏ̶߳ÔÏót1
ºÍt2
¶¼Òª¶ÔÊýÖµnum=0
½øÐÐÔö1ÔËË㣬ÄÇôt1
ºÍt2
¶¼¸÷¶Ônum
ÐÞ¸Ä10
´ÎµÄ»°£¬ÄÇônum
×îÖյĽá¹ûÓ¦¸ÃΪ20
¡£µ«ÊÇÈç¹ûµ±t1
È¡µÃnum
µÄֵʱ£¨¼ÙÈç´Ë ......

Python Ïß³Ìͬ²½¶ÓÁÐ

ÎÒÃǾ­³£»á²ÉÓÃÉú²úÕß/Ïû·ÑÕß¹ØÏµµÄÁ½¸öÏß³ÌÀ´´¦ÀíÒ»¸ö¹²Ïí»º³åÇøµÄÊý¾Ý¡£ÀýÈçÒ»¸öÉú²úÕßÏ߳̽ÓÊÜÓû§Êý¾Ý·ÅÈëÒ»¸ö¹²Ïí»º³åÇøÀµÈ´ýÒ»¸öÏû·ÑÕßÏß
³Ì¶ÔÊý¾ÝÈ¡³ö´¦Àí¡£µ«ÊÇÈç¹û»º³åÇøµÄ̫С¶øÉú²úÕߺÍÏû·ÑÕßÁ½¸öÒì²½Ï̵߳ÄËٶȲ»Í¬Ê±£¬ÈÝÒ׳öÏÖÒ»¸öÏ̵߳ȴýÁíÒ»¸öÇé¿ö¡£ÎªÁ˾¡¿ÉÄܵÄËõ¶Ì¹²Ïí×ÊÔ´²¢ÒÔÏàͬ
Ëٶȹ¤×÷µÄ¸÷Ïß³ ......

python×ÖµäÅÅÐò

python×ÖµäÅÅÐò
1¡¢ 
×¼±¸ÖªÊ¶£º
ÔÚpythonÀ×ÖµädictionaryÊÇÄÚÖõÄÊý¾ÝÀàÐÍ£¬ÊǸöÎÞÐòµÄ´æ´¢½á¹¹£¬Ã¿Ò»ÔªËØÊÇkey-value¶Ô£º
È磺dict = {‘username’£º‘password’£¬‘database’£º‘master’}£¬ÆäÖБusername’ºÍ& ......

Python ×ÖµäʹÓÃÀý×Ó


#!/usr/bin/env python
#coding=utf-8
def buildConnectionString(params):
    return ":".join(["%s=%s" %(k, v) for k, v in params.items()])
if __name__ == "__main__":
    myParams = {"server":"mpilgrim", \
               &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ