28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
# File 'lib/insight.rb', line 28
def createSchema()
query = "CREATE TABLE IF NOT EXISTS #{@rule} ( "
count = 0
@columns = ""
@columnholders = ""
@config["schema"]["columns"].each{|key, value|
query = query + ", " if count != 0
@columns = @columns + ", " if count != 0
@columnholders = @columnholders + ", " if count != 0
@columns = @columns + key
@columnholders = @columnholders + "?"
query = query + key + " " + value
count = count + 1
}
query = query + ");"
@db.execute query
end
|