七日Python之路--第九天（blog与Django）

mysql> status
--------------
mysql  Ver 14.14 Distrib 5.5.38, for debian-linux-gnu (i686) using readline 6.2

Connection id:        36
Current database:    
Current user:        root@localhost
SSL:            Not in use
Current pager:        stdout
Using outfile:        ''
Using delimiter:    ;
Server version:        5.5.38-0ubuntu0.12.04.1 (Ubuntu)
Protocol version:    10
Connection:        Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    utf8
Conn.  characterset:    utf8
UNIX socket:        /var/run/mysqld/mysqld.sock
Uptime:            2 min 39 sec

在[client]节点下添加         
    default-character-set=utf8 
在[mysqld]节点下添加        
    character-set-server=utf8        
    collation-server=utf8_general_ci

root@dizzy-pc:/home/dizzy# service mysql restart
mysql stop/waiting
mysql start/running, process 3233

"""
Django settings for mysite project.

For more information on this file, see
https://docs.djangoproject.com/en/1.6/topics/settings/

For the full list of settings and their values, see
https://docs.djangoproject.com/en/1.6/ref/settings/
"""

# Build paths inside the project like this: os.path.join(BASE_DIR, ...)
import os
BASE_DIR = os.path.dirname(os.path.dirname(__file__))


# Quick-start development settings - unsuitable for production
# See https://docs.djangoproject.com/en/1.6/howto/deployment/checklist/

# SECURITY WARNING: keep the secret key used in production secret!
SECRET_KEY = '4@01u6jlly!dr*x&91$p@bqo4w(%0t0g8zp+6g9s650(&glpkv'

# SECURITY WARNING: don't run with debug turned on in production!
DEBUG = True

TEMPLATE_DEBUG = True

ALLOWED_HOSTS = []

# Application definition

INSTALLED_APPS = (
    'django.contrib.admin',
    'django.contrib.auth',
    'django.contrib.contenttypes',
    'django.contrib.sessions',
    'django.contrib.messages',
    'django.contrib.staticfiles',
    #add by dizzy in 2014-07-29 19:36:23
    'dlog',
)

MIDDLEWARE_CLASSES = (
    'django.contrib.sessions.middleware.SessionMiddleware',
    'django.middleware.common.CommonMiddleware',
    'django.middleware.csrf.CsrfViewMiddleware',
    'django.contrib.auth.middleware.AuthenticationMiddleware',
    'django.contrib.messages.middleware.MessageMiddleware',
    'django.middleware.clickjacking.XFrameOptionsMiddleware',
)

ROOT_URLCONF = 'mysite.urls'

WSGI_APPLICATION = 'mysite.wsgi.application'


# Database
# https://docs.djangoproject.com/en/1.6/ref/settings/#databases

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'dlog',
        'USER': 'root',
        'PASSWORD':'944898186',
        'HOST': 'localhost',
        'PORT': '3306',
    }
}

# Internationalization
# https://docs.djangoproject.com/en/1.6/topics/i18n/

LANGUAGE_CODE = 'zh-cn'

TIME_ZONE = 'Asia/Shanghai'

USE_I18N = True

USE_L10N = True

USE_TZ = True


# Static files (CSS, JavaScript, Images)
# https://docs.djangoproject.com/en/1.6/howto/static-files/

STATIC_URL = '/static/'

#coding=utf-8
from django.db import models

# Create your models here.

class BaseModel(models.Model):
    name = models.CharField(u'名称', max_length=20)
    crttime = models.DateTimeField(u'创建时间',auto_now_add=True)
    def __unicode__(self):
        return self.name

    class Meta:
        abstract=True

class Author(BaseModel):

    class Meta:
        db_table = 'dlog_author'
        verbose_name = u'作者'

class Theme(BsaeModel):

    class Meta:
        db_table = 'dlog_theme'
        verbose_name = u'主题'

class Tag(BaseModel):

    class Meta:
        db_table = 'dlog_tage'
        verbose_name = u'标签'

class Category(BaseModel):

    class Meta:
        db_table = 'dlog_category'
        verbose_name = u'分类'

