Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.xs4all.nl!newsfeed2.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
MIME-Version: 1.0
In-Reply-To: <5223A8F1.9080905@verizon.net>
References: <5223A8F1.9080905@verizon.net>
Date: Wed, 4 Sep 2013 10:28:44 +0100
Subject: Re: MySQL data types vs Django/Python data types
From: =?ISO-8859-1?Q?F=E1bio_Santos?= <fabiosantosart@gmail.com>
To: Gary Roach <gary719_list1@verizon.net>
Content-Type: multipart/alternative; boundary=047d7b5d4e5c8ea3ab04e58b6eb6
Cc: python-list@python.org
Precedence: list
Newsgroups: comp.lang.python
Message-ID: <mailman.36.1378286933.5461.python-list@python.org>
Lines: 157
NNTP-Posting-Host: 2001:888:2000:d::a6
Xref: csiph.com comp.lang.python:53611

--047d7b5d4e5c8ea3ab04e58b6eb6
Content-Type: text/plain; charset=ISO-8859-1

On 1 Sep 2013 21:54, "Gary Roach" <gary719_list1@verizon.net> wrote:
>
> Hi all,
>
> System:
>         Debian Wheezy Linux
>         Python 2.7
>         Django 1.5
>         MySql 5.5
>
> I am new to Python and Django and am having trouble matching Python data
types with those of MySQL. MySQL has about 7 basic data types including
Blobs, Binaries, etc. It also has a rich selection of geometry types. In
addition, types like INT have 7 or 8 different options like Primary Key,
zero fill, auto inc, etc. I can't seem to find anything in python to match
these. I am trying to build a model.py for an existing database that was
created with MySQL Workbench.

First, I want to state that you need to understand that Django was designed
to help build simple, common use case web apps. Database skins, as someone
put it. The ORM is very easy to use, although it is not well prepared for
some things.

It also has a very nice advantage, which is being compatible with many
RDBMS so you can have postgresql on the production server and sqlite on
your development machine. This ends up being bad too. For instance, if it
is not possible to do something in a specific rdbms, for instance, let's
say blobs, Django will not be able to implement it because it has to
support those several rdbms.

