Bug#698969: mysql-workbench: Please Depends against python-pyodbc (>= 3.0.6)

[Laurent Bigonville]

Package: mysql-workbench
Version: 5.2.44+dfsg-1~exp1
Severity: normal

Hi,

The mysql-workbench contains code that allow to migrate databases from
any databases that support odbc connectors to mysql. This code requires
pyodbc python module.

I've just uploaded python-pyodbc 3.0.6-1 package in experimental.

Could you please add a dependency(or a recommends) against that
package?

Kind regards

Laurent Bigonville

-- System Information:
Debian Release: 7.0
APT prefers unstable
APT policy: (500, 'unstable'), (1, 'experimental')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 3.7-trunk-amd64 (SMP w/8 CPU cores)
Locale: LANG=fr_BE.utf8, LC_CTYPE=fr_BE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages mysql-workbench depends on:
ii libatkmm-1.6-1 2.22.6-1
ii libc6 2.16-0experimental1
ii libcairo2 1.12.2-2
ii libctemplate2 2.2-3
ii libgcc1 1:4.7.2-5
ii libgdk-pixbuf2.0-0 2.26.1-1
ii libgl1-mesa-glx [libgl1] 8.0.5-3
ii libglib2.0-0 2.34.3-1
ii libglibmm-2.4-1c2a 2.32.1-1
ii libgnome-keyring0 3.4.1-1
ii libgtk2.0-0 2.24.14-1
ii libgtkmm-2.4-1c2a 1:2.24.2-1
ii liblua5.1-0 5.1.5-4
ii libmysqlclient18 5.5.29+dfsg-1
ii libmysqlcppconn6 1.1.1-2
ii libodbc1 2.2.14p2-5
ii libpango1.0-0 1.30.0-1
ii libpangomm-1.4-1 2.28.4-1
ii libpcre3 1:8.31-2
ii libpython2.7 2.7.3-6
ii libsigc++-2.0-0c2a 2.2.10-0.2
ii libsqlite3-0 3.7.15.2-1
ii libstdc++6 4.7.2-5
ii libtinyxml2.6.2 2.6.2-1
ii libuuid1 2.20.1-5.3
ii libx11-6 2:1.5.0-1
ii libxml2 2.8.0+dfsg1-7
ii libzip2 0.10.1-1.1
ii mysql-client 5.5.29+dfsg-1
ii mysql-client-5.5 [mysql-client] 5.5.29+dfsg-1
ii mysql-workbench-data 5.2.44+dfsg-1~exp1
ii python 2.7.3-3
ii python-mysql.connector 0.3.2-1
ii python-paramiko 1.7.7.1-3.1
ii python-pexpect 2.4-1
ii python-pysqlite2 2.6.3-3
ii python2.7 2.7.3-6

Versions of packages mysql-workbench recommends:
pn mysql-utilities <none>
pn ttf-bitstream-vera <none>

Versions of packages mysql-workbench suggests:
ii gnome-keyring 3.4.1-5

-- no debconf information


--
To UNSUBSCRIBE, email to debian-bugs-...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listm...@lists.debian.org

[Dmitry Smirnov]

Hi Laurent,

On Sat, 26 Jan 2013 08:16:19 Laurent Bigonville wrote:
> The mysql-workbench contains code that allow to migrate databases from
> any databases that support odbc connectors to mysql. This code requires
> pyodbc python module.
>
> I've just uploaded python-pyodbc 3.0.6-1 package in experimental.
>
> Could you please add a dependency(or a recommends) against that
> package?

Thank you for good suggestion.

Few questions please:

Would you prefer adding to Depends or to Recomments?
(I tend towards Recommends for whatever reason).

Would you recommend versioned depends like "python-pyodbc (>= 3.0.6)" ?
Does it work with 2.1.7 from testing/unstable?

Thank you.

--
Best wishes,
Dmitry Smirnov
GPG key : 4096R/53968D1B

---

The man who does not do his own thinking is a slave, and is a traitor
to himself and to his fellow-men.
-- Robert G. Ingersoll, "The Liberty
of Man, Woman and Child" 1877

[Laurent Bigonville]

Le Sat, 26 Jan 2013 13:09:12 +1100,
Dmitry Smirnov <onl...@member.fsf.org> a écrit :

