Webware for Python

Hi Jason,

Good to hear from you. I've checked in that file now, thanks for reporting=
 it.

Btw, nice job on the MixIn enhancement.

Also, I've been testing MiddleKit with MySQL and Microsoft SQL Server.=
 Anyone here want to take Postgres for a spin? I'm sure it's slightly broken=
 after my changes, but I don't have it set up.

-Chuck
-- 
http://ChuckEsterbrook.com/

On Thu, 2004-03-04 at 15:52, Chuck Esterbrook wrote:
> Good to hear from you. I've checked in that file now, thanks for
> reporting it.

Thanks.

> Also, I've been testing MiddleKit with MySQL and Microsoft SQL
> Server. Anyone here want to take Postgres for a spin? I'm sure it's
> slightly broken after my changes, but I don't have it set up.

The last couple of Webware/MiddleKit apps I've written are
database-neutral (either MySQL or PostgreSQL), so I can quite easily do
some PostgreSQL testing.  I have some Postgres-related fixes which I've
been meaning to check in, too, so I can do that at the same time.

--
Jason D. Hildebrand
jason@...

On Thu, 04 Mar 2004 15:59:41 -0600, Jason Hildebrand wrote:
> On Thu, 2004-03-04 at 15:52, Chuck Esterbrook wrote:
>
>> Good to hear from you. I've checked in that file now, thanks for
>> reporting it.
>>
>
> Thanks.
>
>
>> Also, I've been testing MiddleKit with MySQL and Microsoft SQL
>> Server. Anyone here want to take Postgres for a spin? I'm sure
>> it's slightly broken after my changes, but I don't have it set up.
>>
>
> The last couple of Webware/MiddleKit apps I've written are database-
> neutral (either MySQL or PostgreSQL), so I can quite easily do some
> PostgreSQL testing.  I have some Postgres-related fixes which I've
> been meaning to check in, too, so I can do that at the same time.

You might have thought of this already, but Postgres columns for enums=
 (which are varchar) could use a constraint to limit their possible values=
 to the enum set.

Also, MiddleKit/Tests/ReadMe.text could use an example configuration for=
 Postrges.


-Chuck

As you'll see on the checkins list, I made some fixes to MiddleKit. The test=
 suite now passes in full for MySQL even with more recent versions of=
 MySQLdb (which started breaking MiddleKit with MySQLdb 0.9.2).

Two notes:

* Someone should run the test suite on the latest code with Postgres.

* One of the bugs I fixed was a new one. If you modify MiddleKit, please run=
 the test suite for some db (MySQL, Postgres or MSSQL) before checking in=
 changes. There's a ReadMe.text in MiddleKit/Tests with all the instructions=
 you need. You should see this at the end of a good test run:


RESULTS
-------
     succeeded MKBasic.mkmodel
     succeeded MKNone.mkmodel
     succeeded MKString.mkmodel
     succeeded MKDateTime.mkmodel
     succeeded MKEnums.mkmodel
     succeeded MKDefaultMinMax.mkmodel
     succeeded MKTypeValueChecking.mkmodel
     succeeded MKInheritance.mkmodel
     succeeded MKInheritanceAbstract.mkmodel
     succeeded MKList.mkmodel
     succeeded MKObjRef.mkmodel
     succeeded MKObjRefReuse.mkmodel
     succeeded MKDelete.mkmodel
     succeeded MKDeleteMark.mkmodel
     succeeded MKMultipleStores.mkmodel
     succeeded MKMultipleThreads.mkmodel
     succeeded MKModelInh1.mkmodel
     succeeded MKModelInh2.mkmodel
     succeeded MKModelInh3.mkmodel
     succeeded MKExcel.mkmodel


Thanks,
-Chuck

Hello Chuck-

I'm getting errors.  Below is the output from the MKBasic test, as well  
as my LocalConfig.py.

All the tests complain about this:  ERROR 1062 (23000) at line 25:  
Duplicate entry '1' for key 1.  I think the problem is actually a bug  
in MySQL.  If you delete a database, and then recreate the database and  
recreate the tables, then the old data that was in that table is  
"magically" back there.  In other words:

	mysql> use MKBasic
	mysql> select * from _MKClassIds;
	mysql> drop database if exists MKBasic;
	mysql> create database MKBasic;
	mysql> use MKBasic;
	mysql> show tables;
	Empty set (0.00 sec)

