tripal_core.module 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417
  1. <?php
  2. /**
  3. * @file
  4. * The Tripal Core module
  5. */
  6. /**
  7. * @defgroup tripal_modules Tripal Modules
  8. * @{
  9. * All documented functions for the various Tripal Modules excluding API functions and Views Integration functions.
  10. * @}
  11. */
  12. /**
  13. * @defgroup tripal_api Tripal API
  14. * @{
  15. * Provides an application programming interface (API) for Tripal
  16. *
  17. * The Tripal API currently provides generic insert/update/select functions for all chado content as
  18. * well as some module specific functions that insert/update/delete/select specific chado content.
  19. *
  20. * This API is currently in its infancy and some necessary functions might be missing. If you find
  21. * a missing function that you think should be included go to the sourceforge feature request
  22. * page and request it's inclusion in the API. Such feature requests with a working function
  23. * definition will be given priority.
  24. * @}
  25. */
  26. /**
  27. * @defgroup tripal_core_api Core Module API
  28. * @ingroup tripal_api
  29. */
  30. /**
  31. * @defgroup tripal_core Tripal Core Module
  32. * @ingroup tripal_modules
  33. */
  34. require_once "api/tripal_core_chado.api.inc";
  35. require_once "api/tripal_core_files.api.inc";
  36. require_once "api/tripal_core_ahah.api.inc";
  37. require_once "api/tripal_core_custom_tables.api.inc";
  38. require_once "api/tripal_core_jobs.api.inc";
  39. require_once "api/tripal_core_mviews.api.inc";
  40. require_once "api/tripal_core_misc.api.inc";
  41. require_once "includes/jobs.inc";
  42. require_once "includes/mviews.inc";
  43. require_once "includes/custom_tables.inc";
  44. require_once "includes/chado_install.inc";
  45. require_once "includes/form_elements.inc";
  46. /**
  47. * Implements hook_init().
  48. * Used to set the search_path, create default content and set default variables.
  49. *
  50. * @ingroup tripal_core
  51. */
  52. function tripal_core_init() {
  53. global $base_url;
  54. // add javascript files
  55. drupal_add_js(drupal_get_path('module', 'tripal_core') . '/theme/js/tripal_core.js');
  56. drupal_add_css(drupal_get_path('module', 'tripal_core') . '/theme/css/tripal_core.css');
  57. // create the 'tripal' controlled volcabulary in chado but only if it doesn't already exist, and
  58. // only if the chado database is present.
  59. if (tripal_core_is_chado_installed()) {
  60. // make sure the current version of chado is set
  61. tripal_core_set_chado_version();
  62. // if the Tripal cv is missing then add
  63. $results = chado_query("SELECT * FROM {cv} WHERE name = 'tripal'");
  64. $tripal_cv = $results->fetchObject();
  65. if (!$tripal_cv) {
  66. $results = chado_query(
  67. "INSERT INTO {cv} (name,definition) " .
  68. "VALUES ('tripal', 'Terms used by Tripal for modules to manage data such as that stored in property tables like featureprop, analysisprop, etc')"
  69. );
  70. }
  71. // if the Tripal db is missing then add it
  72. $results = chado_query("SELECT * FROM {db} WHERE name = 'tripal'");
  73. $tripal_db = $results->fetchObject();
  74. if (!$tripal_db) {
  75. $results = chado_query(
  76. "INSERT INTO {db} (name,description) " .
  77. "VALUES ('tripal', 'Used as a database placeholder for tripal defined objects such as tripal cvterms')"
  78. );
  79. }
  80. }
  81. // add some variables for all javasript to use for building URLs
  82. global $base_url;
  83. $theme_dir = drupal_get_path('theme', 'tripal');
  84. $clean_urls = variable_get('clean_url', 0);
  85. drupal_add_js(
  86. " var baseurl = '$base_url';
  87. var themedir = '$theme_dir';
  88. var isClean = $clean_urls;",
  89. 'inline', 'header');
  90. // make sure the date time settings are the way Tripal will insert them
  91. // otherwise PostgreSQL version that may have a different datestyle setting
  92. // will fail when inserting or updating a date column in a table.
  93. db_query("SET DATESTYLE TO :style", array(':style' => 'MDY'));
  94. // If we want AHAH elements on the node forms (e.g. chado_pub form) then we need to include
  95. // the node.pages file. Otherwise this error message is given:
  96. //
  97. // warning: call_user_func_array() expects parameter 1 to be a valid callback,
  98. // function 'node_form' not found or invalid function name
  99. // in /var/www/includes/form.inc on line 382.
  100. module_load_include('inc', 'node', 'node.pages');
  101. }
  102. /**
  103. * Implements hook_menu().
  104. * Defines all menu items needed by Tripal Core
  105. *
  106. * @ingroup tripal_core
  107. */
  108. function tripal_core_menu() {
  109. $items = array();
  110. // Triapl setting groups
  111. $items['admin/tripal'] = array(
  112. 'title' => 'Tripal',
  113. 'description' => "Manage the behavior or Tripal and its various modules.",
  114. 'weight' => -8,
  115. 'page callback' => 'system_admin_menu_block_page',
  116. 'access arguments' => array('administer site configuration'),
  117. 'file' => 'system.admin.inc',
  118. 'file path' => drupal_get_path('module', 'system'),
  119. );
  120. $items['admin/tripal/schema'] = array(
  121. 'title' => 'Chado Schema',
  122. 'description' => "Tools to extend the chado schema through custom tables & materialized views.",
  123. 'weight' => -2,
  124. 'access arguments' => array('administer site configuration'),
  125. );
  126. $items['admin/tripal/chado'] = array(
  127. 'title' => 'Chado Modules',
  128. 'description' => 'Configuration for specific chado data types such as Vocabularies, Features, etc.',
  129. 'access arguments' => array('access administration pages'),
  130. 'type' => MENU_NORMAL_ITEM,
  131. 'weight' => -6
  132. );
  133. $items['admin/tripal/loaders'] = array(
  134. 'title' => 'Chado Data Loaders',
  135. 'description' => 'Tools facilitating loading data into the chado database. Includes a generic tab-delimited loader (Bulk Loader).',
  136. 'access arguments' => array('access administration pages'),
  137. 'type' => MENU_NORMAL_ITEM,
  138. 'weight' => -4
  139. );
  140. $items['admin/tripal/extension'] = array(
  141. 'title' => 'Extension Modules',
  142. 'description' => 'Configuration for Tripal extension modules.',
  143. 'access arguments' => array('access administration pages'),
  144. 'type' => MENU_NORMAL_ITEM,
  145. 'weight' => 0
  146. );
  147. // Tripal Setup
  148. $items['admin/tripal/setup'] = array(
  149. 'title' => 'Setup Tripal',
  150. 'description' => 'Tools for initial setup of Tripal',
  151. 'access arguments' => array('administer site configuration'),
  152. 'weight' => -8
  153. );
  154. $items['admin/tripal/setup/customize'] = array(
  155. 'title' => 'Customize Tripal',
  156. 'description' => 'Information on how to customize tripal',
  157. 'page callback' => 'theme',
  158. 'page arguments' => array('tripal_core_customize'),
  159. 'access arguments' => array('administer site configuration'),
  160. 'weight' => 10
  161. );
  162. $items['admin/tripal/setup/chado_install'] = array(
  163. 'title' => 'Install Chado Schema',
  164. 'description' => 'Installs the Chado database tables, views, etc., inside the current Drupal database',
  165. 'page callback' => 'drupal_get_form',
  166. 'page arguments' => array('tripal_core_chado_load_form'),
  167. 'access arguments' => array('install chado'),
  168. 'type' => MENU_NORMAL_ITEM,
  169. 'weight' => -10
  170. );
  171. // Jobs Management
  172. $items['admin/tripal/tripal_jobs'] = array(
  173. 'title' => 'Jobs',
  174. 'description' => 'Jobs managed by Tripal',
  175. 'page callback' => 'tripal_jobs_report',
  176. 'access arguments' => array('access administration pages'),
  177. 'type' => MENU_NORMAL_ITEM,
  178. 'weight' => -10
  179. );
  180. $items['admin/tripal/tripal_jobs/cancel/%'] = array(
  181. 'title' => 'Jobs',
  182. 'description' => 'Cancel a pending job',
  183. 'page callback' => 'tripal_jobs_cancel',
  184. 'page arguments' => array(4),
  185. 'access arguments' => array('access administration pages'),
  186. 'type' => MENU_CALLBACK,
  187. );
  188. $items['admin/tripal/tripal_jobs/rerun/%'] = array(
  189. 'title' => 'Jobs',
  190. 'description' => 'Re-run an existing job.',
  191. 'page callback' => 'tripal_jobs_rerun',
  192. 'page arguments' => array(4),
  193. 'access arguments' => array('access administration pages'),
  194. 'type' => MENU_CALLBACK,
  195. );
  196. $items['admin/tripal/tripal_jobs/view/%'] = array(
  197. 'title' => 'Jobs Details',
  198. 'description' => 'View job details.',
  199. 'page callback' => 'tripal_jobs_view',
  200. 'page arguments' => array(4),
  201. 'access arguments' => array('access administration pages'),
  202. 'type' => MENU_CALLBACK,
  203. );
  204. // Materialized Views
  205. $items['admin/tripal/schema/mviews'] = array(
  206. 'title' => 'Materialized Views',
  207. 'description' => 'Materialized views are used to improve speed of large or complex queries.',
  208. 'access arguments' => array('access administration pages'),
  209. 'type' => MENU_NORMAL_ITEM,
  210. 'weight' => -10
  211. );
  212. $items['admin/tripal/schema/mviews/list'] = array(
  213. 'title' => 'List Materialized Views',
  214. 'description' => 'A list of existing materialized views with the ability to edit & delete existing materialized views.',
  215. 'page callback' => 'tripal_mviews_report',
  216. 'access arguments' => array('access administration pages'),
  217. 'type' => MENU_NORMAL_ITEM,
  218. 'weight' => -10
  219. );
  220. $items['admin/tripal/schema/mviews/report/%'] = array(
  221. 'title' => 'Materialized View',
  222. 'description' => 'Materialized views are used to improve speed of large or complex queries. These are database views as compared to Drupal views.',
  223. 'page callback' => 'tripal_mview_report',
  224. 'page arguments' => array(5),
  225. 'access arguments' => array('access administration pages'),
  226. 'type' => MENU_NORMAL_ITEM,
  227. );
  228. $items['admin/tripal/schema/mviews/new'] = array(
  229. 'title' => 'Create Materialized View',
  230. 'description' => 'Create a new materialized view.',
  231. 'page callback' => 'drupal_get_form',
  232. 'page arguments' => array('tripal_mviews_form'),
  233. 'access arguments' => array('access administration pages'),
  234. 'type' => MENU_NORMAL_ITEM,
  235. );
  236. $items['admin/tripal/schema/mviews/edit/%'] = array(
  237. 'title' => 'Edit Materialized View',
  238. 'page callback' => 'drupal_get_form',
  239. 'page arguments' => array('tripal_mviews_form', 5),
  240. 'access arguments' => array('access administration pages'),
  241. 'type' => MENU_NORMAL_ITEM,
  242. );
  243. $items['admin/tripal/schema/mviews/action/%/%'] = array(
  244. 'title' => 'Create Materialized View',
  245. 'description' => 'Materialized views are used to improve speed of large or complex queries.',
  246. 'page callback' => 'tripal_mviews_action',
  247. 'page arguments' => array(5, 6, "1"),
  248. 'access arguments' => array('access administration pages'),
  249. 'type' => MENU_CALLBACK,
  250. );
  251. // Custom Tables
  252. $items['admin/tripal/schema/custom_tables'] = array(
  253. 'title' => 'Custom Tables',
  254. 'description' => 'Creation of custom tables that are added to Chado database.',
  255. 'access arguments' => array('access administration pages'),
  256. 'type' => MENU_NORMAL_ITEM,
  257. 'weight' => -10
  258. );
  259. $items['admin/tripal/schema/custom_tables/list'] = array(
  260. 'title' => 'List of Custom Tables',
  261. 'description' => 'Provides a list of all custom tables created by Tripal and allows for editing or removing existing custom tables.',
  262. 'page callback' => 'tripal_custom_tables_list',
  263. 'access arguments' => array('access administration pages'),
  264. 'type' => MENU_NORMAL_ITEM,
  265. 'weight' => -10
  266. );
  267. $items['admin/tripal/schema/custom_tables/view/%'] = array(
  268. 'title' => 'Custom Tables',
  269. 'description' => 'Custom tables are added to Chado.',
  270. 'page callback' => 'tripal_custom_table_view',
  271. 'page arguments' => array(4),
  272. 'access arguments' => array('access administration pages'),
  273. 'type' => MENU_NORMAL_ITEM,
  274. );
  275. $items['admin/tripal/schema/custom_tables/new'] = array(
  276. 'title' => 'Create Custom Table',
  277. 'description' => 'An interface for creating your own custom tables.',
  278. 'page callback' => 'tripal_custom_table_new_page',
  279. 'access arguments' => array('access administration pages'),
  280. 'type' => MENU_NORMAL_ITEM,
  281. );
  282. $items['admin/tripal/schema/custom_tables/edit/%'] = array(
  283. 'title' => 'Edit Custom Table',
  284. 'page callback' => 'drupal_get_form',
  285. 'page arguments' => array('tripal_custom_tables_form', 4),
  286. 'access arguments' => array('access administration pages'),
  287. 'type' => MENU_NORMAL_ITEM,
  288. );
  289. $items['admin/tripal/schema/custom_tables/action/%/%'] = array(
  290. 'title' => 'Create Custom Table',
  291. 'description' => 'Custom tables are added to Chado.',
  292. 'page callback' => 'tripal_custom_tables_action',
  293. 'page arguments' => array(4, 5, "1"),
  294. 'access arguments' => array('access administration pages'),
  295. 'type' => MENU_CALLBACK,
  296. );
  297. return $items;
  298. }
  299. /**
  300. * Set the permission types that the chado module uses. Essentially we
  301. * want permissionis that protect creation, editing and deleting of chado
  302. * data objects
  303. *
  304. * @ingroup tripal_core
  305. */
  306. function tripal_core_permission() {
  307. return array(
  308. 'install chado' => array(
  309. 'title' => t('Install Chado'),
  310. 'description' => t('Allow the user to install or upgrade a Chado database in the existing Drupal database.')
  311. ),
  312. );
  313. }
  314. /**
  315. * Implements hook_theme().
  316. * Registers template files/functions used by this module.
  317. *
  318. * @ingroup tripal_core
  319. */
  320. function tripal_core_theme() {
  321. return array(
  322. 'tripal_core_customize' => array(
  323. 'arguments' => array('job_id' => NULL),
  324. 'template' => 'tripal_core_customize',
  325. 'path' => drupal_get_path('module', 'tripal_core') . '/theme'
  326. ),
  327. 'theme_file_upload_combo' => array(
  328. 'render element' => 'element',
  329. ),
  330. 'theme_sequence_combo' => array(
  331. 'render element' => 'element',
  332. ),
  333. );
  334. }
  335. /**
  336. * Implements hook_job_describe_args().
  337. * Describes the arguements for the tripal_update_mview job to allow for greater
  338. * readability in the jobs details pages.
  339. *
  340. * @param $callback
  341. * The callback of the current tripal job (this is the function that will be executed
  342. * when tripal_launch_jobs.php is run.
  343. * @param $args
  344. * An array of arguments passed in when the job was registered.
  345. *
  346. * @return
  347. * A more readable $args array
  348. *
  349. * @ingroup tripal_core
  350. */
  351. function tripal_core_job_describe_args($callback, $args) {
  352. $new_args = array();
  353. if ($callback == 'tripal_update_mview') {
  354. // get this mview details
  355. $sql = "SELECT * FROM {tripal_mviews} WHERE mview_id = :mview_id ";
  356. $results = db_query($sql, array(':mview_id' => $args[0]));
  357. $mview = $results->fetchObject();
  358. $new_args['View Name'] = $mview->name;
  359. }
  360. elseif ($callback == 'tripal_core_install_chado') {
  361. $new_args['Action'] = $args[0];
  362. }
  363. return $new_args;
  364. }
  365. /**
  366. * this is just a wrapper for backwards compatibility with a naming mistake.
  367. * it can go away in the future as it only is useful for jobs created by v0.3b
  368. *
  369. * @todo remove this function
  370. */
  371. function tripal_core_load_gff3($gff_file, $organism_id, $analysis_id, $add_only = 0,
  372. $update = 0, $refresh = 0, $remove = 0, $job = NULL) {
  373. tripal_feature_load_gff3($gff_file, $organism_id, $analysis_id, $add_only,
  374. $update, $refresh, $remove, $job);
  375. }
  376. /**
  377. * Implements hook_coder_ignore().
  378. * Defines the path to the file (tripal_core.coder_ignores.txt) where ignore rules for coder are stored
  379. */
  380. function tripal_core_coder_ignore() {
  381. return array(
  382. 'path' => drupal_get_path('module', 'tripal_core'),
  383. 'line prefix' => drupal_get_path('module', 'tripal_core'),
  384. );
  385. }