一、开发环境配置

1、开发环境

python2.7
需要的包：MySQL_python\PIL
Django1.4

安装nginx 静态文件路径改为：http://static.lsapp.com, 具体见settings文件的改动

nginx配置:


server {
    listen       80;
    server_name static.lsapp.com;

    location / {
        root   /workspace/myhome/static; #你的项目路径下的static目录
        index  index.html index.htm;
    }
}

本地host绑定 127.0.0.1 static.lsapp.com

安装sae本地开发包
```
$ git clone http://github.com/saepython/saepythondevguide.git
$ cd saepythondevguide/dev_server
$ python setup.py install
```
*一般情况下不需要用sae开发环境。但代码中有import，不安装可能会导致页面错误。

2、配置过程

下载项目到本地（废话）
编辑myhome/settings.py, 修改数据库链接等参数
在项目目录下，执行 ./cleardb (windows下执行cleardb.bat)
启动项目：python manage.py runserver 127.0.0.1:8000 --noreload

数据库更新：

1.2012-05-09 Document：


  source_updated_at=models.DateTimeField(u'原文章最后更新时间', default=datetime.now(),db_index=True)

  ALTER TABLE  `ls_document` ADD  `source_updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER  `topic_id` ,
  ADD INDEX (  `source_updated_at` )

2.添加数据表：用于记录收录过的来源站点document信息。 cron_documentmapping


CREATE TABLE `cron_documentmapping` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `document_id` bigint(20) NOT NULL,
  `source_document_id` bigint(20) NOT NULL,
  `source_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

3.添加数据库表：用户记录每个分类下相应的作者uid和name,有初始化数据cron-0509.json cron_categoryauthor


CREATE TABLE `cron_categoryauthor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` bigint(20) NOT NULL,
  `authorName` varchar(256) COLLATE utf8_bin NOT NULL,
  `cid` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=512 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

4.Topic，添加last_reply_at


ALTER TABLE  `ls_topic` ADD  `last_reply_at` DATETIME NULL AFTER  `reply_count` ,
ADD INDEX (  `last_reply_at` );
update ls_topic set last_reply_at=updated_at;

5.2013-5-17 Topic,TopicReply，扩展content长度


alter table ls_topic change content content mediumtext null;
alter table ls_topicreply change content content mediumtext null;

5.2013-5-19 User,添加bind字段


ALTER TABLE  `base_user` ADD  `email_bind` tinyint(1)  default 0 not NULL AFTER  `email`;
ALTER TABLE  `base_user` ADD  `is_bind` tinyint(1)  default 0 not NULL AFTER  `is_active`;

6.2013-5-21 base.EmailBindRecord


CREATE TABLE `base_emailbindrecord` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `created_at` datetime NOT NULL,
    `updated_at` datetime NOT NULL,
    `userid` integer NOT NULL,
    `email` varchar(75) NOT NULL,
    `active_code` varchar(128) NOT NULL,
    `is_used` bool NOT NULL
)
;
CREATE INDEX `base_emailbindrecord_3b1c9c31` ON `base_emailbindrecord` (`created_at`);
CREATE INDEX `base_emailbindrecord_f84f7de6` ON `base_emailbindrecord` (`updated_at`);
CREATE INDEX `base_emailbindrecord_7444f637` ON `base_emailbindrecord` (`userid`);
COMMIT;

5.2013-5-24 TopicReply,添加is_chapter字段


ALTER TABLE  `ls_topicreply` ADD  `is_chapter` tinyint(1)  default 0 not NULL ;
ALTER TABLE  `ls_topicreply` ADD   `source_url` varchar(200) default  NULL;

6.2013-5-27 Document，添加source_tid


ALTER TABLE  `ls_document` ADD  `source_tid` bigint NOT NULL default 0;

7.2013-5-31 TopicReply ，添加索引


CREATE INDEX `ls_topicreply_27d438ea` ON `ls_topicreply` (`topicid`, `is_chapter`);

8.2013-6-2 TopicReply ，添加字段


alter table `ls_document` ADD  `source_uid` bigint NOT NULL default 0;
ALTER TABLE  `ls_topicreply` ADD  `source_pid` bigint NOT NULL default 0;
alter table `ls_topicreply` change  `source_url` `source_url` varchar(200);

9.2013-6-16 Document


alter table ls_document add column `source_cover_img` varchar(200);

10.2013-06-29 保存大人列表



