Using application program (Java/Python) to access MaxCompute Lightning for data development

MaxCompute Lightning It is an interactive query service of maxcompute products. It supports accessing the maxcompute project through PostgreSQL protocol and syntax connection. It enables you to use familiar tools to query and analyze the data in the maxcompute project with standard SQL, and quickly obtain the query results.Many developers want ...

Posted by BobRoberts on Tue, 03 Dec 2019 00:51:50 +0100

GORM associated query

A User and Company are defined. Users can contain multiple companies, as follows: type User struct { ID int `gorm:"TYPE:int(11);NOT NULL;PRIMARY_KEY;INDEX"` Name string `gorm:"TYPE: VARCHAR(255); DEFAULT:'';INDEX"` Companies []Company `gorm:"FOREIGNKEY:UserId;ASSOCIATION_FOREIGNKEY:ID"` Cr ...

Posted by Teh Unseen on Mon, 02 Dec 2019 21:01:14 +0100

PHP verification user name re registration [novice]

This summary uses the simplest way to verify whether the form submission (user name) exists in the data table through PHP. If it exists, it shows that it has been registered. If it does not exist, it can be registered normally. The detailed code is as follows: Steps omit the establishment of database and data table. The front-end submission pag ...

Posted by maxime on Mon, 02 Dec 2019 18:12:07 +0100

08 "enable user mailbox activation

Mailbox activation implementation process analysis code implementation 1) process analysis ① click the link to activate the email: http://localhost:8080/store/user/active?code=xxx ② it is necessary to write a process for / active path in UserServlet Get activation code Call service layer to complete activation Page Jump, ...

Posted by sarika on Mon, 02 Dec 2019 15:00:51 +0100

mysql master-slave read-write separation practice

Environmental Science mysql-5.7.19 Centos7 master: 192.168.111.64 slave: 192.168.111.66 Master slave configuration master configuration ## GTID server_id = 100 # Server id. the slave database should be larger than the master database, and be unique gtid_mode = on #Turn on gtid mode enforce_gtid_consistency = on #Force gtid consistency. ...

Posted by kenyabob on Sun, 01 Dec 2019 08:02:07 +0100

Specific programming scenarios of spark SQL

Introduction case: object SparkSqlTest { def main(args: Array[String]): Unit = { //Block redundant logs Logger.getLogger("org.apache.hadoop").setLevel(Level.WARN) Logger.getLogger("org.apache.spark").setLevel(Level.WARN) Logger.getLogger("org.project-spark").setLevel(Level.WARN) //Building programmin ...

Posted by tigomark on Sun, 01 Dec 2019 01:17:03 +0100

java data written to Excel

Just recently, the company has to write a reconciliation function. The background uses java to get reconciliation information from the bank. The data is of json type, and then it is written into excel and sent to the server in the card center. A lot of codes are found on the Internet, and then they are integrated and corrected. The codes are as ...

Posted by offsprg01 on Sat, 30 Nov 2019 23:45:52 +0100

mybatis implements the user-defined sql parameterization and binds the parameters within the parameters

In some business scenarios, multiple tables are needed to perform statistical operations jointly. In such scenarios, the logic of sql is often complex, and it is difficult to write it out easily by using mybatis. At the same time, various business variables are very large, so it is a little weak to deal with it based on mybatis. ...

Posted by loveitandhateit on Sat, 30 Nov 2019 11:12:16 +0100

cas-overlay-template4.2 build single sign on connection to Oracle database (3. Connect to Oracle database configuration)

    1. It is introduced in pom.xml. Since the ojdbc6.jar package cannot be imported directly in the POM file, Download ojdbc6.jar and import it manually in WEB-INF/lib under the overlays directory   <dependency> <groupId>org.jasig.cas</groupId> <artifactId>cas-server-support-jdbc</artifact ...

Posted by marf on Fri, 29 Nov 2019 20:10:43 +0100

Sequenize learning experience (ORM framework)

What is ORM? Simply speaking, it is the encapsulation of SQL query statements, which enables us to operate the database in the OOP way and generate safe and maintainable SQL code gracefully. Intuitively, it is a mapping relationship between Model and SQL. sequelize.query (original query) By default, the function returns two parameters - an ar ...

Posted by Axeia on Fri, 29 Nov 2019 16:27:53 +0100