def test_change(self):
conn = Database.conn
Database.change(mysql_db)
assert Database.conn is conn
Database.config(db=mysql_db)
Database.execute('insert into user set user.name="test"')
assert Database.conn_is_up()
assert Database.conn is not conn
def test_config(self):
Database.config(db=mysql_db, user=mysql_user, passwd=mysql_passwd,
charset='utf8', autocommit=True)
assert Database.configs == {
'db': mysql_db,
'user': mysql_user,
'passwd': mysql_passwd,
'host': 'localhost',
'port': 3306,
'charset': 'utf8'
}
assert Database.autocommit is True
def _init_db(self, dbname):
if not os.path.exists(dbname):
cx = sqlite3.connect(dbname)
cursor = cx.cursor()
res = cursor.execute("""
create table proxy (
ip_port varchar primary key,
anonymous varchar,
proxy_type varchar,
location varchar,
response_time varchar,
last_confirm varchar,
last_used float,
is_dead boolean
)
""")
print 'create a new proxy database in: %s' % os.path.abspath(dbname)
Database.set_dbapi(sqlite3)
Database.config(db=dbname)
def __init__(self, db_name):
Database.set_dbapi(sqlite3)
Database.config(db=db_name)
return md5(self.email).hexdigest()
return ''
class Blog(Model):
name = Field()
description = Field()
disqus = Field()
class Post(Model):
datetime = Field()
title = Field()
title_pic = Field()
body = Field()
published = Field()
@property
def summary(self):
return markdown.render(self.body[:150])
class Admin(Model):
passwd = Field()
Database.config(**app.config['DB_CFG'])
class Groups(Model):
id = PrimaryKey()
uid = Field() # 用户id
name = Field() # 分类名
class Ngroups(Model):
uid = Field() # 用户id
name = Field() # 分组名
count = Field() # 分组好友数量
if __name__ == "__main__":
import sqlite3
import os
from skylark import Database
Database.set_dbapi(sqlite3)
Database.set_autocommit(True)
Database.config(db = os.path.abspath("../../data/data.db"))
r = Groups.where(Groups.id == "1", Groups.uid == 1).update(name = "bbbdfdfdfb").execute()
print(r)
r = Ngroups.select()
for i in r:
print(i.data)
groups = Ngroups.where(Ngroups.uid == 1).select()
for g in groups:
print(g)
print([group.data for group in groups])
import MySQLdb
from skylark import Database, Model, Field, PrimaryKey, ForeignKey
class User(Model):
name = Field()
email = Field()
class Post(Model):
name = Field()
post_id = PrimaryKey()
user_id = ForeignKey(User.id)
Database.set_dbapi(MySQLdb)
Database.config(db='mydb', user='******', passwd='')
import MySQLdb
from skylark import Database, Model, Field
from django.conf import settings as _options
Database.set_dbapi(MySQLdb)
Database.config(host=_options.DATABASES['default']['HOST'], user=_options.DATABASES['default']['USER'],
passwd=_options.DATABASES['default']['PASSWORD'], port=int(_options.DATABASES['default']['PORT']),
db=_options.DATABASES['default']['NAME'], charset='utf8')
import MySQLdb
from skylark import Database, Model, Field
from django.conf import settings as _options
Database.set_dbapi(MySQLdb)
Database.config(host=_options.DATABASES['default']['HOST'],
user=_options.DATABASES['default']['USER'],
passwd=_options.DATABASES['default']['PASSWORD'],
port=int(_options.DATABASES['default']['PORT']),
db=_options.DATABASES['default']['NAME'],
charset='utf8')
def setUp(self):
create_tables()
Database.config(db=mysql_db, user=mysql_user, passwd=mysql_passwd)
def initdb(path = None):
Database.set_dbapi(sqlite3)
Database.set_autocommit(True)
Database.config(db = path if path else lib.DBPATH, check_same_thread = False)
# -*- coding: utf-8 -*-
import MySQLdb
from skylark import Database, Model, Field
from config import DB_HOST, DB_PORT, DB_USER, DB_PWD, DB
class Userdevice(Model):
id = Field()
deviceId = Field()
deviceType = Field()
openId = Field()
fromUserName = Field()
Database.set_dbapi(MySQLdb)
Database.config(host=DB_HOST, port=DB_PORT, db=DB, user=DB_USER, passwd=DB_PWD)
if __name__ == '__main__':
user = Userdevice(deviceId='koovox_01', deviceType='wechat', openId='123456', fromUserName='******')
user.save()
from zhiz import app
from skylark import Database
# appfog mysql configuration
import json, os
services_json = json.loads(os.getenv("VCAP_SERVICES"))
mysql_config = services_json["mysql-5.1"][0]["credentials"]
DB_CFG = {
"user": mysql_config["username"],
"passwd": mysql_config["password"],
"host": mysql_config["hostname"],
"port": mysql_config["port"],
"db": mysql_config["name"],
}
# update database configuration
app.config["DB_CFG"].update(DB_CFG)
app.name = "wsgi"
application = app # !important
# Configure database again
Database.config(**app.config["DB_CFG"])
if __name__ == "__main__":
app.run()
# coding=utf8
from skylark import Database, Model, Field
Database.config(user='******', passwd='', db='mytest')
class User(Model):
name = Field()
email = Field()
user = User(name='Join', email='*****@*****.**')
user.save()
download_root_dir = os.environ['OPENSHIFT_DATA_DIR']
data_dir = os.environ['OPENSHIFT_DATA_DIR']
template_root_dir = os.environ['OPENSHIFT_REPO_DIR']+"/wsgi/static"
# template_root_dir = _curdir + "/static"
else:
# 表示程式在近端執行
download_root_dir = _curdir + "/local_data/"
data_dir = _curdir + "/local_data/"
template_root_dir = _curdir + "/static"
# 資料庫選用
# 內建使用 sqlite3
ormdb = "sqlite"
#ormdb = "mysql"
if ormdb == "sqlite":
Database.set_dbapi(sqlite3)
Database.config(db=data_dir+"task.db")
else:
# 選用 mysql
# 注意 port 必須為整數, 而非字串
if 'OPENSHIFT_REPO_DIR' in os.environ.keys():
Database.set_dbapi(pymysql)
Database.config(host=os.environ[str('OPENSHIFT_MYSQL_DB_HOST')], \
port=int(os.environ['OPENSHIFT_MYSQL_DB_PORT']), db='cadp', \
user=os.environ['OPENSHIFT_MYSQL_DB_USERNAME'], \
passwd=os.environ['OPENSHIFT_MYSQL_DB_PASSWORD'], charset='utf8')
else:
Database.set_dbapi(pymysql)
Database.config(host='localhost', port=3306, db='cadp', user='******', passwd='root', charset='utf8')
#@-<<declarations>>
#@+others
#@+node:2014fall.20140821113240.3107: ** class Task
# coding=utf8
from skylark import Database, Model, Field
Database.config(user='******', passwd='', db='mytest')
class User(Model):
name = Field()
email = Field()
user = User(name='Join', email='*****@*****.**')
user.save()
# coding=utf8
import pymysql
from skylark import Database, Model, Field
from messageboard import app
class Message(Model):
title = Field()
content = Field()
create_at = Field()
Database.set_dbapi(pymysql)
Database.config(**app.config['DB_CONN_CFG'])
import sqlite3
from skylark import Database, Model, Field, PrimaryKey, ForeignKey
class User(Model):
name = Field()
email = Field()
class Post(Model):
name = Field()
post_id = PrimaryKey()
user_id = ForeignKey(User.id)
Database.set_dbapi(sqlite3)
Database.config(db='mydb')
from lxml import html
import requests
from skylark import Database, Model, Field
#~ database connection
Database.config(db='valdzia', user='******', passwd='123456')
class employees(Model):
name = Field()
position = Field()
#~ get contacts page
contactspage = requests.get('http://president.lt/lt/dbs_kontaktai/printerlist.html')
contactstree = html.fromstring(contactspage.text)
#~ Get staff names and positions from contacts page
staffname = [el.text or ' ' for el in contactstree.xpath('//p[@class="vv"]')]
staffposition = [el.text or ' ' for el in contactstree.xpath('//p[@class="vvv"]')]
#~ Write staff information to database
employees.create(name=staffname[i],position=staffposition[i])
from skylark import Database, Model, Field, PrimaryKey, ForeignKey
class User(Model):
name = Field()
email = Field()
class Post(Model):
name = Field()
post_id = PrimaryKey()
user_id = ForeignKey(User.id)
Database.config(db='mydb', user='******', passwd='')
import sqlite3
from skylark import Database, Model, Field, PrimaryKey, ForeignKey
class User(Model):
name = Field()
email = Field()
class Post(Model):
name = Field()
post_id = PrimaryKey()
user_id = ForeignKey(User.id)
Database.set_dbapi(sqlite3)
Database.config(db='mydb')
