Subversion Repositories SmartDukaan

Rev

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

Rev 15921 Rev 16198
Line 16... Line 16...
16 
 
 16 
 
17 
 
 17 
 
18 
 
 18 
 
19 
 
 19 
 
20 
 
 20 
 
21 
def main():
 21 
def main(delete=False):
- 
 
 22 
    if delete:
22 
    #Mysql.deleteTableData(tableName)
 23 
        Mysql.deleteTableData('user_addresses')
23 
    try:
 24 
    try:
24 
        initialize()
 25 
        initialize()
25 
        #get all users
 26 
        #get all users
26 
        (maxUserId,) = session.query(func.max(All_user_addresses.user_id)).first()
 27 
        (maxUserId,) = session.query(func.max(All_user_addresses.user_id)).first()
27 
        if maxUserId is None:
 28 
        if maxUserId is None:
28 
            maxUserId = 0
 29 
            maxUserId = 0
29 
        query = session.query(Users)
 30 
        query = session.query(Users)
30 
        if maxUserId>0:
 31 
        if maxUserId>0:
31 
            query = query.filter_by(id=maxUserId)
 32 
            query = query.filter(Users.id>maxUserId)
32 
        for user in query.all():
 33 
        for user in query.all():
33 
            userAddress = All_user_addresses()
 34 
            userAddress = All_user_addresses()
34 
            userAddress.user_id = user.id
 35 
            userAddress.user_id = user.id
35 
            address = None
36 
            address = None
36 
            if user.address_line_1:
 37 
            if user.address_line_1: