Comments by Ruban Bharath (Top 14 by date)

sorry i am not clear with it can you tell me broadly please sir

views.py

def olddata(request):
username = request.POST.get("username", False)
if is_valid(username):
data = result.objects.filter(username=username)
return render(request, "result/index.html", {'data': data})
else:
name = Name(username=username)
name.save()
db = sqlite3.connect('db.sqlite3')
cursor = db.cursor()
cursor.execute('''SELECT meaning from music_sample''')
rand = cursor.fetchall()
rand_item = rand[random.randrange(len(rand))]
cursor.execute('INSERT INTO music_sample1(userid,meaning) values(NULL,?)', rand_item)
cursor.execute('''INSERT INTO music_result SELECT username,meaning, NULL
FROM music_name N JOIN music_sample1 T ON N.userid = T.userid ''')
db.commit()
for row in result.objects.all():
if result.objects.filter(username=row.username).count() > 1:
row.delete()
data = result.objects.filter(username=username)
return render(request, "result/index.html", {'data': data})


def is_valid(username):
con = sqlite3.connect('db.sqlite3')
cur = con.cursor()
cur.execute('SELECT username FROM music_output')
data = cur.fetchall()
for row in data:
if row[0] == username:
return True
return False


then my models are:

class sample(models.Model):
userid = models.IntegerField(primary_key=True)
meaning = models.CharField(max_length=300)


class sample1(models.Model):
userid = models.IntegerField(primary_key=True)
meaning = models.CharField(max_length=300)


class Name(models.Model):
userid = models.IntegerField(primary_key=True)
username = models.CharField(max_length=300,)


class result(models.Model):

userid = models.IntegerField()
meaning = models.CharField(max_length=300)
username = models.CharField(max_length=300)

what's wrong with this code i am getting error now like

"NOT NULL constraint failed: music_sample1.userid"

NO sir i could not resolved it
i will show my contents to you

class sample(models.Model):
userid = models.IntegerField(primary_key=True)
meaning = models.CharField(max_length=300)


class sample1(models.Model):
userid = models.IntegerField(primary_key=True)
meaning = models.CharField(max_length=300)


class Name1(models.Model):
userid = models.IntegerField(primary_key=True)
username = models.CharField(max_length=300)



class result(models.Model):
userid = models.IntegerField(primary_key=True)
meaning = models.CharField(max_length=300)
username = models.CharField(max_length=300)

sir sorry what is meant by field definition
are you asking about table creation query

Sir if i remove the NULL
i have this error what can i do for it
sorry i have userId field too in result table
"table music_result has 3 columns but 2 values were supplied"

sir, i have tried your code but it shoots me this error
ambiguous column name: genderId

no sir this is actually not my original design but i need to know how to join two tables into one sir,but the concept is same i have two tables with different fields i wanna join them but i have tried but it emerges an error
i got struct in it for an whole day sir

okay kindly tell me that what is the procedure to join these tables sir.Thank you in advanced