09-python-django一步一步(添加mysql数据库)

3.5  在settings中添加数据库

DATABASES = {

    'default': {

        'ENGINE': 'django.db.backends.mysql', # Add 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'.

        'NAME': 'serManager',                      # Or path to database file if using sqlite3.

        # The following settings are not used with sqlite3:

        'USER': 'root',

        'PASSWORD': '123456',

        'HOST': '',                      # Empty for localhost through domain sockets or '127.0.0.1' for localhost through TCP.

        'PORT': '',                      # Set to empty string for default.

    }

}

创建数据库

root@ubuntu:/opt/serManager/serManager# mysql -uroot -p123456

mysql> create database serManager default charset='utf8';

Query OK, 1 row affected (0.05 sec)

 

mysql>

3.6  设置settings加载静态文件

cp -frp bootstrap /opt/serManager/sshCMD/Templates/

root@ubuntu:/opt/serManager/serManager# vim settings.py

MEDIA_ROOT = '/opt/serManager/sshCMD/Templates/bootstrap/'

root@ubuntu:/opt/serManager/serManager# vim urls.py

from django.conf.urls import patterns, include, url

#add by hans 20130906

from sshCMD.views import index

from django.conf import settings

# Uncomment the next two lines to enable the admin:

# from django.contrib import admin

# admin.autodiscover()

 

urlpatterns = patterns('',

    # Examples:

    # url(r'^$', 'serManager.views.home', name='home'),

    # url(r'^serManager/', include('serManager.foo.urls')),

 

    # Uncomment the admin/doc line below to enable admin documentation:

    # url(r'^admin/doc/', include('django.contrib.admindocs.urls')),

 

    # Uncomment the next line to enable the admin:

    # url(r'^admin/', include(admin.site.urls)),

    (r'^$',index),

    (r'bootstrap/(?P.*)$','django.views.static.serve',{'document_root':settings.MEDIA_ROOT,}),

)

访问测试