def add_user(user):
db = connect_db(app.config.get('DB'))
User.set_db(db)
Comment.set_db(db)
#
db_user = User()
db_user.username = user['username']
db_user.real_name = user['name']
db_user.salt, db_user.password = make_salt_passwd(DEFAULT_PASSWORD)
#
db.save_doc(db_user)
def add_user(user):
db = connect_db(app.config.get("DB"))
User.set_db(db)
Comment.set_db(db)
#
db_user = User()
db_user.username = user["username"]
db_user.real_name = user["name"]
db_user.salt, db_user.password = make_salt_passwd(DEFAULT_PASSWORD)
#
db.save_doc(db_user)
def add_project(project):
db = connect_db(app.config.get('DB'))
Project.set_db(db)
#
db_project = Project()
db_project.author = project['author']
db_project.title = project['title']
db_project.start_date = datetime.date.today()
db_project.due_date = datetime.date.today()
db_project.text = project['descr']
#
db.save_doc(db_project)
def add_project(project):
db = connect_db(app.config.get("DB"))
Project.set_db(db)
#
db_project = Project()
db_project.author = project["author"]
db_project.title = project["title"]
db_project.start_date = datetime.date.today()
db_project.due_date = datetime.date.today()
db_project.text = project["descr"]
#
db.save_doc(db_project)
def add_task(task):
db = connect_db(app.config.get("DB"))
Task.set_db(db)
Project.set_db(db)
#
db_task = Task()
#
db_project = list(Project.view("projects/by_title", key=task["project"]))[0]
db_task.author = task["author"]
db_task.assigned = task["assigned"]
db_task.priority = task["priority"]
db_task.title = task["title"]
db_task.text = task["text"]
db_task.status = task["status"]
db_task.project = db_project.title
db_task.create_date = datetime.datetime.utcnow()
db_task.update_date = datetime.datetime.utcnow()
db_task.due_date = datetime.date.today()
#
db.save_doc(db_task)
def add_task(task):
db = connect_db(app.config.get('DB'))
Task.set_db(db)
Project.set_db(db)
#
db_task = Task()
#
db_project = list(Project.view('projects/by_title',
key=task['project']))[0]
db_task.author = task['author']
db_task.assigned = task['assigned']
db_task.priority = task['priority']
db_task.title = task['title']
db_task.text = task['text']
db_task.status = task['status']
db_task.project = db_project.title
db_task.create_date = datetime.datetime.utcnow()
db_task.update_date = datetime.datetime.utcnow()
db_task.due_date = datetime.date.today()
#
db.save_doc(db_task)
def client():
connect_db()
client = TestClient(app)
yield client
def init_db():
connect_db(app.config["NOME_DB"])
print("before_request: ", db.engine)
#!/usr/bin/env python2
from app import database
from models import User, History
database.connect_db()
database.database.create_tables([User, History])
database.database.execute_sql('alter table history auto_increment=1001')
def hello_posts(nome_db):
connect_db(nome_db)
post = Post.query.filter_by(id=1).first()
print("posts<" + nome_db + ">: ", db.engine)
return "%s<br><br> %s" % (post.title, post.content)
