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

[Gonzalo Martinez]

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 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

[Imdbpy-help] Setting up IMDBPY on Windows

[Gonzalo Martinez]

Hi, 



I'm trying to dump the IMDB interfaces files onto a Microsoft SQL Database 
using SQL Server 2016 (trial) on a Windows Server 2012 R2 server so I can start 
playing with the dataset. I already installed Python 2.7 and used pip install 
Imdbpy successfully. My problem is when I use  the following line to extract 
the data "imdbpy2sql.py -d S:/imdbData/ -u mssql://GMDATASERVER/imdbGM?sspi=1 
--ms-sqlserver" ... I get the following error:





C:\Users\Administrator>imdbpy2sql.py -d S:/imdbData/ -u 
mssql://GMDATASERVER/imdbGM?sspi=1 --ms-sqlserver

Traceback (most recent call last):

  File "C:\Python27\Scripts\imdbpy2sql.py", line 538, in 

conn = setConnection(URI, DB_TABLES)

  File "C:\Python27\lib\site-packages\imdb\parser\sql\objectadapter.py", line 
189, in setConnection

conn = connectionForURI(uri, **kw)

  File "C:\Python27\lib\site-packages\sqlobject\dbconnection.py", line 1072, in 
connectionForURI

conn = connCls.connectionFromURI(uri)

  File "C:\Python27\lib\site-packages\sqlobject\dbconnection.py", line 154, in 
connectionFromURI

return cls._connectionFromParams(*cls._parseURI(uri))

  File "C:\Python27\lib\site-packages\sqlobject\mssql\mssqlconnection.py", line 
101, in _connectionFromParams

host=host or 'localhost', port=port, db=path, **args)

  File "C:\Python27\lib\site-packages\sqlobject\mssql\mssqlconnection.py", line 
36, in __init__

'Cannot find an MSSQL driver, tried %s' % drivers)

ImportError: Cannot find an MSSQL driver, tried adodb,pymssql



C:\Users\Administrator>





Everything is installed on the same server (standalone). 



Any help would be appreciated greatly.





Thanks.




--
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