Subversion Repositories SmartDukaan

Rev

Rev 16535 | Rev 19970 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 16535 Rev 16993
Line 20... Line 20...
20 
 
 20 
 
21 
def main(delete=False):
 21 
def main(delete=False):
22 
    try:
 22 
    try:
23 
        initialize()
 23 
        initialize()
24 
        #get all users
 24 
        #get all users
25 
        (maxUserId,) = session.query(func.max(All_user_addresses.user_id)).first()
 - 
 
26 
        if maxUserId is None:
 - 
 
27 
            maxUserId = 0
 25 
        maxUserId = 0
28 
        query = session.query(Users)
 26 
        query = session.query(Users)
29 
        if maxUserId>0:
 27 
        if maxUserId>0:
30 
            query = query.filter(Users.id>maxUserId)
 28 
            query = query.filter(Users.id>maxUserId)
31 
        for user in query.all():
 29 
        for user in query.all():
32 
            userAddress = All_user_addresses()
 - 
 
33 
            userAddress.user_id = user.id
 - 
 
34 
            address = None
30 
            address = None
35 
            if user.address_line_1:
 31 
            if user.address_line_1:
36 
                address = user.address_line_1
 32 
                address = user.address_line_1
37 
            if user.address_line_2:
 33 
            if user.address_line_2:
38 
                if address:
 34 
                if address:
39 
                    address += " " +  user.address_line_2
 35 
                    address += " " +  user.address_line_2
40 
                else:
 36 
                else:
41 
                    address = user.address_line_2
 37 
                    address = user.address_line_2
- 
 
 38 
            if address:
- 
 
 39 
                userAddress = All_user_addresses()
42 
            userAddress.address = address
 40 
                userAddress.user_id = user.id
43 
            userAddress.city = user.city
 41 
                userAddress.city = user.city
- 
 
 42 
                userAddress.address = address
44 
            userAddress.pincode = user.pincode
 43 
                userAddress.pincode = user.pincode
45 
            userAddress.state = user.state
 44 
                userAddress.state = user.state
46 
            userAddress.source = 'user_profile'
 45 
                userAddress.source = 'user_profile'
47
46
48 
            ra2 = session.query(Retailers).filter(RetailerLinks.user_id==user.id).filter(Retailers.id==RetailerLinks.retailer_id).first()
 47 
            ra2 = session.query(Retailers).filter(RetailerLinks.user_id==user.id).filter(Retailers.id==RetailerLinks.retailer_id).first()
49 
            if ra2:
 48 
            if ra2:
50 
                ua2 = All_user_addresses()
 49 
                ua2 = All_user_addresses()
51 
                ua2.user_id = user.id
 50 
                ua2.user_id = user.id