-- 表结构导出
SELECT
B.TABLE_NAME AS "表名",
C.COMMENTS AS "表说明",
B.COLUMN_NAME AS "属性",
A.COMMENTS AS "描述",
case when B.DATA_TYPE ='VARCHAR2' then  B.DATA_TYPE ||'('|| B.DATA_LENGTH || ')'
when B.DATA_TYPE ='DATE' then B.DATA_TYPE 
when B.DATA_TYPE = 'NUMBER' and B.DATA_SCALE != 0  then B.DATA_TYPE ||'('|| B.DATA_PRECISION || ',' || B.DATA_SCALE || ')'
when B.DATA_TYPE = 'NUMBER' then B.DATA_TYPE ||'('|| B.DATA_PRECISION || ')'
end AS "DB数据类型",
case when B.DATA_TYPE ='VARCHAR2' then  'String'
when B.DATA_TYPE ='DATE' then 'Date'
when B.DATA_TYPE = 'NUMBER' and B.DATA_SCALE != 0 then 'Double'
when B.DATA_TYPE = 'NUMBER' then 'Integer'
end AS "类型",
'' as 规则,
B.DATA_DEFAULT as 默认值,
case when B.NULLABLE = 'N' then 'not null'
    when B.NULLABLE = 'Y' then '' end
  as 必填,
'' as 备注
FROM
ALL_COL_COMMENTS A,
ALL_TAB_COLUMNS B,
ALL_TAB_COMMENTS C
WHERE
A.TABLE_NAME IN (SELECT U.TABLE_NAME FROM USER_ALL_TABLES U)
AND A.OWNER = B.OWNER
AND A.TABLE_NAME = B.TABLE_NAME
AND A.COLUMN_NAME = B.COLUMN_NAME
AND C.TABLE_NAME = A.TABLE_NAME
AND C.OWNER = A.OWNER
AND A.OWNER = 'XXX' --用户名(区分大小写)
AND A.TABLE_NAME = 'XXX' --表名(区分大小写)
ORDER BY A.TABLE_NAME, B.COLUMN_ID;



-- 1.查看索引字段
select t.TABLE_NAME,t.COLUMN_NAME from user_ind_columns t,user_indexes i where t.index_name = i.index_name and
t.table_name='XXX' -- 替换自己使用的表名即可
GROUP by t.TABLE_NAME,t.COLUMN_NAME;
-- 2. 查看主键字段
select cu.* from user_cons_columns cu, user_constraints au where cu.constraint_name = au.constraint_name and
au.constraint_type = 'P' AND cu.table_name = 'XXX'; -- 替换自己使用的表名即可
-- 3. 查看分区字段
SELECT * FROM all_PART_KEY_COLUMNS where OWNER = 'ZC' and name ='XXX'; -- 替换自己使用的表名即可



Clone the repository

git clone git@github.com:tildaslash/RatticWeb.git

Change into the source dir

cd RatticWeb

Make sure you have development libraries installed

sudo yum install mysql-devel openldap-devel python-devel python-virtualenv libxml2-devel libxslt-devel

On Debian based systems:

sudo aptitude install libxml2-dev libxslt-dev libldap2-dev python-virtualenv libsasl2-dev libmysqlclient-dev python-dev

Create a virtualenv for Rattic. (n.b. Don't put the virtualenv directory inside the RatticWeb directory -- this breaks the code style tests, as they process all code under the RatticWeb directory.)

virtualenv ~/venv/RatticWeb

Activate the virtualenv

source ~/venv/RatticWeb/bin/activate

Install dependencies with pip

pip install -r requirements-mysql.txt -r requirements-dev.txt

Configure Rattic

cat > conf/local.cfg <<EOF
[ratticweb]
secretkey = [ENTER SOMETHING RANDOM HERE]
debug = true

[filepaths]
help = ../RatticWeb.wiki
EOF
Confirm that your environment is working as expected

./runtests.sh

Create the database files

./manage.py syncdb

Run DB migrations

./manage.py migrate

Create a default user

./manage.py demosetup

Start the server

./manage.py runserver

Browse to http://127.0.0.1:8000/ (default credentials are admin/rattic)

Help files
Clone the help files

cd ..
git clone git@github.com:tildaslash/RatticWeb.wiki.git



import pymysql
 
# 打开数据库连接
db = pymysql.connect(host='47.111.x.x',
                     port=3306,
                     user='root',
                     passwd='XXXXXXXXXX',
                     db='test')
 
# 使用 cursor() 方法创建一个游标对象cur
cur = db.cursor()
 
# 使用 execute()  方法执行 SQL 查询
cur.execute("select * from sys_users where id=1")
 
# 使用 fetchall() 方法获取查询结果
data = cur.fetchall()
 
print(data)
 
# 关闭数据库连接
db.close()
 
 
如果想查询结果以字典格式输出，可以用db.cursor(cursor=pymysql.cursors.DictCursor)