Hi,
Just read your email while I was coding something very similar. I am
running 0.99.1 and you can get what you need by querying sbmSUBMISSIONS
table.
mysql> desc sbmSUBMISSIONS;
+-----------+-------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------------------+-------+
| email | varchar(50) | NO | | | |
| doctype | varchar(10) | NO | | | |
| action | varchar(10) | NO | | | |
| status | varchar(10) | NO | | | |
| id | varchar(30) | NO | | | |
| reference | varchar(40) | NO | | | |
| cd | datetime | NO | | 0000-00-00 00:00:00 | |
| md | datetime | NO | | 0000-00-00 00:00:00 | |
+-----------+-------------+------+-----+---------------------+-------+
8 rows in set (0.00 sec)
A sample function to return the last 'cuantos' submissions:
def consultaUltimosEnvios(cuantos):
# consulta la lista de ultimos envios (SBI)
from invenio.dbquery import run_sql
query = "SELECT id, doctype, email, md, reference FROM sbmSUBMISSIONS WHERE
action='SBI' AND status='finished' ORDER BY md DESC LIMIT %s" %cuantos
res = run_sql(query)
for i in res:
print i[3],"\t[",i[0],"]\tdoctype:",i[1],"\tRef:",i[4],"\tPor",i[2]
Hope this helps to get you started :-)
Cheers!
Miguel
---
Miguel Martín
www.leccionespracticas.com
El 08/10/13 14:23, [email protected] escribió:
Hi,
I'm trying to write an SQL query to show all the documents submitted
by a user (not necessarily the currently logged in user.) What I
actually want is to show the total disk usage of each user, but if I
can just get a list of the documents submitted, given either a user id
or email, I should be able to take it from there. Is there
documentation out there to describe all the tables in the invenio db?
Thanks in advance,
Huw
--
Scanned by iCritical.
