{"id":17232,"date":"2020-09-25T03:19:37","date_gmt":"2020-09-25T07:19:37","guid":{"rendered":"https:\/\/buzsakilab.com\/wp\/?page_id=17232"},"modified":"2020-11-20T15:58:00","modified_gmt":"2020-11-20T20:58:00","slug":"matlab-database-toolset","status":"publish","type":"page","link":"https:\/\/buzsakilab.com\/wp\/matlab-database-toolset\/","title":{"rendered":"MATLAB database toolset"},"content":{"rendered":"<p>We have developed a MATLAB toolset for interacting with the database. The code is shared on GitHub in the CellExplorer repository: <a href=\"https:\/\/github.com\/petersenpeter\/CellExplorer\">github.com\/petersenpeter\/CellExplorer<\/a>. The first functions below give reading access and they are sufficient for public access.<\/p>\n<p><a id=\"a6d05f14e7d5a134aa78f654bac2e0d7-8b3cb87cb04211d4913d06d6c33ad4aecd315035\" class=\"js-navigation-open link-gray-dark\" title=\"db_example.m\" href=\"https:\/\/github.com\/petersenpeter\/CellExplorer\/blob\/master\/db\/db_example.m\">db_example.m<\/a>: script containing a few examples for interacting with the database<\/p>\n<p><a id=\"b519fe3d9358b9c08d72d006217d192a-63abf2a79c9daed568eecbc92798c772b7dfc0fc\" class=\"js-navigation-open link-gray-dark\" title=\"gui_db_sessions.m\" href=\"https:\/\/github.com\/petersenpeter\/CellExplorer\/blob\/master\/db\/gui_db_sessions.m\">gui_db_sessions.m<\/a>: Shows a graphical interface allowing the user to select a number of sessions for processing.<\/p>\n<p><a id=\"d42707bccb2ca0219addb72e1417e14c-81c11af2f35b581354a6ff2a79a07021f17d8e92\" class=\"js-navigation-open link-gray-dark\" title=\"db_set_session.m\" href=\"https:\/\/github.com\/petersenpeter\/CellExplorer\/blob\/master\/db\/db_set_session.m\">db_set_session.m<\/a>: loads session metadata from the database and generates the local path to the data.<\/p>\n<p><a id=\"15db91a37df2b76316a7c690fca96144-ab3b4b8e23816ef9c31e5935ab1d6716b73c564b\" class=\"js-navigation-open link-gray-dark\" title=\"db_load_table.m\" href=\"https:\/\/github.com\/petersenpeter\/CellExplorer\/blob\/master\/db\/db_load_table.m\">db_load_table.m<\/a>: allows you to query individual database tables, e.g. sessions, projects, silicon probes.<\/p>\n<p><a id=\"34912ab56292d1d99192c8f5a77a41b7-ab2724ab10f5d119413ba1e1c63fb2ee0b6d3258\" class=\"js-navigation-open link-gray-dark\" title=\"db_load_sessions.m\" href=\"https:\/\/github.com\/petersenpeter\/CellExplorer\/blob\/master\/db\/db_load_sessions.m\">db_load_sessions.m<\/a>: the metadata will be loaded from the database for multiple sessions based on user inputs (search terms).<\/p>\n<h3>For contributors and collaborators<\/h3>\n<p><a id=\"847fd0837769352c2f709b85c6e38e28-7b3ba7530c5f837e8bddaf134f395dd7c2ff4cf6\" class=\"js-navigation-open link-gray-dark\" title=\"db_credentials.m\" href=\"https:\/\/github.com\/petersenpeter\/CellExplorer\/blob\/master\/db\/db_credentials.m\">db_credentials.m<\/a>: provide your credentials in this file<\/p>\n<p><a id=\"5d953b642350ae54fd6faeaa721e1bb3-bcee34305e9003e1d4d6cf24ae8f538e0e0429b8\" class=\"js-navigation-open link-gray-dark\" title=\"db_local_repositories.m\" href=\"https:\/\/github.com\/petersenpeter\/CellExplorer\/blob\/master\/db\/db_local_repositories.m\">db_local_repositories.m<\/a>: provide your local repository paths in this file.<\/p>\n<p><a id=\"b2d0a108f865fbbd1b9a83310826ef41-dd98ee075d1ac4887c9351378a9c093f304b0df7\" class=\"js-navigation-open link-gray-dark\" title=\"db_create_animal.m\" href=\"https:\/\/github.com\/petersenpeter\/CellExplorer\/blob\/master\/db\/db_create_animal.m\">db_create_animal.m<\/a>: creates a new animal subject in the database<\/p>\n<p><a id=\"f4be34654c3d04d52a9af3f750442d82-9a48e9312d6e07402debe6ad7a1403137ae1a54d\" class=\"js-navigation-open link-gray-dark\" title=\"db_create_session.m\" href=\"https:\/\/github.com\/petersenpeter\/CellExplorer\/blob\/master\/db\/db_create_session.m\">db_create_session.m<\/a>: creates a new session in the database.<\/p>\n<p><a id=\"ad265c8f6e728a1db707a0bca6a47aa7-c73272038fed56b03203d5f17a74db96c710ada5\" class=\"js-navigation-open link-gray-dark\" title=\"db_upload_session.m\" href=\"https:\/\/github.com\/petersenpeter\/CellExplorer\/blob\/master\/db\/db_upload_session.m\">db_upload_session.m<\/a>: Update an existing session.<\/p>\n<p><a id=\"d7f940cf71a08777c11f0bc2622fdbd2-591f17ee088de27898f3c9fda4841e1995e720e0\" class=\"js-navigation-open link-gray-dark\" title=\"db_submit_cells.m\" href=\"https:\/\/github.com\/petersenpeter\/CellExplorer\/blob\/master\/db\/db_submit_cells.m\">db_submit_cells.m<\/a>: submit and update cells in the database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We have developed a MATLAB toolset for interacting with the database. The code is shared on GitHub in the CellExplorer repository: github.com\/petersenpeter\/CellExplorer. The first functions below give reading access and they are sufficient for public access. db_example.m: script containing a few examples for interacting with the database gui_db_sessions.m: Shows a graphical interface allowing the user to select a number of sessions for processing. db_set_session.m: loads session metadata from the database and generates the local path [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"_links":{"self":[{"href":"https:\/\/buzsakilab.com\/wp\/wp-json\/wp\/v2\/pages\/17232"}],"collection":[{"href":"https:\/\/buzsakilab.com\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/buzsakilab.com\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/buzsakilab.com\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buzsakilab.com\/wp\/wp-json\/wp\/v2\/comments?post=17232"}],"version-history":[{"count":9,"href":"https:\/\/buzsakilab.com\/wp\/wp-json\/wp\/v2\/pages\/17232\/revisions"}],"predecessor-version":[{"id":17258,"href":"https:\/\/buzsakilab.com\/wp\/wp-json\/wp\/v2\/pages\/17232\/revisions\/17258"}],"wp:attachment":[{"href":"https:\/\/buzsakilab.com\/wp\/wp-json\/wp\/v2\/media?parent=17232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}