Seeking Collaboration for Front-End and Back-End Integration
Hello, amazing community!
I’m currently working on an exciting social network project called ABOA, and I’m looking for talented individuals who can lend their expertise in integrating the front-end and back-end components. ABOA aims to connect people for unforgettable experiences, and your help can make it even more incredible!
What We Need Help With: We’re at a crucial stage where we need assistance in seamlessly bringing together the front-end design and the back-end functionality. If you have experience in web development, particularly with front-end technologies like HTML, CSS, and JavaScript, as well as back-end technologies such as Python or Node.js, your skills would be invaluable.
How You Can Contribute:
-
Collaborate on designing and implementing an interactive user interface.
-
Assist in connecting the front-end to the back-end functionalities.
-
Optimize and enhance user experience across different devices.
Why Contribute: By contributing to ABOA, you’ll be part of creating a platform that fosters unforgettable social experiences. It’s an opportunity to showcase your skills, collaborate with a passionate team, and make a positive impact on the way people connect and share moments.
How to Get Involved: Feel free to reach out if you’re interested or have any questions. You can reach at at [email protected]. Your expertise is highly valued, and together, we can bring ABOA to new heights!
Thank you for considering joining this exciting journey!
Best regards, José
import sqlite3
import os
connection = None # ou substitua por um objeto de conexão real, dependendo do seu código
def criar_tabela():
caminho_diretorio = 'C:\Users\ejose\OneDrive\Documentos\Projetos Marolentos\templates'
caminho_banco_dados = os.path.join(caminho_diretorio, 'avaliacoes.db')
conn = sqlite3.connect(caminho_banco_dados)
cursor = conn.cursor()
cursor.execute('''
CREATE TABLE IF NOT EXISTS avaliacoes (
id INTEGER PRIMARY KEY AUTOINCREMENT,
usuario TEXT,
festa TEXT,
avaliacao INTEGER,
comentario TEXT
)
''')
conn.commit()
conn.close()
def adicionar_avaliacao(usuario, festa, avaliacao, comentario):
caminho_diretorio = 'C:\Users\ejose\OneDrive\Documentos\Projetos Marolentos\templates'
caminho_banco_dados = os.path.join(caminho_diretorio, 'avaliacoes.db')
conn = sqlite3.connect(caminho_banco_dados)
cursor = conn.cursor()
cursor.execute('''
INSERT INTO avaliacoes (usuario, festa, avaliacao, comentario)
VALUES (?, ?, ?, ?)
''', (usuario, festa, avaliacao, comentario))
cursor.execute("INSERT INTO avaliacoes (usuario, festa, avaliacao, comentario) VALUES (?, ?, ?, ?)",
(usuario, festa, avaliacao, comentario))
try:
connection.commit()
except AttributeError as e:
print(f"Erro ao tentar commit: {e}")
conn.commit()
conn.close()
def obter_avaliacoes():
caminho_diretorio = 'C:\Users\ejose\OneDrive\Documentos\Projetos Marolentos\templates'
caminho_banco_dados = os.path.join(caminho_diretorio, 'avaliacoes.db')
conn = sqlite3.connect(caminho_banco_dados)
cursor = conn.cursor()
cursor.execute('SELECT * FROM avaliacoes')
avaliacoes = cursor.fetchall()
try:
connection.commit()
except AttributeError as e:
print(f"Erro ao tentar commit: {e}")
conn.close()
return avaliacoes
# Exemplo de uso
criar_tabela()
adicionar_avaliacao('João', 'Festa Legal', 4, 'Gostei bastante!')
adicionar_avaliacao('Maria', 'Evento Top', 5, 'Incrível!')
avaliacoes = obter_avaliacoes()
print(avaliacoes)
adicionar_avaliacao('João', 'Festa Legal', 4, 'Gostei bastante!')
adicionar_avaliacao('Maria', 'Evento Top', 5, 'Incrível!')
avaliacoes = obter_avaliacoes()
print(avaliacoes)
...............................................................
from flask import Flask, render_template, request, jsonify
import sqlite3
app = Flask(__name__)
# Configuração do SQLite
DATABASE = 'database.db'
def create_table():
connection = sqlite3.connect(DATABASE)
cursor = connection.cursor()
cursor.execute('''CREATE TABLE IF NOT EXISTS avaliacao (
id INTEGER PRIMARY KEY AUTOINCREMENT,
usuario TEXT NOT NULL,
festa TEXT NOT NULL,
avaliacao INTEGER NOT NULL,
comentario TEXT NOT NULL
)''')
connection.commit()
connection.close()
@app.route('/')
def index():
create_table()
return render_template('avaliacao.html')
@app.route('/api/adicionar_avaliacao', methods=['POST'])
def adicionar_avaliacao():
data = request.get_json()
usuario = data['usuario']
festa = data['festa']
avaliacao = data['avaliacao']
comentario = data['comentario']
connection = sqlite3.connect(DATABASE)
cursor = connection.cursor()
cursor.execute('''INSERT INTO avaliacoes (usuario, festa, avaliacao, comentario)
VALUES (?, ?, ?, ?)''', (usuario, festa, avaliacao, comentario))
connection.commit()
connection.close()
return jsonify({"message": "Avaliação adicionada com sucesso!"})
@app.route('/api/listar_avaliacoes')
def listar_avaliacoes():
connection = sqlite3.connect(DATABASE)
cursor = connection.cursor()
cursor.execute('''SELECT * FROM avaliacoes''')
avaliacoes = cursor.fetchall()
connection.close()
return jsonify({"avaliacoes": avaliacoes})
if __name__ == '__main__':
app.run(debug=True)
...................................................
<!DOCTYPE html>
<html lang="pt-br">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>ABOA App - Avaliações</title>
<link rel="stylesheet" href="MAROLEX.css"/>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.3/css/all.min.css" integrity="sha512-wtGA6z8A3nh1h9OPI8XU4e0YNbFddA/SwPPznU0Js1zsvugNqumZD3F6ExB5X7j3giF0AZzUnViI/Vd31ZI6foA==" crossorigin="anonymous" referrerpolicy="no-referrer" />
</head>
<body>
<header>
<h1>ABOA App - Avaliações</h1>
<p>Conectando pessoas para experiências inesquecíveis!</p>
</header>
<nav>
<ul>
<li><button onclick="navigateTo('index.html')">Home</button></li>
<li><button onclick="navigateTo('sobre-nos.html')">Sobre Nós</button></li>
<li><button onclick="navigateTo('contato.html')">Contato</button></li>
<li><button onclick="navigateTo('avaliacao.html')">Avaliação</button></li>
<li><button onclick="navigateTo('compartilhamento.html')">Compartilhamento</button></li>
<li><button onclick="navigateTo('social.html')">Social</button></li>
</ul>
</nav>
<main>
<!-- Formulário para Adicionar Avaliação -->
<section>
<h2>Adicionar Avaliação</h2>
<form onsubmit="adicionarAvaliacao(event)">
<label for="usuario">Usuário:</label>
<input type="
<input type="text" id="usuario" name="usuario" required>
<label for="festa">Festa:</label>
<input type="text" id="festa" name="festa" required>
<label for="avaliacao">Avaliação:</label>
<select id="avaliacao" name="avaliacao" required>
<option value="1">1 estrela</option>
<option value="2">2 estrelas</option>
<option value="3">3 estrelas</option>
<option value="4">4 estrelas</option>
<option value="5">5 estrelas</option>
</select>
<label for="comentario">Comentário:</label>
<textarea id="comentario" name="comentario" rows="4" required></textarea>
<button type="submit">Adicionar Avaliação</button>
</form>
</section>
<!-- Lista de Avaliações -->
<section class="history-section">
<h2>Histórico de Avaliações</h2>
<ul id="historicoAvaliacoes">
<!-- As avaliações serão adicionadas dinamicamente aqui -->
</ul>
</section>
<button class="back-button" onclick="goBack()">Voltar</button>
</main>
<footer class="footer-info">
<p>© 2023 ABOA App. Todos os direitos reservados.</p>
</footer>
<script src="https://code.jquery.com/jquery-3.6.4.min.js"></script>
<script>
function navigateTo(page) {
window.location.href = page;
}
function adicionarAvaliacao(event) {
event.preventDefault();
const usuario = $('#usuario').val();
const festa = $('#festa').val();
const avaliacao = $('#avaliacao').val();
const comentario = $('#comentario').val();
$.ajax({
url: '/api/adicionar_avaliacao',
type: 'POST',
contentType: 'application/json',
data: JSON.stringify({ usuario, festa, avaliacao, comentario }),
success: function (response) {
console.log(response.message);
listarAvaliacoes();
},
error: function (error) {
console.error('Erro ao adicionar avaliação:', error);
}
});
}
function listarAvaliacoes() {
$.get('/api/listar_avaliacoes', function (data) {
const historicoAvaliacoes = $('#historicoAvaliacoes');
historicoAvaliacoes.empty();
data.avaliacoes.forEach(function (avaliacao) {
historicoAvaliacoes.append(`
<li>
<p>${avaliacao.usuario}, ${avaliacao.festa}</p>
<p>Avaliação: ${avaliacao.avaliacao} estrela(s)</p>
<p>Comentário: ${avaliacao.comentario}</p>
</li>
`);
});
});
}
function goBack() {
window.history.back();
}
$(document).ready(function () {
listarAvaliacoes();
});
</script>
</body>
</html>
