Hello,
The following link contains the api of generatedata . It has also all the
usage information regarding the api . It is of the site itself and I think
that they permit its usage for other UI's . I think it is a good idea to
use this api to implement this feature.
Any suggestions are welcome.
I have added all the 5 tasks in the idea "user interface improvements" in
my proposal. I saw last few year's proposals , containing 10-12 tasks for
UI- improvements. But, right now I cannot think of any other ideas to be
implemented in this domain . Is it sufficient ( in order of time) to
include these 5 tasks in my proposal for the whole coding period of GSOC
2015? Or is it advisable to come uup with other tasks too.?
Hello,
I am a GSoC aspirant and currently working on UI improvements. I
thought of adding another feature to my proposal i.e generating random
data. I would like to use the api from http://generatedata.com/ for
implementing this feature. it would be really a great feature for
phpMyAdmin. Any suggestions regarding this idea?
Thank you
--
Harish
Hi devs,
I think it would better if we can have continuous integration configured
for 4.4 branch at https://ci.phpmyadmin.net/
--
Thanks and Regards,
Madhura Jayaratne
See <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/1/>
------------------------------------------
Started by user Michal ÄŒihaÅ™
[EnvInject] - Loading node environment variables.
Building in workspace <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/>
Cloning the remote Git repository
Cloning repository git://github.com/phpmyadmin/phpmyadmin.git
> git init <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/> # timeout=10
Fetching upstream changes from git://github.com/phpmyadmin/phpmyadmin.git
> git --version # timeout=10
> git -c core.askpass=true fetch --tags --progress git://github.com/phpmyadmin/phpmyadmin.git +refs/heads/*:refs/remotes/origin/*
> git config remote.origin.url git://github.com/phpmyadmin/phpmyadmin.git # timeout=10
> git config --add remote.origin.fetch +refs/heads/*:refs/remotes/origin/* # timeout=10
> git config remote.origin.url git://github.com/phpmyadmin/phpmyadmin.git # timeout=10
Fetching upstream changes from git://github.com/phpmyadmin/phpmyadmin.git
> git -c core.askpass=true fetch --tags --progress git://github.com/phpmyadmin/phpmyadmin.git +refs/heads/*:refs/remotes/origin/*
> git rev-parse origin/QA_4_4^{commit} # timeout=10
Checking out Revision a9220d89cfd308fe9e29c7c9b7e88895c908877b (origin/QA_4_4)
> git config core.sparsecheckout # timeout=10
> git checkout -f a9220d89cfd308fe9e29c7c9b7e88895c908877b
First time build. Skipping changelog.
Empty changeset, running build.
[workspace] $ /bin/sh -xe /tmp/hudson2836780345958061721.sh
+ ./scripts/generate-mo --quiet
[workspace] $ ant clean locales phpunit pdepend phpmd phpcpd phpcs phploc jshint jshint-checkstyle lint
Unable to locate tools.jar. Expected to find it in /usr/lib/jvm/java-6-openjdk-amd64/lib/tools.jar
Buildfile: <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/build.xml>
clean:
[mkdir] Created dir: <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/build/api>
[mkdir] Created dir: <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/build/code-browser>
[mkdir] Created dir: <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/build/coverage>
[mkdir] Created dir: <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/build/logs>
[mkdir] Created dir: <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/build/pdepend>
locales:
phpunit:
BUILD FAILED
<https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/build.xml>:27: Execute failed: java.io.IOException: Cannot run program "<https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/vendor/bin/phpunit">: java.io.IOException: error=2, No such file or directory
at java.lang.ProcessBuilder.start(ProcessBuilder.java:494)
at java.lang.Runtime.exec(Runtime.java:612)
at org.apache.tools.ant.taskdefs.Execute$Java13CommandLauncher.exec(Execute.java:862)
at org.apache.tools.ant.taskdefs.Execute.launch(Execute.java:481)
at org.apache.tools.ant.taskdefs.Execute.execute(Execute.java:495)
at org.apache.tools.ant.taskdefs.ExecTask.runExecute(ExecTask.java:631)
at org.apache.tools.ant.taskdefs.ExecTask.runExec(ExecTask.java:672)
at org.apache.tools.ant.taskdefs.ExecTask.execute(ExecTask.java:498)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:622)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:390)
at org.apache.tools.ant.Target.performTasks(Target.java:411)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
at org.apache.tools.ant.Project.executeTarget(Project.java:1368)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
at org.apache.tools.ant.Main.runBuild(Main.java:809)
at org.apache.tools.ant.Main.startAnt(Main.java:217)
at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
Caused by: java.io.IOException: java.io.IOException: error=2, No such file or directory
at java.lang.UNIXProcess.<init>(UNIXProcess.java:164)
at java.lang.ProcessImpl.start(ProcessImpl.java:81)
at java.lang.ProcessBuilder.start(ProcessBuilder.java:476)
... 23 more
Total time: 10 seconds
Build step 'Invoke Ant' marked build as failure
[CHECKSTYLE] Skipping publisher since build result is FAILURE
[JSLINT] Skipping publisher since build result is FAILURE
[PMD] Skipping publisher since build result is FAILURE
[DRY] Collecting duplicate code analysis files...
[DRY] Finding all files that match the pattern build/logs/pmd-cpd.xml
[TASKS] Skipping publisher since build result is FAILURE
Recording plot data
Publishing Clover coverage report...
No Clover report will be published due to a Build Failure
[xUnit] [INFO] - Starting to record.
[xUnit] [INFO] - Processing PHPUnit-3.x (default)
[xUnit] [INFO] - [PHPUnit-3.x (default)] - No test report file(s) were found with the pattern 'build/logs/junit.xml' relative to '<https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/'> for the testing framework 'PHPUnit-3.x (default)'. Did you enter a pattern relative to the correct directory? Did you generate the result report(s) for 'PHPUnit-3.x (default)'?
[xUnit] [ERROR] - No test reports found for the metric 'PHPUnit' with the resolved pattern 'build/logs/junit.xml'. Configuration error?.
[xUnit] [INFO] - Failing BUILD.
[xUnit] [INFO] - There are errors when processing test results.
[xUnit] [INFO] - Skipping tests recording.
[xUnit] [INFO] - Stop build.
[JDepend] JDepend plugin is ready
[JDepend] Couldn't generate JDepend file at 'build/logs/jdepend.xml'java.io.FileNotFoundException: <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/build/logs/jdepend.xml> (No such file or directory)
Hello Marc,
I have certain queries like in this mention idea only the UI design has to
be done using JQuery, Html ans CSS or there is some backhand in PHP also..?
If there are some documents to refer then please send the links . And is
phpmyadmin
similar designing a web-application?
I have phpmyadmin 4.3.11 installed in my ubuntu 14.04 OS. How can I upgrade
to verson 4.3.12 ? Is there any different process , as I have cloned the
repository and forked the github repository?
Hello,
i am GSoC Participant. i am interested in Synchronization Project.
what i understood is we have to build PHP Scripts which connect to Remote
Machine and Synchronize data.
which means same database structure at both end and we are coping each
end's new row's to another end. Right?
i have started with my proposal. i wanted to ask what should be length of
proposal? 7 or 8 page is okay or Do i have to make it short?
Actually, i already did something like this in my past project.i can't
disclose code because i signed Non-Disclosure Agreement of that company. it
was two platform project. web-application(PHP) and Desktop application(C#
WPF). data is stored at desktop database(SQLite) locally, so user can view,
update, delete data offline. and when internet available, system will run
script to synchronize data.
I have faced many problems while solving the problem that i have listed
below. can you send me your expected solution for those problem so that i
can understand your expectations and project requirement.
Problems:
*Insert**:*
Case 1: insert at DB1
DB1
DB2
Before Synchronization
Step1: Two record with ID 1 & 2 in inserted
Current rows :1,2
Current rows : null
After Synchronization
Current rows :1,2
Two record with ID 1 & 2 in inserted
Current rows :1,2
Case 2: insert at DB2
DB1
DB2
Before Synchronization
Current rows :1,2
Step1: Two record with ID 3 & 4 in inserted
Current rows :1,2,3,4
After Synchronization
Two record with ID 3 & 4 in inserted
Current rows :1,2,3,4
Current rows :1,2,3,4
Case 3: Insert at Both DB1&DB2
DB1
DB2
Before Synchronization
Current rows :1,2,3,4
Current rows :1,2,3,4
Step 1: one new record inserted with id 5
Current rows :1,2,3,4,5(of DB1)
Current rows :1,2,3,4
Current rows :1,2,3,4,5(of DB1)
Step 2: one new record inserted with id 5
Current rows :1,2,3,4,5(of DB2)
After Synchronization
What should happen in this case? If we want to sync this we need
some differentiate to identify both DB.
In my past project I provided Device ID. Means PRIMARY KEY and DEVICE ID
both will make Composite Key which make it unique to identify.
What is your preferred solution?
*Update**: in this case we required updated row timestamp, I am assuming
there is update_timestamp column in each table*
Case 1: update at DB1
DB1
DB2
Before Synchronization
Step1: updating row with id 1
Current rows :1(updated),2,3,4
Current rows :1(old),2,3,4
After Synchronization
Current rows :1(updated),2,3,4
update row with id 1
Current rows :1(updated),2,3,4
Case 2: update at DB2
DB1
DB2
Before Synchronization
Current rows :1(updated),2(old),3,4
Step1: updating row with id 2
Current rows :1(updated),2(updated),3,4
After Synchronization
update row with id 2
Current rows :1(updated),2(updated),3,4
Current rows :1(updated),2(updated),3,4
Case 3: update at both side but different timestamp
DB1
DB2
Before Synchronization
Step1: updating row with id 2
Current rows :1,2(updated),3,4
Current rows :1,2(old),3,4
Current rows :1,2(updated),3,4
Step1: updating row with id 2
Current rows :1,2(updated),3,4
After Synchronization (both update is different and timestamp is also
different)
In this case both side update is different, what should be final record. I
think I should be last one updated. Right?
What is preferred solution?
Case 4: update at both side but same timestamp
DB1
DB2
Before Synchronization
Step1: updating row with id 2
Current rows :1,2(updated),3,4
Step1: updating row with id 2
Current rows :1,2(updated),3,4
After Synchronization (both update is different but time stamp is same)
In this case both side update is different and time stamp is same!! So here
again we need DEVICE ID by which we can identify that both update is
different.
And what should I store finally, because which one we have to finally store
is depends on timestamp, which is SAME for BOTH DB!!! What is preferred
solution?
*Delete**:*
Case 1: deleted at DB1
DB1
DB2
Before Synchronization
Step1: row with id 3 is deleted.
Current rows :1,2,4
Current rows :1,2,3,4
After Synchronization
In this case row with id 3 will be added at DB1 because for SYSTEM it’s
newly added row at DB2.
To handle this problem in my past project I maintained Activity logs. Which
stores that row with id 3 is deleted, so when synchronization take place, I
fetch logs from activity log and first delete row with ID 3 in DB2.
What is your preferred Solution?
Current rows :1,2,3,4
Current rows :1,2,3,4
Regards,
Jay Jayswal