https://blog.liuts.com/index.php zh-cn https://blog.liuts.com/post// root <admin@yourname.com> Sat, 22 Sep 2007 07:36:58 +0000 https://blog.liuts.com/post// dbconfig.py
# -*- coding: utf-8 -*- from django.conf import settings import sqlalchemy from sqlalchemy.engine.url import URL __all__ = ['metadata'] def create_engine():     url = URL(drivername=settings.DATABASE_ENGINE,               database=settings.DATABASE_NAME,               username=settings.DATABASE_USER,               password=settings.DATABASE_PASSWORD,               host=settings.DATABASE_HOST,               port=settings.DATABASE_PORT or None,               query = getattr(settings, 'DATABASE_OPTIONS', {})               )     options = getattr(settings, 'SQLALCHEMY_OPTIONS', {})     engine = sqlalchemy.create_engine(url, **options)     return engine metadata = sqlalchemy.MetaData(create_engine())
urls.py
from django.conf.urls.defaults import * urlpatterns = patterns('servperf.serlist.views',     (r'^list/(?P<list_type>(\d|\.){10,15})?$', 'Readlist'),     (r'^list/?$', 'Readlist',{'list_type': 'listall'}),     (r'^diskio/?$', 'Readlist', {'list_type': 'diskio_data'}),     (r'^diskspace/$', 'Readlist', {'list_type': 'diskspace_data'}),     (r'^loadavg/$', 'Readlist', {'list_type': 'loadavg_data'}),     (r'^mem/$', 'Readlist', {'list_type': 'mem_data'}),     (r'^net/$', 'Readlist', {'list_type':'net_data'}),     # Uncomment this for admin:, {'list_type': 'net'}     (r'^admin/', include('django.contrib.admin.urls')), )
models.py
# Create your models here. from sqlalchemy import * from servperf.dbconfig import metadata diskio_data = Table('diskio_data', metadata,                   Column('ID', Integer, primary_key=True),                   Column('LAN', char(15), nullable=False),                   Column('WAN', char(15), nullable=False),                   Column('CONTENTS', varchar(225), nullable=False),                   Column('DATETIME', datetime, nullable=False),                   mysql_engine='InnoDB'
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})
Tags - django , sqlalchemy ]]> https://blog.liuts.com/post//#blogcomment <user@domain.com> Thu, 01 Jan 1970 00:00:00 +0000 https://blog.liuts.com/post//#blogcomment