一、流程图:
二、目录结构:
C:\USERS\DAISY\PYCHARMPROJECTS\S12\MARKET
│ __init__.py
│ __init__.pyc
│
├─backend
│ │ __init__.py
│ │ __init__.pyc
│ │
│ ├─database_goods
│ │ dbgoods_con.py
│ │ dbgoods_con.pyc
│ │ goods_data.py
│ │ goods_data.pyc
│ │ modles.py
│ │ modles.pyc
│ │ __init__.py
│ │ __init__.pyc
│ │
│ ├─database_user
│ │ db_con.py
│ │ db_con.pyc
│ │ modle.py
│ │ modle.pyc
│ │ user_database.py
│ │ user_database.pyc
│ │ __init__.py
│ │ __init__.pyc
│ │
│ ├─logic
│ │ handle.py
│ │ handle.pyc
│ │ home.py
│ │ home.pyc
│ │ login.py
│ │ login.pyc
│ │ SHOPPING.py
│ │ SHOPPING.pyc
│ │ shopping_class.py
│ │ sockt.py
│ │ sockt.pyc
│ │ __init__.py
│ │ __init__.pyc
│ │
│ └─seller
│ │ __init__.py
│ │
│ ├─seller_db
│ │ __init__.py
│ │
│ └─seller_goods_db
│ __init__.py
│
├─config
│ seller_setting.py
│ seller_setting.pyc
│ settings.py
│ settings.pyc
│ __init__.py
│ __init__.pyc
│
└─frontend
user_acc.py
user_acc.pyc
__init__.py
__init__.pyc
View Code
三、代码展示:
1、backend
1)database_goods,指定购物的数据库,以及购物网站中的物品清单:
#!/usr/bin/env python
#-*- coding: utf-8 -*-# @Time :2017/9/25 9:28# @Author : xuxuedong
# @Site :
# @File : dbgoods_con.py
# @Software: PyCharm
import os, sysfromsqlalchemy import create_engine,Tablefromsqlalchemy.orm import sessionmakerfrommarket.config import settings
BASE_DIR=os.path.dirname(os.path.dirname(os.path.dirname(os.path.dirname(os.path.abspath(__file__)))))
# print(BASE_DIR)
engine= create_engine(settings.DB_CONN,encoding='utf-8',echo =True) #指定Mysql数据库引擎
SessionCls= sessionmaker(bind=engine) #创建与数据库的会话session class,注意,这里返回给session的是个class,不是实例
session= SessionCls()
dbgoods_con.py
以下中为模拟的数据库中物品信息,当然可参考models.py存入数据库中。
#!/usr/bin/env python
#-*- coding: utf-8 -*-# @Time :2017/5/21 11:13# @Author : xuxuedong
# @Site :
# @File : goods_data.py
# @Software: PyCharm
import os, sys'''模拟数据库,可以用sqlachmy单独建立在seller中创建库'''DATABASE_MAN =[
{"name": "男士寸衣", "price": 100},
{"name": "男士长裤", "price": 200},
{"name": "男士皮鞋", "price": 190},
{"name": "男士皮带", "price": 100},
{"name": "男士外衣", "price": 300},
]
DATABASE_WOMAN=[
{"name": "女士寸衣", "price": 300},
{"name": "女士内衣", "price": 103},
{"name": "女士鞋", "price": 200},
{"name": "女士长裙", "price": 198},
]
DATABASE_CHILD=[
{"name": "迪士尼", "price": 300},
{"name": "玩具飞机", "price": 103},
{"name": "玩具汽车", "price": 200},
{"name": "童装", "price": 198},
]
goods_data.py
以下为已经购买存入数据库中的物品数据库表创建代码实现
#!/usr/bin/env python#-*- coding: utf-8 -*-#@Time : 2017/9/25 9:38#@Author : xuxuedong#@Site :#@File : modles.py#@Software: PyCharm
importos, sys,sqlalchemyfrom sqlalchemy importcreate_engine,Table, MetaDatafrom sqlalchemy.ext.declarative importdeclarative_basefrom sqlalchemy importColumn, Integer, String,ForeignKey,UniqueConstraint,UnicodeText,DateTimefrom sqlalchemy.orm importrelationshipfrom sqlalchemy importor_,and_from sqlalchemy importfuncfrom sqlalchemy_utils importChoiceType,PasswordTypefrom sqlalchemy.orm importsessionmakerfrom market.backend.database_goods importdbgoods_con
BASE_DIR=os.path.dirname(os.path.dirname(os.path.dirname(os.path.dirname(os.path.abspath(__file__)))))#engine = create_engine("mysql+pymysql://root:123@localhost/shooping",encoding='utf-8', echo=True)
Base =declarative_base()
User2goods= Table('user_to_goods',Base.metadata,
Column('binduser_id',ForeignKey('goods.id'),primary_key=True)
)classGOODS(Base):__tablename__ = "goods"id= Column(Integer,primary_key=True)
userid= Column(String(64),unique=True,nullable=False)
goods= Column(String(64),unique=True,nullable=False)
numble= Column(String(128),unique=True,nullable=False)
price= Column( String(64),unique=True,nullable=False)def __repr__(self):return "" %(self.id,self.userid,self.goods,self.numble)#class USER(Base):#__tablename__ &