public static SQLDefinition <TVTProgramme> GetProgrammeSQLDefinition()
{
var definition = new SQLDefinition <TVTProgramme>();
definition.Table = "tvt_programmes";
AddNamesSQLDefinition(definition);
definition.Add(x => x.FakeDescriptionDE);
definition.Add(x => x.FakeDescriptionEN);
definition.Add(x => x.ProductType);
definition.Add(x => x.ProgrammeType);
definition.Add(x => x.Country);
definition.Add(x => x.Year);
definition.Add(x => x.MainGenre);
definition.Add(x => x.SubGenre);
definition.Add(x => x.Blocks);
definition.Add(x => x.LiveHour);
definition.Add(x => x.DistributionChannel);
definition.Add(x => x.Flags);
definition.Add(x => x.TargetGroups);
definition.Add(x => x.ProPressureGroups);
definition.Add(x => x.ContraPressureGroups);
definition.Add(x => x.ImdbId);
definition.Add(x => x.TmdbId);
definition.Add(x => x.RottenTomatoesId);
definition.Add(x => x.ImageUrl);
//definition.Add( x => x.Director, null, "_id" );
//definition.Add( x => x.Participants, "participant1_id", null, 0 );
//definition.Add( x => x.Participants, "participant2_id", null, 1 );
//definition.Add( x => x.Participants, "participant3_id", null, 2 );
definition.Add(x => x.BettyBonus);
definition.Add(x => x.PriceMod);
definition.Add(x => x.CriticsRate);
definition.Add(x => x.ViewersRate);
definition.Add(x => x.BoxOfficeRate);
definition.Add(x => x.MasterId);
definition.Add(x => x.EpisodeIndex);
//Zusatzinfos
AdditionalFields(definition);
definition.AddSubDefinition(x => x.Staff, GetStaffSQLDefinition());
return(definition);
}
public static SQLDefinition <TVTNews> GetNewsSQLDefinition()
{
var definition = new SQLDefinition <TVTNews>();
definition.Table = "tvt_news";
AddNamesBasicSQLDefinition(definition);
definition.Add(x => x.NewsType);
definition.Add(x => x.NewsThreadId);
definition.Add(x => x.Genre);
definition.Add(x => x.Price);
definition.Add(x => x.Quality);
definition.Add(x => x.AvailableAfterDays);
definition.Add(x => x.YearRangeFrom);
definition.Add(x => x.YearRangeTo);
definition.Add(x => x.MinHoursAfterPredecessor);
definition.Add(x => x.TimeRangeFrom);
definition.Add(x => x.TimeRangeTo);
definition.Add(x => x.Resource1Type);
definition.Add(x => x.Resource2Type);
definition.Add(x => x.Resource3Type);
definition.Add(x => x.Resource4Type);
//definition.Add( x => x.Effects );
definition.Add(x => x.ProPressureGroups);
definition.Add(x => x.ContraPressureGroups);
//Zusatzinfos
AdditionalFields(definition);
definition.AddSubDefinition(x => x.Effects, GetNewsEffectSQLDefinition());
//definition.AfterInsert = new Action<MySqlConnection, TVTNews>( ( x, y ) =>
//{
//});
//var definition = GetNewsSQLDefinition();
//var sqlCommandText = "INSERT INTO tvt_news (" + definition.GetFieldNames( ',' ) + ") VALUES (" + definition.GetFieldNames( ',', "?" ) + ")";
//foreach ( var aNews in news )
//{
// var command = connection.CreateCommand();
// command.CommandText = sqlCommandText;
// var enumerator = definition.GetEnumerator();
// while ( enumerator.MoveNext() )
// {
// var field = enumerator.Current;
// command.Parameters.AddWithValue( "?" + field.FieldName, field.GetValue( aNews ) );
// }
// command.ExecuteNonQuery();
// if ( definition.AfterInsert != null )
// definition.AfterInsert( connection, aNews );
//}
return(definition);
}
