Using Database with Python -Basic Structured Query Language-Email Database Demo
来源:互联网 发布:3d打印技术编程教程 编辑:程序博客网 时间:2024/06/14 19:00
import sqlite3
conn = sqlite3.connect('emaildb.sqlite')
cur = conn.cursor()
cur.execute('''
DROP TABLE IF EXISTS Counts''')
cur.execute('''
CREATE TABLE Counts (org TEXT, count INTEGER)''')
fname = raw_input('Enter file name: ')
if ( len(fname) < 1 ) : fname = '3.txt'
fh = open(fname)
for line in fh:
if not line.startswith('From: ') : continue
pieces = line.split()
email = pieces[1]
orgg=email.split('@')
org=orgg[1]
print org
cur.execute('SELECT count FROM Counts WHERE org = ? ', (org, ))
row = cur.fetchone()
if row is None:
cur.execute('''INSERT INTO Counts (org, count)
VALUES ( ?, 1 )''', ( org, ) )
else :
cur.execute('UPDATE Counts SET count=count+1 WHERE org = ?',
(org, ))
conn.commit()
sqlstr = 'SELECT org, count FROM Counts ORDER BY count DESC LIMIT 10'
print
print "Counts:"
ls1=list()
ls2=list()
for row in cur.execute(sqlstr) :
print str(row[0]), row[1]
conn = sqlite3.connect('emaildb.sqlite')
cur = conn.cursor()
cur.execute('''
DROP TABLE IF EXISTS Counts''')
cur.execute('''
CREATE TABLE Counts (org TEXT, count INTEGER)''')
fname = raw_input('Enter file name: ')
if ( len(fname) < 1 ) : fname = '3.txt'
fh = open(fname)
for line in fh:
if not line.startswith('From: ') : continue
pieces = line.split()
email = pieces[1]
orgg=email.split('@')
org=orgg[1]
print org
cur.execute('SELECT count FROM Counts WHERE org = ? ', (org, ))
row = cur.fetchone()
if row is None:
cur.execute('''INSERT INTO Counts (org, count)
VALUES ( ?, 1 )''', ( org, ) )
else :
cur.execute('UPDATE Counts SET count=count+1 WHERE org = ?',
(org, ))
conn.commit()
sqlstr = 'SELECT org, count FROM Counts ORDER BY count DESC LIMIT 10'
print "Counts:"
ls1=list()
ls2=list()
for row in cur.execute(sqlstr) :
print str(row[0]), row[1]
cur.close()
输出结果为
Counts:
iupui.edu 536
umich.edu 491
indiana.edu 178
caret.cam.ac.uk 157
vt.edu 110
uct.ac.za 96
media.berkeley.edu 56
ufp.pt 28
gmail.com 25
et.gatech.edu 17
0 0
- Using Database with Python -Basic Structured Query Language-Email Database Demo
- Structured Query Language (SQL)
- Structured Query Language
- Using Database Transactions with JDBC
- Using Databases with Python -Musical Track Database (produce database from XML file)
- SQL语法 (Structured Query Language)
- Communicating with the Database (Using ADO)
- Using a MySQL Database with C++
- Using Zend Framework with Mutil Database
- Using the data layer API to query your Kentico database
- Using Databases with Python - Many students in many courses (produce database from json file)
- android database SQL language
- SQLServer(Structured Query Language) 2000简介
- 结构化查询语言(Structured Query Language)
- SQL(Structured Query Language)学习笔记
- SQL 函数 笔记((Structured Query Language)
- Database Access with Visual Basic .NET, Third Edition
- AOL Seach query database
- C语言
- java 监听实现办法
- 最新版本: V1.2 , build 1210
- hadoop分布式集群部署步骤总结
- hdu2191 悼念512汶川大地震遇难同胞——珍惜现在,感恩生活 --多重背包
- Using Database with Python -Basic Structured Query Language-Email Database Demo
- ssh批量登录机器并返回命令的执行结果
- 自白
- HDFS的读写限流方案
- java成神之路
- Android ListView 侧滑效果实现(滑动展开、滑动删除)
- memcached 命中率
- ListView嵌套EditText导致软键盘闪退的问题
- 码农小汪-解决java compiler level does not match the version of the installed java project facet