/// <inheritdoc />
/// <summary>
/// 获取表的所有字段名及字段类型
/// </summary>
public List <Dictionary <string, string> > GetAllColumns(string tableName)
{
var sqliteHelper = new SqLiteHelper();
var dt = sqliteHelper.Query("PRAGMA table_info('" + tableName + "')");
var result = new List <Dictionary <string, string> >();
foreach (DataRow dr in dt.Rows)
{
var dic = new Dictionary <string, string>
{
{ "columns_name", dr["name"].ToString() },
{ "notnull", dr["notnull"].ToString() == "NO" ? "1" : "0" },
{ "comments", "" }
};
var dataType = dr["type"].ToString();
var pos = dataType.IndexOf("(", StringComparison.Ordinal);
if (pos != -1)
{
dataType = dataType.Substring(0, pos);
}
dic.Add("data_type", dataType);
dic.Add("data_scale", "");
dic.Add("data_precision", "");
dic.Add("constraint_type", dr["pk"].ToString() != "0" ? "P" : "");
result.Add(dic);
}
return(result);
}
/// <inheritdoc />
/// <summary>
/// 获取数据库名
/// </summary>
public List <Dictionary <string, string> > GetAllTables()
{
var sqliteHelper = new SqLiteHelper();
var dt = sqliteHelper.Query("select tbl_name from sqlite_master where type='table'");
return((from DataRow dr in dt.Rows select new Dictionary <string, string> {
{ "table_name", dr["tbl_name"].ToString() }, { "comments", "" }
}).ToList());
}
/// <inheritdoc />
/// <summary>
/// 获取表的所有字段名及字段类型
/// </summary>
public List <Dictionary <string, string> > GetAllColumns(string tableName)
{
var sqliteHelper = new SqLiteHelper();
var dt = sqliteHelper.Query("PRAGMA table_info('" + tableName + "')");
return((from DataRow dr in dt.Rows
select new Dictionary <string, string>
{
{ "columns_name", dr["name"].ToString() },
{ "notnull", dr["notnull"].ToString() == "1" ? "1" : "0" },
{ "comments", "" },
{ "data_type", "string" },
{ "data_scale", "" },
{ "data_precision", "" },
{ "constraint_type", dr["pk"].ToString() == "1" ? "P" : "" }
}).ToList());
}