CREATE TABLE `sync_source_author` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `created_at` datetime NOT NULL,
    `updated_at` datetime NOT NULL,
    `uid` bigint NOT NULL,
    `username` varchar(100) NOT NULL,
    `desc` varchar(1000) NOT NULL,
    `site_id` integer NOT NULL
)
;
CREATE INDEX `sync_source_author_96511a37` ON `sync_source_author` (`created_at`
);
CREATE INDEX `sync_source_author_a11a40ab` ON `sync_source_author` (`updated_at`
);
CREATE INDEX `sync_source_author_82ae9392` ON `sync_source_author` (`uid`);
CREATE INDEX `sync_source_author_66fec48f` ON `sync_source_author` (`site_id`);
CREATE INDEX `sync_source_author_47b71727` ON `sync_source_author` (`uid`, `site_id`);

11.2013-07-04 在User表添加了用户信息，另外添加了version表


alter table base_user add column `mobile` varchar(30) UNIQUE;
alter table base_user add column `mobile_bind` bool NOT NULL;
alter table base_user add column `reg_source` smallint NOT NULL;

alter table `base_user` ADD  `mobile` varchar(30) UNIQUE;
alter table `base_user` ADD  `mobile_bind` bool NOT NULL;
alter table `base_user` ADD  `reg_source` smallint NOT NULL;

CREATE TABLE `lsapp_version` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `version` varchar(30) UNIQUE not null,
    `desc` varchar(200),
    `created_at` timestamp NOT NULL default CURRENT_TIMESTAMP
);
insert into `lsapp_version` (`version`,`desc`) values('2013-07-04','add mobile and reg_source for user');

CREATE TABLE `ls_bookmark` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `created_at` datetime NOT NULL,
    `updated_at` datetime NOT NULL,
    `uid` integer NOT NULL,
    `tid` integer NOT NULL,
    `rid` integer NOT NULL,
    `title1` varchar(255) NOT NULL,
    `title2` varchar(255) NOT NULL
);
CREATE INDEX `ls_bookmark_96511a37` ON `ls_bookmark` (`created_at`);
CREATE INDEX `ls_bookmark_a11a40ab` ON `ls_bookmark` (`updated_at`);
CREATE INDEX `ls_bookmark_82ae9392` ON `ls_bookmark` (`uid`);

20130707


CREATE TABLE `ls_comment` (
`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
`status` integer NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`uid` integer NOT NULL,
`username` varchar(256) NOT NULL,
`topicid` integer NOT NULL,
`replyid` integer NOT NULL,
`content` longtext NOT NULL,
`source_uid` integer NOT NULL
)
;
CREATE INDEX `ls_comment_48fb58bb` ON `ls_comment` (`status`);
CREATE INDEX `ls_comment_96511a37` ON `ls_comment` (`created_at`);
CREATE INDEX `ls_comment_a11a40ab` ON `ls_comment` (`updated_at`);
CREATE INDEX `ls_comment_a9db1261` ON `ls_comment` (`topicid`);
CREATE INDEX `ls_comment_7cc7297e` ON `ls_comment` (`replyid`);
insert into `lsapp_version` (`version`,`desc`) values('2013-07-07','add comment table');

20130707


CREATE TABLE `base_userloginlog` (
`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
`uid` integer NOT NULL,
`src` smallint NOT NULL,
`src_uuid` varchar(256),
`login_time` datetime NOT NULL,
`raw_pass` varchar(256),
`ip` varchar(20),
`port` smallint NOT NULL
);

CREATE INDEX base_userloginlog_82ae9392 ON base_userloginlog (uid); insert into lsapp_version (version,desc) values('2013-07-09','add login log table');

201307011


alter table `ls_comment` ADD  `source_id` bigint unique;
alter table `ls_comment` change `uid` `uid` bigint NOT NULL;
alter table `ls_comment` change `topicid` `topicid` bigint NOT NULL;
alter table `ls_comment` change `replyid` `replyid` bigint NOT NULL;
alter table `ls_comment` change `source_uid` `source_uid` bigint NOT NULL;
CREATE INDEX `ls_comment_48fb58cc` ON `ls_comment` (`source_id`);
insert into `lsapp_version` (`version`,`desc`) values('2013-07-11','add source rate id in comment table');

13.20130717


CREATE INDEX `ls_topicreply_topicid_source_pid_ea` ON `ls_topicreply` (`topicid`,`source_pid`);
insert into `lsapp_version` (`version`,`desc`) values('2013-07-17','index for ls_topicreply for performance');

dunsword / lsapp

readme

一、开发环境配置

1、开发环境

2、配置过程

数据库更新：