At this point we have dropped and recreated the database.  As soon as  
we recreate the table, the old data magically reappears:

	mysql> create table _MKClassIds (
  	   -> id int not null primary key,
	    -> name varchar(100)
	    -> );
	Query OK, 0 rows affected (0.00 sec)
	mysql> select * from _MKClassIds;
	+----+--------+
	| id | name   |
	+----+--------+
	|  1 | Thing  |
	|  2 | Person |
	+----+--------+
	2 rows in set (0.00 sec)

----------------------------------------------
output from MKBasic test:


% python Test.py MKBasic
*** MKBasic ***

<cmd> python TestDesign.py MKBasic.mkmodel Settings.config
Removing WorkDir...
../Design/Generate.py --outdir WorkDir --db MySQL --model  
MKBasic.mkmodel --config Settings.config
Generating SQL...
Generating Python...
importing classes: Thing, Person
<cmd> mysql -u root  < WorkDir/GeneratedSQL/Create.sql
ERROR 1062 (23000) at line 25: Duplicate entry '1' for key 1
RESULTS
-------
*** FAILED *** MKBasic.mkmodel

1 seconds

----------------------------------------------
The contents of my LocalConfig.py:

# LocalConfig.py
import site
site.addsitedir('/Users/winstonw/Projects/svn/python/extern/MySQL- 
python-1.0.0/build/lib')

dbName = 'MySQL'
storeArgs = {'user': 'root', 'passwd': ''}
sqlCommand = 'mysql -u root '
# end

-----------------------------



On Feb 5, 2005, at 8:16 PM, Chuck Esterbrook wrote:

> As you'll see on the checkins list, I made some fixes to MiddleKit.  
> The test suite now passes in full for MySQL even with more recent  
> versions of MySQLdb (which started breaking MiddleKit with MySQLdb  
> 0.9.2).
>
> Two notes:
>
> * Someone should run the test suite on the latest code with Postgres.
>
> * One of the bugs I fixed was a new one. If you modify MiddleKit,  
> please run the test suite for some db (MySQL, Postgres or MSSQL)  
> before checking in changes. There's a ReadMe.text in MiddleKit/Tests  
> with all the instructions you need. You should see this at the end of  
> a good test run:
>
>
> RESULTS
> -------
>      succeeded MKBasic.mkmodel
>      succeeded MKNone.mkmodel
>      succeeded MKString.mkmodel
>      succeeded MKDateTime.mkmodel
>      succeeded MKEnums.mkmodel
>      succeeded MKDefaultMinMax.mkmodel
>      succeeded MKTypeValueChecking.mkmodel
>      succeeded MKInheritance.mkmodel
>      succeeded MKInheritanceAbstract.mkmodel
>      succeeded MKList.mkmodel
>      succeeded MKObjRef.mkmodel
>      succeeded MKObjRefReuse.mkmodel
>      succeeded MKDelete.mkmodel
>      succeeded MKDeleteMark.mkmodel
>      succeeded MKMultipleStores.mkmodel
>      succeeded MKMultipleThreads.mkmodel
>      succeeded MKModelInh1.mkmodel
>      succeeded MKModelInh2.mkmodel
>      succeeded MKModelInh3.mkmodel
>      succeeded MKExcel.mkmodel
>
>
> Thanks,
> -Chuck
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
> Tool for open source databases. Create drag-&-drop reports. Save time
> by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
> Download a FREE copy at http://www.intelliview.com/go/osdn_nl
> _______________________________________________
> Webware-devel mailing list
> Webware-devel@...
> https://lists.sourceforge.net/lists/listinfo/webware-devel
>
>
_________________________________________
winston wolff - (646) 827-2242 - http://www.stratolab.com - learning by  
creating

Oh, and one more thing.  If you drop the _MKClassIds table before you  
drop the database, then it works.

-ww

On Feb 6, 2005, at 6:30 PM, Winston Wolff wrote:

> Hello Chuck-
>
> I'm getting errors.  Below is the output from the MKBasic test, as  
> well as my LocalConfig.py.
>
> All the tests complain about this:  ERROR 1062 (23000) at line 25:  
> Duplicate entry '1' for key 1.  I think the problem is actually a bug  
> in MySQL.  If you delete a database, and then recreate the database  
> and recreate the tables, then the old data that was in that table is  
> "magically" back there.  In other words:
>
> 	mysql> use MKBasic
> 	mysql> select * from _MKClassIds;
> 	mysql> drop database if exists MKBasic;
> 	mysql> create database MKBasic;
> 	mysql> use MKBasic;
> 	mysql> show tables;
> 	Empty set (0.00 sec)
>
> At this point we have dropped and recreated the database.  As soon as  
> we recreate the table, the old data magically reappears:
>
> 	mysql> create table _MKClassIds (
>  	   -> id int not null primary key,
> 	    -> name varchar(100)
> 	    -> );
> 	Query OK, 0 rows affected (0.00 sec)
> 	mysql> select * from _MKClassIds;
> 	+----+--------+
> 	| id | name   |
> 	+----+--------+
> 	|  1 | Thing  |
> 	|  2 | Person |
> 	+----+--------+
> 	2 rows in set (0.00 sec)
>
> ----------------------------------------------
> output from MKBasic test:
>
>
> % python Test.py MKBasic
> *** MKBasic ***
>
> <cmd> python TestDesign.py MKBasic.mkmodel Settings.config
> Removing WorkDir...
> ../Design/Generate.py --outdir WorkDir --db MySQL --model  
> MKBasic.mkmodel --config Settings.config
> Generating SQL...
> Generating Python...
> importing classes: Thing, Person
> <cmd> mysql -u root  < WorkDir/GeneratedSQL/Create.sql
> ERROR 1062 (23000) at line 25: Duplicate entry '1' for key 1
> RESULTS
> -------
> *** FAILED *** MKBasic.mkmodel
>
> 1 seconds
>
> ----------------------------------------------
> The contents of my LocalConfig.py:
>
> # LocalConfig.py
> import site
> site.addsitedir('/Users/winstonw/Projects/svn/python/extern/MySQL- 
> python-1.0.0/build/lib')
>
> dbName = 'MySQL'
> storeArgs = {'user': 'root', 'passwd': ''}
> sqlCommand = 'mysql -u root '
> # end
>
> -----------------------------
>
>
>
> On Feb 5, 2005, at 8:16 PM, Chuck Esterbrook wrote:
>
>> As you'll see on the checkins list, I made some fixes to MiddleKit.  
>> The test suite now passes in full for MySQL even with more recent  
>> versions of MySQLdb (which started breaking MiddleKit with MySQLdb  
>> 0.9.2).
>>
>> Two notes:
>>
>> * Someone should run the test suite on the latest code with Postgres.
>>
>> * One of the bugs I fixed was a new one. If you modify MiddleKit,  
>> please run the test suite for some db (MySQL, Postgres or MSSQL)  
>> before checking in changes. There's a ReadMe.text in MiddleKit/Tests  
>> with all the instructions you need. You should see this at the end of  
>> a good test run:
>>
>>
>> RESULTS
>> -------
>>      succeeded MKBasic.mkmodel
>>      succeeded MKNone.mkmodel
>>      succeeded MKString.mkmodel
>>      succeeded MKDateTime.mkmodel
>>      succeeded MKEnums.mkmodel
>>      succeeded MKDefaultMinMax.mkmodel
>>      succeeded MKTypeValueChecking.mkmodel
>>      succeeded MKInheritance.mkmodel
>>      succeeded MKInheritanceAbstract.mkmodel
>>      succeeded MKList.mkmodel
>>      succeeded MKObjRef.mkmodel
>>      succeeded MKObjRefReuse.mkmodel
>>      succeeded MKDelete.mkmodel
>>      succeeded MKDeleteMark.mkmodel
>>      succeeded MKMultipleStores.mkmodel
>>      succeeded MKMultipleThreads.mkmodel
>>      succeeded MKModelInh1.mkmodel
>>      succeeded MKModelInh2.mkmodel
>>      succeeded MKModelInh3.mkmodel
>>      succeeded MKExcel.mkmodel
>>
>>
>> Thanks,
>> -Chuck
>>
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by: IntelliVIEW -- Interactive  
>> Reporting
>> Tool for open source databases. Create drag-&-drop reports. Save time
>> by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
>> Download a FREE copy at http://www.intelliview.com/go/osdn_nl
>> _______________________________________________
>> Webware-devel mailing list
>> Webware-devel@...
>> https://lists.sourceforge.net/lists/listinfo/webware-devel
>>
>>
> _________________________________________
> winston wolff - (646) 827-2242 - http://www.stratolab.com - learning  
> by creating
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
> Tool for open source databases. Create drag-&-drop reports. Save time
> by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
> Download a FREE copy at http://www.intelliview.com/go/osdn_nl
> _______________________________________________
> Webware-devel mailing list
> Webware-devel@...
> https://lists.sourceforge.net/lists/listinfo/webware-devel
>
>
_________________________________________
winston wolff - (646) 827-2242 - http://www.stratolab.com - learning by  
creating

That's odd. I use MySQL as well and don't have this problem.

I have version 4.0.20a-win. I'm on Win XP for development (Linux in=
 production, although I haven't run the tests there recently).

What version of MySQL do you have?

I agree it looks like a mysql bug, like it's caching the data. What if you=
 quit the client after you recreate the database and then come back and do a=
 select?

*** Can anyone else run the MiddleKit test suite and report back?

-Chuck


On Sun, 6 Feb 2005 18:30:47 -0500, Winston Wolff wrote:
>=A0Hello Chuck-
>
>=A0I'm getting errors. =A0Below is the output from the MKBasic test, as
>=A0well as my LocalConfig.py.
>
>=A0All the tests complain about this: =A0ERROR 1062 (23000) at line 25:
>=A0Duplicate entry '1' for key 1. =A0I think the problem is actually a
>=A0bug in MySQL. =A0If you delete a database, and then recreate the
>=A0database and recreate the tables, then the old data that was in
>=A0that table is "magically" back there. =A0In other words:
>
>=A0mysql>=A0use MKBasic
>=A0mysql>=A0select * from _MKClassIds;
>=A0mysql>=A0drop database if exists MKBasic;
>=A0mysql>=A0create database MKBasic;
>=A0mysql>=A0use MKBasic;
>=A0mysql>=A0show tables;
>=A0Empty set (0.00 sec)
>
>=A0At this point we have dropped and recreated the database. =A0As soon
>=A0as we recreate the table, the old data magically reappears:
>
>=A0mysql>=A0create table _MKClassIds (
>=A0->=A0id int not null primary key,
>=A0->=A0name varchar(100)
>=A0->=A0);
>=A0Query OK, 0 rows affected (0.00 sec)
>=A0mysql>=A0select * from _MKClassIds;
>=A0+----+--------+
>=A0| id | name =A0 |
>=A0+----+--------+
>=A0| =A01 | Thing =A0|
>=A0| =A02 | Person |
>=A0+----+--------+
>=A02 rows in set (0.00 sec)

Can a few more people run the MiddleKit tests on their machines?  I 
want to see if the failures I am getting are from my version of MySQL 
or from MiddleKit.

-ww

On Feb 5, 2005, at 8:16 PM, Chuck Esterbrook wrote:

> As you'll see on the checkins list, I made some fixes to MiddleKit. 
> The test suite now passes in full for MySQL even with more recent 
> versions of MySQLdb (which started breaking MiddleKit with MySQLdb 
> 0.9.2).
>
> Two notes:
>
> * Someone should run the test suite on the latest code with Postgres.
>
> * One of the bugs I fixed was a new one. If you modify MiddleKit, 
> please run the test suite for some db (MySQL, Postgres or MSSQL) 
> before checking in changes. There's a ReadMe.text in MiddleKit/Tests 
> with all the instructions you need. You should see this at the end of 
> a good test run:
>
>
> RESULTS
> -------
>      succeeded MKBasic.mkmodel
>      succeeded MKNone.mkmodel
>      succeeded MKString.mkmodel
>      succeeded MKDateTime.mkmodel
>      succeeded MKEnums.mkmodel
>      succeeded MKDefaultMinMax.mkmodel
>      succeeded MKTypeValueChecking.mkmodel
>      succeeded MKInheritance.mkmodel
>      succeeded MKInheritanceAbstract.mkmodel
>      succeeded MKList.mkmodel
>      succeeded MKObjRef.mkmodel
>      succeeded MKObjRefReuse.mkmodel
>      succeeded MKDelete.mkmodel
>      succeeded MKDeleteMark.mkmodel
>      succeeded MKMultipleStores.mkmodel
>      succeeded MKMultipleThreads.mkmodel
>      succeeded MKModelInh1.mkmodel
>      succeeded MKModelInh2.mkmodel
>      succeeded MKModelInh3.mkmodel
>      succeeded MKExcel.mkmodel
>
>
> Thanks,
> -Chuck
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
> Tool for open source databases. Create drag-&-drop reports. Save time
> by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
> Download a FREE copy at http://www.intelliview.com/go/osdn_nl
> _______________________________________________
> Webware-devel mailing list
> Webware-devel@...
> https://lists.sourceforge.net/lists/listinfo/webware-devel
>
>
_________________________________________
winston wolff - (646) 827-2242 - http://www.stratolab.com - learning by 
creating

On Tue, 15 Feb 2005 05:20:42 -0500, Winston Wolff wrote:
>=A0Can a few more people run the MiddleKit tests on their machines? =A0I
>=A0want to see if the failures I am getting are from my version of
>=A0MySQL or from MiddleKit.
>
>=A0-ww

I've completed a whole bunch of improvements to MiddleKit which I'll detail=
 in another email. The MiddleKit test suite passes for me on Windows using a=
 slightly older MySQLdb module and MySQL database, and also on Linux using=
 the latest releases of each.

Someone reported that MiddleKit's Postgres support is broken. I'll have=
 access to Postgres soon and fix. I'd bet money that MS SQL is broken and=
 I'll fix that on Sunday Feb 20.

I also enhanced MiddleKit's Test.py to output information about the system=
 it was run on to make it easier for us to compare. Here's the tail of my=
 two runs:

SYSTEM INFO
-----------
sys.version =3D 2.3.4 (#53, May 25 2004, 21:17:02) [MSC v.1200 32 bit=
 (Intel)]
sys.platform =3D win32
os.name =3D nt
sys.getwindowsversion() =3D (5, 1, 2600, 2, 'Service Pack 1')
os.getcwd() =3D C:\All\echuck\Projects\WebwareHEAD\MiddleKit\Tests
dbName =3D MySQL
<cmd> mysql --version
mysql  Ver 12.22 Distrib 4.0.20a, for Win95/Win98 (i32)
modules with versions:
    MySQLdb, (1, 0, 0, 'final', 1),=
 C:\Python23\lib\site-packages\MySQLdb\__init__.pyc
    _mysql, (1, 0, 0, 'final', 1), C:\Python23\lib\site-packages\_mysql.pyd

RESULTS
-------
     succeeded MKBasic.mkmodel
     succeeded MKNone.mkmodel
     succeeded MKString.mkmodel
     succeeded MKDateTime.mkmodel
     succeeded MKEnums.mkmodel
     succeeded MKDefaultMinMax.mkmodel
     succeeded MKTypeValueChecking.mkmodel
     succeeded MKInheritance.mkmodel
     succeeded MKInheritanceAbstract.mkmodel
     succeeded MKList.mkmodel
     succeeded MKObjRef.mkmodel
     succeeded MKObjRefReuse.mkmodel
     succeeded MKDelete.mkmodel
     succeeded MKDeleteMark.mkmodel
     succeeded MKMultipleStores.mkmodel
     succeeded MKMultipleThreads.mkmodel
     succeeded MKModelInh1.mkmodel
     succeeded MKModelInh2.mkmodel
     succeeded MKModelInh3.mkmodel
     succeeded MKExcel.mkmodel



SYSTEM INFO
-----------
sys.version =3D 2.3.4 (#1, Jan 13 2005, 19:39:32)
[GCC 3.2.2 20030222 (Red Hat Linux 3.2.2-5)]
sys.platform =3D linux2
os.name =3D posix
os.getcwd() =3D /home/echuck/WebwareHEAD/MiddleKit/Tests
dbName =3D MySQL
<cmd> mysql --version
mysql  Ver 14.7 Distrib 4.1.10, for pc-linux-gnu (i686)
modules with versions:
    MySQLdb, (1, 2, 0, 'final', 1),=
 /usr/local/lib/python2.3/site-packages/MySQLdb/__init__.pyc
    _mysql, (1, 2, 0, 'final', 1),=
 /usr/local/lib/python2.3/site-packages/_mysql.so

RESULTS
-------
     succeeded MKBasic.mkmodel
     succeeded MKNone.mkmodel
     succeeded MKString.mkmodel
     succeeded MKDateTime.mkmodel
     succeeded MKEnums.mkmodel
     succeeded MKDefaultMinMax.mkmodel
     succeeded MKTypeValueChecking.mkmodel
     succeeded MKInheritance.mkmodel
     succeeded MKInheritanceAbstract.mkmodel
     succeeded MKList.mkmodel
     succeeded MKObjRef.mkmodel
     succeeded MKObjRefReuse.mkmodel
     succeeded MKDelete.mkmodel
     succeeded MKDeleteMark.mkmodel
     succeeded MKMultipleStores.mkmodel
     succeeded MKMultipleThreads.mkmodel
     succeeded MKModelInh1.mkmodel
     succeeded MKModelInh2.mkmodel
     succeeded MKModelInh3.mkmodel
       skipped MKExcel.mkmodel



-Chuck