python 培训之Django

1.Install

sudo apt-get install python-pip
sudo pip install django==1.8

2. Create Project

django-admin startproject projname

3. Create App

cd prjname
python manage.py startapp appname

4. Center URL&&setting

Control center in projname/projname/
##url config
Url Pattern setting
url(r^$,include('tcmwebapp.urls')),
url(r'^tcmwebapp',include('tcmwebapp.urls')),
## static url setting
urlpatterns += static(settings.MEDIA_URL, document_root=settings.MEDIA_ROOT)

urlpatterns += static(settings.STATIC_URL, document_root=settings.STATIC_ROOT)

## setting config
INSTALL APP( appname )

5. app urls&&view,

## url config
cd appname/
touch urls.py
url(r'xxx',views.fucname,name=XXX)
### views.py
def fucname():
      return HttpResponse("helloworld")
cd projname/
python manage.py runserver 9080
(tip:0.0.0.0:9080)
chrome localhost:8090
### helloworld

6. Global Config

cd projname/
mkdir static
mkdir templates
cd appname/
mkdir static/appname
mkdir templates/appname

7. static&templates&setting AutoTool: djangobower

7.1 Install.

sudo apt-get install python-software-properties
sudo apt-get install node
sudo apt-get install nodejs
sudo apt-get install npm
sudo apt-get install git
curl -SL http://deb
.nodesource.com/setup_6.x | sudo -E bash -
sudo apt-get install nodejs-legacy
sudo npm install -g bower
sudo pip install django-bower

7.2 Config

http://django-bower.readthedocs.io/en/latest/index.html 
import os

PROJECT_ROOT = os.path.abspath(
    os.path.join(os.path.dirname(__file__), ".."),
)

DEBUG = True
TEMPLATE_DEBUG = DEBUG

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': 'db',
        'USER': '',
        'PASSWORD': '',
        'HOST': '',
        'PORT': '',
    }
}

STATIC_ROOT = os.path.join(PROJECT_ROOT, 'static')

STATIC_URL = '/static/'

BOWER_COMPONENTS_ROOT = os.path.join(PROJECT_ROOT, 'components')

STATICFILES_FINDERS = (
    'django.contrib.staticfiles.finders.FileSystemFinder',
    'django.contrib.staticfiles.finders.AppDirectoriesFinder',
    'djangobower.finders.BowerFinder',
)

SECRET_KEY = 'g^i##va1ewa5d-rw-mevzvx2^udt63@!xu$-&di^19t)5rbm!5'

TEMPLATE_LOADERS = (
    'django.template.loaders.filesystem.Loader',
    'django.template.loaders.app_directories.Loader',
)

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

ROOT_URLCONF = 'example.urls'

WSGI_APPLICATION = 'example.wsgi.application'

TEMPLATE_DIRS = (
    os.path.join(PROJECT_ROOT, 'templates'),
)

INSTALLED_APPS = (
    'django.contrib.staticfiles',
    'djangobower',
)

BOWER_INSTALLED_APPS = (
    'jquery',
    'underscore',
)

7.2 Use

python manage.py bower_install 
python manage.py collectstatic
Change projname center UrlConfig
urlpattern += (settings.STATIC_URL,name=settings.STATIC_Document)
urlpattern +=(settings.MEDIA_URL,name=settings.MEDIA_Document)

8. Design Web Templates

8.1 View distrubution

python manage.py makemigrations
python manage.py migrate
### update database

8.2 create html

8.2.1 base.html

projectname/templates/base.html
<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE    =edge">
        <meta name="viewport" content = "width=device-width,initial-scale=1">
        <title>
        {% block title %}WebNet{% endblock %} 
        </title>
        {% load staticfiles %}
        <link rel="stylesheet" href={% static 'bootstrap/dist/css/bootstrap.css' %}>
        <script src={% static 'jquery/dist/jquery.min.js' %}></script>
        <script src={% static 'bootstrap/dist/js/bootstrap.min.js' %}></script>
        {% block head %}
        {% endblock %}
    </head>
    <body>
    {% block body %}
    {% endblock %}
    <div class="scripts">
        {% block scripts %}
        {% endblock %}
    </div>
    </body>
