-
Notifications
You must be signed in to change notification settings - Fork 1
/
CreateDB.py
60 lines (50 loc) · 1.43 KB
/
CreateDB.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
from ScrambleRubixcube import xInitial, make_move
import numpy as np
import sqlite3
from sqlite3 import Error
class St:
cube = None
cost = 0
def get_corner_string(cube):
string = ''
for i in range(18):
if i % 3 == 0 or i % 3 == 2:
string = string + cube[i, 0] + cube[i, 2]
return string
###################################################
db = dict()
front = list()
goal = St()
goal.cube = np.array(xInitial)
front.append(goal)
db[get_corner_string(goal.cube)] = 0
# cost = 0
while len(front) != 0:
curr = front.pop(0)
if curr.cost < 5:
child_cost = curr.cost + 1
for i in range(12):
new = St()
new.cube = np.array(curr.cube)
new.cost = child_cost
make_move(new.cube, i + 1, 0)
# if cost < child_cost:
# cost = child_cost
# print(cost)
string = get_corner_string(new.cube)
if string not in db.keys():
db[string] = new.cost
front.append(new)
try:
cube = goal.cube
conn = sqlite3.connect('corners.db')
cursor = conn.cursor()
cursor.execute('CREATE TABLE CornerValue(Corners VARCHAR, Value INT)')
print(sqlite3.version)
cursor.executemany('INSERT INTO CornerValue(Corners, Value) VALUES (?, ?)', db.items())
conn.commit()
except Error as e:
print(e, 'error occurred')
finally:
cursor.close()
conn.close()