01 2017 档案

sqlite 去重
摘要：lst = ['DTS2323','DTS2343','DTS123']con = sqlite3.connect(db)sql1 = ' delete from alpm_dtsinfo where rowid not in(select max(rowid) from alpm_dtsinfo 阅读全文
posted @ 2017-01-18 20:52 aloneOnWorld 阅读(1932) 评论(0) 推荐(0) 编辑
Django 使用原生SQL
摘要：def dictfetchall(cursor): "将游标返回的结果保存到一个字典对象中" desc = cursor.description return [ dict(zip([col[0] for col in desc], row)) for row in cursor.fetchall( 阅读全文
posted @ 2017-01-09 00:51 aloneOnWorld 阅读(1210) 评论(0) 推荐(0) 编辑