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')
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 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='')