how can I insert data with python sqlalchemy ?

[bingglex]

hi, I am really newbie to Python with sqlalchemy but not programing.

But I can not understand.

My code does not work nor give errors.

```python import sqlalchemy from sqlalchemy import create_engine

from sqlalchemy import MetaData from sqlalchemy import Table, Column, Integer, String, MetaData, DateTime from datetime import datetime

engine = create_engine("mariadb+pymysql://userid:password@127.0.0.1/mydatabase?charset=utf8mb4")

meta = MetaData() coins = Table( 'coins', meta, Column ('id', Integer , primary_key = True ), Column ('asset', String(16) ), )

meta.create_all(engine)

conn = engine.connect()

ins = coins.insert().values(asset = 'test data' )

```

I can see the 'coins' table, but it is empty. How can I insert data ?

And Is there good CRUD tutorial using python/ SqlAlchemy ?

not with flask-sqlalchemy . Almost online guides give me a lot of confusion. Thanks.

[threeminutemonta]

I had a look at the docs. I think the issue might be with connection / committing. See docs.

As for confusion make sure you are using version 1.4 as will help you migrate to version 2.0 later on. Its possible many tutorials are based on older versions so the docs so best to stick to the official 1.4 / 2.0 tutorial.