92 w = output.append |
92 w = output.append |
93 w(native.sql_schema(driver)) |
93 w(native.sql_schema(driver)) |
94 w('') |
94 w('') |
95 dbhelper = db.get_db_helper(driver) |
95 dbhelper = db.get_db_helper(driver) |
96 if text_index: |
96 if text_index: |
97 w(dbhelper.sql_init_fti()) |
97 w(dbhelper.sql_init_fti().replace(';', ';;')) |
98 w('') |
98 w('') |
99 w(schema2sql(dbhelper, schema, prefix=SQL_PREFIX, |
99 w(schema2sql(dbhelper, schema, prefix=SQL_PREFIX, |
100 skip_entities=skip_entities, skip_relations=skip_relations)) |
100 skip_entities=skip_entities, |
|
101 skip_relations=skip_relations).replace(';', ';;')) |
101 if dbhelper.users_support and user: |
102 if dbhelper.users_support and user: |
102 w('') |
103 w('') |
103 w(sqlgrants(schema, driver, user, text_index, set_owner, |
104 w(sqlgrants(schema, driver, user, text_index, set_owner, |
104 skip_relations, skip_entities)) |
105 skip_relations, skip_entities).replace(';', ';;')) |
105 return '\n'.join(output) |
106 return '\n'.join(output) |
106 |
107 |
107 |
108 |
108 def sqldropschema(schema, driver, text_index=True, |
109 def sqldropschema(schema, driver, text_index=True, |
109 skip_relations=PURE_VIRTUAL_RTYPES, skip_entities=()): |
110 skip_relations=PURE_VIRTUAL_RTYPES, skip_entities=()): |