附件里是将 kjd.sgf (围棋定式)转换为 sql 语句的 python 源码,以及 sgf 源文件及生成的 sql 源文件。改自 eidogo.com。
今天玩 python 的体会:1、因为用到 simplejson,我用的是 python 2.66 的版本。太低了(2.1.7)好象不行。2、python 里不能用 tab 符号?3、python 确实很强大。
#import MySQLdb as mysql
import simplejson
class SgfNode:
def __init__(self, id, parent):
self.id = id
self.properties = {}
self.parent = parent
self.children = []
# DB prep fields
self.depth = 0
self.lt = 0
self.rt = 0
pass
class SgfParser:
def __init__(self, sgf):
self.sgf = sgf
self.pos = 0
self.root = SgfNode(0, None)
self.nodecounter = 1
self.parse_tree(self.root)
def parse_tree(self, r):
while (self.pos < len(self.sgf)):
c = self.sgf[self.pos]
self.pos += 1
if c == ';':
r = self.parse_node(r)
elif c == '(':
self.parse_tree(r)
elif c == ')':
return
def parse_node(self, parent):
node = SgfNode(self.nodecounter, parent)
self.nodecounter += 1
node = self.parse_properties(node)
cur = node
depth = 0
while 1:
cur = cur.parent
if not cur:
break
depth += 1
node.depth = depth
parent.children.append(node)
return node
def parse_properties(self, node):
prop = ''
vals = []
i = 0
while (self.pos < len(self.sgf)):
c = self.curc()
if c == ';' or c == '(' or c == ')':
break
if self.curc() == '[':
while self.curc() == '[':
self.pos += 1
vals.insert(i, '')
while self.curc() != ']' and self.pos < len(self.sgf):
if self.curc() == '\\':
self.pos += 1
while self.curc() == '\r' or self.curc() == '\n':
self.pos +=1
vals[i] += self.curc()
self.pos += 1
i += 1
while self.curc() == ']' or self.curc() == '\r' or self.curc() == '\n':
self.pos += 1
if node.properties.has_key(prop):
if not (type(node.properties[prop]) is list):
node.properties[prop] = [node.properties[prop]]
node.properties[prop].extend(vals)
else:
if (len(vals) > 1):
node.properties[prop] = vals
else:
node.properties[prop] = vals[0]
prop = ''
vals = []
i = 0
continue
if c != ' ' and c != '\n' and c != '\r' and c != '\t':
prop += c
self.pos += 1
return node
def curc(self):
return self.sgf[self.pos]
def compute_ltrt(node, lt):
rt = lt + 1
for child in node.children:
rt = compute_ltrt(child, rt)
node.lt = lt
node.rt = rt
return rt + 1
def db_populate(n, c):
if n.parent:
parent_id = n.parent.id
else:
parent_id = 0
c.write( "insert into kjd (id, parent, properties, lt, rt, depth) values(" )
c.write(str(n.id) + "," + str(parent_id) + ",'" + str(simplejson.dumps(n.properties))
# c.write(str(n.id) + "," + str(parent_id) + ",'" + str(n.properties)
+ "'," + str(n.lt) + "," + str(n.rt) + "," + str(n.depth) + ")\r\n")
print n.id
for child in n.children:
db_populate(child, c)
def file_print(data, c):
c.write(data)
c.write('\r\n')
#if __name__ == "__main__":
# file = open("../sgf/kjd.sgf")
file = open("kjd.sgf")
sgf = file.read()
file.close()
root = SgfParser(sgf).root
compute_ltrt(root, 1)
# db = mysql.connect(host="localhost", user="", passwd="", db="eidogo")
# c = db.cursor()
# db_populate(root, c)
# c.execute("update kjd set parent=null where id=0")
c = open("kjd.sql", "w")
db_populate(root, c)
# c.write( "insert into kjd (id, parent, properties, lt, rt, depth) values(" )
c.write("update kjd set parent=null where id=0\r\n")
# file_print( "insert into kjd (id, parent, properties, lt, rt, depth) values(", c )
# file_print( "update kjd set parent=null where id=0", c )
c.close()
分享到:
相关推荐
NULL 博文链接:https://zwhc.iteye.com/blog/815308
KJD矿用隔爆兼本安型计算机操作基础手册.doc
KJD25T离层监测系统测试诊断仪使用说明书.doc
KJD十七矿用隔爆兼本安型计算机操作手册.pdf
基于ARM智能KJD400型矿用蓄电池管理器的研究.pdf
基于ARM的智能型KJD400型矿用蓄电池管理器的研究,主要是通过双芯、本质安全型、隔离、双向串行通信等关键技术,精确的充放电检测与管控,解决了普遍存在的过充电、过放电对蓄电池寿命的破坏根源。重点介绍其基本原理、...
为满足高庄矿瓦斯管理要求,在局部通风机中更换使用新型的KJD11-36局部通风机自动切换控制器。介绍了该自动切换控制器的主要参数、功能,安装步骤及注意事项。该装置在各个掘进工作面成功安装后,实现了双风机、双电源...
专题资料
程序可实现曲线左转、右转的整体坐标计算。根据实际工程需要更改编译预处理#define L0 40、#define R 400、#define KJD0 0.000处起算数据,并输入JD0、JD1、JD2坐标,即可获得综合要素、主点里程与测设坐标。
KJD03智能节电器采用科丰自主研发的专利控制电路和高效换流技术,实时监测电网电压,采用低损耗,两级自动调压方式,使之成为节电理想、性能优越的节电产品
为了了解西南某隧道工程施工过程中放射性辐射水平,估计隧道施工人员接受的γ辐射外照射剂量,分别采用BH5-FJ373型携带n-γ辐射仪、KJD2000R型连续测氡仪对隧道施工场所及工人居住区进行γ辐射和氡气浓度测量。...