class Article(BaseModel):
    title = models.CharField(u'标题', max_length=100)
    author = models.ForeignKey(Author, verbose_name=u'作者')
    theme = models.ForeignKey(Theme, verbose_name=u'主题')
    tags = models.ManyToManyField(Tag, blank=True, verbose_name=u'标签')
    category = models.ForeignKey(Category, verbose_name=u'分类')
    abstract = models.TextField(u'摘要')
    created_time = models.DateTimeField(u'创建时间', auto_now_add=True)
    updated_time = models.DateTimeField(u'修改时间', auto_now=True)
    content = models.TextField(u'正文')
    click_count = models.IntegerField(u'点击量', default=0, editable=False)
    comment_count = models.IntegerField(u'评论数',default=0, editable=False)
    def __unicode__(self):
        return self.title

    def click(self):
        pass

    class Meta:
        db_table = 'dlog_article'
        verbose_name = u'文章'

dizzy@dizzy-pc:~/dizzy/mysite$ ./manage.py sql dlog
BEGIN;
CREATE TABLE `dlog_author` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `name` varchar(20) NOT NULL,
    `crttime` datetime NOT NULL
)
;
CREATE TABLE `dlog_theme` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `name` varchar(20) NOT NULL,
    `crttime` datetime NOT NULL
)
;
CREATE TABLE `dlog_tage` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `name` varchar(20) NOT NULL,
    `crttime` datetime NOT NULL
)
;
CREATE TABLE `dlog_category` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `name` varchar(20) NOT NULL,
    `crttime` datetime NOT NULL
)
;
CREATE TABLE `dlog_article_tags` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `article_id` integer NOT NULL,
    `tag_id` integer NOT NULL,
    UNIQUE (`article_id`, `tag_id`)
)
;
ALTER TABLE `dlog_article_tags` ADD CONSTRAINT `tag_id_refs_id_e377ffd2` FOREIGN KEY (`tag_id`) REFERENCES `dlog_tage` (`id`);
CREATE TABLE `dlog_article` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `name` varchar(20) NOT NULL,
    `crttime` datetime NOT NULL,
    `title` varchar(100) NOT NULL,
    `author_id` integer NOT NULL,
    `theme_id` integer NOT NULL,
    `category_id` integer NOT NULL,
    `abstract` longtext NOT NULL,
    `createdtime` datetime NOT NULL,
    `updatedtime` datetime NOT NULL,
    `content` longtext NOT NULL,
    `click_count` integer NOT NULL,
    `comment_count` integer NOT NULL
)
;
ALTER TABLE `dlog_article` ADD CONSTRAINT `author_id_refs_id_c7985c8d` FOREIGN KEY (`author_id`) REFERENCES `dlog_author` (`id`);
ALTER TABLE `dlog_article` ADD CONSTRAINT `category_id_refs_id_b7340953` FOREIGN KEY (`category_id`) REFERENCES `dlog_category` (`id`);
ALTER TABLE `dlog_article` ADD CONSTRAINT `theme_id_refs_id_d135d084` FOREIGN KEY (`theme_id`) REFERENCES `dlog_theme` (`id`);
ALTER TABLE `dlog_article_tags` ADD CONSTRAINT `article_id_refs_id_61edf8a3` FOREIGN KEY (`article_id`) REFERENCES `dlog_article` (`id`);

COMMIT;

#coding=utf-8
from django.contrib import admin
from models import Article,Author,Theme,Tag,Category
# Register your models here.

class ArticleAdmin(admin.ModelAdmin):
    fields = ['title', 'author', 'abstract', 'theme', 'category',
              'content', 'tags']
    list_display = ['id','title', 'theme', 'category', 'tag_display',
                    'created_time', 'click_count', 'comment_count']
    list_editable = ['title','theme','category']
    list_filter = []
    list_display_links = ['id']
    search_fields = ['title']
    def tag_display(self, obj):
        return ','.join([tag.name for tag in obj.tags.all()])
    tag_display.short_description=u'标签'

class CAdmin(admin.ModelAdmin):
    fields = ['name']
    list_display = ['name', 'crttime']

admin.site.register(Article, ArticleAdmin)
admin.site.register([Author, Theme, Tag, Category],CAdmin)