<?xml version="1.0" encoding="UTF-8"?>
<rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns="http://purl.org/rss/1.0/" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:syn="http://purl.org/rss/1.0/modules/syndication/" xmlns:admin="http://webns.net/mvcb/">
  <channel rdf:about="http://blog.gmane.org/gmane.comp.python.imdbpy.user">
    <title>gmane.comp.python.imdbpy.user</title>
    <link>http://blog.gmane.org/gmane.comp.python.imdbpy.user</link>
    <description/>
    <syn:updatePeriod>hourly</syn:updatePeriod>
    <syn:updateFrequency>1</syn:updateFrequency>
    <syn:updateBase>1901-01-01T00:00+00:00</syn:updateBase>
    <items>
      <rdf:Seq>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/470"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/469"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/468"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/467"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/466"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/465"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/464"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/463"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/462"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/461"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/460"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/459"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/458"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/457"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/456"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/455"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/454"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/453"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/452"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/451"/>
      </rdf:Seq>
    </items>
    <image rdf:resource="http://gmane.org/img/gmane-25t.png"/>
    <textinput rdf:resource=""/>
  </channel>
  <image rdf:about="http://gmane.org/img/gmane-25t.png">
    <title>Gmane</title>
    <url>http://gmane.org/img/gmane-25t.png</url>
    <link>http://gmane.org</link>
  </image>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/470">
    <title>Re: help running imdbpy2sql</title>
    <link>http://permalink.gmane.org/gmane.comp.python.imdbpy.user/470</link>
    <description>&lt;pre&gt;On Thu, May 24, 2012 at 11:14 PM, Brian Abelson
&amp;lt;brian-Gd6LDfCjhhMyYCB5lekE3M0vGNN6ct63&amp;lt; at &amp;gt;public.gmane.org&amp;gt; wrote:

If possible, use the development version:
  https://bitbucket.org/alberanid/imdbpy/


You can't use the downloaded file without installing them.
You can try to run, from the main directory of the IMDbPY
package, this:
  python setup.py install

it should take care of all the dependencies, provided that you
have a working environment to compile the needed libraries
and/or that they are pre-packaged for MacOS X (I don't know,
since I don't use it).

Basically, the point is:
- try to install it (it will try to fetch some dependencies and
compile some modules)
- if some dependency fails, try to satisfy it manually.
- if there's no way and/or the compile step stops you, see the options shown
  by the setup.py file to exclude some pieces of IMDbPY.

It would be cool to have an auto-installer for Mac OS X or at least
the steps to follow to manage the installation of python modules;
is anyone out there expert on the subject? :-)


HTH,

&lt;/pre&gt;</description>
    <dc:creator>Davide Alberani</dc:creator>
    <dc:date>2012-05-24T21:28:27</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/469">
    <title>help running imdbpy2sql</title>
    <link>http://permalink.gmane.org/gmane.comp.python.imdbpy.user/469</link>
    <description>&lt;pre&gt;Hi,

I am an unexperienced programmer trying to run imdppy2sql.py in order to
create a local sql database of imdb's data.  Thus far, here is what I have
done:

1. Downloaded all the plain text files from imdb into a single directory:
"/Users/TPF/Desktop/imdb/"
2. Downloaded Mamp and created a mysql database called "imdb"
3. Downloaded the latest version of sql object by typing "svn co
http://svn.colorstudy.com/sqlobject/trunk SQLobject into the command line
4. Downloaded the stable version of IMDbPY  - 4.8.2
5. Navigated to the IMDbPY folder by typing
"cd /Users/TPF/Desktop/IMDbPY-4.8.2" into the command line.
6. Entered this into the command line to execute the script:
"python bin/imdbpy2sql.py -d /Users/TPF/Desktop/imdb/ -u
mysql://root:root&amp;lt; at &amp;gt;localhost:8889/imdb"

However, this seems to continually return this error:

"Traceback (most recent call last):
  File "bin/imdbpy2sql.py", line 34, in &amp;lt;module&amp;gt;
    from imdb.parser.sql.dbschema import *
ImportError: No module named imdb.parser.sql.dbschema"

Yet, when I navigate to this folder, I see the script "dbschema.py" in the
correct location.  I have searched on the internet and suspect that the
problem may have to do with my version of SQLobject, Python (2.6.1), or my
OS (Mac OSX 10.6.8). However, due to my lack of experience, I am not sure
how best to redress these issues or where to start first.  Can somebody
please help walk me through this? I'd be more than willing to compensate
you for your time.

