test-atis

开启mysql的远程连接的方法 mysql-noinstall-5.1.6-alpha-win32.zip

if (!$opt_skip_delete)				# Only used when testing
{
  print "Removing tables\n";
  $loop_time= new Benchmark;
  if ($opt_lock_tables)
  {
    $sth = $dbh->do("UNLOCK TABLES") || die $DBI::errstr;
  }
  for ($ti = 0; $ti <= $#table_names; $ti++)
  {
    my $table_name = $table_names[$ti];
    $sth = $dbh->do("drop table $table_name" . $server->{'drop_attr'});
  }

  $end_time=new Benchmark;
  print "Time to drop_table (" .($#table_names+1) . "): " .
    timestr(timediff($end_time, $loop_time),"all") . "\n";
}

if ($opt_fast && defined($server->{vacuum}))
{
  $server->vacuum(0,\$dbh);
}

####
#### End of benchmark
####

$dbh->disconnect;				# close connection

end_benchmark($start_time);


sub init_data
{
  @aircraft=
    $server->create("aircraft",
		    ["aircraft_code char(3) NOT NULL",
		     "aircraft_type char(64) NOT NULL",
		     "engines tinyint(1) NOT NULL",
		     "category char(10) NOT NULL",
		     "wide_body char(3) NOT NULL",
		     "wing_span float(6,2) NOT NULL",
		     "length1 float(6,2) NOT NULL",
		     "weight integer(7) NOT NULL",
		     "capacity smallint(3) NOT NULL",
		     "pay_load integer(7) NOT NULL",
		     "cruising_speed mediumint(5) NOT NULL",
		     "range_miles mediumint(5) NOT NULL",
		     "pressurized char(3) NOT NULL"],
		    ["PRIMARY KEY (aircraft_code)"]);
  @airline=
    $server->create("airline",
		    ["airline_code char(2) NOT NULL",
		     "airline_name char(64) NOT NULL",
		     "notes char(38) NOT NULL"],
		    ["PRIMARY KEY (airline_code)"]);
  @airport=
    $server->create("airport",
		    ["airport_code char(3) NOT NULL",
		     "airport_name char(40) NOT NULL",
		     "location char(36) NOT NULL",
		     "state_code char(2) NOT NULL",
		     "country_name char(25) NOT NULL",
		     "time_zone_code char(3) NOT NULL"],
		    ["PRIMARY KEY (airport_code)"]);
  @airport_service=
    $server->create("airport_service",
		    ["city_code char(4) NOT NULL",
		     "airport_code char(3) NOT NULL",
		     "miles_distant float(4,1) NOT NULL",
		     "direction char(3) NOT NULL",
		     "minutes_distant smallint(3) NOT NULL"],
		    ["PRIMARY KEY (city_code, airport_code)"]);
  @city=
    $server->create("city",
		    ["city_code char(4) NOT NULL",
		     "city_name char(25) NOT NULL",
		     "state_code char(2) NOT NULL",
		     "country_name char(25) NOT NULL",
		     "time_zone_code char(3) NOT NULL"],
		    ["PRIMARY KEY (city_code)"]);
  @class_of_service=
    $server->create("class_of_service",
		    ["class_code char(2) NOT NULL",
		     "rank tinyint(2) NOT NULL",
		     "class_description char(80) NOT NULL"],
		    ["PRIMARY KEY (class_code)"]);
  @code_description=
    $server->create("code_description",
		    ["code char(5) NOT NULL",
		     "description char(110) NOT NULL"],
		    ["PRIMARY KEY (code)"]);
  @compound_class=
    $server->create("compound_class",
		    ["fare_class char(3) NOT NULL",
		     "base_class char(2) NOT NULL",
		     "class_type char(10) NOT NULL",
		     "premium char(3) NOT NULL",
		     "economy char(3) NOT NULL",
		     "discounted char(3) NOT NULL",
		     "night char(3) NOT NULL",
		     "season_fare char(4) NOT NULL",
		     "class_days char(7) NOT NULL"],
		    ["PRIMARY KEY (fare_class)"]);
  @connect_leg=
    $server->create("connect_leg",
		    ["connect_code integer(8) NOT NULL",
		     "leg_number tinyint(1) NOT NULL",
		     "flight_code integer(8) NOT NULL"],
		    ["PRIMARY KEY (connect_code, leg_number, flight_code)"]);
  @connection=
    $server->create("fconnection",
		    ["connect_code integer(8) NOT NULL",
		     "from_airport char(3) NOT NULL",
		     "to_airport char(3) NOT NULL",
		     "departure_time smallint(4) NOT NULL",
		     "arrival_time smallint(4) NOT NULL",
		     "flight_days char(7) NOT NULL",
		     "stops tinyint(1) NOT NULL",
		     "connections tinyint(1) NOT NULL",
		     "time_elapsed smallint(4) NOT NULL"],
		    ["PRIMARY KEY (connect_code)",
		     "INDEX from_airport1 (from_airport)",
		     "INDEX to_airport1 (to_airport)"]);
  @day_name=
    $server->create("day_name",
		    ["day_code tinyint(1) NOT NULL",
		     "day_name char(9) NOT NULL"],
		    ["PRIMARY KEY (day_code)"]);
  @dual_carrier=
    $server->create("dual_carrier",
		    ["main_airline char(2) NOT NULL",
		     "dual_airline char(2) NOT NULL",
		     "low_flight smallint(4) NOT NULL",
		     "high_flight smallint(4) NOT NULL",
		     "fconnection_name char(64) NOT NULL"],
		    ["PRIMARY KEY (main_airline, dual_airline, low_flight)",
		     "INDEX main_airline1 (main_airline)"]);

  @fare=
    $server->create("fare",
		    ["fare_code char(8) NOT NULL",
		     "from_airport char(3) NOT NULL",
		     "to_airport char(3) NOT NULL",
		     "fare_class char(3) NOT NULL",
		     "fare_airline char(2) NOT NULL",
		     "restrict_code char(5) NOT NULL",
		     "one_way_cost float(7,2) NOT NULL",
		     "rnd_trip_cost float(8,2) NOT NULL"],
		    ["PRIMARY KEY (fare_code)",
		     "INDEX from_airport2 (from_airport)",
		     "INDEX to_airport2 (to_airport)"]);
  @flight=
    $server->create("flight",
		    ["flight_code integer(8) NOT NULL",
		     "flight_days char(7) NOT NULL",
		     "from_airport char(3) NOT NULL",
		     "to_airport char(3) NOT NULL",
		     "departure_time smallint(4) NOT NULL",
		     "arrival_time smallint(4) NOT NULL",
		     "airline_code char(2) NOT NULL",
		     "flight_number smallint(4) NOT NULL",
		     "class_string char(8) NOT NULL",
		     "aircraft_code char(3) NOT NULL",
		     "meal_code char(7) NOT NULL",
		     "stops tinyint(1) NOT NULL",
		     "dual_carrier char(1) NOT NULL",
		     "time_elapsed smallint(4) NOT NULL"],
		    ["PRIMARY KEY (flight_code)",
		     "INDEX from_airport3 (from_airport)",
		     "INDEX to_airport3 (to_airport)"]);
  @flight_class=
    $server->create("flight_class",
		    ["flight_code integer(8) NOT NULL",
		     "fare_class char(3) NOT NULL"],
		    ["PRIMARY KEY (flight_code, fare_class)"]);
  @flight_day=
    $server->create("flight_day",
		    ["day_mask char(7) NOT NULL",
		     "day_code tinyint(1) NOT NULL",
		     "day_name char(9) NOT NULL"],
		    ["PRIMARY KEY (day_mask, day_code)"]);
  @flight_fare=
    $server->create("flight_fare",
		    ["flight_code integer(8) NOT NULL",
		     "fare_code char(8) NOT NULL"],
		    ["PRIMARY KEY (flight_code, fare_code)"]);
  @food_service=
    $server->create("food_service",
		    ["meal_code char(4) NOT NULL",
		     "meal_number tinyint(1) NOT NULL",
		     "meal_class char(10) NOT NULL",
		     "meal_description char(10) NOT NULL"],
		    ["PRIMARY KEY (meal_code, meal_number, meal_class)"]);
  @ground_service=
    $server->create("ground_service",
		    ["city_code char(4) NOT NULL",
		     "airport_code char(3) NOT NULL",
		     "transport_code char(1) NOT NULL",
		     "ground_fare float(6,2) NOT NULL"],
		    ["PRIMARY KEY (city_code, airport_code, transport_code)"]);
  @time_interval=
    $server->create("time_interval",
		    ["period char(20) NOT NULL",
		     "begin_time smallint(4) NOT NULL",
		     "end_time smallint(4) NOT NULL"],
		    ["PRIMARY KEY (period, begin_time)"]);
  @month_name=
    $server->create("month_name",
		    ["month_number tinyint(2) NOT NULL",
		     "month_name char(9) NOT NULL"],
		    ["PRIMARY KEY (month_number)"]);
  @restrict_carrier=
    $server->create("restrict_carrier",
		    ["restrict_code char(5) NOT NULL",
		     "airline_code char(2) NOT NULL"],
		    ["PRIMARY KEY (restrict_code, airline_code)"]);
  @restrict_class=
    $server->create("restrict_class",
		    ["restrict_code char(5) NOT NULL",
		     "ex_fare_class char(12) NOT NULL"],
		    ["PRIMARY KEY (restrict_code, ex_fare_class)"]);
  @restriction=
    $server->create("restriction",
		    ["restrict_code char(5) NOT NULL",
		     "application char(80) NOT NULL",
		     "no_discounts char(80) NOT NULL",
		     "reserve_ticket smallint(3) NOT NULL",
		     "stopovers char(1) NOT NULL",
		     "return_min smallint(3) NOT NULL",
		     "return_max smallint(3) NOT NULL"],
		    ["PRIMARY KEY (restrict_code)"]);
  @state=
    $server->create("state",
		    ["state_code char(2) NOT NULL",
		     "state_name char(25) NOT NULL",
		     "country_name char(25) NOT NULL"],
		    ["PRIMARY KEY (state_code)"]);
  @stop=
    $server->create("stop1",
		    ["flight_code integer(8) NOT NULL",
		     "stop_number tinyint(1) NOT NULL",
		     "stop_flight integer(8) NOT NULL"],
		    ["PRIMARY KEY (flight_code, stop_number)"]);
  @time_zone=
    $server->create("time_zone",
		    ["time_zone_code char(3) NOT NULL",
		     "time_zone_name char(32) NOT NULL"],
		    ["PRIMARY KEY (time_zone_code, time_zone_name)"]);
  @transport=
    $server->create("transport",
		    ["transport_code char(1) NOT NULL",
		     "transport_desc char(32) NOT NULL"],
		    ["PRIMARY KEY (transport_code)"]);

# Avoid not used warnings

  @tables =
    (\@aircraft, \@airline, \@airport, \@airport_service,
     \@city, \@class_of_service, \@code_description,
     \@compound_class, \@connect_leg, \@connection, \@day_name,
     \@dual_carrier, \@fare, \@flight, \@flight_class, \@flight_day,
     \@flight_fare, \@food_service, \@ground_service, \@time_interval,
     \@month_name,
     \@restrict_carrier, \@restrict_class, \@restriction, \@state, \@stop,
     \@time_zone, \@transport);

  @table_names =
    ("aircraft", "airline", "airport", "airport_service",
     "city", "class_of_service", "code_description",
     "compound_class", "connect_leg", "fconnection", "day_name",
     "dual_carrier", "fare", "flight", "flight_class", "flight_day",
     "flight_fare", "food_service", "ground_service", "time_interval",
     "month_name",
     "restrict_carrier", "restrict_class", "restriction", "state", "stop1",
     "time_zone", "transport");

# Alias used in joins
  @extra_names=("airport as from_airport","airport as to_airport");
}