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
|
#!/usr/bin/env python
#
# Copyright 2016 Google Inc.
#
# Use of this source code is governed by a BSD-style license that can be
# found in the LICENSE file.
import argparse
import sqlite3
def create_database(inpath, outpath):
with sqlite3.connect(outpath) as conn:
c = conn.cursor();
c.execute('''CREATE TABLE IF NOT EXISTS gradients (
FileName TEXT,
ColorCount INTEGER,
GradientType TEXT,
TileMode TEXT,
EvenlySpaced INTEGER,
HardStopCount INTEGER,
Verb TEXT,
BoundsWidth INTEGER,
BoundsHeight INTEGER,
Positions TEXT
)''');
c.execute("DELETE FROM gradients");
with open(inpath, "r") as results:
gradients = []
for line in [line.strip() for line in results]:
gradients.append(line.split());
c.executemany(
"INSERT INTO gradients VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
gradients);
conn.commit();
if __name__ == "__main__":
parser = argparse.ArgumentParser(
description = "Transform Lua script output to a SQL DB");
parser.add_argument("inpath", help="Path to Lua script output file");
parser.add_argument("outpath", help="Path to SQL DB");
args = parser.parse_args();
create_database(args.inpath, args.outpath);
|
