def testRequestLoan(self): requests = LoanRequest.objects.all() self.assertEqual(len(requests), 0) # Creating a LoanRequest reason, amount, loanTime = "mortgage", 10000, 2 request = LoanRequest(reason=reason, amount=amount, loanTime=loanTime, user=self.testuser1) request.save() requests = LoanRequest.objects.all() self.assertEqual(len(requests), 1) self.assertEqual(len(self.testuser1.loanrequest_set.all()), 1)
def testRequestLoanOutOfBounds(self): requests = LoanRequest.objects.all() self.assertEqual(len(requests), 0) # Creating a LoanRequest reason, amount, loanTime = "mortgage", 100, 2 request = LoanRequest(reason=reason, amount=amount, loanTime=loanTime, user=self.testuser1) # This should raise a Validation Error self.assertRaises(ValidationError, request.save)
from django.contrib.auth.models import User from growthstreet.models import UserDetails,LoanRequest users = User.objects.all() usernames = [['naman','*****@*****.**'], ['jainy','*****@*****.**'], ['namu','*****@*****.**'], ] counter = 0 for i, email in usernames: a = User.objects.create_user(username=i, password=i, email=email) a.is_active = True if i == 'jainy': # jainy is the superuser a.is_staff = True a.is_superuser = True a.save() request = LoanRequest(reason = "broke%s" %counter , amount = 10000+counter, loanTime=1+counter, user = a) request.save() counter += 3 # database querying conn = sqlite3.connect('db.sqlite3') c = conn.cursor() c.execute("select * from auth_user") results = c.fetchall() print results
import os os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'growthstreet.settings') import sqlite3 import django django.setup() from django.contrib.auth.models import User #from django.contrib.sites.models import Site from growthstreet.models import UserDetails, LoanRequest users = User.objects.all() details = UserDetails.objects.all() conn = sqlite3.connect('db.sqlite3') c = conn.cursor() c.execute("select * from auth_user") results = c.fetchall() print results c.execute("select * from growthstreet_userdetails") a = c.fetchall() # create Loan Request with less than 10,000 request = LoanRequest(reason="adf", amount=100, loanTime=2, user=users[0]) #request.clean() #request.save()