# imports
from com.bitmechanic.maxq import HttpTestCase, EditorPane
from junit.textui import TestRunner
from java.lang import *
from java.io import *
from java.util import *
from HTTPClient import NVPair
import settings

# definition of test class
class MaxQTest(HttpTestCase):
    def __init__(self):
        HttpTestCase.__init__(self, "")

    def runTest(self):
        print '$Id: test_adm_regions.py,v 1.4 2003/12/27 10:06:27 alex Exp $'

        print '.',
        self.get("http://devel.z.halogen.kharkov.ua/ZWarehouse/admin/region_index")
        try:
            self.responseOK()
        except:
            print '/admin/region_index',
            print "... %s" % self.getResponse().getStatusCode()
            self.printResponse()

        print '.',
        self.get("http://devel.z.halogen.kharkov.ua/ZWarehouse/admin/region_add")
        try:
            self.responseOK()
        except:
            print '/admin/region_add',
            print "... %s" % self.getResponse().getStatusCode()
            self.printResponse()

        print '.',
        list = ArrayList()
        list.add(NVPair('''ml_region_name.lang:records''', '''1'''))
        list.add(NVPair('''ml_region_name.value:records''', '''0A'''))
        list.add(NVPair('''code''', '''0B'''))
        list.add(NVPair('''country_id''', '''2'''))
        self.post("http://devel.z.halogen.kharkov.ua/ZWarehouse/admin/region_add", list)
        try:
            self.responseOK()
        except:
            print '/admin/region_add',
            print "... %s" % self.getResponse().getStatusCode()
            self.printResponse()

        print '.',
        #print "-> Connecting to MySQL database"
        db = settings.getDbConnection()
        #print "\tSuccess"
        region_id = db.loadVal("select max(region_id) from regions")
        name_mlid=db.loadVal("select name_mlid from regions where region_id=%s" % region_id)
        existing_country_id=db.loadVal("select id from countries limit 1")

        list = ArrayList()
        list.add(NVPair('''region_id''', region_id))
        self.get("http://devel.z.halogen.kharkov.ua/ZWarehouse/admin/region_edit", list)
        try:
            self.responseOK()
        except:
            print '/admin/region_edit?region_id=%s'%region_id,
            print "... %s" % self.getResponse().getStatusCode()
            self.printResponse()

        print '.',
        list = ArrayList()
        list.add(NVPair('''ml_region_name.lang:records''', '''1'''))
        list.add(NVPair('''ml_region_name.mlid:records''', name_mlid))
        list.add(NVPair('''ml_region_name.value:records''', '''0C'''))
        list.add(NVPair('''region_id''', region_id))
        list.add(NVPair('''code''', '''0D'''))
        list.add(NVPair('''country_id''', existing_country_id))
        self.post("http://devel.z.halogen.kharkov.ua/ZWarehouse/admin/update_region", list)
        try:
            self.responseOK()
        except:
            print '/admin/update_region',
            print "... %s" % self.getResponse().getStatusCode()
            self.printResponse()


        print '.',
        list = ArrayList()
        list.add(NVPair('''region_id''', region_id))
        self.get("http://devel.z.halogen.kharkov.ua/ZWarehouse/admin/region_del", list)
        try:
            self.responseOK()
        except:
            print '/admin/region_del?region_id=%s'%region_id,
            print "... %s" % self.getResponse().getStatusCode()
            self.printResponse()

        print '.',
        list = ArrayList()
        list.add(NVPair('''region_id''', region_id))
        list.add(NVPair('''delete''', '''Delete'''))
        self.post("http://devel.z.halogen.kharkov.ua/ZWarehouse/admin/delete_region", list)
        try:
            self.responseOK()
        except:
            print '/admin/delete_region',
            print "... %s" % self.getResponse().getStatusCode()
            self.printResponse()

        isDeleted = db.loadVal("select count(*) from regions where region_id=%s"%region_id)
        if not isDeleted:
            print '!!! ERROR: Region does not seems to be deleted'

        print ''



##########################################

# Code to load and run the test
test = MaxQTest()
settings.setAuthorization(test)
test.runTest()