{"action":"created","issue":{"url":"https://api.github.com/repos/pocoproject/poco/issues/1170","repository_url":"https://api.github.com/repos/pocoproject/poco","labels_url":"https://api.github.com/repos/pocoproject/poco/issues/1170/labels{/name}","comments_url":"https://api.github.com/repos/pocoproject/poco/issues/1170/comments","events_url":"https://api.github.com/repos/pocoproject/poco/issues/1170/events","html_url":"https://github.com/pocoproject/poco/pull/1170","id":138095063,"number":1170,"title":"PostgreSQL: integration with AppVeyor and Travis","user":{"login":"zosrothko","id":7262593,"avatar_url":"https://avatars.githubusercontent.com/u/7262593?v=3","gravatar_id":"","url":"https://api.github.com/users/zosrothko","html_url":"https://github.com/zosrothko","followers_url":"https://api.github.com/users/zosrothko/followers","following_url":"https://api.github.com/users/zosrothko/following{/other_user}","gists_url":"https://api.github.com/users/zosrothko/gists{/gist_id}","starred_url":"https://api.github.com/users/zosrothko/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zosrothko/subscriptions","organizations_url":"https://api.github.com/users/zosrothko/orgs","repos_url":"https://api.github.com/users/zosrothko/repos","events_url":"https://api.github.com/users/zosrothko/events{/privacy}","received_events_url":"https://api.github.com/users/zosrothko/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2016-03-03T07:07:23Z","updated_at":"2016-03-03T14:31:00Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/pocoproject/poco/pulls/1170","html_url":"https://github.com/pocoproject/poco/pull/1170","diff_url":"https://github.com/pocoproject/poco/pull/1170.diff","patch_url":"https://github.com/pocoproject/poco/pull/1170.patch"},"body":"Hi\r\n\r\nthis PR brings integration of the Data/PostgreSQL module with the AppVeyor CI flow. The main issue to face on is the \"postgres user' password setup which is different on AppVeyor from the traditional setup. AppVeyor sets the usr/pws as postgres/Password12! while on most of not all environment tests, usr/pwd is set to postgres/postgres. The second issue is to expurge all hard coded PostgreSQL paths from the VS project while keeping an easyway to debug the module. Here the changes\r\n\r\n1/ The Data/PostgreSQL testunit suite sets the connection string using static methods that returns the host/port/database/user/password, the latest depending on the APPVEYOR environment variable.\r\n\r\n2/ Building Data/PostgreSQL with msbuild requires to setup the LIB and INCLUDE variables as for MySQL\r\n\r\n3/ Building Data/PostgreSQL within the VS IDE requires to add to the AppData\\Local\\Microsoft\\MSBuild\\v4.0\\Microsoft.Cpp.x64.user.props with the PostgreSQL paths as for the LIB and INCLUDE variables as for example\r\n\t<PropertyGroup>\r\n\t\t<IncludePath>C:\\Program Files\\PostgreSQL\\9.5\\include;$(IncludePath)</IncludePath>\r\n\t\t<LibraryPath>C:\\Program Files\\PostgreSQL\\9.5\\lib;$(LibraryPath)</LibraryPath>\r\n\t</PropertyGroup>\r\n\r\n4/ AppVeyor has been updated to the latest version of the develop branch as well as runtest2.cmd and runtests.sh\r\n\r\n5/ Some module have been removed from the components file since there were failing at compilation on AppVeyor. This should be solved when the PostgreSQL branch will be merged with the develop branch.\r\n\r\n6/ VS2013 Win32 projects have been added but the testsuite is run only for x64 for now. \r\n\r\n7/ Next steps are to run the Win32 testsuite on AppVeyor as well on Travis."},"comment":{"url":"https://api.github.com/repos/pocoproject/poco/issues/comments/191785000","html_url":"https://github.com/pocoproject/poco/pull/1170#issuecomment-191785000","issue_url":"https://api.github.com/repos/pocoproject/poco/issues/1170","id":191785000,"user":{"login":"zosrothko","id":7262593,"avatar_url":"https://avatars.githubusercontent.com/u/7262593?v=3","gravatar_id":"","url":"https://api.github.com/users/zosrothko","html_url":"https://github.com/zosrothko","followers_url":"https://api.github.com/users/zosrothko/followers","following_url":"https://api.github.com/users/zosrothko/following{/other_user}","gists_url":"https://api.github.com/users/zosrothko/gists{/gist_id}","starred_url":"https://api.github.com/users/zosrothko/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zosrothko/subscriptions","organizations_url":"https://api.github.com/users/zosrothko/orgs","repos_url":"https://api.github.com/users/zosrothko/repos","events_url":"https://api.github.com/users/zosrothko/events{/privacy}","received_events_url":"https://api.github.com/users/zosrothko/received_events","type":"User","site_admin":false},"created_at":"2016-03-03T14:31:00Z","updated_at":"2016-03-03T14:31:00Z","body":"All changes are in the PR... but since the postgresql branch is far behing the develop branch, I copied and commited some stuff for making the Travis jobs working up to the end. Those debugging and WIP stuff will have to be fixed after the merge if any and I will take care of that.\r\n\r\nPostgreSQL is availabel on OSX, fine, but it is not available on travis OSX... So even, if one can install it on travis, I would prefer to stabilize the CI AppVeyor for VS  and Travis for Linux before extending it on Travis  OSX.\r\n\r\n"}}