Exemplo n.º 1
0
void
odbc_cat_init (void)
{

  bif_define_typed ("_sql_columns", bif_sql_columns, &bt_any);
  bif_define_typed ("_sql_tables", bif_sql_tables, &bt_any);
  bif_define_typed ("_sql_primary_keys", bif_sql_primary_keys, &bt_any);
  bif_define_typed ("_sql_foreign_keys", bif_sql_foreign_keys, &bt_any);
  bif_define_typed ("sql_special_columns", bif_sql_special_columns, &bt_any);
  bif_define_typed ("_sql_statistics", bif_sql_statistics, &bt_any);
  bif_define_typed ("sql_data_sources", bif_sql_data_sources, &bt_any);
  bif_define_typed ("sql_escape_meta_identifier", bif_sql_escape_meta_identifier, &bt_any);
  bif_define_typed ("sql_unescape_meta_identifier", bif_sql_unescape_meta_identifier, &bt_any);
  bif_define_typed ("_sql_procedures", bif_sql_procedures, &bt_any);
  bif_define_typed ("_sql_procedure_columns", bif_sql_procedure_columns, &bt_any);
  bif_define_typed ("sql_transact", bif_sql_transact, &bt_integer);

  bif_define ("sql_gettypeinfo", bif_sql_gettypeinfo);
  bif_define ("sql_get_type_info", bif_sql_gettypeinfo);  /* backward compatibility */
  bif_define ("vd_autocommit", bif_vd_autocommit);

#ifdef HAVE_ODBCINST_H
  bif_define_typed ("sql_remove_dsn_from_ini", bif_sql_remove_dsn_from_ini, &bt_any);
  bif_define_typed ("sql_get_installed_drivers", bif_sql_get_installed_drivers, &bt_any);
  bif_define_typed ("sql_config_data_sources", bif_sql_config_data_sources, &bt_any);
  bif_define_typed ("sql_get_private_profile_string", bif_sql_get_private_profile_string, &bt_any);
  bif_define_typed ("sql_write_private_profile_string", bif_sql_write_private_profile_string, &bt_any);
  bif_define_typed ("sql_write_file_dsn", bif_sql_write_file_dsn, &bt_any);
  bif_define_typed ("sql_driver_connect", bif_sql_driver_connect, &bt_any);
#endif

  sqls_define_vdb ();
}
Exemplo n.º 2
0
void
bif_date_init ()
{
  bif_define_typed ("dayname", bif_dayname, &bt_varchar);
  bif_define_typed ("monthname", bif_monthname, &bt_varchar);
  bif_define_typed ("dayofmonth", bif_day, &bt_integer);
  bif_define_typed ("dayofweek", bif_dayofweek, &bt_integer);
  bif_define_typed ("dayofyear", bif_dayofyear, &bt_integer);
  bif_define_typed ("quarter", bif_quarter, &bt_integer);
  bif_define_typed ("week", bif_week, &bt_integer);
  bif_define_typed ("month", bif_month, &bt_integer);
  bif_define_typed ("year", bif_year, &bt_integer);
  bif_define_typed ("hour", bif_hour, &bt_integer);
  bif_define_typed ("minute", bif_minute, &bt_integer);
  bif_define_typed ("second", bif_second, &bt_integer);
  bif_define_typed ("timezone", bif_timezone, &bt_integer);
  bif_define_typed ("rdf_now_impl", bif_timestamp, &bt_timestamp);
  bif_define_typed ("rdf_year_impl", bif_year, &bt_integer);
  bif_define_typed ("rdf_month_impl", bif_month, &bt_integer);
  bif_define_typed ("rdf_day_impl", bif_day, &bt_integer);
  bif_define_typed ("rdf_hours_impl", bif_hour, &bt_integer);
  bif_define_typed ("rdf_minutes_impl", bif_minute, &bt_integer);
  bif_define_typed ("nasa_tjd_number", bif_nasa_tjd_number, &bt_integer);
  bif_define_typed ("nasa_tjd_fraction", bif_nasa_tjd_fraction, &bt_double);
  bif_define_typed ("merge_nasa_tjd_to_datetime", bif_merge_nasa_tjd_to_datetime, &bt_datetime);

  bif_define_typed ("now", bif_timestamp, &bt_timestamp);	/* This is standard name */
  bif_define_typed ("getdate", bif_timestamp, &bt_datetime);	/* This is standard name? */
  bif_define_typed ("curdate", bif_curdate, &bt_date);	/* This is standard fun. */
  bif_define_typed ("curtime", bif_curtime, &bt_time);	/* This is standard fun. */
  bif_define_typed ("curdatetime", bif_curdatetime, &bt_timestamp);	/* This is our own. */
  bif_define_typed ("datestring", bif_date_string, &bt_varchar);
  bif_define_typed ("datestring_GMT", bif_date_string_GMT, &bt_varchar);
  bif_define_typed ("stringdate", bif_string_timestamp, &bt_datetime);
  bif_define_typed ("d", bif_string_date, &bt_date);	/* Two aliases for ODBC */
  bif_define_typed ("ts", bif_string_timestamp, &bt_timestamp);	/* brace literals */
  bif_define_typed ("stringtime", bif_string_time, &bt_time);	/* New one. */
  bif_define_typed ("t", bif_string_time, &bt_time);	/* An alias for ODBC */

  bif_define_typed ("get_timestamp", bif_timestamp, &bt_timestamp);
  bif_define_typed ("dateadd", bif_date_add, &bt_timestamp);
  bif_define_typed ("datediff", bif_date_diff, &bt_integer);
  bif_define_typed ("timestampadd", bif_timestampadd, &bt_timestamp);
  bif_define_typed ("timestampdiff", bif_timestampdiff, &bt_integer);
  bif_define_typed ("dt_set_tz", bif_dt_set_tz, &bt_timestamp);
  bif_define_typed ("__extract", bif_extract, &bt_integer);
  dt_init ();
}