old_contents: #  Licensed to the Apache Software Foundation (ASF) under one
  #  or more contributor license agreements.  See the NOTICE file
  #  distributed with this work for additional information
  #  regarding copyright ownership.  The ASF licenses this file
  #  to you under the Apache License, Version 2.0 (the
  #  "License"); you may not use this file except in compliance
  #  with the License.  You may obtain a copy of the License at
  #
  #  http://www.apache.org/licenses/LICENSE-2.0
  #
  #  Unless required by applicable law or agreed to in writing,
  #  software distributed under the License is distributed on an
  #  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
  #  KIND, either express or implied.  See the License for the
  #  specific language governing permissions and limitations
  #  under the License.
  
  from time import sleep
  import unittest
  import os
  import cairis.bin.cairisd
  
  __author__ = 'Robin Quetin'
  
  
  class CairisDaemonTestCase(unittest.TestCase):
    srcRoot = os.environ['CAIRIS_SRC']
    createDbSql = srcRoot + '/test/createdb.sql'
    sqlDir = srcRoot + '/sql'
    initSql = sqlDir + '/init.sql'
    procsSql = sqlDir + '/procs.sql'
    cmd = "/usr/bin/mysql --user=root --password='' < " + createDbSql
    os.system(cmd)
    cmd = "/usr/bin/mysql --user=irisuser --password='' --database=arm < " + initSql
    os.system(cmd)
  #  cmd = "/usr/bin/mysql --user=irisuser --password='' --database=arm < " + procsSql
  #  os.system(cmd)
    app = cairis.bin.cairisd.main(['-d', '--unit-test'])
    sleep(1)
  
new_contents: #  Licensed to the Apache Software Foundation (ASF) under one
  #  or more contributor license agreements.  See the NOTICE file
  #  distributed with this work for additional information
  #  regarding copyright ownership.  The ASF licenses this file
  #  to you under the Apache License, Version 2.0 (the
  #  "License"); you may not use this file except in compliance
  #  with the License.  You may obtain a copy of the License at
  #
  #  http://www.apache.org/licenses/LICENSE-2.0
  #
  #  Unless required by applicable law or agreed to in writing,
  #  software distributed under the License is distributed on an
  #  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
  #  KIND, either express or implied.  See the License for the
  #  specific language governing permissions and limitations
  #  under the License.
  
  from time import sleep
  import unittest
  import os
  import cairis.bin.cairisd
  
  __author__ = 'Robin Quetin'
  
  
  class CairisDaemonTestCase(unittest.TestCase):
    srcRoot = os.environ['CAIRIS_SRC']
    createDbSql = srcRoot + '/test/createdb.sql'
    sqlDir = srcRoot + '/sql'
    initSql = sqlDir + '/init.sql'
    procsSql = sqlDir + '/procs.sql'
    cmd = "/usr/bin/mysql --user=root --password='' < " + createDbSql
    os.system(cmd)
    cmd = "/usr/bin/mysql --user=irisuser --password='' --database=arm < " + initSql
    os.system(cmd)
    cmd = "/usr/bin/mysql --user=irisuser --password='' --database=arm < " + procsSql
    os.system(cmd)
    app = cairis.bin.cairisd.main(['-d', '--unit-test'])
    sleep(1)
  
subject: tweak db init scripts