static void Main(string[] args)
{
var db = new CCSubmitDirect();
var creator = new MysqlModelsGenerator(db);
creator.GenerateFile("tm_action_account", "ActionAccount", @"D:\github\CCMonkeys\_rest\output");
creator.GenerateFile("tm_admin", "Admin", @"D:\github\CCMonkeys\_rest\output");
creator.GenerateFile("tm_action", "Action", @"D:\github\CCMonkeys\_rest\output");
creator.GenerateFile("tm_admin_session", "AdminSession", @"D:\github\CCMonkeys\_rest\output");
creator.GenerateFile("tm_country", "Country", @"D:\github\CCMonkeys\_rest\output");
creator.GenerateFile("tm_country_used", "CountryUsed", @"D:\github\CCMonkeys\_rest\output");
creator.GenerateFile("tm_email_blacklist", "EmailBlacklist", @"D:\github\CCMonkeys\_rest\output");
creator.GenerateFile("tm_lander", "Lander", @"D:\github\CCMonkeys\_rest\output");
creator.GenerateFile("tm_landertype", "LanderType", @"D:\github\CCMonkeys\_rest\output");
creator.GenerateFile("tm_lead", "Lead", @"D:\github\CCMonkeys\_rest\output");
creator.GenerateFile("tm_lead_history", "LeadHistory", @"D:\github\CCMonkeys\_rest\output");
creator.GenerateFile("tm_prelander", "Prelander", @"D:\github\CCMonkeys\_rest\output");
creator.GenerateFile("tm_prelandertype", "PrelanderType", @"D:\github\CCMonkeys\_rest\output");
creator.GenerateFile("tm_provider", "Provider", @"D:\github\CCMonkeys\_rest\output");
creator.GenerateFile("tm_session", "Session", @"D:\github\CCMonkeys\_rest\output");
creator.GenerateFile("tm_session_data", "SessionData", @"D:\github\CCMonkeys\_rest\output");
creator.GenerateFile("tm_session_request", "SessionRequest", @"D:\github\CCMonkeys\_rest\output");
creator.GenerateFile("tm_session_type", "SessionType", @"D:\github\CCMonkeys\_rest\output");
creator.GenerateFile("tm_test", "Test", @"D:\github\CCMonkeys\_rest\output");
creator.GenerateFile("tm_user", "User", @"D:\github\CCMonkeys\_rest\output");
}
// basic implementation of framework
public SnippetContainers()
{
CCSubmitDirect db = new CCSubmitDirect();
int index = 1;
string q = "SELECT * FROM [].tm_lead WHERE msisdn != '' ORDER BY leadid DESC LIMIT 5";
foreach (var elem in db.LoadEnumerable(q))
{
Console.WriteLine(index + ": " + elem.GetString("leadid") + " - " + elem.GetString("email"));
index++;
}
Console.WriteLine();
Console.WriteLine();
Console.WriteLine();
Console.WriteLine();
DirectContainer dc = db.LoadContainer(q);
foreach (var elem in dc.Rows)
{
Console.WriteLine(index + ": " + elem.GetString("leadid") + " - " + elem.GetString("email"));
index++;
}
db.Dispose();
}
static void Main(string[] args)
{
CCSubmitDirect db = new CCSubmitDirect();
//Test();
Console.WriteLine(db.LoadString("SELECT guid FROM [].tm_action WHERE actionid=5"));
Console.ReadKey();
}
public TestClass()
{
CCSubmitDirect db = new CCSubmitDirect();
PrelanderTypeDM dm = new PrelanderTypeDM(db)
{
Name = "test1",
Description = "ok?"
};
dm.Insert();
}
public static async void Test()
{
CCSubmitDirect db = new CCSubmitDirect();
foreach (var entry in
db.Query <ClientDM>()
.Additional("ORDER BY clientid DESC LIMIT 150")
.LoadEnumerable())
{
int a = 0;
Console.WriteLine(string.Format("{0} {1} {2}", entry.clickid, entry.email, entry.firstname));
}
}
public PrelanderTypeDM(CCSubmitDirect db) : base("tm_prelandertype", "prelandertypeid", db)
{
}