simples-controle / brasil-api

Brasil API é um projeto que tem o objetivo de ser um HUB de dados para desenvolvedores brasileiros. Ele deve concentrar todos os tipos de dados possíveis que desenvolvedores costumam capturar (aka catar) por aí em diversas fontes, ou por falta de experiência e conhecimento não conseguem fazer captações mais complexas como buscar e processar html (DOM) de terceiros no backend.
http://brasilapi.simplescontrole.com.br
GNU General Public License v3.0
46 stars 3 forks source link

Migrations #17

Open netoolii opened 6 years ago

netoolii commented 6 years ago

Ao fazer o clone do projeto, fica impossível realizar contribuições por não existir as migrations, assim não da pra rodar nenhuma api, tão pouco criar novas, como não quero fazer uma migration nova pra não conflitar com o projeto, peço para que disponibilizem a tabela user como migration para poder ir para o banco direto.

Assim que eu tento acessar qualquer api aparece uma mensagem semelhante a essa.

<response>
<name>Database Exception</name>
<message>
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'superapi.user' doesn't exist The SQL being executed was: SELECT * FROM `user` WHERE (`auth_key`='') AND (`status`=1)
</message>
<code>42</code>
<type>yii\db\Exception</type>
<file>
C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\db\Schema.php
</file>
<line>597</line>
<stack-trace>
<item>
#0 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\db\Command.php(1222): yii\db\Schema->convertException(Object(PDOException), 'SELECT * FROM `...')
</item>
<item>
#1 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\db\Command.php(1107): yii\db\Command->internalExecute('SELECT * FROM `...')
</item>
<item>
#2 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\db\Command.php(410): yii\db\Command->queryInternal('fetch', NULL)
</item>
<item>
#3 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\db\Query.php(260): yii\db\Command->queryOne()
</item>
<item>
#4 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\db\ActiveQuery.php(292): yii\db\Query->one(NULL)
</item>
<item>
#5 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\db\BaseActiveRecord.php(107): yii\db\ActiveQuery->one()
</item>
<item>
#6 C:\Users\ocean\Desktop\brasil-api-master\vendor\webvimark\module-user-management\components\UserIdentity.php(38): yii\db\BaseActiveRecord::findOne(Array)
</item>
<item>
#7 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\web\User.php(274): webvimark\modules\UserManagement\components\UserIdentity::findIdentityByAccessToken('', 'yii\\filters\\aut...')
</item>
<item>
#8 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\filters\auth\QueryParamAuth.php(31): yii\web\User->loginByAccessToken('', 'yii\\filters\\aut...')
</item>
<item>
#9 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\filters\auth\AuthMethod.php(61): yii\filters\auth\QueryParamAuth->authenticate(Object(webvimark\modules\UserManagement\components\UserConfig), Object(yii\web\Request), Object(yii\web\Response))
</item>
<item>
#10 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\base\ActionFilter.php(76): yii\filters\auth\AuthMethod->beforeAction(Object(yii\base\InlineAction))
</item>
<item>
#11 [internal function]: yii\base\ActionFilter->beforeFilter(Object(yii\base\ActionEvent))
</item>
<item>
#12 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\base\Component.php(627): call_user_func(Array, Object(yii\base\ActionEvent))
</item>
<item>
#13 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\base\Controller.php(274): yii\base\Component->trigger('beforeAction', Object(yii\base\ActionEvent))
</item>
<item>
#14 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\web\Controller.php(164): yii\base\Controller->beforeAction(Object(yii\base\InlineAction))
</item>
<item>
#15 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\base\Controller.php(155): yii\web\Controller->beforeAction(Object(yii\base\InlineAction))
</item>
<item>
#16 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\base\Module.php(528): yii\base\Controller->runAction('consulta', Array)
</item>
<item>
#17 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('mercadoria/cons...', Array)
</item>
<item>
#18 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\base\Application.php(386): yii\web\Application->handleRequest(Object(yii\web\Request))
</item>
<item>
#19 C:\Users\ocean\Desktop\brasil-api-master\web\index.php(12): yii\base\Application->run()
</item>
<item>#20 {main}</item>
</stack-trace>
<error-info>
<item>42S02</item>
<item>1146</item>
<item>Table 'superapi.user' doesn't exist</item>
</error-info>
<previous>
<name>Exception</name>
<message>
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'superapi.user' doesn't exist
</message>
<code>42S02</code>
<type>PDOException</type>
<file>
C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\db\Command.php
</file>
<line>1217</line>
<stack-trace>
<item>
#0 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\db\Command.php(1217): PDOStatement->execute()
</item>
<item>
#1 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\db\Command.php(1107): yii\db\Command->internalExecute('SELECT * FROM `...')
</item>
<item>
#2 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\db\Command.php(410): yii\db\Command->queryInternal('fetch', NULL)
</item>
<item>
#3 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\db\Query.php(260): yii\db\Command->queryOne()
</item>
<item>
#4 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\db\ActiveQuery.php(292): yii\db\Query->one(NULL)
</item>
<item>
#5 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\db\BaseActiveRecord.php(107): yii\db\ActiveQuery->one()
</item>
<item>
#6 C:\Users\ocean\Desktop\brasil-api-master\vendor\webvimark\module-user-management\components\UserIdentity.php(38): yii\db\BaseActiveRecord::findOne(Array)
</item>
<item>
#7 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\web\User.php(274): webvimark\modules\UserManagement\components\UserIdentity::findIdentityByAccessToken('', 'yii\\filters\\aut...')
</item>
<item>
#8 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\filters\auth\QueryParamAuth.php(31): yii\web\User->loginByAccessToken('', 'yii\\filters\\aut...')
</item>
<item>
#9 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\filters\auth\AuthMethod.php(61): yii\filters\auth\QueryParamAuth->authenticate(Object(webvimark\modules\UserManagement\components\UserConfig), Object(yii\web\Request), Object(yii\web\Response))
</item>
<item>
#10 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\base\ActionFilter.php(76): yii\filters\auth\AuthMethod->beforeAction(Object(yii\base\InlineAction))
</item>
<item>
#11 [internal function]: yii\base\ActionFilter->beforeFilter(Object(yii\base\ActionEvent))
</item>
<item>
#12 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\base\Component.php(627): call_user_func(Array, Object(yii\base\ActionEvent))
</item>
<item>
#13 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\base\Controller.php(274): yii\base\Component->trigger('beforeAction', Object(yii\base\ActionEvent))
</item>
<item>
#14 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\web\Controller.php(164): yii\base\Controller->beforeAction(Object(yii\base\InlineAction))
</item>
<item>
#15 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\base\Controller.php(155): yii\web\Controller->beforeAction(Object(yii\base\InlineAction))
</item>
<item>
#16 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\base\Module.php(528): yii\base\Controller->runAction('consulta', Array)
</item>
<item>
#17 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('mercadoria/cons...', Array)
</item>
<item>
#18 C:\Users\ocean\Desktop\brasil-api-master\vendor\yiisoft\yii2\base\Application.php(386): yii\web\Application->handleRequest(Object(yii\web\Request))
</item>
<item>
#19 C:\Users\ocean\Desktop\brasil-api-master\web\index.php(12): yii\base\Application->run()
</item>
<item>#20 {main}</item>
</stack-trace>
</previous>
</response>

Obrigado.