public static void GenerateInsertFixedData(ITableSource table, TextWriter tw, ISqlDialect dialect)
{
ITableStructure ts = table.LoadTableStructure(TableStructureMembers.All);
ISqlDumper dmp = dialect.CreateDumper(tw);
GenerateInsertFixedData(dmp, ts);
}
//public static List<string> GetBaseColumns(this IEnumerable<DmlfColumnRef> cols)
//{
// var res = new List<string>();
// foreach (var col in cols)
// {
// if (col.Source != null && col.Source.Alias != "basetbl") continue;
// res.Add(col.ColumnName);
// }
// return res;
//}
//public static int GetBaseOrdinal(this IEnumerable<DmlfColumnRef> cols, string colname)
//{
// int index = 0;
// foreach (var col in cols)
// {
// if (col.Source == null || col.Source.Alias == "basetbl")
// {
// if (col.ColumnName == colname) return index;
// }
// index++;
// }
// return -1;
//}
public static string ToSql(this IDmlfNode node, ISqlDialect dialect, IDmlfHandler handler)
{
var sw = new StringWriter();
var dmp = dialect.CreateDumper(sw);
node.GenSql(dmp, handler);
return(sw.ToString());
}
public virtual void OpenFile()
{
if (m_fw != null)
{
return;
}
m_fw = new StreamWriter(FileName);
m_formatProps.DumpWriterConfig = Config;
GetFormatProps(m_formatProps);
//if (m_formatProps.DumpFileBegin != null) m_fw.Write(m_formatProps.DumpFileBegin);
m_dmp = m_dialect.CreateDumper(m_fw, m_formatProps);
WriteHeader();
}
public static string GenerateScript(this ISqlDialect dialect, Action <ISqlDumper> script, SqlFormatProperties props)
{
StringWriter sw = new StringWriter();
ISqlDumper dmp;
if (dialect != null)
{
dmp = dialect.CreateDumper(sw, props);
}
else
{
dialect = new GenericDialect();
dmp = new InfoSqlDumper(new SqlOutputStream(dialect, sw, props), dialect, props);
}
script(dmp);
return(sw.ToString());
}
private void DoRefreshPreview()
{
var sw = new StringWriter();
var dmp = m_dialect.CreateDumper(sw, m_formatProps);
if (m_sqlgen is IAppObjectSqlGenerator)
{
foreach (var obj in m_objs)
{
if (m_db != null)
{
((IAppObjectSqlGenerator)m_sqlgen).GenerateSql(m_db, obj.GetFullDatabaseRelatedName(), dmp, m_dialect);
}
else
{
((IAppObjectSqlGenerator)m_sqlgen).GenerateSql(obj, dmp, m_dialect);
}
}
}
if (m_sqlgen is IDataSqlGenerator)
{
if (((IDataSqlGenerator)m_sqlgen).IsRowEnumerator)
{
var preview = m_rowsExtractor.GetPreviewRows(m_previewRows);
int rowcount = m_rowsExtractor.GetRowCount();
dmp.Put("-- All row count: %s, preview row count: %s\n\n", rowcount, preview.Rows.Count);
foreach (var row in preview.Rows)
{
((IDataSqlGenerator)m_sqlgen).GenerateSqlRow(row, dmp, m_dataFrame.GetSelectedColumns());
}
}
else
{
((IDataSqlGenerator)m_sqlgen).GenerateSql(dmp);
}
}
m_preview = sw.ToString();
}
public void CreateDatabase(IDatabaseSource db, TextWriter tw, ISqlDialect dialect)
{
ISqlDumper dmp = dialect.CreateDumper(tw);
dmp.CreateDatabase(db.DatabaseName, null);
}
public void CreateReferences(IDatabaseSource conn, TextWriter tw, ISqlDialect dialect)
{
ISqlDumper dmp = dialect.CreateDumper(tw);
CreateReferences(conn, dmp, dialect);
}
public void CreateSpecificObjects(IDatabaseSource conn, TextWriter tw, ISqlDialect dialect)
{
ISqlDumper dmp = dialect.CreateDumper(tw);
CreateSpecificObjects(conn, dmp, dialect);
}
public static ISqlDumper CreateDumper(this ISqlDialect dialect, TextWriter tw, SqlFormatProperties props)
{
SqlOutputStream sqlo = new SqlOutputStream(dialect, tw, props);
return(dialect.CreateDumper(sqlo, props));
}
public virtual ISqlDumper CreateDumper(ISqlOutputStream stream, SqlFormatProperties props)
{
return(m_dialect.CreateDumper(stream, props));
}