English 中文(简体)
SQLite Python 查询: DESC不工作的命令?
原标题:SQLite Python Query: ORDER BY DESC not working?
  • 时间:2012-05-24 04:44:13
  •  标签:
  • python
  • sql
conn = sqlite3.connect( Path_To_DB.db )
c = conn.cursor() 
    c.execute( SELECT Nick,NumCount,TimesRun FROM databaseTable ORDER BY NumCount desc )
    ordered = c.fetchall()
    print ordered

当然,这只是一个片段 但印刷的"订货"没有出现... 嗯,订货。

更确切地说,这是我的输出

    [(u Coburn , u 52 , 1), (u radii , u 295 , 1), (u Senna_Wong , u 242 , 1), (u sinkingwork , u 17 , 1), (u Yumirose , u 164 , 1), (u yepperoni , u 154 , 1), (u Jeffrey-sama , 861, 2), (u Kethsar , 414, 5), (u sakeisgood , 331, 2), (u lygerzero0zero , 269, 2), (u asdfjjjjjj , 268, 5), (u lunr , 253, 3), (u asdfasf , 237, 2), (u asdfsadjf , 130, 2), (u Neibs , 107, 2)]

它是一个 XChat IRC 插件脚本, 所以我需要提取数据库值来显示一个“ 顶点” 列表。 我一直在考虑手动排序它, 但是这需要很多额外的努力, 自从我新到 Python 脚本, 很多时间和研究也。 (我在考虑单独抓取 SELECT 查询, 把它们合并成一个大列表 [a, b, c], 并通过这个排序 。 )

总之,问题是: 我到底做错什么了? 所以计算不正确?

问题回答

其中一半是字符串, 类型不同 。 擦拭数据, 将字符串转换为数字 。

问题在于您有不同的数据类型 。 看看他 NumCount 字段, 能看到引号符号周围的一些而不是其它的吗? 我认为如果你把所有字符串都改成数字, 您将会解决麻烦 。





相关问题
Can Django models use MySQL functions?

Is there a way to force Django models to pass a field to a MySQL function every time the model data is read or loaded? To clarify what I mean in SQL, I want the Django model to produce something like ...

An enterprise scheduler for python (like quartz)

I am looking for an enterprise tasks scheduler for python, like quartz is for Java. Requirements: Persistent: if the process restarts or the machine restarts, then all the jobs must stay there and ...

How to remove unique, then duplicate dictionaries in a list?

Given the following list that contains some duplicate and some unique dictionaries, what is the best method to remove unique dictionaries first, then reduce the duplicate dictionaries to single ...

What is suggested seed value to use with random.seed()?

Simple enough question: I m using python random module to generate random integers. I want to know what is the suggested value to use with the random.seed() function? Currently I am letting this ...

How can I make the PyDev editor selectively ignore errors?

I m using PyDev under Eclipse to write some Jython code. I ve got numerous instances where I need to do something like this: import com.work.project.component.client.Interface.ISubInterface as ...

How do I profile `paster serve` s startup time?

Python s paster serve app.ini is taking longer than I would like to be ready for the first request. I know how to profile requests with middleware, but how do I profile the initialization time? I ...

Pragmatically adding give-aways/freebies to an online store

Our business currently has an online store and recently we ve been offering free specials to our customers. Right now, we simply display the special and give the buyer a notice stating we will add the ...

Converting Dictionary to List? [duplicate]

I m trying to convert a Python dictionary into a Python list, in order to perform some calculations. #My dictionary dict = {} dict[ Capital ]="London" dict[ Food ]="Fish&Chips" dict[ 2012 ]="...

热门标签