def test_reindex(self):
crate_v3 = CrateNode(crate_dir=get_crate('3.x.x'),
keep_data=True,
settings=self.crate_settings)
self._to_stop.append(crate_v3)
crate_v3.start()
with client(crate_v3.http_url) as c:
aio.run(c.execute, "create table t (x int)")
args = (
(1, ),
(2, ),
(3, ),
)
aio.run(c.execute_many, "insert into t (x) values (?)", args)
crate_v3.stop()
self._to_stop.remove(crate_v3)
crate_v4 = CrateNode(crate_dir=get_crate('4.0.3'),
keep_data=True,
settings=self.crate_settings)
self._to_stop.append(crate_v4)
crate_v4.start()
reindex(crate_v4.http_url)
with client(crate_v4.http_url) as c:
result = aio.run(
c.execute,
"SELECT version FROM information_schema.tables WHERE table_name = 't'"
)
version = result['rows'][0][0]
self.assertEqual(version, {'upgraded': None, 'created': '4.0.3'})
cnt = aio.run(c.execute, 'SELECT count(*) FROM t')['rows'][0][0]
self.assertEqual(cnt, 3)
def test_reindex(self):
crate_v3 = CrateNode(crate_dir=get_crate('3.x.x'),
keep_data=True,
settings=self.crate_settings)
self._to_stop.append(crate_v3)
crate_v3.start()
with connect(crate_v3.http_url) as conn:
cur = conn.cursor()
cur.execute("create table t (x int)")
args = (
(1, ),
(2, ),
(3, ),
)
cur.executemany("insert into t (x) values (?)", args)
crate_v3.stop()
self._to_stop.remove(crate_v3)
crate_v4 = CrateNode(crate_dir=get_crate('4.0.3'),
keep_data=True,
settings=self.crate_settings)
self._to_stop.append(crate_v4)
crate_v4.start()
reindex(crate_v4.http_url)
with connect(crate_v4.http_url) as conn:
cur = conn.cursor()
cur.execute(
"SELECT version FROM information_schema.tables WHERE table_name = 't'"
)
version, = cur.fetchone()
self.assertEqual(version, {'upgraded': None, 'created': '4.0.3'})
cur.execute('SELECT count(*) FROM t')
cnt, = cur.fetchone()
self.assertEqual(cnt, 3)