株式会社ソニー・ミュージックレーベルズ：宮世琉弥 3月19日(水)発売 2nd AL「Soleil」のインタビュームfrom sqlalchemy import create_engine, Column, Integer, String from sqlalchemy.orm import sessionmaker from sqlalchemy.ext.declarative import declarative_base # Create a database engine engine = create_engine(‘sqlite:///users.db’) # Create a Base class for our database models Base = declarative_base() # Define the User model class User(Base): __tablename__ = ‘users’ id = Column(Integer, primary_key=True) username = Column(String) email = Column(String) # Create the database tables Base.metadata.create_all(engine) # Create a session to interact with the database Session = sessionmaker(bind=engine) session = Session() # Add some users to the database user1 = User(username=’john_doe’, email=’john.doe@example.com’) user2 = User(username=’jane_smith’, email=’jane.smith@example.com’) session.add(all=[user1, user2]) session.commit() # Query the database for all users users = session.query(User).all() for user in users: print(f”ID: {user.id}, Username: {user.username}, Email: {user.email}”) # Close the session session.close() End File# Shubhanu1/SQLAlchemy-With-Flask from flask import Flask, request, render_template from sqlalchemy import create_engine, Column, Integer, String from sqlalchemy.orm import sessionmaker from sqlalchemy.ext.declarative import declarative_base app = Flask(__name__) # Create a database engine engine = create_engine(‘sqlite:///users.db’) # Create a Base class for our database models Base = declarative_base() # Define the User model class User(Base): __tablename__ = ‘users’ id = Column(Integer, primary_key=True) username = Column(String) email = Column(String) # Create the database tables Base.metadata.create_all(engine) # Create a session to interact with the database Session = sessionmaker(bind=engine) session = Session() @app.route(‘/’) def index(): users = session.query(User).all() return render_template(‘index.html’, users=users) @app.route(‘/add’, methods=[‘GET’, ‘POST’]) def add_user(): if request.method == ‘POST’: username = request.form[‘username’] email = request.form[‘email’] new_user = User(username=username, email=email) session.add(new_user) session.commit() return ‘User added successfully’ return render_template(‘add.html’) @app.route(‘/delete/‘) def delete_user(id): user = session.query(User).get(id) session.delete(user) session.commit() return ‘User deleted successfully’ if __name__ == ‘__main__’: app.run(debug=True) # README.md # simple_web_browser A simple web browser developed using Python Tkinter library. Features: – Navigation bar – Back and forward buttons – Home button – Refresh button – Stop button – Open new tab – Close tab – Web page zoom in and zoom out – Print web page – Save web page as HTML file Requirements: – Python 3.x – Tkinter library – Pillow library – Printing library (e.g. pywin32) To run the web browser, simply execute the main.py file: “` python main.py “` Enjoy browsing the web! End File# main.py import tkinter as tk from tkinter import ttk from PIL import Image, ImageTk import webbrowser import os import win32api import win32print class WebBrowser(tk.Tk): def __init__(self): super().__init__() self.title(“Simple Web Browser”) self.geometry(“1200×800″) # Create a canvas to display the web page self.canvas = tk.Canvas(self, width=1200, height=700) self.canvas.pack(pady=20) # Create a navigation bar self.nav_bar = ttk.Entry(self, width=100) self.nav_bar.pack(pady=10) # Create buttons self.buttons_frame = tk.Frame(self) self.buttons_frame.pack(pady=10) self.back_button = ttk.Button(self.buttons_frame, text=”Back”, command=self.go_back) self.back_button.pack(side=tk.LEFT, padx=5) self.forward_button = ttk.Button(self.buttons_frame, text=”Forward”, command=self.go_forward) self.forward_button.pack(side=tk.LEFT, padx=5) self.home_button = ttk.Button(self.buttons_frame, text=”Home”, command=self.go_home) self.home_button.pack(side=tk.LEFT, padx=5) self.refresh_button = ttk.Button(self.buttons_frame, text=”Refresh”, command=self.refresh_page) self.refresh_button.pack(side=tk.LEFT, padx=5) self.stop_button = ttk.Button(self.buttons_frame, text=”Stop”, command=self.stop_loading) self.stop_button.pack(side=tk.LEFT, padx=5) self.new_tab_button = ttk.Button(self.buttons_frame, text=”New Tab”, command=self.open_new_tab) self.new_tab_button.pack(side=tk.LEFT, padx=5) self.close_tab_button = ttk.Button(self.buttons_frame, text=”Close Tab”, command=self.close_tab) self.close_tab_button.pack(side=tk.LEFT, padx=5) self.zoom_in_button = ttk.Button(self.buttons_frame, text=”+”, command=self.zoom_in) self.zoom_in_button.pack(side=tk.LEFT, padx=5) self.zoom_out_button = ttk.Button(self.buttons_frame, text=”-“, command=self.zoom_out) self.zoom_out_button.pack(side=tk.LEFT, padx=5) self.print_button = ttk.Button(self.buttons_frame, text=”Print”, command=self.print_page) self.print_button.pack(side=tk.LEFT, padx=5) self.save_button = ttk.Button(self.buttons_frame, text=”Save”, command=self.save_page) self.save_button.pack(side=tk.LEFT, padx=5) # Initialize browser history self.history = [] self.current_index = -1 # Set the home page self.go_home() def go_to_url(self, event=None): url = self.nav_bar.get() self.load_webpage(url) def load_webpage(self, url): try: self.canvas.delete(“webpage”) webbrowser.open(url, new=0, autoraise=True) self.nav_bar.delete(0, tk.END) self.nav_bar.insert(0, url) self.history.append(url) self.current_index += 1 except Exception as e: print(f”Error loading webpage: {e}”) def go_back(self): if self.current_index > 0: self.current_index -= 1 url = self.history[self.current_index] self.load_webpage(url) def go_forward(self): if self.current_index < len(self.history) - 1: self.current_index += 1 url = self.history[self.current_index] self.load_webpage(url) def go_home(self): self.load_webpage("https://www.google.com") def refresh_page(self): self.load_webpage(self.nav_bar.get()) def stop_loading(self): webbrowser.get().stop() def open_new_tab(self): webbrowser.open_new_tab("https://www.google.com") def close_tab(self): webbrowser.get().close() def zoom_in(self): self.canvas.scale("all", 0, 0, 1.1, 1.1) def zoom_out(self): self.canvas.scale("all", 0, 0, 0.9, 0.9) def print_page(self): url = self.nav_bar.get() win32api.ShellExecute(0, "print", url, None, ".", 0) def save_page(self): url = self.nav_bar.get() filename = os.path.splitext(os.path.basename(url))[0] + ".html" webbrowser.get().open(url) with open(filename, "w", encoding="utf-8") as f: f.write(webbrowser.get().page_source) print(f"Page saved as {filename}") if __name__ == "__main__": web_browser = WebBrowser() web_browser.mainloop() # Arham-ifran/OIC-Website End File# Arham-ifran/OIC-Website # assets/img/icon-9.svg End File# assets/img/icon-15.svg End File# Arham-ifran/OIC-Website End File# assets/img/icon-14.svg

本サイトではアフィリエイト広告を利用しています