database design problem.

2014-03-15 Thread willy Hakizimana
First of all, this community is amazing at how fast questions are answered. I have learned so much. I am designing an app with models that look like this. Country(country_id(PK), country_name, gdp, gdp_growth, income_per_capita) Product(product_id(PK), product_name, country_id(FK), imports_vol

Re: database design problem.

2014-03-15 Thread willy Hakizimana
Thank you guys so much. You guys rock! On Saturday, March 15, 2014 10:38:03 AM UTC-5, willy Hakizimana wrote: > > First of all, this community is amazing at how fast questions are > answered. I have learned so much. > > > I am designing an app with models that look like

populating my postgres with openpyxl

2014-03-27 Thread willy Hakizimana
I am new to django/python and have been stuck. What is wrong with my script? from openpyxl import Workbook, load_workbook import os import psycopg2 import pycountry #Make the dictionary of countries country_dict = {} country_list = list(pycountry.countries) for country in country_list: coun

ManytoManyField (through) not showing up !

2014-03-28 Thread willy Hakizimana
I am trying to do a ManytoManyField through a middle Table. After I run syncdb, I do not see the column in pdadmin. What am I doing wrong? Here is my code class Countries(models.Model): country_name = models.CharField(max_length=200) country_id = models.CharField(primary_key=True, max

Re: Database Error (SQLite) Database is locked

2014-03-28 Thread willy Hakizimana
I know this might be stupid question. Did you syncdb after you installed it? On Friday, March 28, 2014 8:22:33 AM UTC-5, KEVIN HUNGAI wrote: > > Hi all am using django-registration app in one of my projects and sqlite3 > for the database. I keep getting Database Error (SQLite) Database is > lo

ManytoManyField refuses to show up when I syncdb

2014-03-29 Thread willy Hakizimana
when I syncdb and use south schemamigration, I still can't get the ManyToManyField to show up. what am I doing wrong. Any parameters I can pass to make it work? Thank you guys class Products(models.Model): #product_id = models.AutoField(primary_key=True) hs_number = models.CharField(pr