# 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_countries.py,v 1.5 2003/12/27 10:06:27 alex Exp $'

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

        db = settings.getDbConnection()

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

        print '.',
        list = ArrayList()
        list.add(NVPair('''h_action''', '''1'''))
        list.add(NVPair('''add''', '''1'''))
        list.add(NVPair('''names.language_id:records:int''', '''1'''))
        list.add(NVPair('''names.name:records''', '''TestSuite'''))
        list.add(NVPair('''iso_code_2''', '''TS'''))
        list.add(NVPair('''iso_code_3''', '''TSC'''))
        self.post("http://devel.z.halogen.kharkov.ua/ZWarehouse/admin/add_country", list)
        try:
            self.responseOK()
        except:
            print '/admin/add_country',
            print "... %s" % self.getResponse().getStatusCode()
            self.printResponse()

        country_id = db.loadVal("select max(id) from countries")
        name_mlid=db.loadVal("select name_mlid from countries where id=%s" % country_id)

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


        print '.',
        list = ArrayList()
        list.add(NVPair('''names.language_id:records:int''', '1'))
        list.add(NVPair('''names.mlid:records:int''', name_mlid))
        list.add(NVPair('''names.name:records''', '''TestSuite1'''))
        list.add(NVPair('''country_id''', country_id))
        list.add(NVPair('''iso_code_2''', '''T1'''))
        list.add(NVPair('''iso_code_3''', '''TS1'''))
        self.post("http://devel.z.halogen.kharkov.ua/ZWarehouse/admin/update_country", list)
        try:
            self.responseOK()
        except:
            print '/admin/update_country',
            print "... %s" % self.getResponse().getStatusCode()
            self.printResponse()

        print '.',
        list = ArrayList()
        list.add(NVPair('''country_id''', country_id))
        self.get("http://devel.z.halogen.kharkov.ua/ZWarehouse/admin/country_export", list)
        try:
            self.responseOK()
        except:
            print "... %s" % self.getResponse().getStatusCode()
            print '/admin/country_export?country_id=%s'%country_id,
            self.printResponse()
        if not self.responseContains('T1') or not self.responseContains('TS1'):
            print '!!! FAILED CHECK of changed country attributes'

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

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

        isDeleted = db.loadVal("select count(*) from countries where id=%s"%country_id)
        if not isDeleted:
            print '/admin/delete_country?h_action=1&country_id=%s&delete=Delete'%country_id,
            print '!!! ERROR: Country does not seems to be deleted'

        print ' '

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

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