All the best,

Brian Abelson
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/_______________________________________________
Imdbpy-help mailing list
Imdbpy-help-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&amp;lt; at &amp;gt;public.gmane.org
https://lists.sourceforge.net/lists/listinfo/imdbpy-help
&lt;/pre&gt;</description>
    <dc:creator>Brian Abelson</dc:creator>
    <dc:date>2012-05-24T21:14:45</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/468">
    <title>Re: imdbpy2sql.py problem on Ubuntu 12.04</title>
    <link>http://permalink.gmane.org/gmane.comp.python.imdbpy.user/468</link>
    <description>&lt;pre&gt;
No good at all. :-/
I'm also getting other similar reports, and I can even confirm it on my system.

So far, no idea; maybe something about transactions?



&lt;/pre&gt;</description>
    <dc:creator>Davide Alberani</dc:creator>
    <dc:date>2012-05-21T17:59:18</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/467">
    <title>Re: imdbpy2sql.py problem on Ubuntu 12.04</title>
    <link>http://permalink.gmane.org/gmane.comp.python.imdbpy.user/467</link>
    <description>&lt;pre&gt;Incidentally, I got up this morning after leaving it running all night and
it has moved on.  However, it is only up to the Ps after 13 hours.  My quad
core is idle, I am using just 32% of my 6GB, there is no network activity,
but my hard drive does seem to be going haywire (though no memory
swapping).  Has anyone seen this?

On Sun, May 20, 2012 at 7:06 PM, Eric Lange &amp;lt;eric-G5GI3ItdQ1PQT0dZR+AlfA&amp;lt; at &amp;gt;public.gmane.org&amp;gt; wrote:

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/_______________________________________________
Imdbpy-help mailing list
Imdbpy-help-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&amp;lt; at &amp;gt;public.gmane.org
https://lists.sourceforge.net/lists/listinfo/imdbpy-help
&lt;/pre&gt;</description>
    <dc:creator>Eric Lange</dc:creator>
    <dc:date>2012-05-21T15:24:58</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/466">
    <title>imdbpy2sql.py problem on Ubuntu 12.04</title>
    <link>http://permalink.gmane.org/gmane.comp.python.imdbpy.user/466</link>
    <description>&lt;pre&gt;Hello,

Has anyone tried running imdbpy2sql.py on Ubuntu 12.04?  It was working
fine under 11.10, but now when I run it, it hangs on FLUSHING MoviesCache:

eric&amp;lt; at &amp;gt;eric-ubuntu:~/imdb$ ./imdbpy2sql.py -d ./compressed -u
mysql://root:xxxxxx&amp;lt; at &amp;gt;localhost/imdb

NOTICE: IF you're using InnoDB tables, data insertion can
be very slow; you can switch to MyISAM tables - forcing it
with the --mysql-force-myisam option - OR use the
--mysql-innodb command line option, but DON'T USE these if
you're already working on MyISAM tables, because it will
force MySQL to use InnoDB, and performances will be poor.

IMPORTING psyco... FAILED (not a big deal, everything is alright...)

