def add_user_to_local_db_from_fortnox(customer): tmp_usr = User(customer['Name'], customer['Email'], customer['Phone'], customer['Address1'], customer['Address2'], customer['City'], customer['Zipcode'], None, customer['FortnoxID'], None, strip_ssn(customer), get_gender_from_ssn(customer), None) tmp_usr.status = 'Inactive' db.session.add(tmp_usr) db.session.commit()
def sync_from_fortnox(): """ Helper script to sync the local database with the content of the database on fortnox. Either updates an existing customer or creates a new. """ try: fortnox_data = Fortnox() customers = fortnox_data.get_all_customers() ret = [] for element in customers: for customer in element: # Split firstname and lastname name = customer['Name'].split() # If the user only got a firstname, add blank to the lastname if len(name) < 2: name.append('') cust = sql_user.SQLUser(None, customer['CustomerNumber'], name[0], name[1], customer['Email'], customer['Phone'], customer['Address1'], customer['Address2'], customer['City'], customer['ZipCode'], None, get_gender_from_ssn(customer), customer['OrganisationNumber'][:-5], None, None, None, None, None) ret.append(cust.dict()) cl = client.UsersSqlClient() # If the user from Fortnox all ready exists in the database, update it. If it doesn't exist, create a new. for customer in ret: if cl.does_user_exist(customer['fortnox_id']): cl.add_user(customer) else: cl.update_user(customer) flash("Members from Fortnox is added/updated to the database!") except: flash("Something happend while adding/updating from fortnox")
def update_user_in_local_db_from_fortnox(customer): user = User.query.filter_by(fortnox_id=customer['FortnoxID']).first() if user is None: return "she wrote upon it; no such number, no such zone" else: user.name = customer['Name'] user.email = customer['Email'] user.phone = customer['Phone'] user.address = customer['Address1'] user.address2 = customer['Address2'] user.city = customer['City'] user.zip_code = customer['Zipcode'] user.gender = get_gender_from_ssn(customer) user.ssn = strip_ssn(customer) user.expiry_date = user.expiry_date user.create_date = user.create_date user.tag_id = user.tag_id if(user.tagcounter is None): user.tagcounter = 0 if user.status is None: user.status = 'Inactive' db.session.commit()
def update_user_in_local_db_from_fortnox(customer): user = User.query.filter_by(fortnox_id=customer['FortnoxID']).first() if user is None: return "she wrote upon it; no such number, no such zone" else: user.name = customer['Name'] user.email = customer['Email'] user.phone = customer['Phone'] user.address = customer['Address1'] user.address2 = customer['Address2'] user.city = customer['City'] user.zip_code = customer['Zipcode'] user.gender = get_gender_from_ssn(customer) user.ssn = strip_ssn(customer) user.expiry_date = user.expiry_date user.create_date = user.create_date user.tag_id = user.tag_id if (user.tagcounter is None): user.tagcounter = 0 if user.status is None: user.status = 'Inactive' db.session.commit()