aboutsummaryrefslogtreecommitdiff
path: root/src/com/benlinskey/grdbc/SyntaxCreator.java
diff options
context:
space:
mode:
authorBen Linskey2013-12-17 09:15:23 -0500
committerBen Linskey2013-12-17 09:15:23 -0500
commit81289d52a0b771de363a361c1d04ae3146e5d8cf (patch)
treea482c1a4bcaff6dc471139fef0eb1a480293fa76 /src/com/benlinskey/grdbc/SyntaxCreator.java
parenta1aacb1a9db2cded467fbd6699a4140529e88ce9 (diff)
downloadgreek-reference-database-creator-81289d52a0b771de363a361c1d04ae3146e5d8cf.tar.gz
Replace tabs with spaces.
This commit also adds a missing documentation comment for the GreekTextParser class.
Diffstat (limited to 'src/com/benlinskey/grdbc/SyntaxCreator.java')
-rw-r--r--src/com/benlinskey/grdbc/SyntaxCreator.java316
1 files changed, 159 insertions, 157 deletions
diff --git a/src/com/benlinskey/grdbc/SyntaxCreator.java b/src/com/benlinskey/grdbc/SyntaxCreator.java
index 172b53e..e5ccb17 100644
--- a/src/com/benlinskey/grdbc/SyntaxCreator.java
+++ b/src/com/benlinskey/grdbc/SyntaxCreator.java
@@ -31,169 +31,171 @@ import javax.xml.parsers.ParserConfigurationException;
import org.xml.sax.SAXException;
/**
- * Reads in an XML file containing the Overview of Greek Syntax text and stores
+ * Reads in an XML file containing the Overview of Greek Syntax text and stores
* sections of the text in an SQLite database.
* <p>
* Note that the Sources Cited section is omitted, as it is on Perseus.
+ *
* @author Ben Linskey
- *
+ *
*/
public class SyntaxCreator {
- private final static String FILE = "../xml/Perseus_text_1999.04.0052.xml";
- private final static String DB = "syntax.db";
- private final static String TABLE_NAME = "syntax";
- private Connection connection;
- private PreparedStatement insertStatement;
-
- /**
- * Class constructor.
- */
- public SyntaxCreator() {
- // Load driver.
- try {
- Class.forName("org.sqlite.JDBC");
- } catch (ClassNotFoundException e) {
- e.printStackTrace();
- System.exit(1);
- }
-
- // Connect to database.
- try {
- connection = DriverManager.getConnection("jdbc:sqlite:" + DB);
- } catch (SQLException e) {
- e.printStackTrace();
- System.exit(1);
- }
-
- // Use batch inserts for speed.
- try {
- connection.setAutoCommit(false);
- } catch (SQLException e) {
- e.printStackTrace();
- System.exit(1);
- }
-
- createDatabase();
-
- // Create a prepared statement to use when inserting entries.
- try {
- insertStatement = connection.prepareStatement("INSERT INTO "
- + TABLE_NAME + " VALUES (NULL, ?, ?, ?)");
- } catch (SQLException e) {
- e.printStackTrace();
- System.exit(1);
- }
- }
-
- /**
- * Creates the Overview of Greek Syntax database.
- */
- public void run() {
- addSections();
- try {
- insertStatement.close();
- connection.close();
- } catch (SQLException e) {
- e.printStackTrace();
- System.exit(1);
- }
- System.out.println("Done.");
- }
-
- /**
- * Resets the database if it already exists and creates a new, empty
- * database.
- */
- private void createDatabase() {
- System.out.println("Creating lexicon database...");
- try {
- String dropTable = "DROP TABLE IF EXISTS " + TABLE_NAME;
- String createTable = "CREATE TABLE " + TABLE_NAME + " (" +
- "_ID INTEGER PRIMARY KEY, " +
- "chapter VARCHAR(100), " +
- "section VARCHAR(100), " +
- "xml TEXT)";
- Statement statement = connection.createStatement();
- statement.executeUpdate(dropTable);
- statement.executeUpdate(createTable);
- connection.commit();
- statement.close();
- } catch (SQLException e) {
- e.printStackTrace();
- System.exit(1);
- }
- }
-
- /**
- * Parses the XML file, modifies the sections, and inserts the modified
- * data into the database.
- */
- private void addSections() {
- System.out.println("Inserting data...");
-
- String chapter = null;
+ private final static String FILE = "../xml/Perseus_text_1999.04.0052.xml";
+ private final static String DB = "syntax.db";
+ private final static String TABLE_NAME = "syntax";
+ private Connection connection;
+ private PreparedStatement insertStatement;
+
+ /**
+ * Class constructor.
+ */
+ public SyntaxCreator() {
+ // Load driver.
+ try {
+ Class.forName("org.sqlite.JDBC");
+ } catch (ClassNotFoundException e) {
+ e.printStackTrace();
+ System.exit(1);
+ }
+
+ // Connect to database.
+ try {
+ connection = DriverManager.getConnection("jdbc:sqlite:" + DB);
+ } catch (SQLException e) {
+ e.printStackTrace();
+ System.exit(1);
+ }
+
+ // Use batch inserts for speed.
+ try {
+ connection.setAutoCommit(false);
+ } catch (SQLException e) {
+ e.printStackTrace();
+ System.exit(1);
+ }
+
+ createDatabase();
+
+ // Create a prepared statement to use when inserting entries.
+ try {
+ insertStatement = connection.prepareStatement("INSERT INTO "
+ + TABLE_NAME + " VALUES (NULL, ?, ?, ?)");
+ } catch (SQLException e) {
+ e.printStackTrace();
+ System.exit(1);
+ }
+ }
+
+ /**
+ * Creates the Overview of Greek Syntax database.
+ */
+ public void run() {
+ addSections();
+ try {
+ insertStatement.close();
+ connection.close();
+ } catch (SQLException e) {
+ e.printStackTrace();
+ System.exit(1);
+ }
+ System.out.println("Done.");
+ }
+
+ /**
+ * Resets the database if it already exists and creates a new, empty
+ * database.
+ */
+ private void createDatabase() {
+ System.out.println("Creating lexicon database...");
+ try {
+ String dropTable = "DROP TABLE IF EXISTS " + TABLE_NAME;
+ String createTable = "CREATE TABLE " + TABLE_NAME + " ("
+ + "_ID INTEGER PRIMARY KEY, "
+ + "chapter VARCHAR(100), " + "section VARCHAR(100), "
+ + "xml TEXT)";
+ Statement statement = connection.createStatement();
+ statement.executeUpdate(dropTable);
+ statement.executeUpdate(createTable);
+ connection.commit();
+ statement.close();
+ } catch (SQLException e) {
+ e.printStackTrace();
+ System.exit(1);
+ }
+ }
+
+ /**
+ * Parses the XML file, modifies the sections, and inserts the modified data
+ * into the database.
+ */
+ private void addSections() {
+ System.out.println("Inserting data...");
+
+ String chapter = null;
String section = null;
StringBuilder xml = new StringBuilder();
- Pattern pattern = Pattern.compile("<head>(.*?)</head>");
-
- try {
- BufferedReader in = new BufferedReader(new FileReader(FILE));
- while (in.ready()) {
- String line = in.readLine();
- if (line.startsWith("<div1")) {
- // Get chapter title.
- line = in.readLine(); // Next line is "head" element with title.
- Matcher matcher = pattern.matcher(line);
- matcher.find();
- chapter = matcher.group(1);
- } else if (line.startsWith("<div2")) {
- // Get section title.
- line = in.readLine(); // Next line is "head" element with title.
- Matcher matcher = pattern.matcher(line);
- matcher.find();
- section = matcher.group(1);
-
- // Reset XML and add "head" element.
- xml.delete(0, xml.length());
- xml.append("<section>");
- xml.append(line);
- } else if (line.contains("</div2>")) {
- // Get any XML before the "</div2>" tag.
- String[] split = line.split("</div2>");
- xml.append(split[0]);
-
- // Add closing root tag.
- xml.append("</section>");
-
- SyntaxParser parser = new SyntaxParser(xml.toString());
- String transcodedXml = parser.transcode();
-
- // Add data to database.
- insertStatement.setString(1, chapter);
- insertStatement.setString(2, section);
- insertStatement.setString(3, transcodedXml);
- insertStatement.addBatch();
- } else {
- // Get next line of XML.
- xml.append(line);
- }
- }
- in.close();
-
- insertStatement.executeBatch();
- connection.commit();
- } catch (SQLException e) {
- e.printStackTrace();
- System.exit(1);
- } catch (IOException e) {
- e.printStackTrace();
- System.exit(1);
- } catch (ParserConfigurationException e) {
- e.printStackTrace();
- System.exit(1);
- } catch (SAXException e) {
- e.printStackTrace();
- System.exit(1);
- }
- }
+ Pattern pattern = Pattern.compile("<head>(.*?)</head>");
+
+ try {
+ BufferedReader in = new BufferedReader(new FileReader(FILE));
+ while (in.ready()) {
+ String line = in.readLine();
+ if (line.startsWith("<div1")) {
+ // Get chapter title.
+ line = in.readLine(); // Next line is "head" element with
+ // title.
+ Matcher matcher = pattern.matcher(line);
+ matcher.find();
+ chapter = matcher.group(1);
+ } else if (line.startsWith("<div2")) {
+ // Get section title.
+ line = in.readLine(); // Next line is "head" element with
+ // title.
+ Matcher matcher = pattern.matcher(line);
+ matcher.find();
+ section = matcher.group(1);
+
+ // Reset XML and add "head" element.
+ xml.delete(0, xml.length());
+ xml.append("<section>");
+ xml.append(line);
+ } else if (line.contains("</div2>")) {
+ // Get any XML before the "</div2>" tag.
+ String[] split = line.split("</div2>");
+ xml.append(split[0]);
+
+ // Add closing root tag.
+ xml.append("</section>");
+
+ SyntaxParser parser = new SyntaxParser(xml.toString());
+ String transcodedXml = parser.transcode();
+
+ // Add data to database.
+ insertStatement.setString(1, chapter);
+ insertStatement.setString(2, section);
+ insertStatement.setString(3, transcodedXml);
+ insertStatement.addBatch();
+ } else {
+ // Get next line of XML.
+ xml.append(line);
+ }
+ }
+ in.close();
+
+ insertStatement.executeBatch();
+ connection.commit();
+ } catch (SQLException e) {
+ e.printStackTrace();
+ System.exit(1);
+ } catch (IOException e) {
+ e.printStackTrace();
+ System.exit(1);
+ } catch (ParserConfigurationException e) {
+ e.printStackTrace();
+ System.exit(1);
+ } catch (SAXException e) {
+ e.printStackTrace();
+ System.exit(1);
+ }
+ }
}