def testServers(self):
from my_deployment import common, master, slaves
for row in common.sql("SELECT * FROM nodes", db="common"):
if row['port'] == master.port:
self.assertEqual(row['type'], 'READ,WRITE')
elif row['port'] in [slave.port for slave in slaves]:
self.assertEqual(row['type'], 'READ')
def testServers(self):
from my_deployment import common, master, slaves
try:
pool_add(common, master, ['READ', 'WRITE'])
except AlreadyInPoolError:
pool_set(common, master, ['READ', 'WRITE'])
for slave in slaves:
try:
pool_add(common, slave, ['READ'])
except AlreadyInPoolError:
pool_set(common, slave, ['READ'])
for row in common.sql("SELECT * FROM nodes", db="common"):
if row['port'] == master.port:
self.assertEqual(row['type'], 'READ,WRITE')
elif row['port'] in [slave.port for slave in slaves]:
self.assertEqual(row['type'], 'READ')
def tearDown(self):
from my_deployment import common, servers
for server in servers:
pool_del(common, server)
common.sql("DROP DATABASE common")
def setUp(self):
from my_deployment import common, master, slaves
common.sql("DROP DATABASE IF EXISTS common")
common.sql("CREATE DATABASE common")
common.sql(_CREATE_TABLE)
