1
2
3
4 package com.webstersmalley.mediacollection.database;
5
6 import java.io.BufferedReader;
7 import java.io.FileInputStream;
8 import java.io.IOException;
9 import java.io.InputStreamReader;
10
11 import org.apache.log4j.Logger;
12 import org.apache.log4j.PropertyConfigurator;
13
14 /**
15 */
16 public class ScriptReader
17 {
18 private static Logger log = Logger.getLogger(ScriptReader.class);
19 static
20 {
21 PropertyConfigurator.configure("log4j.properties");
22 }
23
24 private String filename;
25
26 public ScriptReader(String filename)
27 {
28 this.filename = filename;
29 }
30
31 public String[] splitScript() throws IOException
32 {
33 BufferedReader br = new BufferedReader(new InputStreamReader(
34 new FileInputStream(filename)));
35 String line = br.readLine();
36 StringBuffer sb = new StringBuffer();
37 while (line != null)
38 {
39 sb.append(line);
40 sb.append(" ");
41 line = br.readLine();
42 }
43 String allLines = sb.toString();
44 return allLines.split(";");
45 }
46
47 public static void main(String[] args)
48 {
49 ScriptReader sr = new ScriptReader("db/create_tables.sql");
50 String[] scriptlets = null;
51 try
52 {
53 scriptlets = sr.splitScript();
54 }
55 catch (IOException e)
56 {
57
58 e.printStackTrace();
59 }
60 for (int i = 0; i < scriptlets.length; i++)
61 {
62 log.debug(scriptlets[i]);
63 }
64
65 }
66
67 }