/*Use above created trailhead org for the below example. Create 3 objects Airplanes, Schedules, and Flights. 
* Airplane object has 2 fields Name of airplane, number of seats.chedules object has 4 fields, 
* start date, End date, Post Date (formula field Start Date minus 30- days) and lookup to Airplane object. 
* An Airplane can have multiple schedules. Flight object has lookup to schedules as well as Airplane and 2 
* additional fields as Flight start date and flight end date. 
* 
* Write a code that will run every day on Schedule and when the Post Date is less than or equal to today,
*  create a record of flight object. 
*/
global class BatchForAirplanesch implements Database.batchable<sObject>{
    global  Database.QueryLocator  start(Database.BatchableContext bc)
    {
        return Database.getQueryLocator([select id,name,FlightStartdate__c,FlightEnddate__c from  Flight__c where ScheduleForFlights__r.PostDate__c <= today]);
    }
    global void execute(Database.BatchableContext bc,List<Flight__c> Flightlist)
        
    {
        list<Flight__c> tasklist=new list<Flight__c>();
            

        for(Flight__c a:Flightlist)
        {
            Flight__c f=new flight__c();
            //if(f.ScheduleForFlights__r.PostDate__c <= system.today())
            {
                Airplane__c ap=new Airplane__c();
                ap.name='air1';
                ap.NumberOf_Seats__c=100;
                insert ap;
            

                schedule__c s=new schedule__c();
                s.name='sch1';
                s.EndDate__c=date.parse('3/4/2023');
                s.StartDate__c=date.parse('3/4/2022');
                s.AirplaneForSchedules__c=ap.id;
                insert s;
                
                
                f.Name='Flight100';
                f.FlightEnddate__c=date.parse('02/03/2022');
                f.FlightStartdate__c=date.parse('02/02/2022');
                f.AirplaneForFlights__c=ap.id;
                f.ScheduleForFlights__c= s.id;
                
             
                tasklist.add(f);}
            
        }
        
        insert tasklist;
      
    }
    global void finish(Database.BatchableContext bc)
    {
        
    } 
}

//Any record not inserted