public void ParseShineTable(string file)
{
if (!File.Exists(file))
{
throw new FileNotFoundException(file);
}
FileContents = new Dictionary <string, ShineTable>();
using (var files = File.Open(file, FileMode.Open, FileAccess.Read, FileShare.Read))
{
using (var sr = new StreamReader(files, Encoding.Default))
{
bool definingStruct = false, definingTable = false;
int lineNR = 0;
ShineTable curTable = null;
List <string> ColumnTypes = null;
string comment = "";
char? ignore = null;
KeyValuePair <string, string>?replaceThis = null;
while (!sr.EndOfStream)
{
lineNR++;
string line = sr.ReadLine().TrimStart();
if (line.Contains(Comment))
{
// Remove everything after it.
int index = line.IndexOf(Comment);
comment = line.Substring(index + 1);
//Console.WriteLine("Comment @ {0}: {1}", lineNR, comment);
line = line.Remove(index);
}
if (ignore.HasValue)
{
line = line.Replace(ignore.Value.ToString(), "");
}
if (line == string.Empty)
{
continue;
}
string lineLower = line.ToLower();
string[] lineSplit = line.Split('\t');
if (lineLower.StartsWith(Replace))
{
// ...
replaceThis = new KeyValuePair <string, string>(ConvertShitToString(lineSplit[1]), ConvertShitToString(lineSplit[2])); // take risks :D
//continue;
}
if (lineLower.StartsWith(Ignore))
{
ignore = ConvertShitToString(lineSplit[1])[0];
//continue;
}
if (lineLower.StartsWith(StartDefine))
{
if (definingStruct || definingTable)
{
throw new Exception("Already defining.");
}
// Get the name..
string name = line.Substring(StartDefine.Length + 1);
curTable = new ShineTable(name);
definingStruct = true;
continue;
}
else if (lineLower.StartsWith(Table))
{
if (definingStruct)
{
throw new Exception("Already defining.");
}
// Get the name..
string name = lineSplit[1].Trim(); // I hope this works D;
curTable = new ShineTable(name);
ColumnTypes = new List <string>();
FileContents.Add(name, curTable);
definingTable = true;
continue;
}
if (lineLower.StartsWith(EndDefine))
{
if (!definingStruct)
{
throw new Exception("Not started defining.");
}
definingStruct = false;
FileContents.Add(curTable.TableName, curTable);
continue;
}
line = line.Trim();
lineLower = lineLower.Trim();
if (definingStruct)
{
string columnName = comment.Trim();
if (columnName == string.Empty)
{
continue;
}
curTable.AddColumn(columnName, lineLower);
Console.WriteLine("Added column {0} to table {1}", columnName, curTable.TableName);
}
else if (definingTable)
{
// Lets search for columns..
if (lineLower.StartsWith(ColumnType))
{
for (int i = 1; i < lineSplit.Length; i++)
{
string l = lineSplit[i].Trim();
if (l == string.Empty)
{
continue;
}
ColumnTypes.Add(l);
}
}
else if (lineLower.StartsWith(ColumnName))
{
int j = 0;
for (int i = 1; i < lineSplit.Length; i++)
{
string l = lineSplit[i].Trim();
if (l == string.Empty)
{
continue;
}
var coltype = ColumnTypes[j++];
//curTable.AddColumn(l + "(" + coltype + ")", coltype);
curTable.AddColumn(l, coltype);
}
}
else if (lineLower.StartsWith(RecordLine))
{
// Next column is tablename
string tablename = lineSplit[1].Trim();
if (FileContents.ContainsKey(tablename))
{
curTable = FileContents[tablename];
// Lets start.
object[] data = new object[curTable.Columns.Count];
int j = 0;
for (int i = 2; i < lineSplit.Length; i++)
{
string l = lineSplit[i].Trim();
if (l == string.Empty)
{
continue;
}
data[j++] = Check(replaceThis, l.TrimEnd(','));
}
curTable.AddRow(data);
}
}
else if (lineLower.StartsWith(Record))
{
object[] data = new object[curTable.Columns.Count];
// Right under the table
int j = 0;
for (int i = 1; i < lineSplit.Length; i++)
{
if (j >= curTable.Columns.Count)
{
break;
}
string l = lineSplit[i].Trim();
if (l == string.Empty)
{
continue;
}
data[j++] = Check(replaceThis, l.TrimEnd(','));
}
curTable.AddRow(data);
}
}
else
{
if (FileContents.ContainsKey(lineSplit[0].Trim()))
{
// Should be a struct I guess D:
var table = FileContents[lineSplit[0].Trim()];
int columnsInStruct = table.Columns.Count;
int readColumns = 0;
object[] data = new object[columnsInStruct];
for (int i = 1; ; i++)
{
if (readColumns == columnsInStruct)
{
break;
}
else if (lineSplit.Length < i)
{
throw new Exception(string.Format("Could not read all columns of line {0}", lineNR));
}
// Cannot count on the tabs ...
string columnText = lineSplit[i].Trim();
if (columnText == string.Empty)
{
continue;
}
// Well, lets see if we can put it into the list
columnText = columnText.TrimEnd(',').Trim('"');
data[readColumns++] = columnText;
}
table.AddRow(data);
}
}
}
}
}
}
public void ParseShineTable(string file)
{
if (!File.Exists(file)) throw new FileNotFoundException(file);
FileContents = new Dictionary<string, ShineTable>();
using (var files = File.Open(file, FileMode.Open, FileAccess.Read, FileShare.Read))
{
using (var sr = new StreamReader(files, Encoding.Default))
{
bool definingStruct = false, definingTable = false;
int lineNR = 0;
ShineTable curTable = null;
List<string> ColumnTypes = null;
string comment = "";
char? ignore = null;
KeyValuePair<string, string>? replaceThis = null;
while (!sr.EndOfStream)
{
lineNR++;
string line = sr.ReadLine().TrimStart();
if (line.Contains(Comment))
{
// Remove everything after it.
int index = line.IndexOf(Comment);
comment = line.Substring(index + 1);
//Console.WriteLine("Comment @ {0}: {1}", lineNR, comment);
line = line.Remove(index);
}
if (ignore.HasValue)
{
line = line.Replace(ignore.Value.ToString(), "");
}
if (line == string.Empty)
{
continue;
}
string lineLower = line.ToLower();
string[] lineSplit = line.Split('\t');
if (lineLower.StartsWith(Replace))
{
// ...
replaceThis = new KeyValuePair<string, string>(ConvertShitToString(lineSplit[1]), ConvertShitToString(lineSplit[2])); // take risks :D
//continue;
}
if (lineLower.StartsWith(Ignore))
{
ignore = ConvertShitToString(lineSplit[1])[0];
//continue;
}
if (lineLower.StartsWith(StartDefine))
{
if (definingStruct || definingTable)
{
throw new Exception("Already defining.");
}
// Get the name..
string name = line.Substring(StartDefine.Length + 1);
curTable = new ShineTable(name);
definingStruct = true;
continue;
}
else if (lineLower.StartsWith(Table))
{
if (definingStruct)
{
throw new Exception("Already defining.");
}
// Get the name..
string name = lineSplit[1].Trim(); // I hope this works D;
curTable = new ShineTable(name);
ColumnTypes = new List<string>();
FileContents.Add(name, curTable);
definingTable = true;
continue;
}
if (lineLower.StartsWith(EndDefine))
{
if (!definingStruct)
{
throw new Exception("Not started defining.");
}
definingStruct = false;
FileContents.Add(curTable.TableName, curTable);
continue;
}
line = line.Trim();
lineLower = lineLower.Trim();
if (definingStruct)
{
string columnName = comment.Trim();
if (columnName == string.Empty) continue;
curTable.AddColumn(columnName, lineLower);
Console.WriteLine("Added column {0} to table {1}", columnName, curTable.TableName);
}
else if (definingTable)
{
// Lets search for columns..
if (lineLower.StartsWith(ColumnType))
{
for (int i = 1; i < lineSplit.Length; i++)
{
string l = lineSplit[i].Trim();
if (l == string.Empty) continue;
ColumnTypes.Add(l);
}
}
else if (lineLower.StartsWith(ColumnName))
{
int j = 0;
for (int i = 1; i < lineSplit.Length; i++)
{
string l = lineSplit[i].Trim();
if (l == string.Empty) continue;
var coltype = ColumnTypes[j++];
//curTable.AddColumn(l + "(" + coltype + ")", coltype);
curTable.AddColumn(l, coltype);
}
}
else if (lineLower.StartsWith(RecordLine))
{
// Next column is tablename
string tablename = lineSplit[1].Trim();
if (FileContents.ContainsKey(tablename))
{
curTable = FileContents[tablename];
// Lets start.
object[] data = new object[curTable.Columns.Count];
int j = 0;
for (int i = 2; i < lineSplit.Length; i++)
{
string l = lineSplit[i].Trim();
if (l == string.Empty) continue;
data[j++] = Check(replaceThis, l.TrimEnd(','));
}
curTable.AddRow(data);
}
}
else if (lineLower.StartsWith(Record))
{
object[] data = new object[curTable.Columns.Count];
// Right under the table
int j = 0;
for (int i = 1; i < lineSplit.Length; i++)
{
if (j >= curTable.Columns.Count) break;
string l = lineSplit[i].Trim();
if (l == string.Empty) continue;
data[j++] = Check(replaceThis, l.TrimEnd(','));
}
curTable.AddRow(data);
}
}
else
{
if (FileContents.ContainsKey(lineSplit[0].Trim()))
{
// Should be a struct I guess D:
var table = FileContents[lineSplit[0].Trim()];
int columnsInStruct = table.Columns.Count;
int readColumns = 0;
object[] data = new object[columnsInStruct];
for (int i = 1; ; i++)
{
if (readColumns == columnsInStruct)
{
break;
}
else if (lineSplit.Length < i)
{
throw new Exception(string.Format("Could not read all columns of line {0}", lineNR));
}
// Cannot count on the tabs ...
string columnText = lineSplit[i].Trim();
if (columnText == string.Empty) continue;
// Well, lets see if we can put it into the list
columnText = columnText.TrimEnd(',').Trim('"');
data[readColumns++] = columnText;
}
table.AddRow(data);
}
}
}
}
}
}