{"action":"created","issue":{"url":"https://api.github.com/repos/frioux/DBIx-Class-DeploymentHandler/issues/36","labels_url":"https://api.github.com/repos/frioux/DBIx-Class-DeploymentHandler/issues/36/labels{/name}","comments_url":"https://api.github.com/repos/frioux/DBIx-Class-DeploymentHandler/issues/36/comments","events_url":"https://api.github.com/repos/frioux/DBIx-Class-DeploymentHandler/issues/36/events","html_url":"https://github.com/frioux/DBIx-Class-DeploymentHandler/issues/36","id":104511523,"number":36,"title":"No way to globally pass schema loader options for 'schema_from_schema_loader'","user":{"login":"mrenvoize","id":557612,"avatar_url":"https://avatars.githubusercontent.com/u/557612?v=3","gravatar_id":"","url":"https://api.github.com/users/mrenvoize","html_url":"https://github.com/mrenvoize","followers_url":"https://api.github.com/users/mrenvoize/followers","following_url":"https://api.github.com/users/mrenvoize/following{/other_user}","gists_url":"https://api.github.com/users/mrenvoize/gists{/gist_id}","starred_url":"https://api.github.com/users/mrenvoize/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mrenvoize/subscriptions","organizations_url":"https://api.github.com/users/mrenvoize/orgs","repos_url":"https://api.github.com/users/mrenvoize/repos","events_url":"https://api.github.com/users/mrenvoize/events{/privacy}","received_events_url":"https://api.github.com/users/mrenvoize/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"frioux","id":8163,"avatar_url":"https://avatars.githubusercontent.com/u/8163?v=3","gravatar_id":"","url":"https://api.github.com/users/frioux","html_url":"https://github.com/frioux","followers_url":"https://api.github.com/users/frioux/followers","following_url":"https://api.github.com/users/frioux/following{/other_user}","gists_url":"https://api.github.com/users/frioux/gists{/gist_id}","starred_url":"https://api.github.com/users/frioux/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/frioux/subscriptions","organizations_url":"https://api.github.com/users/frioux/orgs","repos_url":"https://api.github.com/users/frioux/repos","events_url":"https://api.github.com/users/frioux/events{/privacy}","received_events_url":"https://api.github.com/users/frioux/received_events","type":"User","site_admin":false},"milestone":null,"comments":5,"created_at":"2015-09-02T15:42:42Z","updated_at":"2015-10-04T22:14:13Z","closed_at":"2015-10-04T22:14:13Z","body":"I came across this one whilst attempting to use db schema's (as in what the db vendor means) with deployment handler.\r\n\r\nIn the DBIC Connection call I have an 'on_connect_do => [ SET search_path TO my_schema ] setup for my postgres connection.  This works well for the txn_do calls as we use the dbic handle so our search path is always set.. however when we move onto the perl scripts the SET is not run adn therefore the dbic schema that is 'dumped' is not relating the the right database schema (In schema::loader there is a different arguament for this 'db_schema => my_schema').\r\n\r\nI'd like to be able to set this for all my scripts rather than specify it per perl script.. much like 'sql_translator_args' can be."},"comment":{"url":"https://api.github.com/repos/frioux/DBIx-Class-DeploymentHandler/issues/comments/145392741","html_url":"https://github.com/frioux/DBIx-Class-DeploymentHandler/issues/36#issuecomment-145392741","issue_url":"https://api.github.com/repos/frioux/DBIx-Class-DeploymentHandler/issues/36","id":145392741,"user":{"login":"frioux","id":8163,"avatar_url":"https://avatars.githubusercontent.com/u/8163?v=3","gravatar_id":"","url":"https://api.github.com/users/frioux","html_url":"https://github.com/frioux","followers_url":"https://api.github.com/users/frioux/followers","following_url":"https://api.github.com/users/frioux/following{/other_user}","gists_url":"https://api.github.com/users/frioux/gists{/gist_id}","starred_url":"https://api.github.com/users/frioux/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/frioux/subscriptions","organizations_url":"https://api.github.com/users/frioux/orgs","repos_url":"https://api.github.com/users/frioux/repos","events_url":"https://api.github.com/users/frioux/events{/privacy}","received_events_url":"https://api.github.com/users/frioux/received_events","type":"User","site_admin":false},"created_at":"2015-10-04T22:14:13Z","updated_at":"2015-10-04T22:14:13Z","body":"Ok, I documented a pattern because all the ideas I had to generate sugar were just as much work.  I hope this helps; if it doesn't, let me know.\r\n\r\nhttps://metacpan.org/pod/release/FREW/DBIx-Class-DeploymentHandler-0.002217/lib/DBIx/Class/DeploymentHandler/DeployMethod/SQL/Translator/ScriptHelpers.pm#CUSTOM-SCRIPT-HELPERS"}}