一个Django与SQLAlchemy的小项目

root , 2007/09/22 15:36 , Python , 评论(0) , 阅读(7591) , Via 本站原创

dbconfig.py

urls.py

models.py

views.py

#coding=utf-8
# Create your views here.
from sqlalchemy import *
from sqlalchemy.sql import and_
from servperf.dbconfig import metadata
from servperf.serlist.models import diskio_data,loadavg_data,diskspace_data,mem_data,net_data
from django.shortcuts import render_to_response
def Readlist(request,list_type="listall"):
    pagesize = 6
    page = request.GET.get('page', None)
    _sqlc=[]
    _sqllist=[diskio_data.c.DATETIME==diskspace_data.c.DATETIME \
             ,diskio_data.c.DATETIME==loadavg_data.c.DATETIME \
             ,diskio_data.c.DATETIME==mem_data.c.DATETIME \
             ,diskio_data.c.DATETIME==net_data.c.DATETIME \
             ,diskio_data.c.WAN==diskspace_data.c.WAN \
             ,diskio_data.c.WAN==loadavg_data.c.WAN \
             ,diskio_data.c.WAN==mem_data.c.WAN \
             ,diskio_data.c.WAN==net_data.c.WAN \
             ]
    if len(str(list_type))>10:
        _sqlc.append(diskio_data.c.WAN==list_type)
        _sqllist.append(diskio_data.c.WAN==list_type)       
        _sqllist.append(diskspace_data.c.WAN==list_type)
        _sqllist.append(loadavg_data.c.WAN==list_type)
        _sqllist.append(mem_data.c.WAN==list_type)
        _sqllist.append(net_data.c.WAN==list_type)
    _rscount= select([func.count(diskio_data.c.LAN)], and_(*_sqlc)).execute()
    numrows = int(_rscount.fetchone()[0])
    pages=numrows / pagesize
    if numrows % pagesize:
        pages+=1
    if page==None:
       page=1
    offset=pagesize*(int(page)-1)
    previous=int(page)-1
    next=int(page)+1
    if next>pages:
       next=pages
    s= select([diskio_data.c.LAN,diskio_data.c.WAN,diskio_data.c.CONTENTS,loadavg_data.c.CONTENTS, \
                diskspace_data.c.CONTENTS,mem_data.c.CONTENTS,net_data.c.CONTENTS,diskio_data.c.DATETIME], \
                and_( *_sqllist )).order_by(diskio_data.c.DATETIME.desc()).offset(offset).limit(pagesize)
  
    rs = s.execute()
    row = rs.fetchall()
    rs.close()
    return render_to_response('serlist/serlist_list.html',{'myrows':row,'page':page,'pages':pages,'previous':previous,'next':next,'numrows':numrows,'list_type':list_type})