> Hi Laurent,

Hello,

> On Sat, 26 Jan 2013 08:16:19 Laurent Bigonville wrote:
> > The mysql-workbench contains code that allow to migrate databases
> > from any databases that support odbc connectors to mysql. This code
> > requires pyodbc python module.
> >
> > I've just uploaded python-pyodbc 3.0.6-1 package in experimental.
> >
> > Could you please add a dependency(or a recommends) against that
> > package?
>
> Thank you for good suggestion.
>
> Few questions please:
>
> Would you prefer adding to Depends or to Recomments?
> (I tend towards Recommends for whatever reason).

I think you are getting an warning/error when python-pyodbc is not
present instead of a simple crash. I guess recommending the package
would be enough, but then you cannot enforce version. IMHO it would
depends on the number of extra packages that are getting installed.

> Would you recommend versioned depends like "python-pyodbc (>=
> 3.0.6)" ? Does it work with 2.1.7 from testing/unstable?

I don't this it's working with the version in wheezy. In the code I see:

"Could not import the pyodbc python module. You need pyodbc 2.1.8 or
newer for migrations from RDBMSes other than MySQL."

So I guess that the version should be (>= 2.1.8) instead of (>= 3.0.6).

Cheers

Laurent Bigonville

[Dmitry Smirnov]

On Sat, 26 Jan 2013 22:29:07 Laurent Bigonville wrote:
> I think you are getting an warning/error when python-pyodbc is not
> present instead of a simple crash. I guess recommending the package
> would be enough, but then you cannot enforce version. IMHO it would
> depends on the number of extra packages that are getting installed.
>

> I don't this it's working with the version in wheezy. In the code I see:
>
> "Could not import the pyodbc python module. You need pyodbc 2.1.8 or
> newer for migrations from RDBMSes other than MySQL."
>
> So I guess that the version should be (>= 2.1.8) instead of (>= 3.0.6).

I see, we only have 2.1.7 in "testing"...

Recently I've learned that versioned Recommends are considered by aptitude but
ignored by apt-get.
What do you think about combination of

Recommends: python-pyodbc (>= 3.0.6)
Breaks: python-pyodbc (< 3.0.6)

as alternative to

Depends: python-pyodbc (>= 3.0.6)

?

Depends is a good way to enforce version and I reckon we can ignore the
negative effect on backportability for now...

Thanks.

--
All the best,

Dmitry Smirnov
GPG key : 4096R/53968D1B

---

To swallow and follow, whether old doctrine or new propaganda, is a
weakness still dominating the human mind.
-- Charlotte P. Gilman

[Laurent Bigonville]

Le Sat, 26 Jan 2013 22:59:55 +1100,

Dmitry Smirnov <onl...@member.fsf.org> a écrit :

> On Sat, 26 Jan 2013 22:29:07 Laurent Bigonville wrote:
> > I think you are getting an warning/error when python-pyodbc is not
> > present instead of a simple crash. I guess recommending the package
> > would be enough, but then you cannot enforce version. IMHO it would
> > depends on the number of extra packages that are getting installed.
> >
> > I don't this it's working with the version in wheezy. In the code I
> > see:
> >
> > "Could not import the pyodbc python module. You need pyodbc 2.1.8 or
> > newer for migrations from RDBMSes other than MySQL."
> >
> > So I guess that the version should be (>= 2.1.8) instead of (>=
> > 3.0.6).
>
> I see, we only have 2.1.7 in "testing"...
>
> Recently I've learned that versioned Recommends are considered by
> aptitude but ignored by apt-get.
> What do you think about combination of
>
> Recommends: python-pyodbc (>= 3.0.6)
> Breaks: python-pyodbc (< 3.0.6)
>
> as alternative to
>
> Depends: python-pyodbc (>= 3.0.6)
>
> ?
>
> Depends is a good way to enforce version and I reckon we can ignore
> the negative effect on backportability for now...

Well I would probably just reflect what the software really needs (so
2.1.7) even if it's not available.

I don't think the breaks is needed, the error message will show the
needed version if it's not available.

I would personally just do:



Depends: python-pyodbc (>= 2.1.8) or Recommends: python-pyodbc (>=
2.1.8)

Cheers

Laurent Bigonville