def __init__(self, db_conf_path):
self.db = DB(conf_path=db_conf_path)
self.t_info = "video_info"
self.t_episode = "video_episode"
# !/usr/bin/env python
# coding: utf-8
import os
import sys
from mysqldb_rich import DB, TableDB
from zh_config import db_conf_path
__author__ = 'meisa'
script_dir = os.path.dirname(__file__)
if __name__ == "__main__":
if len(sys.argv) >= 2:
root_password = sys.argv[1]
else:
root_password = "******"
db = DB(conf_path=db_conf_path, user="******", password=root_password)
db.root_init_conf('%')
db2 = TableDB(conf_path=db_conf_path)
db2.create_from_dir(os.path.join(script_dir, "table"))
def __init__(self, db_conf_path):
self.db = DB(conf_path=db_conf_path)
self.t = "people_info"
self.t_detail = "people_detail"
self.t_group = "people_group"
self.t_resource = "people_resource"
# !/usr/bin/env python
# encoding: utf-8
from mysqldb_rich import DB
__author__ = 'meisanggou'
if __name__ == "__main__":
db = DB()
items = db.execute_select("zh_test",
prefix_value=dict(a=r"abc_", b="%"),
cols=["a"],
print_sql=True)
for item in items:
print(item)
def __init__(self, db_conf_path):
self.db = DB(conf_path=db_conf_path)
self.t_info = "music_info"
self.t_records = "listen_records"
def __init__(self, db_conf_path):
self.db = DB(conf_path=db_conf_path)
self.t_info = "article_info"
self.t_content = "article_content"
self.t_statistics = "article_statistics"