#!/usr/bin/env python
# **********************************************************************
#
# Copyright (c) 2003-2008 ZeroC, Inc. All rights reserved.
#
# This copy of Ice is licensed to you under the terms described in the
# ICE_LICENSE file included in this distribution.
#
# **********************************************************************

import sys, demoscript, time
import demoscript.pexpect as pexpect

def run(createCmd, recreateCmd, readCmd, readnewCmd):
    print "cleaning databases...",
    sys.stdout.flush()
    demoscript.Util.cleanDbDir("db")
    demoscript.Util.cleanDbDir("dbnew")
    print "ok"

    print "creating database...",
    create = demoscript.Util.spawn(createCmd)
    create.expect('7 contacts were successfully created or updated')
    create.waitTestSuccess()
    print "ok"

    print "reading database...",
    read = demoscript.Util.spawn(readCmd)
    read.expect_list(read.compile_pattern_list([ \
                    "All contacts \(default order\)", \
                    'arnold:\t{1,2}\(333\)333-3333 x1234', \
                    'bob:\t{1,2}\(222\)222-2222', \
                    'carlos:\t{1,2}\(111\)111-1111', \
                    'don:\t{1,2}\(777\)777-7777', \
                    'ed:\t{1,2}\(666\)666-6666', \
                    'frank:\t{1,2}\(555\)555-5555 x123', \
                    'gary:\t{1,2}\(444\)444-4444', \
                    'All contacts \(ordered by phone number\)', \
                    'carlos:\t{1,2}\(111\)111-1111', \
                    'bob:\t{1,2}\(222\)222-2222', \
                    'arnold:\t{1,2}\(333\)333-3333 x1234', \
                    'gary:\t{1,2}\(444\)444-4444', \
                    'frank:\t{1,2}\(555\)555-5555 x123', \
                    'ed:\t{1,2}\(666\)666-6666', \
                    'don:\t{1,2}\(777\)777-7777', \
                    ]))
    read.waitTestSuccess()
    print "ok"

    print "transforming database...",
    transform = demoscript.Util.spawn('transformdb --old ContactData.ice --new NewContactData.ice -f transform.xml  db dbnew', language="C++")
    transform.waitTestSuccess()
    print "ok"

    print "reading new database...",
    readnew = demoscript.Util.spawn(readnewCmd)
    readnew.expect('All contacts \(default order\)')
    readnew.expect('All contacts \(ordered by phone number\)')
    readnew.expect('DbEnv \"dbnew\": Secondary index corrupt: not consistent with primary')
    print "ok"

    print "recreating database...",
    recreate = demoscript.Util.spawn(recreateCmd)
    recreate.expect('Recreated contacts database successfully!')
    recreate.waitTestSuccess()
    print "ok"

    print "rereading new database...",
    readnew = demoscript.Util.spawn(readnewCmd)
    readnew.expect_list(readnew.compile_pattern_list([ \
                    "All contacts \(default order\)", \
                    'arnold:\t{1,2}\(333\)333-3333 x1234 arnold@gmail.com', \
                    'bob:\t{1,2}\(222\)222-2222 bob@gmail.com', \
                    'carlos:\t{1,2}\(111\)111-1111 carlos@gmail.com', \
                    'don:\t{1,2}\(777\)777-7777 don@gmail.com', \
                    'ed:\t{1,2}\(666\)666-6666 ed@gmail.com', \
                    'frank:\t{1,2}\(555\)555-5555 x123 frank@gmail.com', \
                    'gary:\t{1,2}\(444\)444-4444 gary@gmail.com', \
                    'All contacts \(ordered by phone number\)', \
                    'carlos:\t{1,2}\(111\)111-1111 carlos@gmail.com', \
                    'bob:\t{1,2}\(222\)222-2222 bob@gmail.com', \
                    'arnold:\t{1,2}\(333\)333-3333 x1234 arnold@gmail.com', \
                    'gary:\t{1,2}\(444\)444-4444 gary@gmail.com', \
                    'frank:\t{1,2}\(555\)555-5555 x123 frank@gmail.com', \
                    'ed:\t{1,2}\(666\)666-6666 ed@gmail.com', \
                    'don:\t{1,2}\(777\)777-7777 don@gmail.com', \
                        ]))
    readnew.waitTestSuccess()
    print "ok"