</html>

8.2.3 user_base.html

{% extends "base.html" %}
{% load staticfiles %}
    {% block head %}
<!--     <link rel="stylesheet" href={% static 'usercenter/css/style.css' %}>
 -->    {% endblock %}
{% block scripts %}  
{% endblock %}

8.3.4 web html

{% extends "netapp/base_netapp.html" %}
{% block body %}
<link href="/static/netapp/css/search.css" rel="stylesheet">

<section class="content">
    <div class="container-fluid">
        <div class="form">
            <div class="form-title">心脏毒性网络</div>
            <div class="form-body">
                <form  class="navbar-form" action="/netapp/search" method="post" role="search"> {% csrf_token %}
                    <table>
                        <input type="text" class="form-control" name="chem_name" size="60" maxlength="60" placeholder="Chemical Name">
                        <button type="submit" class="btn btn-danger navbar-btn">Submit</button>
                    </table>
                </form>
            </div>
        </div>
    </div>
</section>
{% endblock %}
{% block scripts %}
<!-- <script src = "/static/usercenter/js/userApp.js"></script> -->
{% endblock %}

8.3.5 css add

.form{
    margin-top: 150px;
    margin-right: 10px;
    margin-left: 10px;
    text-align: center;
}

.form-title{
  font-weight:bold;
  font-family:arial,verdana,sans-serif;
  font-size:18px;
}

9. Design View

from django.shortcuts import render
from django.http import HttpResponse
from tasks import chem_gene_query
# Create your views here.
def index(request):
    return render(request,"netapp/index.html")

def search(request):
    if request.method == "POST":
        message = request.POST["chem_name"]
        result = chem_gene_query(message)
        return render(request,"netapp/result.html",{"result":result})
    return render(request,"netapp/index.html")

10. add scripts in project

#!/usr/bin/env/python
# -*- coding:UTF-8 -*-
from __future__ import print_function
import MySQLdb
import sys


def mysql_connect():
    try:
        conn = MySQLdb.connect(host="localhost",user="tcd_net",
            passwd='tcd_net',db='ctd_net',port=3306,charset='utf8')
        cur = conn.cursor()
        return conn,cur
    except MySQLdb.Error,e:
        print(e.args)
        sys.exit(1)

def query_db(conn,cursor,command):
    try:
        cursor.execute(command)
        conn.commit()
        results = cursor.fetchall()
        return results
    except MySQLdb.Error,e:
        print(e.args)
        sys.exit(1)

def chem_gene_query(chem):
    conn,cur = mysql_connect()
    query_command = """select chemicalName,chemicalID,casId,
                    genesymbol,geneid,geneforms,organism,organismid,interaction,
                    interactionActions,pubmedid from chem_gene where chemicalName = "%s";"""%chem
    chem_gene_result = query_db(conn,cur,query_command)
    result = []
    keys = ["chemicalName","chemicalID","casId","genesymbol",
            "geneid","geneforms","organism","organismid",
            "interaction","interactionActions","pubmedid"]
    for res in chem_gene_result:
        out = {}
        for i in range(len(res)):
            out[keys[i]] = res[i]
        if out:
            result.append(out)
    return result

11. Design results Display

{% extends "netapp/base_netapp.html" %}
{% block body %}
<link href="/static/netapp/css/search.css" rel="stylesheet">

<section class="content">
    <div class="container-fluid">
         <table class="table table-bordered table-condensed">
               <caption>SearchResults</caption>
               <thead>
            <tr>
             <th>chemicalName</th>
             <th>genesymbol</th>
             <th>interactionActions</th>
             <th>pubmedid</th>
            </tr>
               </thead>
               {% for i in result %}
               <tbody>
                <tr>
                 <td>{{ i.chemicalName }}</td>
                 <td>{{ i.genesymbol }}</td>
                 <td>{{ i.interactionActions }}</td>
                 <td>{{ i.pubmedid }}</td>
                </tr>
               </tbody>
               {% endfor %}
        </table>
     </div>
</section>
{% endblock %}
{% block scripts %}
<!-- <script src = "/static/usercenter/js/userApp.js"></script> -->
{% endblock %}