| | |
|---|
| | | |
|---|
| | | const ( |
|---|
| | | PersonSqliteDBPath = "~/workspace/gitblit/dbserver/config/testdb.db" |
|---|
| | | DbT_TableName = "dbtables" |
|---|
| | | DBP_TableName = "dbtablepersons" |
|---|
| | | ) |
|---|
| | | |
|---|
| | | var syncMut sync.Mutex |
|---|
| | |
|---|
| | | for _,col :=range tDescArr { |
|---|
| | | columnNames = append(columnNames, fmt.Sprintf(`'||quote("%s")||'`, col.Name)) |
|---|
| | | } |
|---|
| | | if table == "dbTables" { |
|---|
| | | if table == DbT_TableName { |
|---|
| | | tSql = fmt.Sprintf(`SELECT 'INSERT INTO "%s" VALUES(%s)' as sql FROM "%s" where (analyServerId='' or analyServerId is NULL);`, |
|---|
| | | table, |
|---|
| | | strings.Join(columnNames, ","), |
|---|
| | | table) |
|---|
| | | } else if table == "dbtablepersons" { |
|---|
| | | } else if table == DBP_TableName { |
|---|
| | | tSql = fmt.Sprintf(`SELECT 'INSERT INTO "%s" VALUES(%s)' as sql FROM "%s" where tableId in (select id from dbTables where (analyServerId='' or analyServerId is NULL));`, |
|---|
| | | table, |
|---|
| | | strings.Join(columnNames, ","), |
|---|
