garrylachman / electrocrud Goto Github PK
View Code? Open in Web Editor NEWDatabase CRUD Application Built on Electron | MySQL, Postgres, SQLite
Home Page: http://garrylachman.github.io/ElectroCRUD/
License: MIT License
Database CRUD Application Built on Electron | MySQL, Postgres, SQLite
Home Page: http://garrylachman.github.io/ElectroCRUD/
License: MIT License
Pls add auth private key for ssl tunnel
Error in /Applications/ElectroCRUD.app/Contents/Resources/app.asar/dist/index.html
Uncaught (in promise): TypeError: Cannot read property 'id' of undefined
TypeError: Cannot read property 'id' of undefined
at n. (file:///Applications/ElectroCRUD.app/Contents/Resources/app.asar/dist/6.ebccde249530f6399212.js:1:63719)
at file:///Applications/ElectroCRUD.app/Contents/Resources/app.asar/dist/6.ebccde249530f6399212.js:1:62776
at Object.next (file:///Applications/ElectroCRUD.app/Contents/Resources/app.asar/dist/6.ebccde249530f6399212.js:1:62881)
at file:///Applications/ElectroCRUD.app/Contents/Resources/app.asar/dist/6.ebccde249530f6399212.js:1:61817
at new t (file:///Applications/ElectroCRUD.app/Contents/Resources/app.asar/dist/polyfills.f7f89e0c338a4bcc4985.js:1:14487)
at wn (file:///Applications/ElectroCRUD.app/Contents/Resources/app.asar/dist/6.ebccde249530f6399212.js:1:61594)
at n.ngOnInit (file:///Applications/ElectroCRUD.app/Contents/Resources/app.asar/dist/6.ebccde249530f6399212.js:1:63325)
at file:///Applications/Elect...
webpack:/src/app/views/configure/configure.component.ts:73 - n.<anonymous>
webpack:/src/app/views/configure/configure.component.ts.pre-build-optimizer.js:42 -
webpack:/src/app/views/configure/configure.component.ts.pre-build-optimizer.js:23 - Object.next
webpack:/src/app/views/configure/configure.component.ts.pre-build-optimizer.js:17 -
webpack:/src/app/views/configure/configure.component.ts.pre-build-optimizer.js:13 - __awaiter
webpack:/src/app/views/configure/configure.component.ts.pre-build-optimizer.js:78 - n.ngOnInit
webpack:/src/app/views/configure/configure.component.ts.pre-build-optimizer.js:13 - __awaiter
webpack:/src/app/views/configure/configure.component.ts.pre-build-optimizer.js:78 - n.ngOnInit
webpack:/src/app/views/configure/configure.component.ngfactory.js.pre-build-optimizer.js:194 - Object.updateDirectives
Created by Garry Lachman via Bugsnag
when i run grunt build
Running "concurrent:dist" (concurrent) task
Warning: Running "compass:dist" (compass) task
Warning: not found: compass Use --force to continue.
Aborted due to warnings.
Execution Time (2018-08-12 09:26:45 UTC+5:30)
loading tasks 17.3s ▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇ 90%
compass:dist 1.8s ▇▇▇▇▇ 10%
Total 19.1s Use --force to continue.
Aborted due to warnings.
I also tried grunt build --force but getting uglify error
Uglifying source .tmp/concat/scripts/scripts.js failed.
Warning: Uglification failed.
Unexpected token name «of», expected punc «;».
Line 948 in .tmp/concat/scripts/scripts.js
Used --force, continuing.
Warning: Cannot read property 'code' of undefined Used --force, continuing.
Error in /Applications/ElectroCRUD.app/Contents/Resources/app.asar/dist/index.html
formGroup expects a FormGroup instance. Please pass one in.
Example:
<div [formGroup]="myGroup">
<input formControlName="firstName">
</div>
In your class:
this.myGroup = new FormGroup({
firstName: new FormControl()
});
webpack:/src/app/views/configure/configure.component.html:15 - Object.updateDirectives
Created by Garry Lachman via Bugsnag
Error in /Applications/ElectroCRUD.app/Contents/Resources/app.asar/dist/index.html
The requested path contains undefined segment at index 5
webpack:/src/app/views/view/view/view.component.ts:125 - n.editRow
webpack:/src/app/views/view/view/view.component.ts:76 - t._next
Created by Garry Lachman via Bugsnag
If in the DataSource of the view I select only some field to display when I go to edit a recor I see all fields with the unselected fields.
The unselected fields is blank.
https://github.com/garrylachman/ElectroCRUD/blob/gh-pages/index.html#L43
Linux x64 and ia32 are mixed up.
[email protected] /home/mervo/mywork/ElectroCRUD
├── [email protected]
├── UNMET PEER DEPENDENCY [email protected]
I've tried to connect to mysql on localhost but it's not working
Host: localhost
Port: 80
user: root
Password: No password
MySQL server is requesting the old and insecure pre-4.1 auth mechanism.Upgrade the user password or use the {insecureAuth: true} option.
In which file I can set it to true.
When trying to configure a datasource I get the error: no such table when I use a tablename with a dot in its name.
Cant make a new project; Connect and Save buttons always show a "No" symbol.
As described in the title
If i change a row, all rows are made to duplicate the edited row
Describe the bug
Typo
To Reproduce
Expected behavior
previus -> previous
Is your feature request related to a problem? Please describe.
Describe the solution you'd like
A clear and concise description of what you want to happen.
Please add scroll bars for views and return to v1 ordering or add selction of column order.
Have not run on linux and don't know if it is different there.
possible?
PS X:\angular\ElectroCRUD> npm install
npm WARN deprecated [email protected]: You can find the new Popper v2 at @popperjs/core, this package is dedicated to the legacy v1
npm WARN deprecated [email protected]: request has been deprecated, see request/request#3142
npm WARN deprecated @types/[email protected]: This is a stub types definition. handlebars provides its own type definitions, so you do not need this installed.
npm WARN deprecated [email protected]: core-js@<3 is no longer maintained and not recommended for usage due to the number of issues. Please, upgrade your dependencies to the actual version of core-js@3.
npm WARN deprecated [email protected]: outdated version, please use @next
[email protected] install X:\angular\ElectroCRUD\node_modules\electron-chromedriver
node ./download-chromedriver.js
[email protected] postinstall X:\angular\ElectroCRUD\node_modules@angular-devkit\build-angular\node_modules\core-js
node scripts/postinstall || echo "ignore"
Thank you for using core-js ( https://github.com/zloirock/core-js ) for polyfilling JavaScript standard library!
The project needs your help! Please consider supporting of core-js on Open Collective or Patreon:
https://opencollective.com/core-js
https://www.patreon.com/zloirock
Also, the author of core-js ( https://github.com/zloirock ) is looking for a good job -)
[email protected] postinstall X:\angular\ElectroCRUD\node_modules\babel-runtime\node_modules\core-js
node -e "try{require('./postinstall')}catch(e){}"
Thank you for using core-js ( https://github.com/zloirock/core-js ) for polyfilling JavaScript standard library!
The project needs your help! Please consider supporting of core-js on Open Collective or Patreon:
https://opencollective.com/core-js
https://www.patreon.com/zloirock
Also, the author of core-js ( https://github.com/zloirock ) is looking for a good job -)
[email protected] postinstall X:\angular\ElectroCRUD\node_modules\ejs
node ./postinstall.js
Thank you for installing EJS: built with the Jake JavaScript build tool (https://jakejs.com/)
[email protected] postinstall X:\angular\ElectroCRUD\node_modules\global-agent\node_modules\core-js
node -e "try{require('./postinstall')}catch(e){}"
[email protected] postinstall X:\angular\ElectroCRUD\node_modules\wait-on\node_modules\core-js
node -e "try{require('./postinstall')}catch(e){}"
@angular/[email protected] postinstall X:\angular\ElectroCRUD\node_modules@angular\cli
node ./bin/postinstall/script.js
[email protected] postinstall X:\angular\ElectroCRUD\node_modules\core-js
node -e "try{require('./postinstall')}catch(e){}"
[email protected] postinstall X:\angular\ElectroCRUD\node_modules\electron
node install.js
[email protected] postinstall X:\angular\ElectroCRUD
npm run postinstall:electron && ./node_modules/electron-builder/out/cli/cli.js install-app-deps
[email protected] postinstall:electron X:\angular\ElectroCRUD
node postinstall
'.' is not recognized as an internal or external command,
operable program or batch file.
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! [email protected] postinstall: npm run postinstall:electron && ./node_modules/electron-builder/out/cli/cli.js install-app-deps
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] postinstall script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
npm ERR! A complete log of this run can be found in:
npm ERR! C:\Users\I.T\AppData\Roaming\npm-cache_logs\2020-02-20T05_57_18_042Z-debug.log
PS X:\angular\ElectroCRUD>
Seems the issues happens at this command
[email protected] postinstall X:\angular\ElectroCRUD
npm run postinstall:electron && ./node_modules/electron-builder/out/cli/cli.js install-app-deps
Please forgive me if i'm doing this wrong, I don't mean to be rude or anything, it is just that i am new to all of this and this is my first time here. I've been trying to install Electro Crud for a week now and doing research to find my way around it. but I always end up with this error.
My details are as follows
PS X:\angular\ElectroCRUD> npm -v
6.13.4
PS X:\angular\ElectroCRUD> node -v
v12.16.0
PS X:\angular\ElectroCRUD> ng -version
Your global Angular CLI version (9.0.2) is greater than your local
version (8.3.20). The local Angular CLI version is used.
To disable this warning use "ng config -g cli.warnings.versionMismatch false".
Thank You
how about add .deb, .rpm , .exe package
Is the related tables working (pk fk etc). Schema has child tables but I see no options to use it or set it up
Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]
Describe the solution you'd like
A clear and concise description of what you want to happen.
Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.
Additional context
Add any other context or screenshots about the feature request here.
Is possible view locale strings for translate, i want to collaborate with that
How can I get it to accept a SSH key instead of password?
It's possible to have a version (builded) that works totally offline?
Thanks
Describe the bug
I have configured an SSH tunnel with a PPK file. The tunnel is being built but the database connection is not working.
I have a MariaDB 10.3 running on the remote server.
Settings:
SSH domain.de port 2212 username sshkey
mysql localhost 3306 username password databasename
To Reproduce
I don't know how to comprehend this.
But in the screen you can see quite well that he wants to establish a database connection with port 5000 but I have definitely specified port 3306.
Desktop (please complete the following information):
Additional context
It's the program I've been searching for years for my databases.
When I edit a single row I have this error:
Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''DOC_COD', 'cognome', 'nome', 'SSD_DOC', 'web_page', 'mail', 'telefono', 'dipart' at line 1
When I delete a record, there are two choice, yes or no, but only the yes, delete it!
can work.
When i edit and save. All the records are affected and changed.
where i can get mysql setting?
Getting Below Error on npm run electron:mac-win-linux
> [email protected] electron:mac-win-linux /var/www/vhosts/ElectroCRUD
> npm run build:prod && electron-builder build --mac --win --linux
> [email protected] build:prod /var/www/vhosts/ElectroCRUD
> npm run build -- -c production
> [email protected] build /var/www/vhosts/ElectroCRUD
> npm run postinstall:electron && npm run electron:serve-tsc && ng build "-c" "production"
> [email protected] postinstall:electron /var/www/vhosts/ElectroCRUD
> node postinstall
> [email protected] electron:serve-tsc /var/www/vhosts/ElectroCRUD
> tsc -p tsconfig-serve.json
node_modules/get-port/index.d.ts:5:28 - error TS2304: Cannot find name 'Omit'.
5 interface Options extends Omit<ListenOptions, 'port'> {
~~~~
Found 1 error.
npm ERR! code ELIFECYCLE
npm ERR! errno 2
npm ERR! [email protected] electron:serve-tsc: `tsc -p tsconfig-serve.json`
npm ERR! Exit status 2
npm ERR!
npm ERR! Failed at the [email protected] electron:serve-tsc script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
npm ERR! A complete log of this run can be found in:
npm ERR! /root/.npm/_logs/2020-01-02T11_13_02_930Z-debug.log
npm ERR! code ELIFECYCLE
npm ERR! errno 2
npm ERR! [email protected] build: `npm run postinstall:electron && npm run electron:serve-tsc && ng build "-c" "production"`
npm ERR! Exit status 2
npm ERR!
npm ERR! Failed at the [email protected] build script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
npm ERR! A complete log of this run can be found in:
npm ERR! /root/.npm/_logs/2020-01-02T11_13_03_037Z-debug.log
npm ERR! code ELIFECYCLE
npm ERR! errno 2
npm ERR! [email protected] build:prod: `npm run build -- -c production`
npm ERR! Exit status 2
npm ERR!
npm ERR! Failed at the [email protected] build:prod script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
npm ERR! A complete log of this run can be found in:
npm ERR! /root/.npm/_logs/2020-01-02T11_13_03_108Z-debug.log
npm ERR! code ELIFECYCLE
npm ERR! errno 2
npm ERR! [email protected] electron:mac-win-linux: `npm run build:prod && electron-builder build --mac --win --linux`
npm ERR! Exit status 2
npm ERR!
npm ERR! Failed at the [email protected] electron:mac-win-linux script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
npm ERR! A complete log of this run can be found in:
npm ERR! /root/.npm/_logs/2020-01-02T11_13_03_172Z-debug.log
Firstly, epic work. This is the cleanest example of this type of software I've ever seen and had the pleasure of using.
A feature I think could be really neat is the ability to export/save the configuration, both for backup/versioning and so that it can be shared with others. If this could work across all supported platforms it would make EletroCRUD very versatile indeed!
if I modify a single row and i click on save, the app modify all rows. Sorry for my bad english... :)
Hello All,
This code works fine running through binary files
But issue occurs when cloning the code
caught ReferenceError: jqlite is not defined
module.js:457 Uncaught Error: Cannot find module 'angular'
angular.js:4587 Uncaught Error: [$injector:modulerr]
Please help
In macOS with MAMP need add field for socketPath on page "Project details".
example:
this.socketPath = options.socketPath || '/Applications/MAMP/tmp/mysql/mysql.sock';
Otherwise: "Error: connect ECONNREFUSED 127.0.0.1:3306"
npm ERR! not a package /tmp/npm-8331-N1ca2H2B/github.com/garrylachman/github-update-checker.git
npm ERR! Error: ENOENT: no such file or directory, open '/tmp/npm-8331-N1ca2H2B/github.com/garrylachman/github-update-checker.git-unpack/package.json'
npm ERR! at Error (native)
npm ERR! If you need help, you may report this entire log,
npm ERR! including the npm and node versions, at:
npm ERR! http://github.com/npm/npm/issues
npm ERR! System Linux 3.16.0-4-amd64
npm ERR! command "/usr/bin/nodejs" "/usr/bin/npm" "install"
npm ERR! cwd /root/CRUDs/ElectronCRUD/ElectroCRUD
npm ERR! node -v v4.4.3
npm ERR! npm -v 1.4.21
npm ERR! path /tmp/npm-8331-N1ca2H2B/github.com/garrylachman/github-update-checker.git-unpack/package.json
npm ERR! syscall open
npm ERR! code ENOENT
npm ERR! errno -2
npm ERR! not a package /tmp/npm-8331-N1ca2H2B/github.com/SoftwearDevelopment/grunt-contrib-uglify.git
npm ERR!
npm ERR! Additional logging details can be found in:
npm ERR! /root/CRUDs/ElectronCRUD/ElectroCRUD/npm-debug.log
npm ERR! not ok code 0
MySQL version: 8.0.15
when i click "START TEST",error occurs:
resMessage { server:
{ valid: false,
error:
'Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client' },
ssh: { valid: undefined, error: undefined } }
(It's so great to see this app live again!!)
It should be possible to "rename" the display value of field. i.e., My table has a field (column) "genretype" it should be presented as "Genre Type". Following the great examples from Metabase you can start with a sane guesstimate (i.e., if the field name is CamelCase then you can convert it to words) and also let operator edit this mapping.
when I execute 'grunt build' command, I got below info:
I can't figure out what's going on. I also try re-install npm and bower, but it still don't work.
➜ ElectroCRUD git:(master) grunt build
Running "clean:dist" (clean) task
>> 2 paths cleaned.
Running "wiredep:app" (wiredep) task
Running "wiredep:test" (wiredep) task
Running "wiredep:sass" (wiredep) task
Running "useminPrepare:html" (useminPrepare) task
Configuration changed for concat, uglify, cssmin
Running "concurrent:dist" (concurrent) task
Running "svgmin:dist" (svgmin) task
Total saved: 0 B
Done.
Execution Time (2016-08-09 14:24:41 UTC+8)
loading tasks 5.3s ▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇ 99%
svgmin:dist 71ms ▇ 1%
Total 5.4s
Warning: Running "compass:dist" (compass) task
Warning: not found: compass Use --force to continue.
Aborted due to warnings.
Execution Time (2016-08-09 14:24:41 UTC+8)
loading tasks 5.4s ▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇ 100%
Total 5.4s Use --force to continue.
Aborted due to warnings.
Execution Time (2016-08-09 14:24:37 UTC+8)
loading tasks 3.4s ▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇ 34%
wiredep:app 188ms ▇▇▇ 2%
concurrent:dist 6.1s ▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇ 63%
Total 9.8s
Can you please explain what is the use of View Relations. I created a new relation but nothing changed
TypeError in /Applications/ElectroCRUD.app/Contents/Resources/app.asar/dist/index.html
Cannot read property 'get' of undefined
webpack:/src/app/views/configure/configure.component.html:19 - Object.updateRenderer
Created by Garry Lachman via Bugsnag
Among the download buttons you have this one: Download (Linux 63Bit)
which should be Download (Linux 64Bit)
.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.