You have the wrong package name.

[MySQL-python][1] is the right one:

&lt;pre&gt;
easy_install MySQL-python
&lt;/pre&gt;

or 

&lt;pre&gt;
pip install MySQL-python
&lt;/pre&gt;

  [1]: http://pypi.python.org/pypi/MySQL-python/

Adam is right but before you run `easy_install MySQL-python` you need to make sure `python-dev` is installed as it is not installed by default.

Install is with `apt-get install python-dev`.

If you are using &quot;yum&quot; the command is `sudo yum install python-devel` (where &#39;sudo&#39; may be optional depending on your user account)

Is it possible to change the unit for `Paint.setTextSize()`? As far as I know, it&#39;s pixel but I like to set the text size in DIP for multiple screen support.



How to set unit for Paint.setTextSize()

I&#39;ve seen regex patterns that use explicitly numbered repetition instead of `?`, `*` and `+`, i.e.:

    Explicit            Shorthand
    (something){0,1}    (something)?
    (something){1}      (something)
    (something){0,}     (something)*
    (something){1,}     (something)+

The questions are:

* Are these two forms identical? What if you add possessive/reluctant modifiers?
* If they are identical, which one is more idiomatic? More readable? Simply &quot;better&quot;?


Using explicitly numbered repetition instead of question mark, star and plus

This is what I tried:

    $ easy_install-2.6 -d /home/user/lib/python2.6 MySQLdb  
    Searching for MySQLdb  
    Reading http://pypi.python.org/simple/MySQLdb/  
    Couldn&#39;t find index page for &#39;MySQLdb&#39; (maybe misspelled?)  
    Scanning index of all packages (this may take a while)  
    Reading http://pypi.python.org/simple/  
    No local packages or download links found for MySQLdb  
    error: Could not find suitable distribution for Requirement.parse(&#39;MySQLdb&#39;)  



Why can&#39;t easy_install find MySQLdb?

This is what I tried:
<pre><code class="hljs language-rust">$ easy_install-2.6 -d /home/user/lib/python2.6 MySQLdb 
Searching for MySQLdb 
Reading http://pypi.python.org/simple/MySQLdb/ 
Couldn't find index page for 'MySQLdb' (maybe misspelled?) 
Scanning index of all packages (this may take a while) 
Reading http://pypi.python.org/simple/ 
No local packages or download links found for MySQLdb 
error: Could not find suitable distribution for Requirement.parse('MySQLdb') 
</code></pre>

I&#39;m writing a lightweight class whose attributes are intended to be publicly accessible, and only sometimes overridden in specific instantiations.  There&#39;s no provision in the Python language for creating docstrings for class attributes, or any sort of attributes, for that matter.  What is the expected and supported way, should there be one, to document these attributes?  Currently I&#39;m doing this sort of thing:

    class Albatross(object):
        &quot;&quot;&quot;A bird with a flight speed exceeding that of an unladen swallow.

        Attributes:
        &quot;&quot;&quot;
    
        flight_speed = 691
        __doc__ += &quot;&quot;&quot;
            flight_speed (691)
              The maximum speed that such a bird can attain.
        &quot;&quot;&quot;
    
        nesting_grounds = &quot;Raymond Luxury-Yacht&quot;
        __doc__ += &quot;&quot;&quot;
            nesting_grounds (&quot;Raymond Luxury-Yacht&quot;)
              The locale where these birds congregate to reproduce.
        &quot;&quot;&quot;
    
        def __init__(self, **keyargs):
            &quot;&quot;&quot;Initialize the Albatross from the keyword arguments.&quot;&quot;&quot;
            self.__dict__.update(keyargs)

This will result in the class&#39;s docstring containing the initial standard docstring section, as well as the lines added for each attribute via augmented assignment to `__doc__`.

Although this style doesn&#39;t seem to be expressly forbidden in the [docstring style guidelines][1], it&#39;s also not mentioned as an option.  The advantage here is that it provides a way to document attributes alongside their definitions, while still creating a presentable class docstring, and avoiding having to write comments that reiterate the information from the docstring.  I&#39;m still kind of annoyed that I have to actually write the attributes twice; I&#39;m considering using the string representations of the values in the docstring to at least avoid duplication of the default values.

Is this a heinous breach of the ad hoc community conventions?  Is it okay?  Is there a better way?  For example, it&#39;s possible to create a dictionary containing values and docstrings for the attributes and then add the contents to the class `__dict__` and docstring towards the end of the class declaration; this would alleviate the need to type the attribute names and values twice.  **edit**: this last idea is, I think, not actually possible, at least not without dynamically building the entire class from data, which seems like a really bad idea unless there&#39;s some other reason to do that.

I&#39;m pretty new to python and still working out the details of coding style, so unrelated critiques are also welcome.


  [1]: http://www.python.org/dev/peps/pep-0257/

How to document class attributes in Python?

Is there any Python library that allows me to parse an HTML document similar to what `jQuery` does?

i.e. I&#39;d like to be able to use **CSS selectors syntax** to grab an arbitrary set of nodes from the document, read their content/attributes, etc.

The only Python HTML parsing lib I&#39;ve used before was **BeautifulSoup**, and even though it&#39;s fine I keep thinking it would be faster to do my parsing if I had jQuery syntax available. :D

jquery-like HTML parsing in Python?

I have a multi-line string defined like this:

    foo = &quot;&quot;&quot;
    this is 
    a multi-line string.
    &quot;&quot;&quot;

This string we used as test-input for a parser I am writing. The parser-function receives a `file`-object as input and iterates over it. It does also call the `next()` method directly to skip lines, so I really need an iterator as input, not an iterable.
I need an iterator that iterates over the individual lines of that string like a `file`-object would over the lines of a text-file. I could of course do it like this:

    lineiterator = iter(foo.splitlines())

Is there a more direct way of doing this? In this scenario the string has to traversed once for the splitting, and then again by the parser. It doesn&#39;t matter in my test-case, since the string is very short there, I am just asking out of curiosity. Python has so many useful and efficient built-ins for such stuff, but I could find nothing that suits this need.

Iterate over the lines of a string

As a result of the comments in my answer on [this thread][1], I wanted to know what the speed difference is between the `+=` operator and `&#39;&#39;.join()`

So what is the speed comparison between the two?


  [1]: https://stackoverflow.com/questions/3054604/iterate-over-the-lines-of-a-string/3054679#3054679

How slow is Python&#39;s string concatenation vs. str.join?

How can I get the file name and line number in a Python script? 

Exactly the file information we get from an exception traceback. In this case without raising an exception.

filename and line number of Python script

I&#39;ve been using indexes on my MySQL databases for a while now but never properly *learnt* about them. Generally I put an index on any fields that I will be searching or selecting using a `WHERE` clause but sometimes it doesn&#39;t seem so black and white.

**What are the best practices for MySQL indexes?**

Example situations/dilemmas:

* If a table has six columns and all of them are searchable, should I index all of them or none of them?

* What are the negative performance impacts of indexing?

* If I have a VARCHAR 2500 column which is searchable from parts of my site, should I index it?



MySQL indexes - what are the best practices?

I&#39;ve been working on writing SQL to create a MySQL database with several default options, including character set and collation.  Is it possible to set the default storage engine for tables in this database to InnoDB? 

I&#39;ve been looking through the MySQL 5.1 manual and I&#39;ve found the statement `ENGINE=innodb` which would be appended to a `CREATE TABLE` statement, but I haven&#39;t found anything related to a `CREATE DATABASE` statement.  

Is there a normal way to do this as part of the database creation, or does it need to be specified on a table-by-table basis?


How can I set default storage engine used by MySQL?

I&#180;d like to SELECT a single value into a variable. I&#180;d tried to following:

    DECLARE myvar INT(4);

-- immediately returns some syntax error.

    SELECT myvalue 
      FROM mytable 
     WHERE anothervalue = 1;

-- returns a single integer

    SELECT myvalue 
      INTO myvar 
      FROM mytable 
     WHERE anothervalue = 1;

-- does not work, also tried @myvar

Is possible to use DECLARE outside of stored procedures or functions?

Maybe I just dont get the concept of user variables... I just tried:

    SELECT myvalue INTO @var FROM `mytable` WHERE uid = 1;
    SELECT @var;

...which worked just like it&#180;s supposed to. But if I run each query at a time i just get @var NULL.






SELECT INTO Variable in MySQL DECLARE causes syntax error?

Does anyone know how I can take a MySQL `datetime` data type value, such as `YYYY-MM-DD HH:MM:SS` and either parse it or convert it to work in JavaScript&#39;s `Date()` function, for example:- Date(&#39;YYYY, MM, DD, HH, MM, SS);

Thank you!

Convert MySql DateTime stamp into JavaScript&#39;s Date format

I am doing `SELECT GROUP_CONCAT(categories SEPARATOR &#39; &#39;) FROM table`. Sample data below:

    categories
    ----------
    test1 test2 test3
    test4
    test1 test3
    test1 test3

However, I am getting `test1 test2 test3 test4 test1 test3` back and I would like to get `test1 test2 test3 test4` back. Any ideas?

Many thanks!

MySQL DISTINCT on a GROUP_CONCAT()

A [tweet][1] reads: 

&gt; Don&#39;t use easy_install, unless you
&gt; like stabbing yourself in the face.
&gt; Use pip.

Why use pip over easy_install? Doesn&#39;t the [fault lie with PyPI and package authors mostly][2]? If an author uploads crap source tarball (eg: missing files, no setup.py) to PyPI, then both pip and easy_install will fail. Other than cosmetic differences, why do Python people (like in the above tweet) seem to **strongly** favor pip over easy_install?

(Let&#39;s assume that we&#39;re talking about easy_install from the Distribute package, that is maintained by the community)

  [1]: http://twitter.com/jperras/statuses/18160589493
  [2]: http://mail.python.org/pipermail/catalog-sig/2010-June/002985.html

Why use pip over easy_install?

I&#39;m running Python 2.7 on Windows 7 64-bit, and when I run the installer for setuptools it tells me that Python 2.7 is not installed.  The specific error message is:

    `Python Version 2.7 required which was not found in the registry`

My installed version of Python is:

    `Python 2.7 (r27:82525, Jul  4 2010, 07:43:08) [MSC v.1500 64 bit (AMD64)] on win32`

I&#39;m looking at the setuptools site and it doesn&#39;t mention any installers for 64-bit Windows.  Have I missed something or do I have to install this from source?

Installing SetupTools on 64-bit Windows

I&#39;m trying to install `lxml`. I&#39;ve had a look at the website, and version 2.2.8 looked reasonable to me but when I did `easy_install lxml`, it installed version 2.3.beta1 which is not really what I want I presume.

What is the best way to fix this and how can I force easy_install to install a particular version?

(Mac os x 10.6)

Install particular version with easy_install

After installing Python 2.7 on Windows XP, then manually setting the `%PATH%` to `python.exe` (why won&#39;t the python installer do this?), then installing `setuptools 0.6c11` (why doesn&#39;t the python installer do this?), then manually setting the `%PATH%` to `easy_install.exe` (why doesn&#39;t the installer do this?), I finally tried to install a python package with `easy_install`, but `easy_install` failed when it couldn&#39;t install the pywin32 package, which is a dependency. **How can I make easy_install work properly on Windows XP?** The failure follows:


&lt;pre&gt;C:\&gt;easy_install winpexpect
Searching for winpexpect
Best match: winpexpect 1.4
Processing winpexpect-1.4-py2.7.egg
winpexpect 1.4 is already the active version in easy-install.pth

Using c:\python27\lib\site-packages\winpexpect-1.4-py2.7.egg
Processing dependencies for winpexpect
Searching for pywin32&gt;=214
Reading http://pypi.python.org/simple/pywin32/
Reading http://sf.net/projects/pywin32
Reading http://sourceforge.net/project/showfiles.php?group_id=78018
No local packages or download links found for pywin32&gt;=214
Best match: None
Traceback (most recent call last):
  File &quot;C:\python27\scripts\easy_install-script.py&quot;, line 8, in &lt;module&gt;
    load_entry_point(&#39;setuptools==0.6c11&#39;, &#39;console_scripts&#39;, &#39;easy_install&#39;)()
  File &quot;C:\python27\lib\site-packages\setuptools\command\easy_install.py&quot;, line 1712, in main
    with_ei_usage(lambda:
  File &quot;C:\python27\lib\site-packages\setuptools\command\easy_install.py&quot;, line 1700, in with_ei_usage
    return f()
  File &quot;C:\python27\lib\site-packages\setuptools\command\easy_install.py&quot;, line 1716, in &lt;lambda&gt;
    distclass=DistributionWithoutHelpCommands, **kw
  File &quot;C:\python27\lib\distutils\core.py&quot;, line 152, in setup
    dist.run_commands()
  File &quot;C:\python27\lib\distutils\dist.py&quot;, line 953, in run_commands
    self.run_command(cmd)
  File &quot;C:\python27\lib\distutils\dist.py&quot;, line 972, in run_command
    cmd_obj.run()
  File &quot;C:\python27\lib\site-packages\setuptools\command\easy_install.py&quot;, line 211, in run
    self.easy_install(spec, not self.no_deps)
  File &quot;C:\python27\lib\site-packages\setuptools\command\easy_install.py&quot;, line 446, in easy_install
    return self.install_item(spec, dist.location, tmpdir, deps)
  File &quot;C:\python27\lib\site-packages\setuptools\command\easy_install.py&quot;, line 481, in install_item
    self.process_distribution(spec, dists[0], deps, &quot;Using&quot;)
  File &quot;C:\python27\lib\site-packages\setuptools\command\easy_install.py&quot;, line 519, in process_distribution
    [requirement], self.local_index, self.easy_install
  File &quot;C:\python27\lib\site-packages\pkg_resources.py&quot;, line 563, in resolve
    dist = best[req.key] = env.best_match(req, self, installer)
  File &quot;C:\python27\lib\site-packages\pkg_resources.py&quot;, line 799, in best_match
    return self.obtain(req, installer) # try and download/install
  File &quot;C:\python27\lib\site-packages\pkg_resources.py&quot;, line 811, in obtain
    return installer(requirement)
  File &quot;C:\python27\lib\site-packages\setuptools\command\easy_install.py&quot;, line 434, in easy_install
    self.local_index
  File &quot;C:\python27\lib\site-packages\setuptools\package_index.py&quot;, line 475, in fetch_distribution
    return dist.clone(location=self.download(dist.location, tmpdir))
AttributeError: &#39;NoneType&#39; object has no attribute &#39;clone&#39;
&lt;/pre&gt;

How to use Python&#39;s &quot;easy_install&quot; on Windows ... it&#39;s not so easy

[`pip`][1] is a replacement for [`easy_install`][2]. But should I install `pip` using `easy_install` on Windows? Is there a better way?

  [1]: https://pip.pypa.io/en/stable/
  [2]: http://setuptools.readthedocs.io/en/latest/easy_install.html


Content Type	Original Author	Original Content on Stackoverflow
Question	BryanWheelock	View Question on Stackoverflow
Solution 1 - Python	mechanical_meat	View Answer on Stackoverflow
Solution 2 - Python	Jeff H	View Answer on Stackoverflow
Solution 3 - Python	Adam	View Answer on Stackoverflow

Why can't easy_install find MySQLdb?

Python Problem Overview

Python Solutions

Solution 1 - Python

Solution 2 - Python

Solution 3 - Python

Using explicitly numbered repetition instead of question mark, star and plus

How to set unit for Paint.setTextSize()

Attributions