0
|
1 |
#!/usr/bin/python
|
|
2 |
# -*- coding: utf-8 -*-
|
|
3 |
|
|
4 |
import MySQLdb,sys
|
|
5 |
|
|
6 |
database = 'lingvigilo'
|
|
7 |
dbuser = 'lingvigilouser'
|
|
8 |
dbpass = 'carrinclo'
|
|
9 |
dbtable = 'frazoj_ru_ca'
|
|
10 |
|
|
11 |
if (len(sys.argv) != 2):
|
|
12 |
print "Uzo: " + sys.argv[0] + " <numero>"
|
|
13 |
print "Parametro <numero>:"
|
|
14 |
print " 0 Ne korektitaj"
|
|
15 |
print " 1 Ĝustaj"
|
|
16 |
print " 2 Malĝustaj"
|
|
17 |
print " 3 Nekutimaj"
|
|
18 |
sys.exit(1)
|
|
19 |
else:
|
|
20 |
korekteco=sys.argv[1]
|
|
21 |
|
|
22 |
db = MySQLdb.connect(host='vicerveza',user=dbuser,passwd=dbpass,db=database)
|
|
23 |
|
|
24 |
cursor = db.cursor()
|
|
25 |
|
|
26 |
cursor.execute('DELETE FROM ' + dbtable + ' WHERE korekta='+sys.argv[1])
|
|
27 |
|
|
28 |
db.close()
|