fjdklsakhirluyterlg / revisionwebsitev3 Goto Github PK

from backends.models import User
import csv

def write_users():
    users = []
    query = User.query.all()
    for q in query:
        data = [q.name, q.timestamp, q.points, q.email]
        users.append(data)

    with open('users.csv', 'w', newline='') as file:
        fieldnames = ["name", "timestamp", "points", "email"]
        writer = csv.writer(file)
        writer.writerows(users)

import click
from flask import Blueprint
from backends import db
from backends.models import User

clix = Blueprint("cli", __name__, cli_group=None)

@clix.cli.command('create')
@click.argument('name')
def create(name):
    print(name)

@clix.cli.command("get")
@click.argument("users")
def get_useres(users):
    users = User.query.all()
    dict = {}
    for user in users:
        dict[user.id] = {"name":user.name, "email":user.email, "points":user.points}
    print(dict)

from backends.models import User
from backends import db
import csv

def write_users():
    users = []
    query = db.session.query(User).all()
    for q in query:
        data = [q.name, q.timestamp, q.points, q.email]
        users.append(data)

    with open('users.csv', 'w', newline='') as file:
        fieldnames = ["name", "timestamp", "points", "email"]
        writer = csv.writer(file)
        writer.writerows(users)

write_users()