private void GetTableStructure(string table_name)
{
tableModel.Clear();
SqliteConnection conn = (SqliteConnection)sqlLiteDal.GetConnect();
SqliteDataReader dr = null;
try {
//conn.Open();
using (SqliteCommand cmd = conn.CreateCommand())
{
cmd.CommandText = String.Format("PRAGMA table_info( '{0}' );", table_name);
dr = cmd.ExecuteReader();
}
if (dr.HasRows)
{
//int fieldcount = dr.FieldCount;
while (dr.Read())
{
int cid = Convert.ToInt32(dr[0]);
string name = dr[1].ToString();
string type = dr[2].ToString();
bool notnull = Convert.ToBoolean(dr[3]);
string dfltValue = dr[4].ToString();
bool pk = Convert.ToBoolean(dr[5]);
tableModel.AppendValues(cid, name, type, notnull.ToString(), dfltValue, pk.ToString());
}
}
} catch (Exception ex) {
MessageDialogs ms = new MessageDialogs(MessageDialogs.DialogButtonType.Ok, "Error", ex.Message, MessageType.Error, null);
ms.ShowDialog();
} finally {
if (dr != null)
{
dr.Close();
}
dr = null;
conn.Close();
conn = null;
}
}
private void GetTableStructure()
{
fieldsStore.Clear();
fields.Clear();
SqliteConnection conn = (SqliteConnection)sqlLiteDal.GetConnect();
SqliteDataReader dr = null;
string sql = String.Format("PRAGMA table_info( '{0}' );", tableName);
//DataTable dt = null;
try {
//dt = sqlLiteDal.RunSqlReader(sql);
using (SqliteCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
dr = cmd.ExecuteReader();
}
if (dr.HasRows)
{
while (dr.Read())
{
string name = dr[1].ToString();
string type = dr[2].ToString();
bool notnull = Convert.ToBoolean(dr[3]);
string dfltValue = dr[4].ToString();
//bool pk = Convert.ToBoolean(dr[5]);
FieldTable ft = new FieldTable(name, type);
ft.NotNULL = notnull;
ft.DefaultValue = dfltValue;
fields.Add(ft);
fieldsStore.AppendValues(name, type, notnull.ToString(), dfltValue, ft);
}
}
} catch (Exception ex) {
MessageDialogs ms = new MessageDialogs(MessageDialogs.DialogButtonType.Ok, "Error", ex.Message, MessageType.Error, this);
ms.ShowDialog();
} finally {
if (dr != null)
{
dr.Close();
}
dr = null;
conn.Close();
conn = null;
}
}
public void GetCompletedData()
{
ListDataKeywords = new List <CompletionData>();
ListDataTypes = new List <CompletionData>();
ListDataMembers = new List <CompletionData>();
ListDataProperties = new List <CompletionData>();
ListDataEvents = new List <CompletionData>();
AllCompletionRepeat = new CompletionDataList();
AllCompletionOnlyOne = new CompletionDataList();
NewCompletion = new CompletionDataList();
DotCompletion = new CompletionDataList();
if (!System.IO.File.Exists(FilePath))
{
Tool.Logger.Error("CodeCompletion file not exist!", null);
return;
}
SqlLiteDal sqlLiteDal = new SqlLiteDal(FilePath);
SqliteConnection dbcon = (SqliteConnection)sqlLiteDal.GetConnect(); //GetConnect();
if (dbcon == null)
{
return;
}
SqliteCommand dbcmd = dbcon.CreateCommand();
string sql = "SELECT * FROM completed;";
dbcmd.CommandText = sql;
SqliteDataReader reader = null;
try {
reader = dbcmd.ExecuteReader();
int numberCollumns = reader.FieldCount;
if (numberCollumns < 5)
{
return;
}
while (reader.Read())
{
CompletionData cd;
string name = reader.GetValue(1).ToString();
string signature = reader.GetValue(2).ToString();
int type = reader.GetInt32(3);
string parent = reader.GetValue(4).ToString();
string summary = "";
string returnType = "";
if (numberCollumns >= 6)
{
summary = reader.GetValue(5).ToString();
}
if (numberCollumns >= 7)
{
returnType = reader.GetValue(6).ToString();
}
cd = new CompletionData(name, null, signature, name, 1, parent, returnType);
cd.Signature = signature;
if (!string.IsNullOrEmpty(summary))
{
cd.Description = cd.Description + Environment.NewLine + summary; //+Environment.NewLine;
}
if (type == (int)CompletionDataTyp.keywords)
{
ListDataKeywords.Add(cd);
}
else if (type == (int)CompletionDataTyp.members)
{
ListDataMembers.Add(cd);
}
else if (type == (int)CompletionDataTyp.types)
{
ListDataTypes.Add(cd);
}
else if (type == (int)CompletionDataTyp.properties)
{
ListDataProperties.Add(cd);
}
else if (type == (int)CompletionDataTyp.events)
{
ListDataEvents.Add(cd);
}
}
} catch (Exception ex) {
Console.WriteLine(ex.Message);
Tool.Logger.Error("ERROR LOADING COMPLETED CACHE");
Tool.Logger.Error(ex.Message);
//MessageDialogs ms = new MessageDialogs(MessageDialogs.DialogButtonType.Ok, "Error", ex.Message, MessageType.Error);
//ms.ShowDialog();
} finally {
if (reader != null)
{
reader.Close();
}
reader = null;
dbcmd.Dispose();
dbcmd = null;
dbcon.Close();
dbcon = null;
}
AllCompletionRepeat = GetCompletionData(CompletionTyp.allType, false);
AllCompletionOnlyOne = GetCompletionData(CompletionTyp.allType, true);
NewCompletion = GetCompletionData(CompletionTyp.newType, true);
DotCompletion = GetCompletionData(CompletionTyp.dotType, true);
IncludeCompletion = GetCompletionData(CompletionTyp.includeType, true);
}
private void GetTableData(string table_name)
{
tableModel.Clear();
foreach (TreeViewColumn col in treeView.Columns)
{
treeView.RemoveColumn(col);
}
SqliteConnection dbcon = (SqliteConnection)sqlLiteDal.GetConnect(); //GetConnect();
if (dbcon == null)
{
return;
}
SqliteCommand dbcmd = dbcon.CreateCommand();
string sql = String.Format("SELECT * FROM '{0}';", table_name);
dbcmd.CommandText = sql;
SqliteDataReader reader = null;
try {
reader = dbcmd.ExecuteReader();
int numberCollumns = reader.FieldCount;
if (numberCollumns < 1)
{
return;
}
Type[] type = new Type[numberCollumns];
CellRendererText rendererText = new CellRendererText();
for (int i = 0; i < numberCollumns; i++)
{
type[i] = typeof(string);
TreeViewColumn column = new TreeViewColumn(reader.GetName(i).Replace("_", "__"), rendererText, "text", i);
column.SortColumnId = i;
column.Resizable = true;
column.Reorderable = true;
treeView.AppendColumn(column);
}
tableModel = new ListStore(type);
while (reader.Read())
{
string[] obj = new string[numberCollumns];
for (int j = 0; j < numberCollumns; j++)
{
obj[j] = reader.GetValue(j).ToString();
}
tableModel.AppendValues(obj);
}
treeView.Model = tableModel;
} catch (Exception ex) {
MessageDialogs ms = new MessageDialogs(MessageDialogs.DialogButtonType.Ok, "Error", ex.Message, MessageType.Error);
ms.ShowDialog();
} finally {
if (reader != null)
{
reader.Close();
}
reader = null;
dbcmd.Dispose();
dbcmd = null;
dbcon.Close();
dbcon = null;
}
}
