Hi, I updated my PC and downloaded my old codes. However, the SQLAlchemy execute function is not working. but it works on Ubuntu. The code is basically like this: -- from sqlalchemy import ( MetaData, Table, Column, Integer, String, Boolean, create_engine, DateTime, VARCHAR, ) from datetime import datetime from flask_sqlalchemy import SQLAlchemy from flask import Flask, render_template, abort, request from sqlalchemy.sql import select
engine = create_engine( "sqlite:///C:/Users/furka/OneDrive/Masaüstü/programlama/Python/db3.db" ) app = Flask(__name__) app.secret_key = "#$#$#$" app.config[ "SQLALCHEMY_DATABASE_URI" ] = "sqlite:///C:/Users/furka/OneDrive/Masaüstü/programlama/Python/db3.db" meta = MetaData() meta.reflect(bind=engine) db = SQLAlchemy(app) print(len(meta.tables)) if not ("application" in meta.tables): Table( "application", meta, Column("id", Integer, primary_key=True), Column("name", VARCHAR(80)), Column("password", VARCHAR(80)), Column("anaSayfa", VARCHAR(80)), Column("manuelSayfa", VARCHAR(80)), Column("varsayilanlar", VARCHAR(80)), Column("dinamik", VARCHAR(80)), Column("dinamikSayfa", VARCHAR(80)), Column("kitap", VARCHAR(80)), Column("kalem", VARCHAR(80)), Column("date", DateTime, default=datetime.utcnow), ) meta.create_all(engine) if 1: if 1: application = Table("application", meta) conn = engine.connect() app = application.insert().values(name = "name", password = "password", anaSayfa = "anaSayfa", manuelSayfa = "manuelSayfa", varsayilanlar= "varsayilanlar", dinamikSayfa = "dinamikSayfa", dinamik = "dinamik", kitap = "kitap", kalem = "kalem" ) conn.execute(app) conn.close() print("crtd") -- output: -- 1 crtd -- application table is created but new values doesnt appear -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/ced6580a-c3d9-4586-84f7-36a539f4ead2n%40googlegroups.com.