static void toXML()
{
EDbVendor dbVendor = EDbVendor.dbvoracle;
Console.WriteLine("Selected SQL dialect: " + dbVendor.ToString());
TGSqlParser sqlparser = new TGSqlParser(dbVendor);
sqlparser.sqltext = @"SELECT e.last_name AS name,
e.commission_pct comm,
e.salary * 12 ""Annual Salary""
FROM scott.employees AS e
WHERE e.salary > 1000
ORDER BY
e.first_name,
e.last_name; ";
int ret = sqlparser.parse();
if (ret == 0)
{
xmlVisitor xv2 = new xmlVisitor();
xv2.run(sqlparser);
Console.WriteLine(xv2.FormattedXml);
}
else
{
Console.WriteLine(sqlparser.Errormessage);
}
}
public void testToXML()
{
string sqltext = "MERGE INTO bonuses D\r\n" +
" USING(SELECT employee_id, salary, department_id FROM employees\r\n" +
" WHERE department_id = 80) S\r\n" +
" ON(D.employee_id = S.employee_id)\r\n" +
" WHEN MATCHED THEN UPDATE SET D.bonus = D.bonus + S.salary * .01\r\n" +
" WHEN NOT MATCHED THEN INSERT(D.employee_id, D.bonus)\r\n" +
" VALUES(S.employee_id, S.salary * 0.1);";
TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvoracle);
sqlparser.sqltext = sqltext;
sqlparser.parse();
xmlVisitor xv2 = new xmlVisitor();
xv2.run(sqlparser);
//Type type = MethodBase.GetCurrentMethod().DeclaringType;
//string _namespace = Assembly.GetExecutingAssembly().GetName().Name+"."+type.Namespace;
//string resourceName = _namespace + ".result.xml";
//Stream stream = Assembly.GetExecutingAssembly().GetManifestResourceStream(resourceName);
//byte[] arrFileData = new byte[stream.Length];
//stream.Read(arrFileData, 0, arrFileData.Length);
//stream.Close();
// Assert.IsTrue(xv2.FormattedXml.Equals(Encoding.Default.GetString(arrFileData)));
}
static void toXML(String sqlFilename, EDbVendor dbVendor)
{
Console.WriteLine("Selected SQL dialect: " + dbVendor.ToString());
TGSqlParser sqlparser = new TGSqlParser(dbVendor);
String inputFile = sqlFilename;
sqlparser.sqlfilename = inputFile;
string xmlFile = inputFile + ".xml";
int ret = sqlparser.parse();
if (ret == 0)
{
xmlVisitor xv2 = new xmlVisitor();
xv2.run(sqlparser);
xv2.writeToFile(xmlFile);
Console.WriteLine(xmlFile + " was generated!");
}
else
{
Console.WriteLine(sqlparser.Errormessage);
}
}
