def get(self):
#InputName=a&InputEmail=a%40b.com&InputEmail=a%40b.com&InputMessage=a&submit=Submit
c = Company()
c.name = self['InputName']
c.email = self['InputEmail']
c.details = self['InputMessage']
c.put()
self.redirect('/add_member')
def get(self):
#InputName=a&InputEmail=a%40b.com&InputEmail=a%40b.com&InputMessage=a&submit=Submit
c = Company()
c.name = self['InputName']
c.email = self['InputEmail']
c.details = self['InputMessage']
c.put()
self.redirect('/add_member')
def create_company(self, image_key):
c = Company()
c.name = self['company_name']
c.website = self['website']
c.profile = self['profile']
c.hello = self['hello']
tags = re.findall(r"[\w']+", str(self['tags']))
c.tags = tags[0:3] if len(tags)>3 else tags
c.image = image_key
c.put()
return c
def migrate_company():
try:
cnx = mysql.connector.connect(
host=self.host,
user=self.username,
password=self.password,
database=self.database,
)
cursor = cnx.cursor()
query = "SELECT * FROM company"
cursor.execute(query)
for (id, name, city, timezone, alarm_email, address, tel, logo,
manager, extra, creator, createdat) in cursor:
u = Company()
u.id = id
u.name = name
u.city = city
u.timezone = timezone
u.alarm_email = alarm_email
u.address = address
u.telephone = tel
u.logo = logo
if manager in [0, -1]:
manager = 10
u.manager = manager
u.extra = extra
u.created_by = 10
u.created_on = createdat
db.session.add(u)
db.session.commit()
cursor.close()
cnx.close()
return "done"
except Exception as e:
return str(e), 500