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()