Projects tagged ‘django’, ‘mysql’, and ‘python’

A community web site for Pardus GNU/Linux distribution. Powered by Django.

South is a database migration framework for Django applications.

Clapton aims to be a complete Content Management System for Django. Users will have a variety of content types available to them, such as Stories, Blogs, Photos, Videos, Audio (Podcasts), Events, and whatever else comes along.

Rancho is an Open Source Group/Project Management Tool developed with Django.

This is a command line tool written in Python. It displays all the differences between two database schemas. The schema are provided as SQL dump. 1. ExampleInputdb1.sql: sql dump of a database with ... [More] a single table: 'person' CREATE TABLE `person` ( `last name` varchar(50) NOT NULL, `date_of_birth` varchar(45) NOT NULL, PRIMARY KEY (`last name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;db2.sql: sql dump of the same database after adding a new table 'car' and modified fields in the 'person' table. CREATE TABLE `car` ( `color` varchar(50) NOT NULL, `number_plate` varchar(50) NOT NULL, `brand` varchar(50) NOT NULL, PRIMARY KEY (`number_plate`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE `person` ( `last name` varchar(50) NOT NULL, `date_of_birth` datetime NOT NULL, `first_name` varchar(45) NOT NULL, PRIMARY KEY (`last name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;Commandpython compdb.py db1.sql db2.sqlOutput% FIELD: person.date_of_birth `date_of_birth` varchar(45) NOT NULL => `date_of_birth` datetime NOT NULL + FIELD: person.`first_name` varchar(45) NOT NULL + TABLE: car 3 difference(s).2. Notation%: difference +: new field or table -: missing field or table 3. LimitationsCurrently works only with MySQL dumps Obviously this tool cannot detect when the name of a field or a table has changed! 4. MotivationThis script was originally written to help me keep track of the evolution of Django models (hence the Python implementation). Before upgrading a staging server, I would compare the SQL dump from my development database (generated with mysqldump -d or with python manage.py sql) with the dump from my staging server. Note that more sophisticated tools have been developed for this purpose, search for 'django schema evolution' on any search engine to find them. This tool was developed as part of a UML to Django conversion project. 5. FeedbackYour comments and contributions are welcome. [Less]

Import, store and retrieve news from the web. - use provided websites importers or build your own very easily - newsmemory will parse the web and store the articles periodically - a web interface ... [More] lets you browse the news or search the database - flag a newsitem, the others users will see it as flagged [Less]

Django External Schema Evolution Branch Django, via the command ./manage syncdb, can automatically build a database schema based on your applications models.py file. However, after you've done this ... [More] once, it leaves you with two unpleasant follow-up options if you ever make any changes to your model structure: 1. destroy your existing schema (along with all your data) and let ./manage syncdb rebuild it for you 2. manage your own schema upgrades by writing your own SQL Project deseb aims to fill this void by providing s third option: 3. generate schema upgrades via the command: ./manage evolvedb [Less]

This Online Programming Contest Judge is a highly modular program. It uses the Django Web framework for a web frontend. Colleges (Universities) around the world create and host `Online Programming ... [More] Contests', in which participants can send the code (in different languages) for a problem hosted, to the server, which in turn evaluates the program and informs the user regarding its validity. The idea of a Judge is not only to verify the code, but also to report the memory usage, execution time, and other such benchmarks. Intended Audience :: College OPCs, Programming Language :: Python Web Framework :: Django Database :: MySQL, PostGres, SQLite Operating System Server :: Linux, FreeBSD Clients :: Platform Independant [Less]

Gloydius is Groupware for Local Work Group

In the current state of Django, Django does not support the multiple database in it's own ORM, so we try to make the Django to support the multiple database, especially in the read-write MySQL replication environment.