https://wiki.secondlife.com/w/index.php?action=history&feed=atom&title=User%3ABabbage_Linden%2FDjango%2FORM 2026-04-05T04:36:34Z Revision history for this page on the wiki MediaWiki 1.42.1 https://wiki.secondlife.com/w/index.php?title=User:Babbage_Linden/Django/ORM&diff=162663&oldid=prev 2008-12-02T15:25:00Z

<p>New page: Django provides a powerful [http://docs.djangoproject.com/en/dev/topics/db/ object relational mapper] which can generate database schema and SQL queries from python object descriptions or ...</p> <p><b>New page</b></p><div>Django provides a powerful [http://docs.djangoproject.com/en/dev/topics/db/ object relational mapper] which can generate database schema and SQL queries from python object descriptions or generate python classes to describe an existing database schema:<br /> <br /> &lt;pre&gt;<br /> class Simulator(models.Model):<br /> sim_name = models.CharField(max_length=105)<br /> grid_x = models.IntegerField()<br /> grid_y = models.IntegerField()<br /> host_name = models.CharField(max_length=300, blank=True)<br /> start_time = models.DateTimeField()<br /> access = models.IntegerField()<br /> region_id = models.CharField(primary_key=True, max_length=108, blank=True)<br /> estate_id = models.IntegerField()<br /> enabled = models.CharField(max_length=3)<br /> status = models.CharField(max_length=24)<br /> external_host_ip_string = models.CharField(max_length=45, blank=True)<br /> host_port = models.IntegerField(null=True, blank=True)<br /> pid = models.IntegerField(null=True, blank=True)<br /> simstate_asset_id = models.CharField(max_length=108, blank=True)<br /> priority = models.IntegerField()<br /> sim_cpu_ratio = models.IntegerField()<br /> needs_genids = models.CharField(max_length=3)<br /> telehub_local_x = models.FloatField(null=True, blank=True)<br /> telehub_local_y = models.FloatField(null=True, blank=True)<br /> telehub_local_z = models.FloatField(null=True, blank=True)<br /> is_prelude = models.CharField(max_length=3)<br /> class_id = models.IntegerField()<br /> seq = models.IntegerField()<br /> first_occupied = models.DateField(null=True, blank=True)<br /> status_updated = models.DateTimeField()<br /> needs_wash = models.CharField(max_length=3)<br /> island_fee = models.DecimalField(null=True, max_digits=11, decimal_places=2, blank=True)<br /> island_bill_date = models.DateField(null=True, blank=True)<br /> simstate_url = models.CharField(max_length=765, blank=True)<br /> version = models.CharField(max_length=96, blank=True)<br /> channel = models.CharField(max_length=384, blank=True)<br /> class Meta:<br /> db_table = u&#039;simulator&#039;<br /> &lt;/pre&gt;<br /> <br /> The models are kept separate from the views, allowing schema and API to vary independently.</div>

Babbage Linden