【 在 xest 的大作中提到: 】
: 表太多。写的好痛苦,都是体力劳动~
: 有没有类似java的数据生成工具啊
这是自动工具生成的表结构:
extern T_PkgType CUT_PI_EXIT_tpl[];
typedef struct {
INT64 streaming_session_id;
int data_version;
INT64 txn_class;
INT64 txn_revision;
INT64 txn_ssn_a;
INT64 txn_ssn_b;
INT64 ols_txn_type;
INT4 settlement_date;
int application_validation_flags;
char host_name[31];
short multipart_txn_count;
short issuer_abort_reason;
INT64 acquirer_id;
INT64 destination_participant_id;
short account_type;
short portioned_txn_flag;
INT64 format_version;
INT64 txn_date_time;
INT64 source_participant_id;
INT64 device_id;
char sam_id[22];
INT64 udsn;
INT64 service_participant_id;
INT64 device_location;
INT64 device_ssn;
INT4 business_date;
short transaction_status;
int cd_set_version;
INT4 reconciliation_date;
short ud_type;
short ud_subtype;
short device_home_depot;
char mass_installation_id[8];
char iss_exception_proc_abrtd[2];
char iss_exception[2];
char iss_txn_reflection[2];
char cch_flags_txn_portion[2];
char cch_flags_txn_summarised[2];
char cch_flags_txn_forwarded[2];
char cch_flags_txn_apportioned[2];
char cch_txn_good_for_summaries[2];
char cch_no_further_proc[2];
char cch_exception[2];
char cch_txn_not_to_issuer[2];
char cch_txn_approved[2];
char exception_list[481];
INT64 card_issuer_id;
INT64 card_serial_number;
short card_type;
int card_life_cycle_count;
short card_action_sequence_number;
short num_rides;
short remaining_rides;
INT64 product_issuer_id;
int product_serial_number;
int product_type;
short product_action_sequence_number;
int ptsn;
short invoice_printed;
INT64 application_provider_id;
INT64 application_serial_number;
short application_personalise_cat;
short app_action_sequence_number;
short application_type;
short application_passenger_type;
INT64 key_version;
int route_line_id;
short route_direction;
short passenger_type;
int journey_type;
int current_location;
short number_of_passengers;
short number_of_zones;
INT64 previous_operator;
int trip_origin_location;
INT64 trip_previous_location;
char lav_sam_id[22];
INT64 lav_participant_id;
INT4 lav_date;
INT64 lav_txn_value;
short lav_remaining_rides;
int lav_ptsn;
short lav_method_of_payment;
short data_is_valid;
int number_of_entries;
char portion_to_participant_id[88];
char portion_value[88];
INT64 v_start_date_time;
INT64 v_end_date_time;
int v_duration;
INT64 v_distance_origin;
INT64 v_distance_destination;
int v_distance_distance;
short v_journey_period_journeys;
short v_journey_transfers;
char v_route_routes[71];
char v_location_locations[121];
int restrictions_day;
short restrictions_time;
int v_period_duration;
INT64 v_origin;
INT64 v_destination;
INT64 lav_pass_expiry_date_time;
INT64 pass_end_date_time;
INT64 transaction_value;
int currency_indicator_fin_details;
INT64 sales_tax;
INT64 discount;
int tax_rate;
short tax_code;
short number_of_payments;
short payment_method;
INT64 payment_value;
INT64 partial_transaction_value;
INT64 partial_sales_tax;
INT64 purse_remaining_value;
INT64 lav_remaining_value;
INT64 lav_amount_paid;
short invoice_not_printed;
INT64 entry_time;
short end_of_journey;
INT4 delay_date;
INT64 delay_station_location;
short delay_operation_mode;
INT64 value_per_ride;
short first_use_activation;
INT64 total_journey_amount;
short card_captured;
char file_name_and_record[101];
INT4 cms_settlement_date;
char flag;
INT64 use_time;
INT64 acc_time;
short o_acccode;
short d_acccode;
int route_line_count;
char line_desc[2048];
char line_passby_code[50];
short od_walk_time;
char acc_list[100];
char line_trip_route[100];
char sacccode_arr_dep[4001];
int od_route_sn;
int version_sn;
char method;
char ud_attr;
char changer[16];
} CUT_PI_EXIT_stu;
extern T_PkgType CM_UDPACKAGE_LIST_tpl[];
typedef struct {
char file_name[101];
INT4 settlement_date;
char receive_time[YEAR_TO_SEC_LEN];
int number_of_record;
char flag;
} CM_UDPACKAGE_LIST_stu;
extern T_PkgType CM_SETTLEMENT_DATE_tpl[];
typedef struct {
INT4 settlement_date;
char begin_time[YEAR_TO_SEC_LEN];
char end_time[YEAR_TO_SEC_LEN];
char eod_time[YEAR_TO_SEC_LEN];
char rpt_time[YEAR_TO_SEC_LEN];
char ud_finished;
char rpt_started;
char is_current;
char is_last;
} CM_SETTLEMENT_DATE_stu;
--
FROM 221.221.48.*