def on_status(self, status):
# if a tweet is a retweet, take the original tweet and insert into the database
if hasattr(status, 'retweeted_status'):
original = status.retweeted_status
else:
original = status
models.insert(original)
def store(self):
for i in self.items():
if i:
data_layer = MONGO_STORAGE_INPUT_DICT
#order is important
data_layer['name'],data_layer['price'],data_layer['url'],data_layer['rating'] = i
insert(data_layer)
def store(self):
for i in self.items():
if i:
data_layer = MONGO_STORAGE_INPUT_DICT
#order is important
data_layer['name'], data_layer['price'], data_layer[
'url'], data_layer['rating'] = i
insert(data_layer)
def post(self):
''' Get a specific fingerprint by key, and insert it'''
# get blip key
key = self.request.get('key')
f = models.get(key)
models.insert(f, False)
for i in f.fingerprint_set:
# process children
doitlater.insert_blip(i)
def signup():
if request.method=='POST':
username = request.form['username']
email = request.form['email']
password = request.form['password']
dbHandler.insert(username,email,password)
return render_template('register.html')
else:
return render_template('register.html')
def post(self):
corekey = self.request.get('key')
text = self.request.get('reply')
parent_f = models.get_response_by_corekey(corekey).response_to
laura = makerobot.make_authorized()
dbw = parent_f.wavelet
wavelet = laura.fetch_wavelet(dbw.wave_id, wavelet_id=dbw.wavelet_id)
reply = wavelet.blips[parent_f.blip].continue_thread()
reply.append_markup(text)
laura.submit(wavelet)
models.insert(models.finger_blip(reply, parent_f, dbw), False)
def insert():
#-- form object from form class
form = InsertForm()
# instead of request.method = post using validate on submit
if form.validate_on_submit():
title = form.title.data
author = form.author.data
quantity = form.quantity.data
price = form.price.data
models.insert(title, author, quantity, price)
return home()
return render_template("insert.html", form=form)
def addStory():
new_story_data = json.loads(request.data)
new_story = Story(title=new_story_data['title'],
synopsis=new_story_data['synopsis'])
# Try to add the new story
try:
insert(new_story)
except:
abort(500)
return jsonify({'success': True})
def post(self):
key = self.request.get('wavelet')
self.blip_id = self.request.get('blip_id')
self.dbw, fullwavelet = models.load_wavelet_key(key)
parent_id = self.thread(fullwavelet.root_thread, None)
if not parent_id:
logging.info("Hopeless case, parent no longer exists")
if parent_id == "root":
parent_id = None
parent = models.Fingerprint.all().filter('wavelet =',
self.dbw).filter('blip =',parent_id).fetch(1)[0]
blip = fullwavelet.blips[self.blip_id]
f = models.finger_blip(blip, parent, wavelet=self.dbw)
models.insert(f, True)
def add_chapter(story_id):
new_chapter_data = json.loads(request.data)
new_chapter = Chapter(number=new_chapter_data['number'],
title=new_chapter_data['title'],
synopsis=new_chapter_data['synopsis'],
story_id=story_id)
# Try to add the new chapter
try:
insert(new_chapter)
except Exception as e:
abort(500)
return jsonify({'success': True, 'updated': return_object})
def create_ja():
""" 新規作成処理 """
id = models.insert(get_db(), request.form['title'],
request.form['title_ja'], request.form['description'],
request.form['description_ja'], request.form['author'])
flash('登録完了しました。')
return redirect(url_for('ja/view', id=id))
def create():
""" 新規作成処理 """
id = models.insert(get_db(), request.form['title'],
request.form['title_ja'], request.form['description'],
request.form['description_ja'], request.form['author'])
flash('The suggestion created.')
return redirect(url_for('view', id=id))
def create(user_id, class_, extra_data=None):
def fix_value(k, v):
t = class_.__table__
if isinstance(t.columns[k].type,
(models.db.Integer, models.db.Float)) and v == '':
return None
else:
return v
access_user(user_id)
data = request.get_json()
valid_fields = {
c.name.lower()
for c in class_.__table__.c if c.info.get("changeable")
}
valid_data = {
k.lower(): fix_value(k, v)
for k, v in data.items() if k.lower() in valid_fields
}
valid_data["user_id"] = user_id
if extra_data:
valid_data.update(**extra_data)
if "id" in data and data["id"]:
result = class_.query.filter((class_.id == data["id"])
& user_or_trainer_condition()).first()
if not result:
raise NotAuthorizedError
valid_data["id"] = data["id"]
result = models.db.engine.execute(models.insert(class_,
valid_data)).fetchone()
return dict(result)
def analysis():
""" 分析実行処理 """
title = request.form['title']
data = request.form['data']
img = models.create_scatter(data)
con = get_db()
pk = models.insert(con, title, data, img)
return redirect(url_for('view', pk=pk))
def POST(self):
i = web.input(action='', sitename='', siteurl='')
web.header('Content-Type', 'application/json')
if i.action == 'add':
return json.dumps(models.insert(i.sitename, i.siteurl))
elif i.action == 'remove':
return json.dumps(models.remove(i.sitename))
else:
return json.dumps('none')
def analysis():
""" 分析実行処理 """
title = request.form['title']
desc = request.form['desc']
data = request.form['data']
img = models.create_scatter(data)
con = get_db()
pk = models.insert(con, title, desc, data, img)
flash('登録処理が完了しました。') # ←ここを追記
return redirect(url_for('view', pk=pk))
def analysis():
""" 分析実行処理 """
title = request.form['title']
plottype = request.form.get('plottype')
data = request.form['data']
img = models.create_plt(data, plottype)
con = get_db()
pk = models.insert(con, title, data, img)
flash('登録処理が完了しました。') # ←ここを追記
return redirect(url_for('view', pk=pk))
def create_post():
data = request.get_json()
user = data['user']
post = data['post']
id_user = check_user(user['login'], user['password'])
if id_user == -1:
return make_response(f'User is not logged in', 401)
query = insert(Post).values(id_user=id_user,
header=post['header'],
text=post['text'])
try:
session.execute(query)
session.commit()
except IntegrityError:
return make_response('Server error', 500)
return make_response('Post created!')
def register():
data = request.get_json()
query = insert(User).values(
login=data['login'],
password=md5(data['password'].encode('utf-8')).hexdigest())
try:
session.execute(query)
session.commit()
except IntegrityError:
resp = make_response(f'<h2>User {data["login"]} already exists</h2>',
400)
resp.headers['Content-Type'] = 'text/plain'
return resp
resp = make_response(
f'<h2>User {data["login"]} was created successfully</h2>', 200)
resp.headers['Content-Type'] = 'text/plain'
return resp
def post(self):
# POST http://[hostname]/api/books 建立新的書本
args = self.reqparse.parse_args()
return models.insert(args)
def init():
"""initialize blog collection
"""
# synchronize articles from http://www.cnblogs.com/russellluo/archive/2013/06/15/3137270.html
models.insert('3137270') # insert a post into blog.posts
def post(self):
insert(request.json["name"], request.json["status"],
request.json["limit"], request.json["detail"])
name = request.json["name"]
return name
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///myspa.db'
app.register_blueprint(api_bp)
@app.route('/', defaults={'path': ''})
@app.route('/<path:path>')
def index(path):
return render_template('index.html')
def gen(camera):
while True:
frame = camera.get_frame()
yield b'--frame\r\n' + b'Content-Type: image/jpeg\r\n\r\n' + frame + b'\r\n\r\n'
sleep(0.33)
@app.route('/video')
def video():
camera = LifeGameCamera()
return Response(gen(camera),
mimetype='multipart/x-mixed-replace; boundary=frame')
if __name__ == '__main__':
with app.app_context():
init_db(app)
if not get_all():
insert('foo', 'This is foo.')
insert('bar', 'This is bar.')
app.run()
