这篇文章主要介绍了python中如何通过elixir包操作mysql数据库，具有一定借鉴价值，感兴趣的朋友可以参考下，希望大家阅读完这篇文章之后大有收获，下面让小编带着大家一起了解一下。
站在用户的角度思考问题，与客户深入沟通，找到天峨网站设计与天峨网站推广的解决方案，凭借多年的经验，让设计与互联网技术结合，创造个性化、用户体验好的作品，建站类型包括：成都做网站、网站设计、
外贸营销网站建设、企业官网、英文网站、手机端网站、网站推广、
域名注册、
雅安服务器托管、企业邮箱。业务覆盖天峨地区。
本文研究的主要是python通过elixir包操作mysql数据库的相关实例，具体如下。
python操作数据库有很多方法，下面介绍elixir来操作数据库。elixir是对sqlalchemy lib的一个封装，classes和tables是一一对应的，能够一步定义classes，tables和mappers，支持定义多个primary key。
定义model.py
from elixir import sqlalchemy
from elixir import *
engine =sqlalchemy.create_engine('mysql://root:root@localhost/') #the first root is the user, and the sencond root is the password
#engine.execute("DROP DATABASE IF EXISTS elixir")
engine.execute("CREATE DATABASE IF NOT EXISTS elixir")
metadata.bind='mysql://root:root@localhost:3306/elixir'
#metadata.bind.echo =True
class Movie(Entity):
using_options(tablename='movies')
title = Field(Unicode(30),primary_key = True)
year = Field(Integer, primary_key = True)
description = Field(UnicodeText)
director = ManyToOne('Director')
genres = ManyToMany('Genre')
actor = ManyToMany('Actor')
def __repr__(self):
return '' % (self.title, self.year)
class Person(Entity):
using_options(inheritance='multi')
using_options(tablename='person')
name = Field(Unicode(60))
def __repr__(self):
return '' % self.name
class Director(Person):
using_options(inheritance='multi')
using_options(tablename='director')
movies = OneToMany('Movie')
def __repr__(self):
return '' % self.name
class Genre(Person):
using_options(inheritance='multi')
using_options(tablename='genre')
movies = ManyToMany('Movie')
def __repr__(self):
return '' % self.name
class Actor(Person):
using_options(inheritance='multi')
using_options(tablename='actor')
movies = ManyToMany('Movie')
def __repr__(self):
return '' % self.namemodel_test.py
from model import *
# setup_all(True) is equal to the following two staps:
setup_all() # create sqlalchemy table object as mapper object for the class
create_all() # take all table objcts and create real tables by issuing SQL statements on the databse.
Actor1 = Actor(name=u"lvliang")
scifi = Genre(name = u"Science-Fiction")
rscott = Director(name = u"Ridley Scott")
glucas = Director(name = u"George Lucas")
alien = Movie(title = u"Alien", year = 1979, director=rscott, genres=[scifi, Genre(name=u"Horror")], actor = [Actor1])
brunner = Movie(title = u"Blade Runner", year = 1982, director = rscott, genres=[scifi])
swars = Movie(title = u"Star Wars", year = 1977, director = glucas, genres=[scifi])
session.commit()
m1 = Movie.query.filter_by(title=u"Alien").one()
m2 = Movie.query.filter(Movie.year>1980).all()
m3 = Movie.query.filter(Movie.director.has(name = u"Ridley Scott")).all()
m4 = Movie.query.filter(Movie.director.has(Director.name.endswith(u"Scott"))).all()
m5 = Movie.query.filter(Movie.genres.any(name = u"Horror")).all()
print m1
print m2
print m3
print m4
print m5
d = Director.get_by(name = u"Ridley Scott") # Class.get_by(xxx) is a shortcut for Class.query.filter_by(xxx).first
q = Movie.query.filter_by(director = d) #get all movies directed by director d
m = q.filter_by(year = 1979).all()
print "Movie direct by %s in year 1979 are " %(d.name)
print m
movies = q.order_by(sqlalchemy.desc(Movie.year)).all()
print movies
fro m in movies:
m.delete()
session.commit()
执行model.py，结果为：
查看数据库，结果为：
感谢你能够认真阅读完这篇文章，希望小编分享的“python中如何通过elixir包操作mysql数据库”这篇文章对大家有帮助，同时也希望大家多多支持创新互联成都网站设计公司，关注创新互联成都网站设计公司行业资讯频道，更多相关知识等着你来学习!
另外有需要云服务器可以了解下创新互联scvps.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、网站设计器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。
文章标题：python中如何通过elixir包操作mysql数据库-创新互联
URL链接：
http://cdkjz.cn/article/dpjeoc.html
