repo.or.cz
/
aur.git
/
blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
log
|
graphiclog1
|
graphiclog2
|
commit
|
commitdiff
|
tree
|
refs
|
edit
|
fork
blame
|
history
|
raw
|
HEAD
scripts: Do not use UNIX_TIMESTAMP
[aur.git]
/
scripts
/
pkgmaint.py
blob
3ad9ed8d5480712e7671145c4b85e2cdab5c43c7
1
#!/usr/bin/python3
2
3
import
time
4
5
import
aurweb
.
db
6
7
8
def
main
():
9
conn
=
aurweb
.
db
.
Connection
()
10
11
limit_to
=
int
(
time
.
time
()) -
86400
12
conn
.
execute
(
"DELETE FROM PackageBases WHERE "
+
13
"SubmittedTS < ? AND PackagerUID IS NULL"
, [
limit_to
])
14
15
conn
.
commit
()
16
conn
.
close
()
17
18
19
if
__name__
==
'__main__'
:
20
main
()