Re: [Imdbpy-help] Setting up IMDBPY on Windows

[Davide Alberani]

Hi Amy and Gonzalo,
does this happens also without --ms-sqlserver?

Another option is to run it with the -o sqlalchemy to use another ORM
(shouldn't change much...)

Besides this, I fear you have to debug this issue looking at the logs
of the db, and see why it get stuck.

Basically, imdbpy2sql.py before writing of a batch of data executes,
for some tables, something like:
  SET IDENTITY_INSERT $table ON;
and after the insert:
  SET IDENTITY_INSERT $table off;

if I remember correctly, it was needed for tables with auto-increment values.
Maybe something was changed in the latest versions of MSSQL?

HTH,

On Sat, Apr 22, 2017 at 7:49 PM, Amy Garcia Kennedy  wrote:
> Hey Gonzalo,
>
> did you find a solution to this? I have the same problem.
>
> thanks!
>
> El viernes, 6 de enero de 2017, 16:48:07 (UTC+1), Gonzalo Martinez escribió:
>>
>> Hi,
>>
>> I ran "pip install pymssql" and it is working now but it makes me wonder
>> why it did not install when running "pip install imdbpy" in the first place?
>>
>> Now, I have some issues because the following line "imdbpy2sql.py -d
>> S:/imdbData/ -u
>> mssql://GMDATASERVER\Administrator:Pa$$w0rd@GMDATASERVER/imdbGM
>> --ms-sqlserver" stalled an is stuck at this point...
>>
>> EXECUTING "BEFORE_MOVIES_TODB:SET IDENTITY_INSERT %(table)s
>> ON;"...EXECUTING "SET IDENTITY_INSERT title ON;"...
>>
>> It's been 2h+ and it  hasn't moved so there something wrong I'm sure.
>>
>> I'm using python 2.7 (the latest available at the moment from python.org),
>> Windows Server 2012R2 and SQL Server 2016 trial... all is fully patched.
>>
>>
>>
>>
>> Thanks for any help you guys can provide me.
>>
>>
>>
>>
>>
>>  On Fri, 06 Jan 2017 07:28:24 -0500 Davide Alberani
>>  wrote 
>>
>> On Wed, Jan 4, 2017 at 6:31 PM, Gonzalo Martinez 
>> wrote:
>> >
>> > ImportError: Cannot find an MSSQL driver, tried adodb,pymssql
>>
>> Hi Gonzalo,
>> have you also installed the pymssql package?
>>
>> HTH,
>>
>> --
>> Davide Alberani  [PGP KeyID: 0x3845A3D4AC9B61AD]
>> http://www.mimante.net/
>>
>>
>



-- 
Davide Alberani   [PGP KeyID: 0x3845A3D4AC9B61AD]
http://www.mimante.net/

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Imdbpy-help mailing list
Imdbpy-help@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-help

Re: [Imdbpy-help] Setting up IMDBPY on Windows

[Amy Garcia Kennedy]

Hey Gonzalo,

did you find a solution to this? I have the same problem.

thanks!

El viernes, 6 de enero de 2017, 16:48:07 (UTC+1), Gonzalo Martinez escribió:
>
> Hi, 
>
> I ran "pip install pymssql" and it is working now but it makes me wonder 
> why it did not install when running "pip install imdbpy" in the first 
> place? 
>
> Now, I have some issues because the following line "imdbpy2sql.py -d 
> S:/imdbData/ -u 
> mssql://GMDATASERVER\Administrator:Pa$$w0rd@GMDATASERVER/imdbGM 
> --ms-sqlserver" stalled an is stuck at this point... 
>
> EXECUTING "BEFORE_MOVIES_TODB:SET IDENTITY_INSERT %(table)s 
> ON;"...EXECUTING "SET IDENTITY_INSERT title ON;"...
>
> It's been 2h+ and it  hasn't moved so there something wrong I'm sure.
>
> I'm using python 2.7 (the latest available at the moment from python.org), 
> Windows Server 2012R2 and SQL Server 2016 trial... all is fully patched.
>
>
>
>
> Thanks for any help you guys can provide me.
>
>
>
>
>
>  On Fri, 06 Jan 2017 07:28:24 -0500 *Davide Alberani 
> * wrote 
>
> On Wed, Jan 4, 2017 at 6:31 PM, Gonzalo Martinez  > wrote: 
> > 
> > ImportError: Cannot find an MSSQL driver, tried adodb,pymssql 
>
> Hi Gonzalo, 
> have you also installed the pymssql package? 
>
> HTH, 
>
> -- 
> Davide Alberani  [PGP KeyID: 
> 0x3845A3D4AC9B61AD] 
> http://www.mimante.net/ 
>
>
>--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Imdbpy-help mailing list
Imdbpy-help@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-help

Re: [Imdbpy-help] Setting up IMDBPY on Windows

[Davide Alberani]

On Fri, Jan 6, 2017 at 4:32 PM, Gonzalo Martinez  wrote:
>
> I ran "pip install pymssql" and it is working now but it makes me wonder why
> it did not install when running "pip install imdbpy" in the first place?

Hi, and pardon the long delay.

That's normal: the dependency is on the ORM (sqlobect or sqlalchemy),
not on the specific driver to access a database, that depends on which
system you are on and which db you want to access.

> Now, I have some issues because the following line "imdbpy2sql.py -d
> S:/imdbData/ -u
> mssql://GMDATASERVER\Administrator:Pa$$w0rd@GMDATASERVER/imdbGM
> --ms-sqlserver" stalled an is stuck at this point...

Unfortunately I have no experience on this db.
Maybe you can try without the --ms-sqlserver argument, which by the way
executes some commands at specific times.


HTH,

-- 
Davide Alberani   [PGP KeyID: 0x3845A3D4AC9B61AD]
http://www.mimante.net/

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
___
Imdbpy-help mailing list
Imdbpy-help@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-help

Re: [Imdbpy-help] Setting up IMDBPY on Windows

[Davide Alberani]

On Wed, Jan 4, 2017 at 6:31 PM, Gonzalo Martinez  wrote:
>
> ImportError: Cannot find an MSSQL driver, tried adodb,pymssql

Hi Gonzalo,
have you also installed the pymssql package?

HTH,

-- 
Davide Alberani   [PGP KeyID: 0x3845A3D4AC9B61AD]
http://www.mimante.net/

--
Check out the vibrant tech community on one of the world's most 
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
___
Imdbpy-help mailing list
Imdbpy-help@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-help