public void SupRemigration(MySQL_DB pMysql, PostgreSQL_DB pPostgres, string pDate = "1.1.2500")
{
MySqlDataReader dataReader = pMysql.Select("select id, name, link, type, web_home_webcast_banner, currentseason, facebook_link, ageasofyear, " +
"intopmenu, workshoponly from events; ");
pMysql.Message = "tbl_events - extraction(from table events) - START";
string pom1 = "null";
string pom2 = "null";
while (dataReader.Read())
{
pom1 = (dataReader[2].ToString() == "") ? "null" : "'" + dataReader[2].ToString() + "'";
pom2 = (dataReader[6].ToString() == "") ? "null" : "'" + dataReader[6].ToString() + "'";
pPostgres.Insert("insert into tbl_events(id, name, link, event_types_id, web_home_webcast_banner, facebook_link, " +
"ageasofyear,intopmenu, currentseason, " +
"workshoponly) values('" + dataReader[0] + "','" + dataReader[1].ToString().Replace("'", "''") + "'," + pom1 + ",'" + dataReader[3] + "','" + CheckBool(dataReader[4].ToString()) + "'," + pom2 + "" +
",'" + dataReader[7] + "','" + CheckBool(dataReader[8].ToString()) + "','" + dataReader[5] + "','" + CheckBool(dataReader[9].ToString()) + "');");
//pPostgres.Insert("insert into tbl_current_season(season_id, events_id, is_current_season) values('"+ dataReader[5] + "','"+ dataReader[0] + "',True);");
}
// this is DUMMY evenet with ID 6 - this event was missing in original DB
pPostgres.Insert("insert into tbl_events(id, event_types_id, name) values(6,2, 'DUMMY EVENT');");
pPostgres.Insert("insert into tbl_events(id, event_types_id, name) values(0,2,'DUMMY EVENT');");
pPostgres.Message = "tbl_events - extraction - FINISH";
}
public void Remigration(MySQL_DB pMysql, PostgreSQL_DB pPostgres, string pDate = "1.1.2500")
{
MySqlDataReader dataReader = pMysql.Select("select id, name, link, type, web_home_webcast_banner, currentseason, facebook_link, ageasofyear, " +
"intopmenu, workshoponly, update_date, insert_date from events; ");
pMysql.Message = "tbl_events - extraction(from table events) - START";
string pom1 = "null";
string pom2 = "null";
while (dataReader.Read())
{
// update part start HERE
if (!String.IsNullOrEmpty(dataReader["update_date"].ToString()) && Convert.ToDateTime(dataReader["update_date"].ToString()) >= Convert.ToDateTime(pDate))
{
List <string> MySQLData = new List <string> {
"null", dataReader["name"].ToString(), dataReader["link"].ToString(), dataReader["web_home_webcast_banner"].ToString(), dataReader["facebook_link"].ToString(),
dataReader["ageasofyear"].ToString(), dataReader["intopmenu"].ToString(), dataReader["currentseason"].ToString(), dataReader["workshoponly"].ToString()
};
List <string> PostgreSQLData = new List <string> {
"tbl_events", "name", "link", "web_home_webcast_banner", "facebook_link", "ageasofyear", "intopmenu", "currentseason", "workshoponly"
};
UpdatePostgreRow(dataReader["id"].ToString(), MySQLData, PostgreSQLData, pPostgres);
}
// update part END
}
pPostgres.Message = "tbl_events - extraction - FINISH";
}
public void SupRemigration(MySQL_DB pMysql, PostgreSQL_DB pPostgres, string pDate = "1.1.2500")
{
MySqlDataReader dataReader = pMysql.Select("select * from store_promocodes;");
pMysql.Message = "tbl_store_promocodes - extraction - START ";
while (dataReader.Read())
{
string TypeId = GetId("select id, name from tbl_promo_codes_type where name like '" + dataReader["type"] + "';", pPostgres);
pPostgres.Insert("insert into tbl_store_promocodes(id, name, description, value, charges, uses, active, expires, promo_codes_type_id) " +
"values(" + dataReader["id"] + ",'" + dataReader["name"] + "','" + dataReader["description"] + "'" +
"," + dataReader["value"] + "," + dataReader["charges"] + "," + dataReader["uses"] + "" +
"," + dataReader["active"] + ",'" + FromUnixTime(Convert.ToInt64(dataReader["expires"])) + "'," + TypeId + ");");
}
pPostgres.Message = "tbl_store_promocodes - extraction - FINISH";
}