RUNNING imdbpy2sql.py using the sqlobject ORM
SAVING imdbID values for movies... DONE! (0 entries)
SAVING imdbID values for people... DONE! (0 entries)
SAVING imdbID values for characters... DONE! (0 entries)
SAVING imdbID values for companies... DONE! (0 entries)
DROPPING current database... DONE!
CREATING new tables... DONE!
# TIME dropping and recreating the database : 0min, 14sec (wall) 0min, 0sec
(user) 0min, 0sec (system)
SCANNING movies: !Women Art Revolution (2010) (movieID: 1)
SCANNING movies: "31 minutos" (2003) {Benjamín Listillo (#1.4)} (movieID:
10001)
SCANNING movies: "A Favorita" (2008) {(#1.81)} (movieID: 20001)
SCANNING movies: "Access Hollywood Live" (2010) {(2011-05-10)} (movieID:
30001)
SCANNING movies: "Ajuste de Contas" (2000) {(#1.122)} (movieID: 40001)
SCANNING movies: "All Saints" (1998) {What Lies Beneath (#10.8)} (movieID:
50001)
SCANNING movies: "America's Next Top Model" (2003) {The Girl Who Forgot Her
Shoes (#3.7)} (movieID: 60001)
SCANNING movies: "Animal Crackers" (1988) (movieID: 70001)
SCANNING movies: "Aquí hay tomate" (2003) {(2006-08-09)} (movieID: 80001)
SCANNING movies: "Ask That Guy with the Glasses" (2008) {(#3.9)} (movieID:
90001)
 * FLUSHING MoviesCache...

And then just stays there indefinitely.  I have tried it with both mysql
5.5 and postgresql 9.1 and have the same problem with both.  I tried using
the -c option (-c /var/tmp) but it will generate the CSVs fine, but then
fail to write them to the db (for different reasons in both mysql and
postgresql -- some issue with not being supported or needing to be
superuser).  I also tried downgrading to python 2.6, but ran into problems
doing that.

Anyone done this successfully?

Thanks,
Eric
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/_______________________________________________
Imdbpy-help mailing list
Imdbpy-help-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&amp;lt; at &amp;gt;public.gmane.org
https://lists.sourceforge.net/lists/listinfo/imdbpy-help
&lt;/pre&gt;</description>
    <dc:creator>Eric Lange</dc:creator>
    <dc:date>2012-05-21T02:06:18</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/465">
    <title>imdbpy2slq</title>
    <link>http://permalink.gmane.org/gmane.comp.python.imdbpy.user/465</link>
    <description>&lt;pre&gt;Hi,
trying to run script imdbpy2sql, I got these issues (see below).
Mysqldb has been installed from site MySQL-python-1.2.3
and built like written in its readme file:


Issues I have (running python 2.7 preinstalled on Macbook pro)
thank you for helping me! I am total new in python, scripting and unix 


Traceback (most recent call last):



------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/_______________________________________________
Imdbpy-help mailing list
Imdbpy-help-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&amp;lt; at &amp;gt;public.gmane.org
https://lists.sourceforge.net/lists/listinfo/imdbpy-help
&lt;/pre&gt;</description>
    <dc:creator>gg4u</dc:creator>
    <dc:date>2012-05-07T10:25:42</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/464">
    <title>Re: Want to create xml files for every type of supported imdbpy object from mysql database</title>
    <link>http://permalink.gmane.org/gmane.comp.python.imdbpy.user/464</link>
    <description>&lt;pre&gt;

Sort of, but I can't guarantee you that it will not be painfully slow. :-)

First of all, you have to know the maximum ID of the object
you're considering (movies, persons, ...)
For movies, you can use something like:
  SELECT MAX(id) FROM title;

After that you can write a Python script to extract the information.
Something like this (beware that it's mostly pseudo-code) should work:

from imdb import IMDb

ia = IMDb('sql', uri='mysql://USERNAME:PASSWORD&amp;lt; at &amp;gt;localhost/imdb')

for idx in xrange(idx, MAX_ID+1):
    # get the movie object.
    movie = ia.get_movie(idx)
    # fetch all other information, if you need them.
    # ia.update(movie, 'all')
    # or maybe you're only interested in goofs:
    # ia.update(movie, 'goofs')
    # get the XML representation, and do what you want with it.
    xml = movie.asXML()
    # YOUR XML PROCESSING HERE

You better put all the code inside the 'for' cycle in a try/except clause,
since a lot of things can go wrong... just skip to the next item.

A recent suggestion that I want to implement is a JSON output,
but I still had no time to look at it. :-(


HTH

&lt;/pre&gt;</description>
    <dc:creator>Davide Alberani</dc:creator>
    <dc:date>2012-04-29T09:08:17</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/463">
    <title>Want to create xml files for every type of supported imdbpy object from mysql database</title>
    <link>http://permalink.gmane.org/gmane.comp.python.imdbpy.user/463</link>
    <description>&lt;pre&gt;Hello,

First of all, thanks to the devs for putting together a really nice api.
I'm new to imdbpy and python so I thought I'd throw my question at the list
and see what happens ;)

I've followed the instructions and populated a mysql db w/ the info from the
imdb flat files.
I want to output from this db an xml file for every single imdbpy object
type(Movie, Person, etc.).
Is there a way to do this?

Thanks!

-Ben


------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/_______________________________________________
Imdbpy-help mailing list
Imdbpy-help-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&amp;lt; at &amp;gt;public.gmane.org
https://lists.sourceforge.net/lists/listinfo/imdbpy-help
&lt;/pre&gt;</description>
    <dc:creator>Benjamin</dc:creator>
    <dc:date>2012-04-27T22:48:45</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/462">
    <title>Re: SQL Server Express 2008 R2 - Connection Error</title>
    <link>http://permalink.gmane.org/gmane.comp.python.imdbpy.user/462</link>
    <description>&lt;pre&gt;   [...]

Yep. :-(
Sorry, but I know next to nothing about databases on a Windows environment,
so I can't be of any help on this.


&lt;/pre&gt;</description>
    <dc:creator>Davide Alberani</dc:creator>
    <dc:date>2012-04-08T10:58:30</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/461">
    <title>Re: SQL Server Express 2008 R2 - Connection Error</title>
    <link>http://permalink.gmane.org/gmane.comp.python.imdbpy.user/461</link>
    <description>&lt;pre&gt;

Hi David, no worries about the delay - we're all busy :)

I should have stated in my original post  also tried SQL Alchemy. Here's the 
output:

---
c:\Python27\Scripts&amp;gt;python27 imdbpy2sql.py -d d:/install/imdb/subset/ -u "mssql+
pymssql://imdb:imdb&amp;lt; at &amp;gt;localhost/imdb" --ms-sqlserver -o sqlalchemy
2012-04-03 13:36:47,696 WARNING [imdbpy.parser.sql.alchemy] C:\Python27\lib\site
-packages\imdb\parser\sql\alchemyadapter.py:38: Unable to import migrate.changes
et: Foreign Keys will not be created.
Traceback (most recent call last):
  File "imdbpy2sql.py", line 501, in &amp;lt;module&amp;gt;
    conn = setConnection(URI, DB_TABLES)
  File "C:\Python27\lib\site-packages\imdb\parser\sql\alchemyadapter.py", line 4
86, in setConnection
    eng_conn = engine.connect()
  File "C:\Python27\lib\site-packages\sqlalchemy\engine\base.py", line 2458, in
connect
    return self._connection_cls(self, **kwargs)
  File "C:\Python27\lib\site-packages\sqlalchemy\engine\base.py", line 881, in _
_init__
    self.__connection = connection or engine.raw_connection()
  File "C:\Python27\lib\site-packages\sqlalchemy\engine\base.py", line 2544, in
raw_connection
    return self.pool.unique_connection()
  File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 183, in unique_c
onnection
    return _ConnectionFairy(self).checkout()
  File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 387, in __init__

    rec = self._connection_record = pool._do_get()
  File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 739, in _do_get
    con = self._create_connection()
  File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 188, in _create_
connection
    return _ConnectionRecord(self)
  File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 270, in __init__

    self.connection = self.__connect()
  File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 330, in __connec
t
    connection = self.__pool._creator()
  File "C:\Python27\lib\site-packages\sqlalchemy\engine\strategies.py", line 80,
 in connect
    return dialect.connect(*cargs, **cparams)
  File "C:\Python27\lib\site-packages\sqlalchemy\engine\default.py", line 285, i
n connect
    return self.dbapi.connect(*cargs, **cparams)
  File "pymssql.pyx", line 549, in pymssql.connect (pymssql.c:7110)
sqlalchemy.exc.OperationalError: (OperationalError) (20009, 'Net-Lib error durin
g Unknown error') None None

c:\Python27\Scripts&amp;gt;

---

I have created a blank DB in SQL Server which I can connect to okay using SQL 
Server Management Studio. I would expect the error messages to be a little more 
helpful, perhaps stating the login is incorrect or something - but the last few 
lines seem to indicate something is broken :(

Damien.


------------------------------------------------------------------------------
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second 
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev
&lt;/pre&gt;</description>
    <dc:creator>Damien</dc:creator>
    <dc:date>2012-04-03T03:42:00</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/460">
    <title>Re: SQL Server Express 2008 R2 - Connection Error</title>
    <link>http://permalink.gmane.org/gmane.comp.python.imdbpy.user/460</link>
    <description>&lt;pre&gt;
First of all, pardon for the long delay. :-/

Hmmm... not much, not knowing enough of SQL Server.
Maybe you can just try interfacing with it using SQLAlchemy, instead of the
default SQLObject.  Try adding the "-o sqlalchemy" argument to the
imdbpy2sql.py command line...


HTH,

&lt;/pre&gt;</description>
    <dc:creator>Davide Alberani</dc:creator>
    <dc:date>2012-03-31T15:58:47</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/459">
    <title>SQL Server Express 2008 R2 - Connection Error</title>
    <link>http://permalink.gmane.org/gmane.comp.python.imdbpy.user/459</link>
    <description>&lt;pre&gt;Hi there,

After running into some issues compiling from source - bumping up against the --
mno-cygwin issue using the latest MinGW release! :( - I reverted back to using 
Python 32 bit 2.7.2 environment, with the precompiled IMDbPy binary.

Using Pip, here's what I have:

c:\Python27\Scripts&amp;gt;pip freeze
Cython==0.15.1
FormEncode==1.2.4
IMDbPY==4.8.2
MySQL-python==1.2.3
SQLAlchemy==0.7.6
SQLObject==1.2.2
distribute==0.6.24
lxml==2.3.3
pymssql==2.0.0b1

This is under Windows 7. Each of the above was installed from a binary package. 
Now with this setup, I can dump the entire IMDb to MySQL using:

python27 imdbpy2sql.py -d d:/install/imdb/subset/ -u 
"mysql://root:mysql&amp;lt; at &amp;gt;localhost/imdb" --mysql-force-myisam

Which works great. However, now I'd like to get the same info into SQL Server 
Express 2008 R2. I have created an imdb user/login for SQL Server.

Yet when I execute:

c:\Python27\Scripts&amp;gt;python27 imdbpy2sql.py -d d:/install/imdb/subset/ -u "mssql:
//imdb:imdb&amp;lt; at &amp;gt;localhost/imdb" --ms-sqlserver

I get:

Traceback (most recent call last):
  File "imdbpy2sql.py", line 519, in &amp;lt;module&amp;gt;
    connectObject = conn.getConnection()
  File "C:\Python27\lib\site-packages\sqlobject\dbconnection.py", line 336, in g
etConnection
    conn = self.makeConnection()
  File "C:\Python27\lib\site-packages\sqlobject\mssql\mssqlconnection.py", line
94, in makeConnection
    con = self.dbconnection( *self.make_conn_str(self) )
  File "pymssql.pyx", line 552, in pymssql.connect (pymssql.c:7162)
pymssql.InterfaceError: Connection to the database failed for an unknown reason.

Any ideas?

Regards,

Damien.


------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here 
http://p.sf.net/sfu/sfd2d-msazure
&lt;/pre&gt;</description>
    <dc:creator>Damien</dc:creator>
    <dc:date>2012-03-26T07:25:06</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/458">
    <title>Re: Episode information of not available</title>
    <link>http://permalink.gmane.org/gmane.comp.python.imdbpy.user/458</link>
    <description>&lt;pre&gt;
Recently the episode pages changed a lot.
A fix is already available on the Mercurial repository:
  https://bitbucket.org/alberanid/imdbpy/

Let me know if you encounter other problems!


&lt;/pre&gt;</description>
    <dc:creator>Davide Alberani</dc:creator>
    <dc:date>2012-03-24T15:15:49</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/457">
    <title>Re: timing out</title>
    <link>http://permalink.gmane.org/gmane.comp.python.imdbpy.user/457</link>
    <description>&lt;pre&gt;
Ah, great!


Yep, it stalls on the read.  I thought that the setdefaulttimeout would have
fixed only problems at opening the socket... better this way. :-)

I've introduced a 'timeout' parameter, set by default to 30 seconds.
Please anyone report any strange behavior. :-)

It can be used from programmatically or from the configuration file,
as usual.

Thanks again!

&lt;/pre&gt;</description>
    <dc:creator>Davide Alberani</dc:creator>
    <dc:date>2012-03-24T15:07:55</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/456">
    <title>Episode information of not available</title>
    <link>http://permalink.gmane.org/gmane.comp.python.imdbpy.user/456</link>
    <description>&lt;pre&gt;Hi there,

I was looking if I could retreive episode information through imdbpy,
but was unable to do so:

I executed following code which can be found here:
http://imdbpy.sourceforge.net/docs/README.series.txt

  from imdb import IMDb
  i = IMDb()
  m = i.get_movie('0389564')  # The 4400.
  m['kind']    # kind is 'tv series'.
  i.update(m, 'episodes')   # retrieves episodes information.

 Whenever I call:
 m['episodes']

I get following error message:

...\imdb\utils.pyc in __getitem__(self, key)
   1431         # Handle key aliases.

   1432         key = self.keys_alias.get(key, key)
-&amp;gt; 1433         rawData = self.data[key]
   1434         if key in self.keys_tomodify and \
   1435                 self.modFunct not in (None, modNull):

KeyError: 'episodes'


I'm I doing something wrong? I currently using IMDbPY 4.8.2 2011-11-01
with Python 2.7.2 32 Bit.

It would be very nice if someone could help me here or at least see if
you also get the error.

Greetings,
David

------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here 
http://p.sf.net/sfu/sfd2d-msazure
&lt;/pre&gt;</description>
    <dc:creator>David Kaufman</dc:creator>
    <dc:date>2012-03-24T13:44:13</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/455">
    <title>Re: timing out</title>
    <link>http://permalink.gmane.org/gmane.comp.python.imdbpy.user/455</link>
    <description>&lt;pre&gt;On Sat, 24 Mar 2012 12:56:09 +0100, Davide Alberani  
&amp;lt;davide.alberani-Re5JQEeQqe8AvxtiuMwx3w&amp;lt; at &amp;gt;public.gmane.org&amp;gt; wrote:

Understood.

Well, I think this'd better stay in programs that use IMDbPy, for the very  
reasons you stated.

Yeap, it does not happen always, but pretty often. Usually, trying to run  
it one or two more times is enough, but the program needs to know that it  
has failed, so that is why I am asking about this. I am running this in  
ipython console, just the commands I stated (import and then I call  
imdb.IMDB...)

Hm, this seems to work, thanks!


BTW: when it hangs and I stop it with ctrl+C, this is what ipython tells  
me:

/usr/local/lib/python2.7/dist-packages/IMDbPY-4.9dev_20120324-py2.7-linux-x86_64.egg/imdb/__init__.pyc  
in get_movie(self, movieID, info, modFunct)
     408         if modFunct is not None:
     409             movie.set_mod_funct(modFunct)
--&amp;gt; 410         self.update(movie, info)
     411         return movie
     412

/usr/local/lib/python2.7/dist-packages/IMDbPY-4.9dev_20120324-py2.7-linux-x86_64.egg/imdb/__init__.pyc  
in update(self, mop, info, override)
     769                 method = lambda *x: {}
     770             try:
--&amp;gt; 771                 ret = method(mopID)
     772             except Exception, e:
     773                 self._imdb_logger.critical('caught an exception  
retrieving ' \

/usr/local/lib/python2.7/dist-packages/IMDbPY-4.9dev_20120324-py2.7-linux-x86_64.egg/imdb/parser/http/__init__.pyc  
in get_movie_main(self, movieID)
     483
     484     def get_movie_main(self, movieID):
--&amp;gt; 485         cont = self._retrieve(self.urls['movie_main'] % movieID +  
'combined')
     486         return self.mProxy.movie_parser.parse(cont,  
mdparse=self._mdparse)
     487

/usr/local/lib/python2.7/dist-packages/IMDbPY-4.9dev_20120324-py2.7-linux-x86_64.egg/imdb/parser/http/__init__.pyc  
in _retrieve(self, url, size, _noCookies)
     430         self._http_logger.debug('fetching url %s (size: %d)', url,  
size)
     431         try:
--&amp;gt; 432             ret = self.urlOpener.retrieve_unicode(url, size=size)
     433         finally:
     434             if _noCookies and _cookies:

/usr/local/lib/python2.7/dist-packages/IMDbPY-4.9dev_20120324-py2.7-linux-x86_64.egg/imdb/parser/http/__init__.pyc  
in retrieve_unicode(self, url, size)
     193             if PY_VERSION &amp;gt; (2, 3) and not IN_GAE:
     194                 kwds['size'] = size
--&amp;gt; 195             content = uopener.read(**kwds)
     196             self._last_url = uopener.url
     197             # Maybe the server is so nice to tell us the charset...


/usr/lib/python2.7/socket.pyc in read(self, size)
     349             while True:
     350                 try:
--&amp;gt; 351                     data = self._sock.recv(rbufsize)
     352                 except error, e:
     353                     if e.args[0] == EINTR:

KeyboardInterrupt:

------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here 
http://p.sf.net/sfu/sfd2d-msazure
&lt;/pre&gt;</description>
    <dc:creator>Tomáš Hnyk</dc:creator>
    <dc:date>2012-03-24T12:10:15</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/454">
    <title>Re: timing out</title>
    <link>http://permalink.gmane.org/gmane.comp.python.imdbpy.user/454</link>
    <description>&lt;pre&gt;
:-/
It's very possible that it will wait until the end of time, I fear.


My fault: I misunderstood the problem.
No, IMDbPY uses urllib, and it doesn't provide a way to set
a timeout.  urllib2 has it, but only in very recent python versions,
so I'd prefer not to use it (and, by the way, a conversion from urllib
to urllib2 would take me some time).


Yes, it's more or less reasonable, but I want to think twice about
it, before I introduce an alarm in the IMDbPY code... after
all i's a library and it could heavily interfere with signal handling
made by the programs that uses it. :-(

Real point is, it's very strange that it happens so methodically on
your system... I think I've never seen it hangs during a request.

Anyway, if you can try to put _before_ IMDb is imported/instanced this:
  import socket
  socket.setdefaulttimeout(10)

With that, at least the 'open' should fail after at most 10 seconds.
If this doesn't work for you, it means that the connection is established,
but hangs (or is really slow) reading the data.
If it's so, I fear an alarm-based solution is the only way... :-/

Thanks for the debugging!

&lt;/pre&gt;</description>
    <dc:creator>Davide Alberani</dc:creator>
    <dc:date>2012-03-24T11:56:09</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/453">
    <title>Re: timing out</title>
    <link>http://permalink.gmane.org/gmane.comp.python.imdbpy.user/453</link>
    <description>&lt;pre&gt;
Ok, in the mercurial repository you can set the 'reraiseExceptions' argument
(of the IMDb() instance or in the imdbpy.cfg file, if you use it) to True, to
re-raise every caught exception.  By default, it's false.

Thanks for the idea, I've added your name to the credits.


&lt;/pre&gt;</description>
    <dc:creator>Davide Alberani</dc:creator>
    <dc:date>2012-03-24T07:46:21</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/452">
    <title>Re: timing out</title>
    <link>http://permalink.gmane.org/gmane.comp.python.imdbpy.user/452</link>
    <description>&lt;pre&gt;
No, you're right.
It's done to gracefully handle the (many) problems that can arise parsing
information... in the general case, it's better to go on and live without
some information.

Anyway, it's easy to add a parameter of IMDb() that can be used to
re-raise the caught exception, if one wants it.

I'll do it in the weekend, and I'll let you know.


Thanks for the report!

&lt;/pre&gt;</description>
    <dc:creator>Davide Alberani</dc:creator>
    <dc:date>2012-03-22T07:46:44</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/451">
    <title>timing out</title>
    <link>http://permalink.gmane.org/gmane.comp.python.imdbpy.user/451</link>
    <description>&lt;pre&gt;Hello all,
so let's say I am trying to get movie's info:
movie = imdb.IMDb().get_movie('FilmID')
but it times out - i.e. something goes wrong and the movie's info is not
retrieved. Ideally, I would like to do something like:
try:
      movie = imdb.IMDb().get_movie('FilmID')
except imdb.IMDbDataAccessError:
      # tell me it times out and do something about it
But it seems imdb.IMDb().get_movie() does not give exceptions when it
times out. (It sometimes is not succesful in retrieving movies info but is
suspiciously silent about it).

Am I doing something wrong?
Regards,
Tomas

------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here 
http://p.sf.net/sfu/sfd2d-msazure
&lt;/pre&gt;</description>
    <dc:creator>Tomáš Hnyk</dc:creator>
    <dc:date>2012-03-21T21:31:02</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.comp.python.imdbpy.user/450">
    <title>Re: install fails</title>
    <link>http://permalink.gmane.org/gmane.comp.python.imdbpy.user/450</link>
    <description>&lt;pre&gt;
I admit that this error is somewhat strange, and I'm unable
to reproduce it (python 2.7, ubuntu 11.10 - but distutils doesn't
seem to be changed).
Are you sure to have the python-setuptools package installed,
and that there are no other packages/modules with the
same name installed somewhere else on the system?

Anyway, the command to install it should be:
  python ./setup.py install

Let us know if this fixes the problem.

&lt;/pre&gt;</description>
    <dc:creator>Davide Alberani</dc:creator>
    <dc:date>2012-03-18T18:28:44</dc:date>
  </item>
  <textinput rdf:about="http://search.gmane.org/?group=$group=gmane.comp.python.imdbpy.user">
    <title>Search Engine</title>
    <description>Search the mailing list at Gmane</description>
    <name>query</name>
    <link>http://search.gmane.org/?group=$group=gmane.comp.python.imdbpy.user</link>
  </textinput>
</rdf:RDF>

