Re: Appveyor Builds & Testing

Ha!  I forgot I opened that.

Are you making any progress on FreeTDS windows binaries?  FYI, we have a 
paid AppVeyor account which makes the builds go much faster vs the free 
version.  I could set up FreeTDS and pymssql on our account if you think 
that would be helpful.

FYI, we are going to PyOhio next weekend and I'm hoping to sprint on 
pymssql on Friday and Saturday night.  I'm thinking getting FreeTDS and 
pymssql appveyor support going might be a hug win for that sprint.

*Randy Syring*
Husband | Father | Redeemed Sinner

/"For what does it profit a man to gain the whole world
and forfeit his soul?" (Mark 8:36 ESV)/

On 07/18/2015 05:16 PM, Ramiro Morales wrote:
> Randy,
>
> There is, of course issse #303 you opened:
> https://github.com/pymssql/pymssql/issues/303
>
> I see now I had posted a comment with links there.
>
> On Fri, Jul 17, 2015 at 4:43 PM, Ramiro Morales <[email protected]> wrote:
>> Randy,
>>
>> On Fri, Jul 17, 2015 at 1:33 PM, Randy Syring <[email protected]> wrote:
>>> Ramiro,
>>>
>>> I've been doing some work on Appveyor lately as we move to get a CI environment setup for some of our apps that run on Windows servers.  I thought I remembered you saying something about working on this for pymssql.  Have you got anywhere with it or should I start from scratch?  I've worked out all the bugs already with getting a the SQL Server going in a way we can connect to:
>>>
>>> https://github.com/level12/sqlalchemy-appveyor/blob/appveyor/appveyor.yml
>>>
>>> So starting from scratch isn't a big deal.  I just didn't want to step on your toes.
>>
>> My work on this is on the appveyor branch of the pymssql repo:
>>
>>    https://github.com/ramiro/pymssql/commits/appveyor
>>
>> and is composed by the appveyor.yml file:
>>
>>    https://github.com/ramiro/pymssql/blob/appveyor/appveyor.yml
>>
>> and helper files under the appveyor/ subdir:
>>
>>    https://github.com/ramiro/pymssql/tree/appveyor/appveyor
>>
>> These files actually do build pymssql on Windows with the two MS
>> Visual C compilers needed to generate binaries for Python 2.7 -3.3.
>> and run our test suite against SQL server instance in Appveyor:
>>
>>    https://ci.appveyor.com/project/ramiro/pymssql
>>
>> There is one hacky step which is fetching and usage of the FreeTDS
>> binaries because it downloads it from a build I perfomed in Appveyor
>> of the 0.91 maintenance branch of FreeTDS.
>>
>> Once I reached that point I kind of stopped working on pymssql and
>> switched to work on using Appveyor as a CI platform and for building
>> FreeTDS under Windows but in a cleaner way and to actually get the
>> needed changes merged in upstream for the FreeTDS 0.95 release.
>> Unfortunately didn't achieve that in time for the 0.95 release
>> (although once things are finished on master it's cleanly backportable
>> to the 0.95 maintenance branch.)
>>
>> Plan is in the future possibly to use the release API of GitGub to,
>> once a build (of a tag?) of FreeTDS is successful, upload a Windows
>> FreeTD binaries zipball to GitHub. And use (ie.e download, unpack)
>> these release zipballs from the pymssql appveyor.yml CI recipe.
>>
>> Fell free to ping if you need any help with this.
>>
>> Regards,
>>
>>>
>>> Thanks.
>>>
>>> Randy Syring
>>> Husband | Father | Redeemed Sinner
>>>
>>> "For what does it profit a man to gain the whole world
>>> and forfeit his soul?" (Mark 8:36 ESV)
>>>
>>
>>
>> --
>> Ramiro Morales
>> @ramiromorales
>
>