メモ02:sqlalchemy-MySQLに接続

sqlalchemy-MySQLに接続
メモ03:sqlalchemy追加削除
データベースの接続

# -*- coding: utf-8 -*-

#import pymysql #    pymysql，        ，     
from sqlalchemy import create_engine

host = 'localhost' #     
port = '3306' #  
database = 'dd_db' #     
user = 'root' #       
password = '' #    ，         
'''
dd   ：
     +       ://   :  @    :   /    ?    
   ：MySQL、postgresql、sqlite ，    
     ：pymysql、MySQLdb
pymysql：  python 3.x
MySQLdb：   python3.x
  ：mysql+pymysql://root:@localhost:3306/test_db?charset=utf8
charset=utf8：        
'''
dd = 'mysql+pymysql://{}:{}@{}:{}/{}?charset=utf8'.format(user,password,host,port,database)

print(dd)

engine = create_engine(dd)

with engine.connect() as con:
    con.execute('drop table if exists users')
#python     """"""        ，            ，  html sql   
    con.execute("""create table users(id int primary key auto_increment,name varchar(25),age int, income float)""")
    con.execute("""insert into users(name,age,income) values('   ',26,8755)""")
    con.execute("""insert into users(name,age,income) values('  ',28,4671)""")
    rs = con.execute('select * from users')
    
    for row in rs:
        print(row)