/// <summary>
/// Inserts the row.
/// </summary>
/// <param name="insertObj">The insert object.</param>
/// <returns></returns>
public int InsertRow(object obj)
{
int result = 0;
InsertObject insertObject = null;
string sqlInsert = null;
try
{
insertObject = InsertObject.CreateInstance(obj);
sqlInsert = string.Format(StringFormat.SqlInsert, insertObject.Table, insertObject.Columns, insertObject.Values);
result = SQLiteQuery.ExecuteNonQuery(sqlInsert, this.Connection);
if (result > 0)
{
this.HandleByteArrayList(insertObject.Table, insertObject.ByteArrayColumns, insertObject.ByteArrayValues, insertObject.KeyString);
}
}
catch (Exception exception)
{
APILog.Error(this, "InsertRow", exception);
}
finally
{
insertObject = null;
sqlInsert = null;
}
return(result);
}
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// entry point //
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/// <summary>This is the program main entry point.</summary>
/// <param name="args">Command line arguments.</param>
static void Main(string[] args)
{
Orm.Connection = new SQLiteConnection("Data Source=test.sqlite;Version=3;");
Orm.Connection.Open();
Orm.Cache = new TrackingCache();
InsertObject.Show();
ModifyObject.Show();
WithFK.Show();
WithFKList.Show();
WithMToN.Show();
WithLazyList.Show();
WithCache.Show();
WithQuery.Show();
WithLocking.Show();
Orm.Connection.Close();
}
public IList <string> Calculate()
{
var sw = new StreamWriter(@"C:\Users\jyp1510\Documents\TestData\InsertStatements.txt", append: true);
var insertStrings = new List <string>();
if (!isFile)
{
var readerResults = reader.GetData(readTableName, noOfColumns, connectionString);
var insertObject = new InsertObject(readerResults, numericInsertFieldIndices);
var strings = insertObject.GetInsertStrings(hasIndex);
var cnt = 0;
foreach (var str in strings)
{
var insert = "INSERT INTO " + writeTableName + " VALUES (" + str + ");";
Console.WriteLine("Calculating : {0} {1}", insert, cnt);
sw.WriteLine(insert);
insertStrings.Add(insert);
cnt++;
}
sw.Close();
}
else
{
var readerResults = fileReader.GetData();
var insertObject = new InsertObject(readerResults, numericInsertFieldIndices);
var strings = insertObject.GetInsertStrings(hasIndex);
var cnt = 0;
foreach (var str in strings)
{
var insert = "INSERT INTO " + writeTableName + " VALUES (" + str + ");";
Console.WriteLine("Calculating : {0} {1}", insert, cnt);
sw.WriteLine(insert);
insertStrings.Add(insert);
cnt++;
}
sw.Close();
}
return(insertStrings);
}