There are many hacks ( http://djangosnippets.org/snippets/1597/ ) but hacks
will be hacks and you want your app to be reliable and not compromise your
code quality right from the start, right?

Many field options have equivalents in Django (primary key, auto
increment). You just have to find them. For auto increment there is
AutoField. Primary key is an option of the base Field (so you can provide
it as a keyword argument to any field).

Also if you want gis geometry data types (is that what you meant?) you can
install and use geodjango.

> I do not wish to use anything other than MySQL because of the complexity
of my storage needs (searchable text, PDF, Audio, Video and Photos). The
text searches will often be word phrase searches through thousands of
documents. I need the speed and the data type flexibility.

Are you sure mysql is up to it? For searchable text you will want to have
an index, and while mysql's FULLTEXT kind of works, it is clearly not a
core feature. Some options for it are enabled or disabled in compile time.
Also, I won't judge but it's often wrong to use a rdbms to store
PDF/audio/video. Those belong in the file system or nosql storage.

> How do I build or modify a model.py to do this. I really don't want to
write a model.py manually. That would really be a major pain. Workbench to
the database an import to Django and edit is my choice. Unfortunately, the
model.py produced has lost most of the functionality of the original
database and I can't seem to figure out how to fix it.
>
> Any help will be sincerely appreciated.
>
> Gary R.

A lot can be done by using the database manually. Django helps you a bit
here, for instance it gives you access to the database cursor for raw SQL
access to the database, supports custom fields, and every orm query "chain"
(like MyModel.objects.all().filter(...)) can be incremented with raw SQL
"where" and "select" clauses.

But you might not want to be using Django or at least not its ORM.

--047d7b5d4e5c8ea3ab04e58b6eb6
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<p dir=3D"ltr"><br>
On 1 Sep 2013 21:54, &quot;Gary Roach&quot; &lt;<a href=3D"mailto:gary719_l=
ist1@verizon.net">gary719_list1@verizon.net</a>&gt; wrote:<br>
&gt;<br>
&gt; Hi all,<br>
&gt;<br>
&gt; System:<br>
&gt; =A0 =A0 =A0 =A0 Debian Wheezy Linux<br>
&gt; =A0 =A0 =A0 =A0 Python 2.7<br>
&gt; =A0 =A0 =A0 =A0 Django 1.5<br>
&gt; =A0 =A0 =A0 =A0 MySql 5.5<br>
&gt;<br>
&gt; I am new to Python and Django and am having trouble matching Python da=
ta types with those of MySQL. MySQL has about 7 basic data types including =
Blobs, Binaries, etc. It also has a rich selection of geometry types. In ad=
dition, types like INT have 7 or 8 different options like Primary Key, zero=
 fill, auto inc, etc. I can&#39;t seem to find anything in python to match =
these. I am trying to build a model.py for an existing database that was cr=
eated with MySQL Workbench.</p>

<p dir=3D"ltr">First, I want to state that you need to understand that Djan=
go was designed to help build simple, common use case web apps. Database sk=
ins, as someone put it. The ORM is very easy to use, although it is not wel=
l prepared for some things.</p>

<p dir=3D"ltr">It also has a very nice advantage, which is being compatible=
 with many RDBMS so you can have postgresql on the production server and sq=
lite on your development machine. This ends up being bad too. For instance,=
 if it is not possible to do something in a specific rdbms, for instance, l=
et&#39;s say blobs, Django will not be able to implement it because it has =
to support those several rdbms.</p>

<p dir=3D"ltr">There are many hacks ( <a href=3D"http://djangosnippets.org/=
snippets/1597/">http://djangosnippets.org/snippets/1597/</a> ) but hacks wi=
ll be hacks and you want your app to be reliable and not compromise your co=
de quality right from the start, right?</p>

<p dir=3D"ltr">Many field options have equivalents in Django (primary key, =
auto increment). You just have to find them. For auto increment there is Au=
toField. Primary key is an option of the base Field (so you can provide it =
as a keyword argument to any field). </p>

<p dir=3D"ltr">Also if you want gis geometry data types (is that what you m=
eant?) you can install and use geodjango.<br>
 <br>
&gt; I do not wish to use anything other than MySQL because of the complexi=
ty of my storage needs (searchable text, PDF, Audio, Video and Photos). The=
 text searches will often be word phrase searches through thousands of docu=
ments. I need the speed and the data type flexibility.</p>

<p dir=3D"ltr">Are you sure mysql is up to it? For searchable text you will=
 want to have an index, and while mysql&#39;s FULLTEXT kind of works, it is=
 clearly not a core feature. Some options for it are enabled or disabled in=
 compile time. Also, I won&#39;t judge but it&#39;s often wrong to use a rd=
bms to store PDF/audio/video. Those belong in the file system or nosql stor=
age.</p>

<p dir=3D"ltr">&gt; How do I build or modify a model.py to do this. I reall=
y don&#39;t want to write a model.py manually. That would really be a major=
 pain. Workbench to the database an import to Django and edit is my choice.=
 Unfortunately, the model.py produced has lost most of the functionality of=
 the original database and I can&#39;t seem to figure out how to fix it.<br=
>

&gt;<br>
&gt; Any help will be sincerely appreciated.<br>
&gt;<br>
&gt; Gary R.</p>
<p dir=3D"ltr">A lot can be done by using the database manually. Django hel=
ps you a bit here, for instance it gives you access to the database cursor =
for raw SQL access to the database, supports custom fields, and every orm q=
uery &quot;chain&quot; (like MyModel.objects.all().filter(...)) can be incr=
emented with raw SQL &quot;where&quot; and &quot;select&quot; clauses. </p>

<p dir=3D"ltr">But you might not want to be using Django or at least not it=
s ORM.<br>
</p>

--047d7b5d4e5c8ea3ab04e58b6eb6--